栗色?蓝色?--动态添加sql语句

The Neurotic Fishbowl

麦林发表于 2007/12/4 17:10:03

if (cghlfenxigl.grid1.Rows.Count > 0 && cghlfenxigl.grid1.Rows[0].Cells["ts"].Value != DBNull.Value) { addcol(); string c = ""; string d = ""; string selectsql = " union select orgname,depname,connumber,name,number,proname,measurename,spec,price,count"; string wheresql = " from ##temp a where a.date "; int b = 0; b = cghlfenxigl.grid1.Rows.Count; for (int i = 1; i <= b; i++) { string a = ""; for (int j = 1; j <= b; j++) { if (i == j) { a = a + ",date" + i + "=a.date"; } else { a = a + ",date" + j + " = null "; } if (j == b) { if (i == 1) c = selectsql + a + wheresql + "between 0 and " + Convert.ToInt32(cghlfenxigl.grid1.Rows[0].Cells["ts"].Value) + "\n"; else if (i == b && cghlfenxigl.grid1.Rows[i - 1].Cells["ts"].Value == DBNull.Value) c = selectsql + a + wheresql + " > " + Convert.ToInt32(cghlfenxigl.grid1.Rows[i - 2].Cells["ts"].Value) + "\n"; else c = selectsql + a + wheresql + "between " + Convert.ToInt32(cghlfenxigl.grid1.Rows[i - 2].Cells["ts"].Value) + " and " + Convert.ToInt32(cghlfenxigl.grid1.Rows[i - 1].Cells["ts"].Value) + "\n"; } } d = d + c; } sql = d.Substring(7, d.Length - 8); } } public void addcol() { if (cghlfenxigl.rowcount > 0) { grid0.ReadOnly = false; for (int i = 1; i <= cghlfenxigl.rowcount; i++) { Jeez.Control.JeezGrid.Column col = new Jeez.Control.JeezGrid.Column(); grid0.Columns.Add(col); col.Name = "date" + i; col.Caption = cghlfenxigl.grid1.Rows[i - 1].Cells[0].Text; } } }

阅读全文(2235) | 回复(0) | 编辑 | 精华

发表评论：