//删除2016-12-19 private void button3_Click(object sender, EventArgs e) { //List<string> list = new List<string>(); string code = string.Empty; string lsSql = string.Empty; StringBuilder loString = new StringBuilder(); for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Cells["SC"].Value == null) //第一次 都是null { dataGridView1.Rows[i].Cells["SC"].Value = "0"; } if (dataGridView1.Rows[i].Cells["SC"].Value.ToString() == "1") { //MessageBox.Show(dataGridView1.Rows[i].Cells["Code"].Value.ToString()); code = dataGridView1.Rows[i].Cells["Code"].Value.ToString(); //list.Add(code); lsSql = "Delete PMP000101 where Code='" + code + "' "; loString.AppendLine(lsSql); } } lsSql = loString.ToString(); if (!string.IsNullOrEmpty(lsSql)) { SqlHelperXhf loSqlHelperXhf = new SqlHelperXhf(Comm.ConnStringFrom); loSqlHelperXhf.ExecuteNonQuery(lsSql); } else { MessageBox.Show("没有任何选中数据!"); } button1_Click(null, null); }
//保存 private void button2_Click(object sender, EventArgs e) { GNLBEntity gnlb = new GNLBEntity(); string lsSql = string.Empty; StringBuilder loString = new StringBuilder(); try { for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Cells["SC"].Value == null) //第一次 都是null { dataGridView1.Rows[i].Cells["SC"].Value = "0"; } if (dataGridView1.Rows[i].Cells["SC"].Value.ToString() == "1") { gnlb.code = dataGridView1.Rows[i].Cells["Code"].Value.ToString(); gnlb.name = dataGridView1.Rows[i].Cells["U_Name"].Value.ToString(); gnlb.zygn = dataGridView1.Rows[i].Cells["ZYGN"].Value.ToString(); gnlb.xt = dataGridView1.Rows[i].Cells["XT"].Value.ToString(); gnlb.pt = dataGridView1.Rows[i].Cells["PT"].Value.ToString(); gnlb.lx = dataGridView1.Rows[i].Cells["GNLX"].Value.ToString(); gnlb.createDate = dataGridView1.Rows[i].Cells["CreateDate"].Value.ToString(); gnlb.cjyh = dataGridView1.Rows[i].Cells["CJYH"].Value.ToString(); gnlb.gxyh = dataGridView1.Rows[i].Cells["GXYH"].Value.ToString(); if (string.IsNullOrEmpty(gnlb.code)) { throw new Exception("功能代码不能为空"); } if (string.IsNullOrEmpty(gnlb.name)) { throw new Exception("功能名称不能为空"); } if (string.IsNullOrEmpty(gnlb.pt)) { throw new Exception("平台不能为空"); } if (string.IsNullOrEmpty(gnlb.cjyh)) { throw new Exception("创建用户不能为空"); } string sql = "Select count(*) from PMP000101 t10 where Code='" + gnlb.code + "' "; SqlHelperXhf loSqlHelperXhf = new SqlHelperXhf(Comm.ConnStringFrom); if (Convert.ToInt32(loSqlHelperXhf.ExecuteScalar(sql)) == 0) { lsSql = @"Insert into PMP000101(Code,Name,XT,ZYGN,PT,LX,CreateDate,UpdateDate,CJYH,GXYH) values ('" + gnlb.code + "','" + gnlb.name + "','" + gnlb.xt + "','" + gnlb.zygn + "','" + gnlb.pt + "','" + gnlb.lx + "','" + System.DateTime.Now + "','','" + gnlb.cjyh + "','" + gnlb.gxyh + "')"; } else { lsSql = "update PMP000101 set Name='" + gnlb.name + "',XT='" + gnlb.xt + "',ZYGN='" + gnlb.zygn + "',PT='" + gnlb.pt + "',LX='" + gnlb.lx + "',CreateDate='" + gnlb.createDate + "',UpdateDate='" + System.DateTime.Now + "',CJYH='" + gnlb.cjyh + "',GXYH='" + gnlb.gxyh + "' where Code='" + gnlb.code + "' "; } loString.AppendLine(lsSql); } } lsSql = loString.ToString(); if (!string.IsNullOrEmpty(lsSql)) { SqlHelperXhf loSqlHelperXhf = new SqlHelperXhf(Comm.ConnStringFrom); loSqlHelperXhf.ExecuteNonQuery(lsSql); } else { MessageBox.Show("没有任何选中数据!"); } button1_Click(null, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }