private void btn_Save_Click(object sender, EventArgs e) { try { Mod_TPB_STA_HISTORY_CAP mod = bll.GetModel(c_id); mod.C_PRO_ID = cbo_GX.EditValue.ToString(); mod.C_STA_ID = cbo_GW.EditValue.ToString(); mod.N_CAPACITY = Convert.ToDecimal(txt_cn.Text); mod.C_EMP_ID = RV.UI.UserInfo.UserID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); if (mod.N_CAPACITY == 0) { MessageBox.Show("保存失败!产能不能为空"); return; } bll.Update(mod); MessageBox.Show("保存成功!"); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "修改工位历史产能");//添加操作日志 this.DialogResult = DialogResult.Cancel; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FrmPB_GWLSCN_EDIT_Load(object sender, EventArgs e) { strMenuName = RV.UI.UserInfo.menuName; commonSub.ImageComboBoxEditBindGX("", cbo_GX, "'CC','ZL','LF','RH','ZX'");//绑定工序 Mod_TPB_STA_HISTORY_CAP mod = bll.GetModel(c_id); cbo_GX.EditValue = mod.C_PRO_ID; commonSub.ImageComboBoxEditBindGW(cbo_GX.EditValue.ToString(), cbo_GW);//绑定工位 cbo_GW.EditValue = mod.C_STA_ID; cbo_GX.Enabled = false; cbo_GW.Enabled = false; txt_cn.Text = mod.N_CAPACITY.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TPB_STA_HISTORY_CAP model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TPB_STA_HISTORY_CAP set "); strSql.Append("C_STA_ID=:C_STA_ID,"); strSql.Append("C_PRO_ID=:C_PRO_ID,"); strSql.Append("N_CAPACITY=:N_CAPACITY,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("D_MOD_DT=:D_MOD_DT,"); strSql.Append("C_REMARK=:C_REMARK"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_CAPACITY", OracleDbType.Decimal, 15), 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_REMARK", OracleDbType.Varchar2, 200), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_STA_ID; parameters[1].Value = model.C_PRO_ID; parameters[2].Value = model.N_CAPACITY; parameters[3].Value = model.N_STATUS; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.D_MOD_DT; parameters[6].Value = model.C_REMARK; parameters[7].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TPB_STA_HISTORY_CAP DataRowToModel(DataRow row) { Mod_TPB_STA_HISTORY_CAP model = new Mod_TPB_STA_HISTORY_CAP(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_STA_ID"] != null) { model.C_STA_ID = row["C_STA_ID"].ToString(); } if (row["C_PRO_ID"] != null) { model.C_PRO_ID = row["C_PRO_ID"].ToString(); } if (row["N_CAPACITY"] != null && row["N_CAPACITY"].ToString() != "") { model.N_CAPACITY = decimal.Parse(row["N_CAPACITY"].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()); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TPB_STA_HISTORY_CAP model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TPB_STA_HISTORY_CAP("); strSql.Append("C_STA_ID,C_PRO_ID,N_CAPACITY,N_STATUS,C_EMP_ID,D_MOD_DT,C_REMARK)"); strSql.Append(" values ("); strSql.Append(":C_STA_ID,:C_PRO_ID,:N_CAPACITY,:N_STATUS,:C_EMP_ID,:D_MOD_DT,:C_REMARK)"); OracleParameter[] parameters = { new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_PRO_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_CAPACITY", OracleDbType.Decimal, 15), 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_REMARK", OracleDbType.Varchar2, 200) }; parameters[0].Value = model.C_STA_ID; parameters[1].Value = model.C_PRO_ID; parameters[2].Value = model.N_CAPACITY; parameters[3].Value = model.N_STATUS; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.D_MOD_DT; parameters[6].Value = model.C_REMARK; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TPB_STA_HISTORY_CAP GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_STA_ID,C_PRO_ID,N_CAPACITY,N_STATUS,C_EMP_ID,D_MOD_DT,C_REMARK from TPB_STA_HISTORY_CAP "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TPB_STA_HISTORY_CAP model = new Mod_TPB_STA_HISTORY_CAP(); 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_Stop_Click(object sender, EventArgs e) { try { if (DialogResult.No == MessageBox.Show("是否确认删除?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } int[] row = gv_GWCN.GetSelectedRows(); foreach (var item in row) { DataRow dr = this.gv_GWCN.GetDataRow(item); Mod_TPB_STA_HISTORY_CAP mod = bll.GetModel(dr["C_ID"].ToString()); mod.N_STATUS = 0; bll.Update(mod); } Query(); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "删除工位历史产能");//添加操作日志 } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btn_save_Click(object sender, EventArgs e) { try { bool res = false; if (DialogResult.No == MessageBox.Show("是否确认添加记录?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } if (this.cbo_GX.EditValue == null) { MessageBox.Show("未选择工序!"); return; } if (this.cbo_GW.EditValue == null) { MessageBox.Show("未选择工位!"); return; } if (this.txt_cn.Text.Trim() == "" || this.txt_cn.Text.Trim() == "0") { MessageBox.Show("产能不能0或为空!"); return; } Mod_TPB_STA_HISTORY_CAP model = new Mod_TPB_STA_HISTORY_CAP(); model.C_PRO_ID = this.cbo_GX.EditValue.ToString(); model.C_STA_ID = this.cbo_GW.EditValue.ToString(); model.N_CAPACITY = Convert.ToDecimal(this.txt_cn.Text); model.C_EMP_ID = RV.UI.UserInfo.userID; #region 检测是否重复添加 System.Collections.Hashtable ht = new System.Collections.Hashtable(); ht.Add("C_STA_ID", model.C_STA_ID); ht.Add("N_STATUS", 1); if (Common.CheckRepeat.CheckTable("TPB_STA_HISTORY_CAP", ht) > 0) { MessageBox.Show("保存失败!存在该记录!"); return; } else { res = bll.Add(model); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加工位日产能");//添加操作日志 } #endregion if (res) { MessageBox.Show("操作成功!"); cbo_GX2.EditValue = cbo_GX.EditValue; Query(); } else { MessageBox.Show("操作失败!"); Query(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TPB_STA_HISTORY_CAP model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TPB_STA_HISTORY_CAP model) { return(dal.Add(model)); }