/// <summary> /// 增加一条数据 /// </summary> public string Add(业务.Model._WorkGroup model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.WorkGroup != null) { strSql1.Append("WorkGroup,"); strSql2.Append("'" + model.WorkGroup + "',"); } if (model.Remark != null) { strSql1.Append("Remark,"); strSql2.Append("'" + model.Remark + "',"); } strSql.Append("insert into _WorkGroup("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); return(strSql.ToString()); }
/// <summary> /// 更新一条数据 /// </summary> public string Update(业务.Model._WorkGroup model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update _WorkGroup set "); if (model.Remark != null) { strSql.Append("Remark='" + model.Remark + "',"); } else { strSql.Append("Remark= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where iID=" + model.iID + ""); return(strSql.ToString()); }
/// <summary> /// 保存 /// </summary> private void btnSave() { string sErr = ""; int iCount = 0; try { try { gridView1.FocusedRowHandle -= 1; gridView1.FocusedRowHandle += 1; } catch { } SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { for (int i = 0; i < gridView1.RowCount; i++) { if (gridView1.GetRowCellValue(i, gridColWorkGroup).ToString().Trim().Length > 0) { long lID = BaseFunction.ReturnLong(gridView1.GetRowCellValue(i, gridCol序号)); Model._WorkGroup mod = new 业务.Model._WorkGroup(); mod.WorkGroup = gridView1.GetRowCellValue(i, gridColWorkGroup).ToString().Trim(); mod.Remark = gridView1.GetRowCellValue(i, gridColRemark).ToString().Trim(); mod.iID = lID; DAL._WorkGroup dal = new 业务.DAL._WorkGroup(); if (lID == 0) { sSQL = dal.Add(mod); } else { sSQL = dal.Update(mod); } iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } } if (sErr.Length > 0) { throw new Exception(sErr); } if (iCount > 0) { tran.Commit(); MessageBox.Show("保存成功"); GetGrid(); } } catch (Exception ee) { tran.Rollback(); throw new Exception(ee.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } catch (Exception ee) { throw new Exception(ee.Message); } }