簡訊模板(在SQL中利用replace函數完成替換)

模板：

[OwnerName][OwnerTitle],您好!我是[ProjectName]保險公司業務員[UserName],您的[QuoteContent],不清楚可聯絡服務電話：(公司[ProjectContactPhone])或(個人[UserMobilePhone]),謝謝您的查收!祝您身體健康!

任務：將[……]的內容用實際內容進行替換

代碼：

           string sql = "DECLARE @OwnerMobile VARCHAR(250) \r\n";           
            sql += "DECLARE @OwnerName VARCHAR(250) \r\n";
            sql += "DECLARE @OwnerTitle VARCHAR(250) \r\n";
            sql += "DECLARE @ProjectName VARCHAR(100) \r\n";
            sql += "DECLARE @UserName VARCHAR(100) \r\n";
            sql += "DECLARE @ProjectContactPhone VARCHAR(100) \r\n";
            sql += "DECLARE @UserMobilePhone VARCHAR(100) \r\n";
            sql += "DECLARE @QuoteContent VARCHAR(4000) \r\n";
            sql += "DECLARE @MessageTemplate VARCHAR(1000) \r\n";

            sql += "SELECT @OwnerMobile=a.Mobile,@OwnerName=a.OwnerName,@OwnerTitle=case a.sex WHEN '1' THEN '先生' WHEN '2' THEN '小姐' ELSE '' END,@QuoteContent=b.QuoteContent,@ProjectName=c.ProjectName,@ProjectContactPhone=c.ContactPhone,@UserName=d.UserName,@UserMobilePhone=isnull(d.MobilePhone,''),@MessageTemplate=c.MessageTemplate FROM [Sales_CarOwners] a \r\n"
                + "LEFT JOIN [Sales_QuoteBill] b ON a.[CarID] = b.[CarID] \r\n"
                + "LEFT JOIN [Sales_System_Project] c ON b.ProjectID=c.ID \r\n"
                + "LEFT JOIN [System_Users] d ON b.QuoteUserID = d.UserID \r\n"
                + "WHERE b.[ID] =" + QuoteID + " \r\n";

            //替換
            sql += "SET @MessageTemplate=REPLACE(@MessageTemplate,'[OwnerName]',@OwnerName) \r\n";
            sql += "SET @MessageTemplate=REPLACE(@MessageTemplate,'[OwnerTitle]',@OwnerTitle) \r\n";
            sql += "SET @MessageTemplate=REPLACE(@MessageTemplate,'[ProjectName]',@ProjectName) \r\n";
            sql += "SET @MessageTemplate=REPLACE(@MessageTemplate,'[UserName]',@UserName) \r\n";
            sql += "SET @MessageTemplate=REPLACE(@MessageTemplate,'[QuoteContent]',@QuoteContent) \r\n";
            sql += "SET @MessageTemplate=REPLACE(@MessageTemplate,'[ProjectContactPhone]',@ProjectContactPhone) \r\n";
            sql += "SET @MessageTemplate=REPLACE(@MessageTemplate,'[UserMobilePhone]',@UserMobilePhone) \r\n";