首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > C# >

"VAR1#""VAR2#"这样的字符代表什么意思阿?解决办法

2012-04-11 
#VAR1#,#VAR2#这样的字符代表什么意思阿?sqlSELECTLEFT(QSDM,#VAR1#),CURRENTYEAR,+SUM(A1)ASA1,S

"#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# ", " "));

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

热点排行