/// <summary> /// 获取铁水标准列表焦点行信息 /// </summary> public void BindFocusedRowMain() { int selectedHandle = this.gv_tsbz_main.FocusedRowHandle;//获取焦点行索引 if (selectedHandle < 0) { this.lbl_tsbz_main_id.Text = ""; this.groupControl2.Text = "标准成分"; return; } this.lbl_tsbz_main_id.Text = this.gv_tsbz_main.GetRowCellValue(selectedHandle, "C_ID").ToString();//获取焦点行主键 //根据主键得到铁水标准对象,并在界面赋值 Mod_TQB_TSBZ_MAIN model = bllTsbz_Main.GetModel(this.lbl_tsbz_main_id.Text); this.txt_prod_kind.Text = model.C_PROD_KIND; this.cbo_stl_grd.Text = model.C_STL_GRD; this.cbo_std_code.Text = model.C_XY_CODE; this.cbo_route.Text = model.C_ROUTE; if (model.C_IS_OFTEN == "1") { this.rbtn_iscy.SelectedIndex = 0; } else { this.rbtn_iscy.SelectedIndex = 1; } this.txt_bzjb.Text = model.C_REMARK_JB; this.txt_remark_mian.Text = model.C_REMARK; this.groupControl2.Text = "标准成分:" + this.cbo_stl_grd.Text + "(" + this.cbo_std_code.Text + ")"; //加载成分信息 BindCF(this.lbl_tsbz_main_id.Text, this.rbtn_isty_cf.SelectedIndex == 0 ? 1 : 0); }
/// <summary> /// 导入Excle模板数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_import_Click(object sender, EventArgs e) { try { // DataTable dt = OpenExcelFile(this.txtUrl.Text, "Sheet2"); DataTable dt = ReadExcel(this.txtUrl.Text); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string strGUID = System.Guid.NewGuid().ToString(); Mod_TQB_TSBZ_MAIN model = new Mod_TQB_TSBZ_MAIN(); model.C_ID = strGUID; //主键 model.C_PROD_KIND = dt.Rows[i][0].ToString(); //钢种分类 model.C_STL_GRD = dt.Rows[i][1].ToString(); //钢种 model.C_XY_CODE = dt.Rows[i][2].ToString(); //协议号 model.C_ROUTE = dt.Rows[i][3].ToString(); //工艺 model.C_REMARK = dt.Rows[i][4].ToString(); //备注 model.C_IS_OFTEN = dt.Rows[i][5].ToString(); //是否常用 //model.C_REMARK_JB = dt.Rows[i][6].ToString();//备注级别 model.C_EMP_ID = dt.Rows[i][6].ToString(); //负责人 bool res = bllTsbz_Main.Add(model); if (res) { for (int j = 7; j < 27; j++)//成分信息 { string nvalue = dt.Rows[i][j].ToString().Trim().Replace("-", ""); if (nvalue != "") { string itemName = dt.Columns[j].ColumnName; Mod_TQB_TSBZ_CF modcf = new Mod_TQB_TSBZ_CF(); // modcf.C_TSBZ_MAIN_ID = strGUID; modcf.C_EMP_ID = RV.UI.UserInfo.userName; modcf.C_NAME = itemName; try { modcf.N_TARGET_VALUE = Convert.ToDecimal(nvalue); } catch (Exception) { modcf.N_TARGET_VALUE = -1; } bool rescf = bllTsbz_CF.Add(modcf); } } } } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQB_TSBZ_MAIN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQB_TSBZ_MAIN("); strSql.Append("C_ID,C_XY_CODE,C_XY_DESC,C_STL_GRD,C_PROD_NAME,C_PROD_KIND,C_ROUTE,C_EDITION,N_IS_CHECK,C_REMARK,C_EMP_ID,C_IS_OFTEN,C_REMARK_JB,N_EDIT_NUM)"); strSql.Append(" values ("); strSql.Append(":C_ID,:C_XY_CODE,:C_XY_DESC,:C_STL_GRD,:C_PROD_NAME,:C_PROD_KIND,:C_ROUTE,:C_EDITION,:N_IS_CHECK,:C_REMARK,:C_EMP_ID,:C_IS_OFTEN,:C_REMARK_JB,:N_EDIT_NUM)"); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_XY_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_XY_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_PROD_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_PROD_KIND", OracleDbType.Varchar2, 100), new OracleParameter(":C_ROUTE", OracleDbType.Varchar2, 100), new OracleParameter(":C_EDITION", OracleDbType.Varchar2, 100), new OracleParameter(":N_IS_CHECK", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_IS_OFTEN", OracleDbType.Varchar2, 100), new OracleParameter(":C_REMARK_JB", OracleDbType.Varchar2, 100), new OracleParameter(":N_EDIT_NUM", OracleDbType.Decimal, 5) }; parameters[0].Value = model.C_ID; parameters[1].Value = model.C_XY_CODE; parameters[2].Value = model.C_XY_DESC; parameters[3].Value = model.C_STL_GRD; parameters[4].Value = model.C_PROD_NAME; parameters[5].Value = model.C_PROD_KIND; parameters[6].Value = model.C_ROUTE; parameters[7].Value = model.C_EDITION; parameters[8].Value = model.N_IS_CHECK; parameters[9].Value = model.C_REMARK; parameters[10].Value = model.C_EMP_ID; parameters[11].Value = model.C_IS_OFTEN; parameters[12].Value = model.C_REMARK_JB; parameters[13].Value = model.N_EDIT_NUM; 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_Stop_main_Click(object sender, EventArgs e) { try { if (DialogResult.No == MessageBox.Show("是否确认停用选中的数据?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } int selectedNum = this.gv_tsbz_main.SelectedRowsCount; int commitNum = 0; //停用记录数量 int failtNum = 0; //停用失败数量 int[] rownumber = this.gv_tsbz_main.GetSelectedRows(); //获取选中行号数组; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = this.gv_tsbz_main.GetRowCellValue(selectedHandle, "C_ID").ToString(); Mod_TQB_TSBZ_MAIN model = bllTsbz_Main.GetModel(strID); model.N_STATUS = 0; model.C_EMP_ID = RV.UI.UserInfo.userID; model.D_MOD_DT = RV.UI.ServerTime.timeNow(); bool update = bllTsbz_Main.Update(model); if (update) { commitNum = commitNum + 1; } else { failtNum = failtNum + 1; } } MessageBox.Show("选择" + selectedNum.ToString() + "条记录,停用" + commitNum.ToString() + "条记录!"); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "停用铁水条件信息");//添加操作日志 btn_query_main_Click(null, null); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQB_TSBZ_MAIN GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_XY_CODE,C_XY_DESC,C_STL_GRD,C_PROD_NAME,C_PROD_KIND,C_ROUTE,C_EDITION,N_IS_CHECK,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT,C_IS_OFTEN,C_REMARK_JB,N_EDIT_NUM from TQB_TSBZ_MAIN "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TQB_TSBZ_MAIN model = new Mod_TQB_TSBZ_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> public bool Update(Mod_TQB_TSBZ_MAIN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQB_TSBZ_MAIN set "); strSql.Append("C_XY_CODE=:C_XY_CODE,"); strSql.Append("C_XY_DESC=:C_XY_DESC,"); strSql.Append("C_STL_GRD=:C_STL_GRD,"); strSql.Append("C_PROD_NAME=:C_PROD_NAME,"); strSql.Append("C_PROD_KIND=:C_PROD_KIND,"); strSql.Append("C_ROUTE=:C_ROUTE,"); strSql.Append("C_EDITION=:C_EDITION,"); strSql.Append("N_IS_CHECK=:N_IS_CHECK,"); 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_IS_OFTEN=:C_IS_OFTEN,"); strSql.Append("C_REMARK_JB=:C_REMARK_JB,"); strSql.Append("N_EDIT_NUM=:N_EDIT_NUM"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_XY_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_XY_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_PROD_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_PROD_KIND", OracleDbType.Varchar2, 100), new OracleParameter(":C_ROUTE", OracleDbType.Varchar2, 100), new OracleParameter(":C_EDITION", OracleDbType.Varchar2, 100), new OracleParameter(":N_IS_CHECK", 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_IS_OFTEN", OracleDbType.Varchar2, 100), new OracleParameter(":C_REMARK_JB", OracleDbType.Varchar2, 100), new OracleParameter(":N_EDIT_NUM", OracleDbType.Decimal, 5), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_XY_CODE; parameters[1].Value = model.C_XY_DESC; parameters[2].Value = model.C_STL_GRD; parameters[3].Value = model.C_PROD_NAME; parameters[4].Value = model.C_PROD_KIND; parameters[5].Value = model.C_ROUTE; parameters[6].Value = model.C_EDITION; parameters[7].Value = model.N_IS_CHECK; parameters[8].Value = model.N_STATUS; parameters[9].Value = model.C_REMARK; parameters[10].Value = model.C_EMP_ID; parameters[11].Value = model.D_MOD_DT; parameters[12].Value = model.C_IS_OFTEN; parameters[13].Value = model.C_REMARK_JB; parameters[14].Value = model.N_EDIT_NUM; parameters[15].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TQB_TSBZ_MAIN DataRowToModel(DataRow row) { Mod_TQB_TSBZ_MAIN model = new Mod_TQB_TSBZ_MAIN(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_XY_CODE"] != null) { model.C_XY_CODE = row["C_XY_CODE"].ToString(); } if (row["C_XY_DESC"] != null) { model.C_XY_DESC = row["C_XY_DESC"].ToString(); } if (row["C_STL_GRD"] != null) { model.C_STL_GRD = row["C_STL_GRD"].ToString(); } if (row["C_PROD_NAME"] != null) { model.C_PROD_NAME = row["C_PROD_NAME"].ToString(); } if (row["C_PROD_KIND"] != null) { model.C_PROD_KIND = row["C_PROD_KIND"].ToString(); } if (row["C_ROUTE"] != null) { model.C_ROUTE = row["C_ROUTE"].ToString(); } if (row["C_EDITION"] != null) { model.C_EDITION = row["C_EDITION"].ToString(); } if (row["N_IS_CHECK"] != null && row["N_IS_CHECK"].ToString() != "") { model.N_IS_CHECK = decimal.Parse(row["N_IS_CHECK"].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_IS_OFTEN"] != null) { model.C_IS_OFTEN = row["C_IS_OFTEN"].ToString(); } if (row["C_REMARK_JB"] != null) { model.C_REMARK_JB = row["C_REMARK_JB"].ToString(); } if (row["N_EDIT_NUM"] != null && row["N_EDIT_NUM"].ToString() != "") { model.N_EDIT_NUM = decimal.Parse(row["N_EDIT_NUM"].ToString()); } } return(model); }
/// <summary> /// 保存信息主表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_save_main_Click(object sender, EventArgs e) { try { #region 验证信息 if (this.txt_prod_kind.Text.Trim().Length == 0) { MessageBox.Show("请输入钢种分类!"); this.txt_prod_kind.Focus(); return; } if (this.cbo_stl_grd.Text.Trim().Length == 0) { MessageBox.Show("请选择检钢种!"); this.cbo_stl_grd.Focus(); return; } if (this.cbo_std_code.Text.Trim().Length == 0) { MessageBox.Show("请选择协议号!"); this.cbo_std_code.Focus(); return; } if (this.cbo_route.Text.Trim() == "") { MessageBox.Show("请选择生产工艺!"); this.cbo_route.Focus(); return; } #endregion bool res = false; if (this.lbl_tsbz_main_id.Text == "") { if (DialogResult.No == MessageBox.Show("是否确认添加记录?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } Mod_TQB_TSBZ_MAIN model = new Mod_TQB_TSBZ_MAIN(); model.C_PROD_KIND = this.txt_prod_kind.Text; model.C_STL_GRD = this.cbo_stl_grd.Text; model.C_XY_CODE = this.cbo_std_code.Text; model.C_ROUTE = this.cbo_route.Text; if (this.rbtn_iscy.SelectedIndex == 0) { model.C_IS_OFTEN = "1"; } else { model.C_IS_OFTEN = "2"; } model.C_REMARK_JB = this.txt_bzjb.Text; model.C_REMARK = this.txt_remark_mian.Text; model.C_EMP_ID = RV.UI.UserInfo.userID; res = bllTsbz_Main.Add(model); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加铁水条件信息");//添加操作日志 } else { if (DialogResult.No == MessageBox.Show("是否确认编辑选中的记录?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } Mod_TQB_TSBZ_MAIN model = bllTsbz_Main.GetModel(this.lbl_tsbz_main_id.Text); model.C_PROD_KIND = this.txt_prod_kind.Text; model.C_STL_GRD = this.cbo_stl_grd.Text; model.C_XY_CODE = this.cbo_std_code.Text; model.C_ROUTE = this.cbo_route.Text; if (this.rbtn_iscy.SelectedIndex == 0) { model.C_IS_OFTEN = "1"; } else { model.C_IS_OFTEN = "2"; } model.C_REMARK_JB = this.txt_bzjb.Text; model.C_REMARK = this.txt_remark_mian.Text; model.C_EMP_ID = RV.UI.UserInfo.userID; model.D_MOD_DT = RV.UI.ServerTime.timeNow(); res = bllTsbz_Main.Update(model); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "修改铁水条件信息");//添加操作日志 } if (res) { MessageBox.Show("操作成功!"); btn_query_main_Click(null, null); btn_Reset_main_Click(null, null);//清空控件 } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQB_TSBZ_MAIN model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQB_TSBZ_MAIN model) { return(dal.Add(model)); }