/// <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.量具品名 != null) { strSql1.Append("量具品名,"); strSql2.Append("'" + model.量具品名 + "',"); } if (model.测定项目 != null) { strSql1.Append("测定项目,"); strSql2.Append("'" + model.测定项目 + "',"); } if (model.规格 != null) { strSql1.Append("规格,"); strSql2.Append("'" + model.规格 + "',"); } if (model.测定项目日文 != null) { strSql1.Append("测定项目日文,"); strSql2.Append("N'" + model.测定项目日文 + "',"); } if (model.尺寸公差 != null) { strSql1.Append("尺寸公差,"); strSql2.Append("'" + model.尺寸公差 + "',"); } if (model.限 != null) { strSql1.Append("下限,"); strSql2.Append("" + model.限 + ","); } 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> 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 { string sSQL = "select getdate()"; DateTime dNow = BaseFunction.ReturnDate(DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0].Rows[0][0]); DateTime dNowDate = BaseFunction.ReturnDate(dNow.ToString("yyyy-MM-dd")); for (int i = 0; i < gridView1.RowCount; i++) { if (!BaseFunction.ReturnBool(gridView1.GetRowCellValue(i, gridColSelected))) { continue; } if (gridView1.GetRowCellValue(i, gridCol发射器ID).ToString().Trim() == "" && gridView1.GetRowCellValue(i, gridCol测定项目).ToString().Trim() == "") { continue; } long lID = BaseFunction.ReturnLong(gridView1.GetRowCellValue(i, gridColiID)); Model.检验标准档案 mod = new 业务.Model.检验标准档案(); mod.发射器ID = BaseFunction.ReturnInt(gridView1.GetRowCellValue(i, gridCol发射器ID)); if (mod.发射器ID == 0) { sErr = sErr + "行" + (i + 1).ToString() + "发射器ID不正确\n"; continue; } mod.量具品名 = gridView1.GetRowCellValue(i, gridCol量具品名).ToString().Trim(); if (mod.量具品名 == string.Empty) { sErr = sErr + "行" + (i + 1).ToString() + "量具品名不正确\n"; continue; } mod.测定项目 = gridView1.GetRowCellValue(i, gridCol测定项目).ToString().Trim(); if (mod.测定项目 == string.Empty) { sErr = sErr + "行" + (i + 1).ToString() + "测定项目不正确\n"; continue; } mod.测定项目日文 = gridView1.GetRowCellValue(i, gridCol测定项目日文).ToString().Trim(); mod.规格 = gridView1.GetRowCellValue(i, gridCol规格).ToString().Trim(); mod.尺寸公差 = gridView1.GetRowCellValue(i, gridCol尺寸公差).ToString().Trim(); if (mod.尺寸公差 == string.Empty) { sErr = sErr + "行" + (i + 1).ToString() + "尺寸公差不正确\n"; continue; } if (gridView1.GetRowCellValue(i, gridCol下限).ToString().Trim() != "") { mod.限 = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridCol下限)); } if (gridView1.GetRowCellValue(i, gridCol上限).ToString().Trim() != "") { mod.限 = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridCol上限)); } if (gridView1.GetRowCellValue(i, gridCol下限).ToString().Trim() != "" && gridView1.GetRowCellValue(i, gridCol上限).ToString().Trim() != "" && mod.限 > mod.限) { sErr = sErr + "行" + (i + 1).ToString() + "上下限数值不正确\n"; continue; } if (BaseFunction.ReturnDecimal(mod.限) == 0 && BaseFunction.ReturnDecimal(mod.限) == 0) { sErr = sErr + "行" + (i + 1).ToString() + "上下限数值不正确\n"; continue; } mod.备注 = gridView1.GetRowCellValue(i, gridCol备注).ToString().Trim(); mod.iID = lID; DAL.检验标准档案 dal = new 业务.DAL.检验标准档案(); if (lID > 0) { sSQL = dal.Update(mod); } else { sSQL = dal.Add(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); } }
/// <summary> /// 更新一条数据 /// </summary> public string Update(业务.Model.检验标准档案 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 检验标准档案 set "); if (model.发射器ID != null) { strSql.Append("发射器ID=" + model.发射器ID + ","); } else { strSql.Append("发射器ID= null ,"); } if (model.量具品名 != null) { strSql.Append("量具品名='" + model.量具品名 + "',"); } else { strSql.Append("量具品名= null ,"); } if (model.测定项目 != null) { strSql.Append("测定项目='" + model.测定项目 + "',"); } else { strSql.Append("测定项目= null ,"); } if (model.规格 != null) { strSql.Append("规格='" + model.规格 + "',"); } else { strSql.Append("规格= null ,"); } if (model.测定项目日文 != null) { strSql.Append("测定项目日文=N'" + model.测定项目日文 + "',"); } else { strSql.Append("测定项目日文= null ,"); } if (model.尺寸公差 != null) { strSql.Append("尺寸公差='" + model.尺寸公差 + "',"); } else { strSql.Append("尺寸公差= null ,"); } if (model.限 != null) { strSql.Append("下限=" + model.限 + ","); } else { strSql.Append("下限= null ,"); } if (model.限 != null) { strSql.Append("上限=" + model.限 + ","); } else { strSql.Append("上限= null ,"); } 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()); }