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#"是什么意思
+ " 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#"是什么意思
解决方案 »
- 關於c#字符轉換的問題
- 怎么将一个ContextMenuStrip判定到一个按钮上?
- c#中什么是引用?详细点得理论解答
- 在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (prov
- 用C#写UltraEdit32那样的编辑器,当中的关键子突出显示怎样实现
- 高手进来帮帮哦
- 如何把我的事件处理函放在事件队列的第一个执行?
- C#AD域用户添加邮箱问题。
- 鼠标右键点网页中的图片时如何获得该图片的URL
- 勾引,不要自己进来。比如PB中用直线画出的表格,在C#中如何实现?(散分+源程序)。来者有分
- COM组件运行需要运行库吗
- 如何镜像打印二代证临时身份证底卡
纯粹是为了后面的替换才使用上?是这个意思吧