新增文章

文章标题分类内容

sql 特殊符号

\r\n  换行符
\t    制表符

aSql = string.Format("/*dialect*/ \r\n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\r\n-- 1. 出货未对账\r\n\r\n   select  1 FLevel ,1 FRow1 ,'出货未对账' FType\r\n   \r\n      ,a1.FBillTypeName,a1.FBillNo,a1.FSeq ,a1.FCustBelong,a1.FCustNo,a1.FCustName\r\n      ,0  FDay3\t-- 天数｜收款逾期\r\n\t\r\n     \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\r\n   ) a\r\n\r\n   where 1=1 {1} \r\n   \r\n   order by FBillNo,FSeq\r\n;\r\n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\r\n", aTableName, aWhereFilter, arg);
			DBUtils.Execute(aContext, aSql);

转换后的效果：

aSql = string.Format("/*dialect*/ 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 1. 出货未对账

select  1 FLevel ,1 FRow1 ,'出货未对账' FType
   
      ,a1.FBillTypeName,a1.FBillNo,a1.FSeq ,a1.FCustBelong,a1.FCustNo,a1.FCustName
      ,0  FDay3   -- 天数｜收款逾期
   
     ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   ) a

where 1=1 {1} 
   
   order by FBillNo,FSeq
;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
", aTableName, aWhereFilter, arg);
			DBUtils.Execute(aContext, aSql);