/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_ROOL_CHECK_AFFIRM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQC_ROOL_CHECK_AFFIRM("); strSql.Append("C_WE_CHECK_ROOL_ID,C_SUGGESTION,N_STATUS,C_REMARK,C_CHECK_EMP_ID,D_CHECK_DT)"); strSql.Append(" values ("); strSql.Append(":C_WE_CHECK_ROOL_ID,:C_SUGGESTION,:N_STATUS,:C_REMARK,:C_CHECK_EMP_ID,:D_CHECK_DT)"); OracleParameter[] parameters = { new OracleParameter(":C_WE_CHECK_ROOL_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_SUGGESTION", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_CHECK_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_CHECK_DT", OracleDbType.Date) }; parameters[0].Value = model.C_WE_CHECK_ROOL_ID; parameters[1].Value = model.C_SUGGESTION; parameters[2].Value = model.N_STATUS; parameters[3].Value = model.C_REMARK; parameters[4].Value = model.C_CHECK_EMP_ID; parameters[5].Value = model.D_CHECK_DT; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 库检确认 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_OK_Click(object sender, EventArgs e) { try { DataRow dr = this.gv_PDJG.GetDataRow(this.gv_PDJG.FocusedRowHandle); if (dr == null) { MessageBox.Show("请选择要确认的库检信息!", "提示"); return; } if (dr["C_CHECK_EMP_ID"].ToString() != "") { MessageBox.Show("请勿重复确认!", "提示"); return; } if (imgcbo_HGZT.Text.Trim() == "") { MessageBox.Show("请选择是否合格!", "提示"); return; } DialogResult dialogResult = MessageBox.Show("是否确认\n批号:'" + dr["C_BATCH_NO"].ToString() + "'", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dialogResult == DialogResult.OK)//如果点击“确定”按钮 { Mod_TQC_ROOL_CHECK_AFFIRM mod = new Mod_TQC_ROOL_CHECK_AFFIRM(); mod.C_WE_CHECK_ROOL_ID = dr["C_ID"].ToString(); mod.C_SUGGESTION = txt_SHYJ.Text; mod.C_CHECK_EMP_ID = RV.UI.UserInfo.UserID; mod.D_CHECK_DT = RV.UI.ServerTime.timeNow(); if (bll_affirm.Add(mod)) { Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "确认线材库检信息");//添加操作日志 ClearContent.ClearFlowLayoutPanel(panelControl1.Controls); Mod_TQC_WAREHOUSE_CHECK_ROLL mod_roll = bll_roll.GetModel(dr["C_ID"].ToString()); mod_roll.C_CHECK_EMP_ID = RV.UI.UserInfo.UserID; mod_roll.D_CHECK_DT = RV.UI.ServerTime.timeNow(); if (bll_roll.Update(mod_roll)) { Mod_TRC_ROLL_PRODCUT mod_Product = bllProduct.GetModel(mod_roll.C_ROLL_ID); mod_Product.C_DEPOT_TYPE = imgcbo_HGZT.Text.Trim(); bllProduct.Update(mod_Product); btn_Query1_Click(null, null); } MessageBox.Show("已确认!", "提示"); } } else//如果点击“取消”按钮 { return; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQC_ROOL_CHECK_AFFIRM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQC_ROOL_CHECK_AFFIRM set "); strSql.Append("C_WE_CHECK_ROOL_ID=:C_WE_CHECK_ROOL_ID,"); strSql.Append("C_SUGGESTION=:C_SUGGESTION,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_CHECK_EMP_ID=:C_CHECK_EMP_ID,"); strSql.Append("D_CHECK_DT=:D_CHECK_DT"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_WE_CHECK_ROOL_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_SUGGESTION", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_CHECK_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_CHECK_DT", OracleDbType.Date), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_WE_CHECK_ROOL_ID; parameters[1].Value = model.C_SUGGESTION; parameters[2].Value = model.N_STATUS; parameters[3].Value = model.C_REMARK; parameters[4].Value = model.C_CHECK_EMP_ID; parameters[5].Value = model.D_CHECK_DT; parameters[6].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_ROOL_CHECK_AFFIRM DataRowToModel(DataRow row) { Mod_TQC_ROOL_CHECK_AFFIRM model = new Mod_TQC_ROOL_CHECK_AFFIRM(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_WE_CHECK_ROOL_ID"] != null) { model.C_WE_CHECK_ROOL_ID = row["C_WE_CHECK_ROOL_ID"].ToString(); } if (row["C_SUGGESTION"] != null) { model.C_SUGGESTION = row["C_SUGGESTION"].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_CHECK_EMP_ID"] != null) { model.C_CHECK_EMP_ID = row["C_CHECK_EMP_ID"].ToString(); } if (row["D_CHECK_DT"] != null && row["D_CHECK_DT"].ToString() != "") { model.D_CHECK_DT = DateTime.Parse(row["D_CHECK_DT"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQC_ROOL_CHECK_AFFIRM GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_WE_CHECK_ROOL_ID,C_SUGGESTION,N_STATUS,C_REMARK,C_CHECK_EMP_ID,D_CHECK_DT from TQC_ROOL_CHECK_AFFIRM "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TQC_ROOL_CHECK_AFFIRM model = new Mod_TQC_ROOL_CHECK_AFFIRM(); 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_ROOL_CHECK_AFFIRM model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQC_ROOL_CHECK_AFFIRM model) { return(dal.Add(model)); }