/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_UPD_MATERIAL_MAIN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQC_UPD_MATERIAL_MAIN("); strSql.Append("C_BATCH_NO,C_REMARK,N_STATUS,C_EMP_ID,D_MOD_DT)"); strSql.Append(" values ("); strSql.Append(":C_BATCH_NO,:C_REMARK,:N_STATUS,:C_EMP_ID,:D_MOD_DT)"); OracleParameter[] parameters = { new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date) }; parameters[0].Value = model.C_BATCH_NO; parameters[1].Value = model.C_REMARK; parameters[2].Value = model.N_STATUS; parameters[3].Value = model.C_EMP_ID; parameters[4].Value = model.D_MOD_DT; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_UPD_MATERIAL_MAIN DataRowToModel(DataRow row) { Mod_TQC_UPD_MATERIAL_MAIN model = new Mod_TQC_UPD_MATERIAL_MAIN(); 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_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].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()); } } return(model); }
/// <summary> /// 申请 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Apply_Click(object sender, EventArgs e) { try { DataRow dr = gv_SJXX.GetDataRow(this.gv_SJXX.FocusedRowHandle); if (dr == null) { return; } Mod_TQC_UPD_MATERIAL_MAIN mod = new Mod_TQC_UPD_MATERIAL_MAIN(); mod.C_BATCH_NO = dr["批号"].ToString(); mod.C_REMARK = txt_CZYJ.Text.Trim(); mod.C_EMP_ID = RV.UI.UserInfo.UserID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); #region 检测是否重复添加 System.Collections.Hashtable ht = new System.Collections.Hashtable(); ht.Add("C_BATCH_NO", mod.C_BATCH_NO); ht.Add("N_STATUS", 1); if (Common.CheckRepeat.CheckTable("TQC_UPD_MATERIAL_MAIN", ht) > 0) { if (DialogResult.OK != MessageBox.Show("该批号已申请'" + mod.C_BATCH_NO + "',是否确认继续申请!", "提示", MessageBoxButtons.OKCancel)) { return; } else { DataTable dt = bll_Update.GetList_CXXL(dr["批号"].ToString()).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { Mod_TQC_UPDATE_MATERIAL mod_update = bll_Update.GetModel(dt.Rows[i]["C_ID"].ToString()); mod_update.N_STATUS = 0; mod_update.C_EMP_ID = RV.UI.UserInfo.UserID; mod_update.D_MOD_DT = RV.UI.ServerTime.timeNow(); bll_Update.Update(mod_update); } } } #endregion if (bllUpdMain.Add(mod)) { Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加修料申请");//添加操作日志 MessageBox.Show("申请成功!"); Query(); Query1(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_UPD_MATERIAL_MAIN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQC_UPD_MATERIAL_MAIN set "); strSql.Append("C_BATCH_NO=:C_BATCH_NO,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("D_MOD_DT=:D_MOD_DT"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_BATCH_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_BATCH_NO; parameters[1].Value = model.C_REMARK; parameters[2].Value = model.N_STATUS; parameters[3].Value = model.C_EMP_ID; parameters[4].Value = model.D_MOD_DT; parameters[5].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_UPD_MATERIAL_MAIN GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_BATCH_NO,C_REMARK,N_STATUS,C_EMP_ID,D_MOD_DT from TQC_UPD_MATERIAL_MAIN "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TQC_UPD_MATERIAL_MAIN model = new Mod_TQC_UPD_MATERIAL_MAIN(); 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> /// <param name="sender"></param> /// <param name="e"></param> private void btn_FJSQ_Click(object sender, EventArgs e) { try { int result = 0; if (!int.TryParse(txt_Num.Text.Trim(), out result)) { MessageBox.Show("数量只能填写整数!"); return; } if (Convert.ToInt32(txt_Num.Text.Trim()) == 0) { MessageBox.Show("请输入取样数量!"); return; } if (image_Count.Text.Trim() == "") { MessageBox.Show("请选择复检次数!"); return; } DataRow dr = this.gv_SJXX.GetDataRow(this.gv_SJXX.FocusedRowHandle); DataRow dr_right = this.gv_right.GetDataRow(this.gv_right.FocusedRowHandle); if (dr == null) { return; } if (dr_right == null) { return; } int cou = bll_recheck.GetRecordCount(dr["C_BATCH_NO"].ToString()); if (cou > 0) { if (DialogResult.OK != MessageBox.Show("该批号已申请'" + cou + "'件,是否确认继续申请!", "提示", MessageBoxButtons.OKCancel)) { return; } } string strItemName = ""; DataTable dt = bll_item_result.Get_Item(dr["C_STOVE"].ToString(), dr["C_BATCH_NO"].ToString(), dr_right["C_CODE"].ToString()).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { Mod_TQC_COMPRE_ITEM_RESULT mod = bll_item_result.GetModel(dt.Rows[i]["C_ID"].ToString()); strItemName += mod.C_ITEM_NAME + ";"; } if (Convert.ToInt32(txt_Num.Text.Trim()) > 0) { for (int i = 0; i < Convert.ToInt32(txt_Num.Text.Trim()); i++) { Mod_TQC_RECHECK model = new Mod_TQC_RECHECK(); model.C_PHYSICS_CODE = dr_right["C_CODE"].ToString(); model.C_PHYSICS_NAME = dr_right["C_NAME"].ToString(); model.C_STOVE = dr["C_STOVE"].ToString(); 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.C_STD_CODE = dr["C_STD_CODE"].ToString(); model.C_ITEM_NAME = strItemName; model.C_SHIFT = imcbo_Shift.Text.Trim(); model.C_GROUP = imcbo_Group.Text.Trim(); model.C_DISPOSAL = txt_CLYJ.Text.Trim(); model.N_RECHECK = Convert.ToDecimal(image_Count.Text.Trim()); model.C_EMP_ID = RV.UI.UserInfo.userID; bll_recheck.Add(model); } Mod_TQC_UPD_MATERIAL_MAIN mod_UpdMaterial = new Mod_TQC_UPD_MATERIAL_MAIN(); mod_UpdMaterial.C_BATCH_NO = dr["C_BATCH_NO"].ToString(); mod_UpdMaterial.C_REMARK = txt_CLYJ.Text.Trim(); mod_UpdMaterial.C_EMP_ID = RV.UI.UserInfo.UserID; mod_UpdMaterial.D_MOD_DT = RV.UI.ServerTime.timeNow(); #region 检测是否重复添加 System.Collections.Hashtable ht = new System.Collections.Hashtable(); ht.Add("C_BATCH_NO", mod_UpdMaterial.C_BATCH_NO); ht.Add("N_STATUS", 1); if (Common.CheckRepeat.CheckTable("TQC_UPD_MATERIAL_MAIN", ht) > 0) { if (DialogResult.OK != MessageBox.Show(" 批号'" + mod_UpdMaterial.C_BATCH_NO + "'已申请修料,是否确认继续申请!", "提示", MessageBoxButtons.OKCancel)) { return; } else { DataTable dts = bll_Update.GetList_CXXL(dr["C_BATCH_NO"].ToString()).Tables[0]; for (int s = 0; s < dt.Rows.Count; s++) { Mod_TQC_UPDATE_MATERIAL mod_update = bll_Update.GetModel(dts.Rows[s]["C_ID"].ToString()); mod_update.N_STATUS = 0; mod_update.C_EMP_ID = RV.UI.UserInfo.UserID; mod_update.D_MOD_DT = RV.UI.ServerTime.timeNow(); bll_Update.Update(mod_update); } } } #endregion bllUpdMaterial.Add(mod_UpdMaterial); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加复检申请信息");//添加操作日志 Query_SQ(); MessageBox.Show("申请成功!"); txt_Num.Text = ""; image_Count.Text = ""; } else { MessageBox.Show("请选择需要申请的信息!"); return; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_UPD_MATERIAL_MAIN model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_UPD_MATERIAL_MAIN model) { return(dal.Add(model)); }
/// <summary> /// 库检申请 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_KJSQ_Click(object sender, EventArgs e) { try { int[] rownumber = gv_SJXX.GetSelectedRows();//获取选中行号数组; if (rownumber.Length == 0) { MessageBox.Show("请选择需要保存的信息!"); return; } DataRow row = gv_SJXX.GetDataRow(rownumber[0]); if (imgcbo_YYMC.EditValue == null) { MessageBox.Show("库检原因不能为空!", "提示"); return; } if (imgcbo_ZRBM.EditValue == null) { MessageBox.Show("责任单位不能为空!", "提示"); return; } if (imgcbo_CZYJ.EditValue == null) { MessageBox.Show("处置意见不能为空!", "提示"); return; } if (DialogResult.OK != MessageBox.Show("是否确认保存已选中的数据?", "提示", MessageBoxButtons.OKCancel)) { return; } for (int i = 0; i < rownumber.Length; i++) { DataRow dr = gv_SJXX.GetDataRow(rownumber[i]); if (dr["C_BATCH_NO"].ToString() != row["C_BATCH_NO"].ToString()) { MessageBox.Show("请选择相同的批号!"); return; } Mod_TQC_WAREHOUSE_CHECK_ROLL mod = new Mod_TQC_WAREHOUSE_CHECK_ROLL(); mod.C_ROLL_ID = dr["C_ID"].ToString(); mod.C_STOVE = dr["C_STOVE"].ToString(); mod.C_BATCH_NO = dr["C_BATCH_NO"].ToString(); mod.C_TICK_NO = dr["C_TICK_NO"].ToString(); mod.C_STL_GRD = dr["C_STL_GRD"].ToString(); mod.N_WGT = Convert.ToDecimal(dr["N_WGT"]); mod.C_STD_CODE = dr["C_STD_CODE"].ToString(); mod.C_SPEC = dr["C_SPEC"].ToString(); mod.C_MAT_CODE = dr["C_MAT_CODE"].ToString(); mod.C_MAT_NAME = dr["C_MAT_DESC"].ToString(); mod.D_WAREHOUSE_IN = Convert.ToDateTime(dr["D_MOD_DT"]); mod.C_SHIFT = dr["C_SHIFT"].ToString(); mod.C_GROUP = dr["C_GROUP"].ToString(); mod.C_REASON_NAME = imgcbo_YYMC.Text; mod.C_REASON_CODE = imgcbo_YYMC.EditValue.ToString(); mod.C_REASON_DEPMT_ID = imgcbo_ZRBM.Text; mod.C_REASON_DEPMT_DESC = imgcbo_ZRBM.Text; mod.C_SUGGESTION = imgcbo_CZYJ.Text; mod.C_REMARK = txt_Remark.Text; mod.C_EMP_ID = RV.UI.UserInfo.UserID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); if (bll_we_check_roll.Add(mod)) { Mod_TRC_ROLL_PRODCUT mod_roll = bll_TRC_Roll_Product.GetModel(dr["C_ID"].ToString()); mod_roll.C_IS_DEPOT = "Y"; bll_TRC_Roll_Product.Update(mod_roll); } } Mod_TQC_UPD_MATERIAL_MAIN mod_UpdMaterial = new Mod_TQC_UPD_MATERIAL_MAIN(); mod_UpdMaterial.C_BATCH_NO = row["C_BATCH_NO"].ToString(); mod_UpdMaterial.C_REMARK = txt_Remark.Text.Trim(); mod_UpdMaterial.C_EMP_ID = RV.UI.UserInfo.UserID; mod_UpdMaterial.D_MOD_DT = RV.UI.ServerTime.timeNow(); #region 检测是否重复添加 System.Collections.Hashtable ht = new System.Collections.Hashtable(); ht.Add("C_BATCH_NO", mod_UpdMaterial.C_BATCH_NO); ht.Add("N_STATUS", 1); if (Common.CheckRepeat.CheckTable("TQC_UPD_MATERIAL_MAIN", ht) > 0) { if (DialogResult.OK != MessageBox.Show(" 批号'" + mod_UpdMaterial.C_BATCH_NO + "'已申请修料,是否确认继续申请!", "提示", MessageBoxButtons.OKCancel)) { return; } else { DataTable dt = bll_Update.GetList_CXXL(row["C_BATCH_NO"].ToString()).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { Mod_TQC_UPDATE_MATERIAL mod_update = bll_Update.GetModel(dt.Rows[i]["C_ID"].ToString()); mod_update.N_STATUS = 0; mod_update.C_EMP_ID = RV.UI.UserInfo.UserID; mod_update.D_MOD_DT = RV.UI.ServerTime.timeNow(); bll_Update.Update(mod_update); } } } #endregion bllUpdMaterial.Add(mod_UpdMaterial); MessageBox.Show("申请成功!", "提示"); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "线材库检申请");//添加操作日志 btn_Query_Main_Click(null, null); btn_Query1_Click(null, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }