读书人

quot;VAR1#quot;quot;VAR2#quot;这样的字符代表什么意思

发布时间: 2012-04-11 17:42:33 作者: rapoo

"#VAR1#","#VAR2#"这样的字符代表什么意思阿?
sql = "SELECT LEFT(QSDM, #VAR1#), CURRENTYEAR, "
+ " SUM(A1) AS A1, SUM(A2) AS A2, SUM(A3) AS A3, "
+ " SUM(A11) AS A11, SUM(A12) AS A12, SUM(A13) AS A13, SUM(A14) AS A14, SUM(A15) AS A15, "
+ " SUM(A20) AS A20, SUM(A26) AS A26, SUM(A27) AS A27, SUM(A31) AS A31, SUM(A32) AS A32, "
+ " SUM(A111) AS A111, SUM(A112) AS A112, SUM(A113) AS A113, SUM(A114) AS A114, SUM(A115) AS A115, SUM(A121) AS A121, SUM(A121K) AS A121K, "
+ " SUM(A122) AS A122, SUM(A122K) AS A122K, SUM(A123) AS A123, SUM(A123K) AS A123K, SUM(A124) AS A124, SUM(A124K) AS A124K, SUM(A125) AS A125, "
+ " SUM(A125K) AS A125K, SUM(A131) AS A131, SUM(A131K) AS A131K, SUM(A132) AS A132, SUM(A133) AS A133, SUM(A134) AS A134, SUM(A134K) AS A134K, "
+ " SUM(A135) AS A135, SUM(A136) AS A136, SUM(A136K) AS A136K, SUM(A141) AS A141, SUM(A142) AS A142, SUM(A143) AS A143, SUM(A143K) AS A143K, "
+ " SUM(A151) AS A151, SUM(A152) AS A152, SUM(A153) AS A153, SUM(A154) AS A154, SUM(A155) AS A155, SUM(A155K) AS A155K, SUM(A156) AS A156, "
+ " SUM(A157) AS A157, SUM(A158) AS A158, SUM(A201) AS A201, SUM(A202) AS A202, SUM(A203) AS A203, SUM(A204) AS A204, SUM(A205) AS A205, "


+ " SUM(A206) AS A206, SUM(A261) AS A261, SUM(A262) AS A262, SUM(A263) AS A263, SUM(A264) AS A264, SUM(A265) AS A265, SUM(A271) AS A271, "
+ " SUM(A272) AS A272, SUM(A311) AS A311, SUM(A312) AS A312, SUM(A313) AS A313, SUM(A314) AS A314, SUM(A315) AS A315, SUM(A316) AS A316, "
+ " SUM(A317) AS A317, SUM(A321) AS A321, SUM(A322) AS A322, SUM(A323) AS A323, SUM(A324) AS A324, SUM(A325) AS A325 "
+ " FROM RPT_V_CSTJB WHERE 1=1 #VAR2# AND CURRENTYEAR= ' " + Year + " ' AND LEFT(QSDM, #VAR1#)= ' " + Qsdm
+ " ' GROUP BY LEFT(QSDM, #VAR1#), CURRENTYEAR ";

sql_list.Add(sql.Replace( "#VAR1# ", qsdm_len.ToString()).Replace( "#VAR2# ", " "));


这是别人的代码,其中 "#VAR1# ", "#VAR2# "是什么意思

[解决办法]
看最后一句

sql_list.Add(sql.Replace( "#VAR1# ", qsdm_len.ToString()).Replace( "#VAR2# ", " "));

应该是他自己的置位字符串
[解决办法]
自定义的占位符
[解决办法]
高手......三级钻..第一次见....佩服..

读书人网 >C#

热点推荐