/// <summary> /// 保存备注 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_BCBZ_Click(object sender, EventArgs e) { int[] rownumber = gv_SYXX.GetSelectedRows();//获取选中行号数组; int a = 0; if (rownumber.Length == 0) { MessageBox.Show("请选择需要添加备注的信息!"); return; } for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; if (gv_SYXX.GetRowCellValue(selectedHandle, "状态").ToString() == "已委托") { a++; MessageBox.Show("勾选的数据已委托,不能保存备注!"); break; } } if (a == 0) { for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; if (gv_SYXX.GetRowCellValue(selectedHandle, "状态").ToString() == "已委托") { MessageBox.Show("勾选的数据已委托,不能保存备注!"); break; } string strID = gv_SYXX.GetRowCellValue(selectedHandle, "主键").ToString(); Mod_TQC_PRESENT_SAMPLES mod = bllTqcPresentSamples.GetModel(strID); mod.C_REMARK = txt_Remark.Text.Trim(); if (!bllTqcPresentSamples.Update(mod)) { MessageBox.Show("保存失败"); return; } } Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "保存未委托的常规送样的备注信息");//添加操作日志 MessageBox.Show("保存成功!"); BindSampling(); NewMethod1(); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_PRESENT_SAMPLES GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_BATCH_NO,C_TICK_NO,C_STL_GRD,C_SPEC,N_ENTRUST_TYPE,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_EMP_ID_ZY,D_MOD_DT_ZY,C_EMP_ID_JS,D_MOD_DT_JS,C_EQ_NAME,C_EQ_NUMBER,C_EQ_CODE,N_SAMPLES_NUM,C_TICK_STATE,C_BC_SY,C_BZ_SY,C_BC_JY,C_BZ_JY from TQC_PRESENT_SAMPLES "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TQC_PRESENT_SAMPLES model = new Mod_TQC_PRESENT_SAMPLES(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_PRESENT_SAMPLES model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_PRESENT_SAMPLES model) { return(dal.Add(model)); }
/// <summary> /// 接收制样 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_JS_CG_Click(object sender, EventArgs e) { try { bool IS_Success = true; string userID = RV.UI.UserInfo.userID; bool flag = true; if (string.IsNullOrEmpty(icbo_BC.Text.ToString()) || string.IsNullOrEmpty(icbo_BZ.Text.ToString())) { MessageBox.Show("请选择班次班组!"); return; } for (int i = 0; i < gv_SYXX.DataRowCount; i++) { string val = this.gv_SYXX.GetRowCellValue(i, this.gv_SYXX.Columns["chk"]).ToString(); if (val == "True") { string strID = gv_SYXX.GetRowCellValue(i, "取样主表主键").ToString(); int count = bllTqcPresentSamples.Get_JS_Count(strID, "0"); if (count > 0) { flag = false; MessageBox.Show("批号:" + gv_SYXX.GetRowCellValue(i, "批号").ToString() + " 钩号:" + gv_SYXX.GetRowCellValue(i, "钩号").ToString() + " 的数据已取消委托,不能执行接样操作!"); break; } int count2 = bllTqcPresentSamples.Get_JS_Count(strID, "1"); if (count2 > 0) { flag = false; MessageBox.Show("批号:" + gv_SYXX.GetRowCellValue(i, "批号").ToString() + " 钩号:" + gv_SYXX.GetRowCellValue(i, "钩号").ToString() + " 的数据明细未保存,不能执行接样操作!"); break; } } } if (!flag) { return; } ArrayList SQLStringList = new ArrayList(); for (int i = 0; i < gv_SYXX.DataRowCount; i++) { string val = this.gv_SYXX.GetRowCellValue(i, this.gv_SYXX.Columns["chk"]).ToString(); if (val == "True") { string strID = gv_SYXX.GetRowCellValue(i, "取样主表主键").ToString(); SQLStringList.Add(" update tqc_present_samples set N_ENTRUST_TYPE=3,C_EMP_ID_ZY='" + userID + "',D_MOD_DT_ZY=SYSDATE,C_BC_JY='" + icbo_BC.EditValue.ToString() + "',C_BZ_JY='" + icbo_BZ.EditValue.ToString() + "' where C_ID='" + strID + "' "); SQLStringList.Add(" update tqc_present_samples_jszx set N_ENTRUST_TYPE=0,D_MOD_DT=SYSDATE,C_EMP_ID_SY='" + userID + "',D_MOD_DT_SY=sysdate where C_ID='" + strID + "' "); Mod_TQC_PRESENT_SAMPLES mod = bllTqcPresentSamples.GetModel(strID); if (mod != null) { DataTable dt_GroupID = bllTqcPresentSamplesName.Get_PHYSICS_GROUP_ID(strID, "质控部").Tables[0]; if (dt_GroupID.Rows.Count > 0) { for (int kk = 0; kk < dt_GroupID.Rows.Count; kk++) { SQLStringList.Add(" insert into tqc_physics_result_main(C_BATCH_NO,C_TICK_NO,c_stl_grd,c_spec,c_emp_id,d_mod_dt,c_emp_id_zy,d_mod_dt_zy,c_emp_id_js,d_mod_dt_js,C_PHYSICS_GROUP_ID,C_CHECK_STATE,C_PRESENT_SAMPLES_ID)values('" + mod.C_BATCH_NO + "','" + mod.C_TICK_NO + "','" + mod.C_STL_GRD + "','" + mod.C_SPEC + "','" + mod.C_EMP_ID + "',to_date('" + mod.D_MOD_DT + "','yyyy-mm-dd hh24:mi:ss'),'" + userID + "',SYSDATE,'" + mod.C_EMP_ID_JS + "',to_date('" + mod.D_MOD_DT_JS + "','yyyy-mm-dd hh24:mi:ss'),'" + dt_GroupID.Rows[kk]["C_PHYSICS_GROUP_ID"].ToString() + "','0','" + strID + "' ) "); } } } } } if (IS_Success) { if (bllTqcPresentSamplesName.SaveSamp(SQLStringList)) { Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "生成制样信息");//添加操作日志 MessageBox.Show("保存成功!"); BindSYXX_CG(); BindJYXX_CG(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 添加送样 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_TJSY_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(icbo_BC.Text.ToString()) || string.IsNullOrEmpty(icbo_BZ.Text.ToString())) { MessageBox.Show("请选择班次班组!"); return; } DataRow dr = this.gv_SJXX.GetDataRow(this.gv_SJXX.FocusedRowHandle); for (int i = 0; i < gv_right.DataRowCount; i++) { string val = this.gv_right.GetRowCellValue(i, this.gv_right.Columns["chk"]).ToString(); if (val == "True") { string strSG = this.gv_right.GetRowCellValue(i, this.gv_right.Columns["strSG"]).ToString(); //首钩 string strCG = this.gv_right.GetRowCellValue(i, this.gv_right.Columns["strCG"]).ToString(); //次钩 string strT = this.gv_right.GetRowCellValue(i, this.gv_right.Columns["strT"]).ToString(); //头 string strW = this.gv_right.GetRowCellValue(i, this.gv_right.Columns["strW"]).ToString(); //尾 if (strT == "True" || strW == "True") { if (strT == "True") { Mod_TQC_PRESENT_SAMPLES model = new Mod_TQC_PRESENT_SAMPLES(); model.C_BATCH_NO = dr["C_BATCH_NO"].ToString(); model.C_STL_GRD = dr["C_STL_GRD"].ToString(); model.C_SPEC = dr["C_SPEC"].ToString(); model.N_ENTRUST_TYPE = 0; model.C_TICK_NO = gv_right.GetRowCellValue(i, "N_HOOK_NO").ToString() + "-T"; model.C_EMP_ID = RV.UI.UserInfo.userID; model.C_BC_SY = icbo_BC.EditValue.ToString(); model.C_BZ_SY = icbo_BZ.EditValue.ToString(); if (strSG == "True") { model.C_TICK_STATE = "2"; } else if (strCG == "True") { model.C_TICK_STATE = "1"; } else { model.C_TICK_STATE = "0"; model.N_SAMPLES_NUM = 1; } bllTqcPresentSamples.Add(model); } if (strW == "True") { Mod_TQC_PRESENT_SAMPLES model = new Mod_TQC_PRESENT_SAMPLES(); model.C_BATCH_NO = dr["C_BATCH_NO"].ToString(); model.C_STL_GRD = dr["C_STL_GRD"].ToString(); model.C_SPEC = dr["C_SPEC"].ToString(); model.N_ENTRUST_TYPE = 0; model.C_TICK_NO = gv_right.GetRowCellValue(i, "N_HOOK_NO").ToString() + "-W"; model.C_EMP_ID = RV.UI.UserInfo.userID; model.C_BC_SY = icbo_BC.EditValue.ToString(); model.C_BZ_SY = icbo_BZ.EditValue.ToString(); if (strSG == "True") { model.C_TICK_STATE = "2"; } else if (strCG == "True") { model.C_TICK_STATE = "1"; } else { model.C_TICK_STATE = "0"; model.N_SAMPLES_NUM = 1; } bllTqcPresentSamples.Add(model); } } else { Mod_TQC_PRESENT_SAMPLES model = new Mod_TQC_PRESENT_SAMPLES(); model.C_BATCH_NO = dr["C_BATCH_NO"].ToString(); model.C_STL_GRD = dr["C_STL_GRD"].ToString(); model.C_SPEC = dr["C_SPEC"].ToString(); model.N_ENTRUST_TYPE = 0; model.C_TICK_NO = gv_right.GetRowCellValue(i, "N_HOOK_NO").ToString(); model.C_EMP_ID = RV.UI.UserInfo.userID; model.C_BC_SY = icbo_BC.EditValue.ToString(); model.C_BZ_SY = icbo_BZ.EditValue.ToString(); if (strSG == "True") { model.C_TICK_STATE = "2"; } else if (strCG == "True") { model.C_TICK_STATE = "1"; } else { model.C_TICK_STATE = "0"; model.N_SAMPLES_NUM = 1; } bllTqcPresentSamples.Add(model); } } } BindSampling(); NewMethod1(); MessageBox.Show("添加成功!"); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加常规送样信息");//添加操作日志 } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 保存性能录入结果信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Save_Click(object sender, EventArgs e) { try { string userID = RV.UI.UserInfo.userID; int[] rownumber = gv_ZYXX.GetSelectedRows();//获取选中行号数组; if (rownumber.Length > 0) { ArrayList SQLStringList = new ArrayList(); for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string C_PRESENT_SAMPLES_ID = gv_ZYXX.GetRowCellValue(selectedHandle, "取样主表主键").ToString(); Mod_TQC_PRESENT_SAMPLES mod = bllTqcPresentSamples.GetModel(C_PRESENT_SAMPLES_ID); if (mod != null) { mod.C_EQ_NAME = gv_ZYXX.GetRowCellValue(selectedHandle, "设备信息").ToString(); bllTqcPresentSamples.Update(mod); } bllTqcPhysicsResult.Delete(str_PHYSICS_GROUP_ID, C_PRESENT_SAMPLES_ID); for (int k = 10; k < gv_ZYXX.Columns.Count; k++) { string strType = ""; if (dtXN.Rows[k - 10]["C_CODE"].ToString().Contains("000GCL")) { strType = "0"; } else { strType = "1"; } if (gv_ZYXX.GetRowCellValue(selectedHandle, gv_ZYXX.Columns[k].FieldName).ToString() != "") { SQLStringList.Add("insert into TQC_PHYSICS_RESULT(C_PHYSICS_GROUP_ID,C_PRESENT_SAMPLES_ID,C_CHARACTER_ID,C_CHARACTER_CODE,C_CHARACTER_NAME,C_VALUE,C_EMP_ID,N_TYPE)values('" + str_PHYSICS_GROUP_ID + "','" + C_PRESENT_SAMPLES_ID + "','" + dtXN.Rows[k - 10]["C_CHARACTER_ID"].ToString() + "','" + dtXN.Rows[k - 10]["C_CODE"].ToString() + "','" + gv_ZYXX.Columns[k].FieldName + "','" + gv_ZYXX.GetRowCellValue(selectedHandle, gv_ZYXX.Columns[k].FieldName).ToString() + "','" + userID + "','" + strType + "') "); } } } if (bllTqcPhysicsResult.SaveResult(SQLStringList)) { Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "保存性能信息");//添加操作日志 MessageBox.Show("保存成功!"); BindZYXX(); } } else { MessageBox.Show("请选择需要保存的信息!"); return; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 生成制样(常规 ) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Sure_CG_Click(object sender, EventArgs e) { try { bool IS_Success = true; string userID = RV.UI.UserInfo.userID; int[] rownumber = gv_SYXX.GetSelectedRows();//获取选中行号数组; if (rownumber.Length > 0) { ArrayList SQLStringList = new ArrayList(); for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = gv_SYXX.GetRowCellValue(selectedHandle, "取样主表主键").ToString(); SQLStringList.Add(" update tqc_present_samples_jszx set N_ENTRUST_TYPE=3,C_EMP_ID_ZY='" + userID + "',D_MOD_DT_ZY=SYSDATE where C_ID='" + strID + "' "); Mod_TQC_PRESENT_SAMPLES mod = bllTqcPresentSamples.GetModel(strID); if (mod != null) { DataTable dt_GroupID = bllTqcPresentSamplesName.Get_PHYSICS_GROUP_ID(strID, "技术中心").Tables[0]; if (dt_GroupID.Rows.Count > 0) { for (int kk = 0; kk < dt_GroupID.Rows.Count; kk++) { SQLStringList.Add(" insert into tqc_physics_result_main(C_BATCH_NO,C_TICK_NO,c_stl_grd,c_spec,c_emp_id,d_mod_dt,c_emp_id_zy,d_mod_dt_zy,c_emp_id_js,d_mod_dt_js,C_PHYSICS_GROUP_ID,C_CHECK_STATE)values('" + mod.C_BATCH_NO + "','" + mod.C_TICK_NO + "','" + mod.C_STL_GRD + "','" + mod.C_SPEC + "','" + mod.C_EMP_ID + "',to_date('" + mod.D_MOD_DT + "','yyyy-mm-dd hh24:mi:ss'),'" + userID + "',SYSDATE,'" + mod.C_EMP_ID_JS + "',to_date('" + mod.D_MOD_DT_JS + "','yyyy-mm-dd hh24:mi:ss'),'" + dt_GroupID.Rows[kk]["C_PHYSICS_GROUP_ID"].ToString() + "','0' ) "); } } else { MessageBox.Show("取样名称和性能分组没有匹配关系!"); IS_Success = false; } } } if (IS_Success) { if (bllTqcPresentSamplesName.SaveSamp(SQLStringList)) { Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "生成制样信息");//添加操作日志 MessageBox.Show("保存成功!"); BindSYXX_CG(); BindZYXX_CG(); } } } else { MessageBox.Show("请选择需要制样的信息!"); return; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_PRESENT_SAMPLES model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQC_PRESENT_SAMPLES("); strSql.Append(" C_BATCH_NO,C_TICK_NO,C_STL_GRD,C_SPEC,N_ENTRUST_TYPE,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_EMP_ID_ZY,D_MOD_DT_ZY,C_EMP_ID_JS,D_MOD_DT_JS,C_EQ_NAME,C_EQ_NUMBER,C_EQ_CODE,N_SAMPLES_NUM,C_TICK_STATE,C_BC_SY,C_BZ_SY,C_BC_JY,C_BZ_JY)"); strSql.Append(" values ("); strSql.Append(" :C_BATCH_NO,:C_TICK_NO,:C_STL_GRD,:C_SPEC,:N_ENTRUST_TYPE,:N_STATUS,:C_REMARK,:C_EMP_ID,:D_MOD_DT,:C_EMP_ID_ZY,:D_MOD_DT_ZY,:C_EMP_ID_JS,:D_MOD_DT_JS,:C_EQ_NAME,:C_EQ_NUMBER,:C_EQ_CODE,:N_SAMPLES_NUM,:C_TICK_STATE,:C_BC_SY,:C_BZ_SY,:C_BC_JY,:C_BZ_JY)"); OracleParameter[] parameters = { new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_TICK_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":N_ENTRUST_TYPE", OracleDbType.Decimal, 1), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_EMP_ID_ZY", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_ZY", OracleDbType.Date), new OracleParameter(":C_EMP_ID_JS", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_JS", OracleDbType.Date), new OracleParameter(":C_EQ_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_EQ_NUMBER", OracleDbType.Varchar2, 100), new OracleParameter(":C_EQ_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":N_SAMPLES_NUM", OracleDbType.Decimal, 5), new OracleParameter(":C_TICK_STATE", OracleDbType.Varchar2, 10), new OracleParameter(":C_BC_SY", OracleDbType.Varchar2, 10), new OracleParameter(":C_BZ_SY", OracleDbType.Varchar2, 10), new OracleParameter(":C_BC_JY", OracleDbType.Varchar2, 10), new OracleParameter(":C_BZ_JY", OracleDbType.Varchar2, 10) }; parameters[0].Value = model.C_BATCH_NO; parameters[1].Value = model.C_TICK_NO; parameters[2].Value = model.C_STL_GRD; parameters[3].Value = model.C_SPEC; parameters[4].Value = model.N_ENTRUST_TYPE; parameters[5].Value = model.N_STATUS; parameters[6].Value = model.C_REMARK; parameters[7].Value = model.C_EMP_ID; parameters[8].Value = model.D_MOD_DT; parameters[9].Value = model.C_EMP_ID_ZY; parameters[10].Value = model.D_MOD_DT_ZY; parameters[11].Value = model.C_EMP_ID_JS; parameters[12].Value = model.D_MOD_DT_JS; parameters[13].Value = model.C_EQ_NAME; parameters[14].Value = model.C_EQ_NUMBER; parameters[15].Value = model.C_EQ_CODE; parameters[16].Value = model.N_SAMPLES_NUM; parameters[17].Value = model.C_TICK_STATE; parameters[18].Value = model.C_BC_SY; parameters[19].Value = model.C_BZ_SY; parameters[20].Value = model.C_BC_JY; parameters[21].Value = model.C_BZ_JY; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_PRESENT_SAMPLES DataRowToModel(DataRow row) { Mod_TQC_PRESENT_SAMPLES model = new Mod_TQC_PRESENT_SAMPLES(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_BATCH_NO"] != null) { model.C_BATCH_NO = row["C_BATCH_NO"].ToString(); } if (row["C_TICK_NO"] != null) { model.C_TICK_NO = row["C_TICK_NO"].ToString(); } if (row["C_STL_GRD"] != null) { model.C_STL_GRD = row["C_STL_GRD"].ToString(); } if (row["C_SPEC"] != null) { model.C_SPEC = row["C_SPEC"].ToString(); } if (row["N_ENTRUST_TYPE"] != null && row["N_ENTRUST_TYPE"].ToString() != "") { model.N_ENTRUST_TYPE = decimal.Parse(row["N_ENTRUST_TYPE"].ToString()); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } if (row["C_EMP_ID"] != null) { model.C_EMP_ID = row["C_EMP_ID"].ToString(); } if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "") { model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString()); } if (row["C_EMP_ID_ZY"] != null) { model.C_EMP_ID_ZY = row["C_EMP_ID_ZY"].ToString(); } if (row["D_MOD_DT_ZY"] != null && row["D_MOD_DT_ZY"].ToString() != "") { model.D_MOD_DT_ZY = DateTime.Parse(row["D_MOD_DT_ZY"].ToString()); } if (row["C_EMP_ID_JS"] != null) { model.C_EMP_ID_JS = row["C_EMP_ID_JS"].ToString(); } if (row["D_MOD_DT_JS"] != null && row["D_MOD_DT_JS"].ToString() != "") { model.D_MOD_DT_JS = DateTime.Parse(row["D_MOD_DT_JS"].ToString()); } if (row["C_EQ_NAME"] != null) { model.C_EQ_NAME = row["C_EQ_NAME"].ToString(); } if (row["C_EQ_NUMBER"] != null) { model.C_EQ_NUMBER = row["C_EQ_NUMBER"].ToString(); } if (row["C_EQ_CODE"] != null) { model.C_EQ_CODE = row["C_EQ_CODE"].ToString(); } if (row["N_SAMPLES_NUM"] != null && row["N_SAMPLES_NUM"].ToString() != "") { model.N_SAMPLES_NUM = decimal.Parse(row["N_SAMPLES_NUM"].ToString()); } if (row["C_TICK_STATE"] != null) { model.C_TICK_STATE = row["C_TICK_STATE"].ToString(); } if (row["C_BC_SY"] != null) { model.C_BC_SY = row["C_BC_SY"].ToString(); } if (row["C_BZ_SY"] != null) { model.C_BZ_SY = row["C_BZ_SY"].ToString(); } if (row["C_BC_JY"] != null) { model.C_BC_JY = row["C_BC_JY"].ToString(); } if (row["C_BZ_JY"] != null) { model.C_BZ_JY = row["C_BZ_JY"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_PRESENT_SAMPLES model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQC_PRESENT_SAMPLES set "); strSql.Append("C_BATCH_NO=:C_BATCH_NO,"); strSql.Append("C_TICK_NO=:C_TICK_NO,"); strSql.Append("C_STL_GRD=:C_STL_GRD,"); strSql.Append("C_SPEC=:C_SPEC,"); strSql.Append("N_ENTRUST_TYPE=:N_ENTRUST_TYPE,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("D_MOD_DT=:D_MOD_DT,"); strSql.Append("C_EMP_ID_ZY=:C_EMP_ID_ZY,"); strSql.Append("D_MOD_DT_ZY=:D_MOD_DT_ZY,"); strSql.Append("C_EMP_ID_JS=:C_EMP_ID_JS,"); strSql.Append("D_MOD_DT_JS=:D_MOD_DT_JS,"); strSql.Append("C_EQ_NAME=:C_EQ_NAME,"); strSql.Append("C_EQ_NUMBER=:C_EQ_NUMBER,"); strSql.Append("C_EQ_CODE=:C_EQ_CODE,"); strSql.Append("N_SAMPLES_NUM=:N_SAMPLES_NUM,"); strSql.Append("C_TICK_STATE=:C_TICK_STATE,"); strSql.Append("C_BC_SY=:C_BC_SY,"); strSql.Append("C_BZ_SY=:C_BZ_SY,"); strSql.Append("C_BC_JY=:C_BC_JY,"); strSql.Append("C_BZ_JY=:C_BZ_JY"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_TICK_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":N_ENTRUST_TYPE", OracleDbType.Decimal, 1), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_EMP_ID_ZY", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_ZY", OracleDbType.Date), new OracleParameter(":C_EMP_ID_JS", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT_JS", OracleDbType.Date), new OracleParameter(":C_EQ_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_EQ_NUMBER", OracleDbType.Varchar2, 100), new OracleParameter(":C_EQ_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":N_SAMPLES_NUM", OracleDbType.Decimal, 5), new OracleParameter(":C_TICK_STATE", OracleDbType.Varchar2, 10), new OracleParameter(":C_BC_SY", OracleDbType.Varchar2, 10), new OracleParameter(":C_BZ_SY", OracleDbType.Varchar2, 10), new OracleParameter(":C_BC_JY", OracleDbType.Varchar2, 10), new OracleParameter(":C_BZ_JY", OracleDbType.Varchar2, 10), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_BATCH_NO; parameters[1].Value = model.C_TICK_NO; parameters[2].Value = model.C_STL_GRD; parameters[3].Value = model.C_SPEC; parameters[4].Value = model.N_ENTRUST_TYPE; parameters[5].Value = model.N_STATUS; parameters[6].Value = model.C_REMARK; parameters[7].Value = model.C_EMP_ID; parameters[8].Value = model.D_MOD_DT; parameters[9].Value = model.C_EMP_ID_ZY; parameters[10].Value = model.D_MOD_DT_ZY; parameters[11].Value = model.C_EMP_ID_JS; parameters[12].Value = model.D_MOD_DT_JS; parameters[13].Value = model.C_EQ_NAME; parameters[14].Value = model.C_EQ_NUMBER; parameters[15].Value = model.C_EQ_CODE; parameters[16].Value = model.N_SAMPLES_NUM; parameters[17].Value = model.C_TICK_STATE; parameters[18].Value = model.C_BC_SY; parameters[19].Value = model.C_BZ_SY; parameters[20].Value = model.C_BC_JY; parameters[21].Value = model.C_BZ_JY; parameters[22].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }