private bool AddLcp(string strMatCode) { Mod_TQB_GP_LCP_BASIS model = new Mod_TQB_GP_LCP_BASIS(); model.C_MAT_CODE_PLAN = str_Plan_Code; model.C_MAT_CODE_GP = strMatCode; return(bllTqbGpLcpBasis.Add(model)); }
/// <summary> /// 确定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_OK_Click(object sender, EventArgs e) { try { int[] rownumber = gv_Matrl.GetSelectedRows();//获取选中行号数组; if (rownumber.Length > 0) { for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; DataRow dr = gv_Matrl.GetDataRow(selectedHandle); if (dr != null) { bool IsExists = bllTqbGpLcpBasis.Exists(strPlanMatCode, dr["物料编码"].ToString(), dr["钢种"].ToString(), dr["执行标准"].ToString()); if (!IsExists) { Mod_TQB_GP_LCP_BASIS model = bllTqbGpLcpBasis.Get_Model(strPlanMatCode); if (model == null) { model = new Mod_TQB_GP_LCP_BASIS(); model.C_MAT_CODE_PLAN = strPlanMatCode; model.C_MAT_CODE_GP = dr["物料编码"].ToString(); model.C_STL_GRD = dr["钢种"].ToString(); model.C_STD_CODE = dr["执行标准"].ToString(); model.C_EMP_ID = RV.UI.UserInfo.userID; bllTqbGpLcpBasis.Add(model); } else { model.C_MAT_CODE_PLAN = strPlanMatCode; model.C_MAT_CODE_GP = dr["物料编码"].ToString(); model.C_STL_GRD = dr["钢种"].ToString(); model.C_STD_CODE = dr["执行标准"].ToString(); model.C_EMP_ID = RV.UI.UserInfo.userID; bllTqbGpLcpBasis.Update(model); } } } } DialogResult = DialogResult.OK; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQB_GP_LCP_BASIS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQB_GP_LCP_BASIS set "); strSql.Append("C_MAT_CODE_PLAN=:C_MAT_CODE_PLAN,"); strSql.Append("C_MAT_CODE_GP=:C_MAT_CODE_GP,"); 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("N_SORT=:N_SORT,"); strSql.Append("C_STL_GRD=:C_STL_GRD,"); strSql.Append("C_STD_CODE=:C_STD_CODE"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_MAT_CODE_PLAN", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_CODE_GP", OracleDbType.Varchar2, 100), 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(":N_SORT", OracleDbType.Decimal, 5), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_MAT_CODE_PLAN; parameters[1].Value = model.C_MAT_CODE_GP; parameters[2].Value = model.N_STATUS; parameters[3].Value = model.C_REMARK; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.D_MOD_DT; parameters[6].Value = model.N_SORT; parameters[7].Value = model.C_STL_GRD; parameters[8].Value = model.C_STD_CODE; parameters[9].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQB_GP_LCP_BASIS DataRowToModel(DataRow row) { Mod_TQB_GP_LCP_BASIS model = new Mod_TQB_GP_LCP_BASIS(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_MAT_CODE_PLAN"] != null) { model.C_MAT_CODE_PLAN = row["C_MAT_CODE_PLAN"].ToString(); } if (row["C_MAT_CODE_GP"] != null) { model.C_MAT_CODE_GP = row["C_MAT_CODE_GP"].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["N_SORT"] != null && row["N_SORT"].ToString() != "") { model.N_SORT = decimal.Parse(row["N_SORT"].ToString()); } if (row["C_STL_GRD"] != null) { model.C_STL_GRD = row["C_STL_GRD"].ToString(); } if (row["C_STD_CODE"] != null) { model.C_STD_CODE = row["C_STD_CODE"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQB_GP_LCP_BASIS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQB_GP_LCP_BASIS("); strSql.Append("C_MAT_CODE_PLAN,C_MAT_CODE_GP,N_STATUS,C_REMARK,C_EMP_ID,N_SORT,C_STL_GRD,C_STD_CODE)"); strSql.Append(" values ("); strSql.Append(":C_MAT_CODE_PLAN,:C_MAT_CODE_GP,:N_STATUS,:C_REMARK,:C_EMP_ID,:N_SORT,:C_STL_GRD,:C_STD_CODE)"); OracleParameter[] parameters = { new OracleParameter(":C_MAT_CODE_PLAN", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_CODE_GP", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_SORT", OracleDbType.Decimal, 5), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_MAT_CODE_PLAN; parameters[1].Value = model.C_MAT_CODE_GP; parameters[2].Value = model.N_STATUS; parameters[3].Value = model.C_REMARK; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.N_SORT; parameters[6].Value = model.C_STL_GRD; parameters[7].Value = model.C_STD_CODE; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQB_GP_LCP_BASIS Get_Model(string C_MAT_CODE_PLAN) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_MAT_CODE_PLAN,C_MAT_CODE_GP,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,N_SORT,C_STL_GRD,C_STD_CODE from TQB_GP_LCP_BASIS "); strSql.Append(" where C_MAT_CODE_PLAN=:C_MAT_CODE_PLAN and C_MAT_CODE_GP is null and rownum=1 "); OracleParameter[] parameters = { new OracleParameter(":C_MAT_CODE_PLAN", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_MAT_CODE_PLAN; Mod_TQB_GP_LCP_BASIS model = new Mod_TQB_GP_LCP_BASIS(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void btn_Add_Click(object sender, EventArgs e) { try { FrmQB_SELECT_WL frm = new FrmQB_SELECT_WL(); if (frm.ShowDialog() == DialogResult.OK) { string str_Mat_Code = frm.mat_code; frm.Close(); bool IsExists = bllTqbGpLcpBasis.Exists(str_Mat_Code); if (IsExists) { MessageBox.Show("该物料已存在!"); } else { Mod_TQB_GP_LCP_BASIS model = new Mod_TQB_GP_LCP_BASIS(); model.C_MAT_CODE_PLAN = str_Mat_Code; model.C_EMP_ID = RV.UI.UserInfo.userID; if (bllTqbGpLcpBasis.Add(model)) { MessageBox.Show("添加成功!"); BindPlanInfo(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQB_GP_LCP_BASIS model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQB_GP_LCP_BASIS model) { return(dal.Add(model)); }