/// <summary> /// 增加一条数据 /// </summary> public string Add(业务.Model.发射器档案设置 model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.发射器ID != null) { strSql1.Append("发射器ID,"); strSql2.Append("" + model.发射器ID + ","); } if (model.CMITiID != null) { strSql1.Append("CMITiID,"); strSql2.Append("'" + model.CMITiID + "',"); } if (model.检验工位 != null) { strSql1.Append("检验工位,"); strSql2.Append("'" + model.检验工位 + "',"); } if (model.备注 != null) { strSql1.Append("备注,"); strSql2.Append("'" + model.备注 + "',"); } strSql.Append("insert into 发射器档案设置("); 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.发射器档案设置 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 发射器档案设置 set "); if (model.CMITiID != null) { strSql.Append("CMITiID='" + model.CMITiID + "',"); } else { strSql.Append("CMITiID= null ,"); } if (model.检验工位 != null) { strSql.Append("检验工位='" + model.检验工位 + "',"); } if (model.备注 != null) { strSql.Append("备注='" + model.备注 + "',"); } else { strSql.Append("备注= 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, gridColiSave).ToString().Trim().Length > 0) { long lID = BaseFunction.ReturnLong(gridView1.GetRowCellValue(i, gridCol序号)); Model.发射器档案设置 mod = new 业务.Model.发射器档案设置(); mod.检验工位 = gridView1.GetRowCellValue(i, gridCol检验工位).ToString().Trim(); mod.发射器ID = BaseFunction.ReturnInt(gridView1.GetRowCellValue(i, gridCol发射器ID)); mod.CMITiID = gridView1.GetRowCellValue(i, gridColCMITiID).ToString().Trim(); mod.备注 = gridView1.GetRowCellValue(i, gridCol备注).ToString().Trim(); mod.iID = lID; if (mod.发射器ID == 0) { sErr = sErr + "行" + (i + 1).ToString() + " 发射器ID必须配置\n"; continue; } if (mod.检验工位 == string.Empty) { sErr = sErr + "行" + (i + 1).ToString() + " 检验工位必须配置\n"; continue; } DAL.发射器档案设置 dal = new 业务.DAL.发射器档案设置(); 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); } }