/// <summary> /// 根据钢种、执行标准、合金名称得到实体对象 /// </summary> /// <param name="C_STL_GRD">钢种</param> /// <param name="C_STD_CODE">执行标准</param> /// <param name="C_ALLOYN__CODE">合金代码</param> /// <param name="C_ALLOYN__NAME">合金名称</param> /// <returns></returns> public Mod_TQB_ALLOY_CONSUMPTION GetModel(string C_STL_GRD, string C_STD_CODE, string C_ALLOYN__CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_STL_GRD,C_STD_CODE,C_ALLOYN__NAME,N_ALLOY_WGT,N_STATUS,C_EMP_ID,D_MOD_DT,C_REMARK,C_ALLOYN__CODE from TQB_ALLOY_CONSUMPTION "); strSql.Append(" where C_STL_GRD=:C_STL_GRD and C_STD_CODE=:C_STD_CODE and C_ALLOYN__CODE=:C_ALLOYN__CODE "); OracleParameter[] parameters = { new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_ALLOYN__CODE", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_STL_GRD; parameters[1].Value = C_STD_CODE; parameters[2].Value = C_ALLOYN__CODE; Mod_TQB_ALLOY_CONSUMPTION model = new Mod_TQB_ALLOY_CONSUMPTION(); 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 simpleButton2_Click(object sender, EventArgs e) { try { if (DialogResult.No == MessageBox.Show("是否确认删除选中的数据?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } int selectedNum = this.gridView1.SelectedRowsCount; int commitNum = 0;//删除记录数量 int cannotNum = 0;//不能删除记录数量 int failtNum = 0;//删除失败数量 int[] rownumber = this.gridView1.GetSelectedRows();//获取选中行号数组; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = this.gridView1.GetRowCellValue(selectedHandle, "C_ID").ToString(); Mod_TQB_ALLOY_CONSUMPTION model = bll_hjxh.GetModel(strID); model.N_STATUS = 0; model.C_EMP_ID = RV.UI.UserInfo.userID; model.D_MOD_DT = RV.UI.ServerTime.timeNow(); bool update = bll_hjxh.Update(model); if (update) { commitNum = commitNum + 1; } else { failtNum = failtNum + 1; } } if (selectedNum == 0) { MessageBox.Show("未选中需要删除的数据!"); } else { MessageBox.Show("选择" + selectedNum.ToString() + "条记录,删除" + commitNum.ToString() + "条记录!"); } Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "删除钢种合金信息");//添加操作日志 btn_query_hj_Click(null, null); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQB_ALLOY_CONSUMPTION model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TQB_ALLOY_CONSUMPTION set "); strSql.Append("C_STL_GRD=:C_STL_GRD,"); strSql.Append("C_STD_CODE=:C_STD_CODE,"); strSql.Append("C_ALLOYN__NAME=:C_ALLOYN__NAME,"); strSql.Append("N_ALLOY_WGT=:N_ALLOY_WGT,"); 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("C_ALLOYN__CODE=:C_ALLOYN__CODE"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_ALLOYN__NAME", OracleDbType.Varchar2, 100), new OracleParameter(":N_ALLOY_WGT", OracleDbType.Decimal), new OracleParameter(":N_STATUS", OracleDbType.Decimal), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_ALLOYN__CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_STL_GRD; parameters[1].Value = model.C_STD_CODE; parameters[2].Value = model.C_ALLOYN__NAME; parameters[3].Value = model.N_ALLOY_WGT; parameters[4].Value = model.N_STATUS; parameters[5].Value = model.C_EMP_ID; parameters[6].Value = model.D_MOD_DT; parameters[7].Value = model.C_REMARK; parameters[8].Value = model.C_ALLOYN__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_ALLOY_CONSUMPTION DataRowToModel(DataRow row) { Mod_TQB_ALLOY_CONSUMPTION model = new Mod_TQB_ALLOY_CONSUMPTION(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].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(); } if (row["C_ALLOYN__NAME"] != null) { model.C_ALLOYN__NAME = row["C_ALLOYN__NAME"].ToString(); } if (row["C_ALLOYN__CODE"] != null) { model.C_ALLOYN__CODE = row["C_ALLOYN__CODE"].ToString(); } if (row["N_ALLOY_WGT"] != null && row["N_ALLOY_WGT"].ToString() != "") { model.N_ALLOY_WGT = decimal.Parse(row["N_ALLOY_WGT"].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_TQB_ALLOY_CONSUMPTION model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TQB_ALLOY_CONSUMPTION("); strSql.Append("C_STL_GRD,C_STD_CODE,C_ALLOYN__NAME,N_ALLOY_WGT,N_STATUS,C_EMP_ID,D_MOD_DT,C_REMARK,C_ALLOYN__CODE)"); strSql.Append(" values ("); strSql.Append(":C_STL_GRD,:C_STD_CODE,:C_ALLOYN__NAME,:N_ALLOY_WGT,:N_STATUS,:C_EMP_ID,:D_MOD_DT,:C_REMARK,:C_ALLOYN__CODE)"); OracleParameter[] parameters = { new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_ALLOYN__NAME", OracleDbType.Varchar2, 100), new OracleParameter(":N_ALLOY_WGT", OracleDbType.Decimal), new OracleParameter(":N_STATUS", OracleDbType.Decimal), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_ALLOYN__CODE", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_STL_GRD; parameters[1].Value = model.C_STD_CODE; parameters[2].Value = model.C_ALLOYN__NAME; parameters[3].Value = model.N_ALLOY_WGT; parameters[4].Value = model.N_STATUS; parameters[5].Value = model.C_EMP_ID; parameters[6].Value = model.D_MOD_DT; parameters[7].Value = model.C_REMARK; parameters[8].Value = model.C_ALLOYN__CODE; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void btn_import_Click(object sender, EventArgs e) { try { if (this.txtUrl.Text.Trim().Length == 0) { MessageBox.Show("请选择需要导入的文件!"); return; } Workbook book = new Workbook(this.txtUrl.Text); int count = book.Worksheets.Count; for (int c = 0; c < count; c++) { Worksheet sheet = book.Worksheets[c]; Cells cells = sheet.Cells; string cellname = sheet.Name; if (cellname == "操作说明") { continue; } DataTable dt = cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true); if (dt.Rows.Count > 0) { int colnum = dt.Columns.Count; for (int i = 1; i < dt.Rows.Count; i++) { string strGUID = System.Guid.NewGuid().ToString(); string c_stl_grd = dt.Rows[i][0].ToString();//钢种 string c_std_code = dt.Rows[i][1].ToString();//执行标准 for (int j = 2; j < colnum; j++) { string c_aolly_name = dt.Columns[j].ColumnName;//合金名 string c_aolly_code = dt.Rows[0][j].ToString().Trim();//合金代码 string c_aolly_value = dt.Rows[i][j].ToString().Trim();//合金值 decimal n_aolly_value = 0;//合金值 try { n_aolly_value = Convert.ToDecimal(c_aolly_value); } catch (Exception) { n_aolly_value = 0; } if (c_aolly_value.Length > 0 && n_aolly_value > 0 && c_aolly_code.Trim().Length > 0) { //插入数据库 //验证数据是否重复(钢种、执行标准(国标的不带版本号)、合金名称) Mod_TQB_ALLOY_CONSUMPTION modhj = bll_hjxh.GetModel(c_stl_grd, c_std_code, c_aolly_code); if (modhj == null) { //插入 Mod_TQB_ALLOY_CONSUMPTION modadd = new Mod_TQB_ALLOY_CONSUMPTION(); modadd.C_STL_GRD = c_stl_grd; modadd.C_STD_CODE = c_std_code; modadd.C_ALLOYN__NAME = c_aolly_name; modadd.C_ALLOYN__CODE = c_aolly_code; modadd.N_ALLOY_WGT = n_aolly_value; modadd.C_EMP_ID = RV.UI.UserInfo.userID; modadd.D_MOD_DT = RV.UI.ServerTime.timeNow(); modadd.C_REMARK = cellname; bll_hjxh.Add(modadd); } else { //更新 modhj.C_ALLOYN__NAME = c_aolly_name; modhj.N_ALLOY_WGT = n_aolly_value; modhj.C_EMP_ID = RV.UI.UserInfo.userID; modhj.D_MOD_DT = RV.UI.ServerTime.timeNow(); modhj.C_REMARK = cellname; bll_hjxh.Update(modhj); } } } } MessageBox.Show("导入成功!"); this.txtUrl.Text = ""; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btn_change_code_Click(object sender, EventArgs e) { try { int selectedNum = this.gridView1.SelectedRowsCount; if (selectedNum<=0) { MessageBox.Show("请选择需要转换的数据!"); return; } int[] rownumber = this.gridView1.GetSelectedRows();//获取选中行号数组; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string jccode = this.gridView1.GetRowCellValue(rownumber[0], "C_ALLOYN__CODE").ToString(); string dqcode = this.gridView1.GetRowCellValue(selectedHandle, "C_ALLOYN__CODE").ToString();//合金代码 if (jccode!= dqcode) { MessageBox.Show("选中行的合金代码必须一致才能批量转换!"); return; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } string code = ""; string name = ""; Frm_HJEdit frm = new Frm_HJEdit(); frm.Owner = this; if (frm.ShowDialog() == DialogResult.Cancel) { code = frm.textEdit3.Text.Trim(); name = frm.textEdit4.Text.Trim(); frm.Close(); } if (code==""||name=="") { return; } else { if (DialogResult.Yes == MessageBox.Show("是否确认替换选中合金的代码?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { //替换选中的数据 int selectedNum = this.gridView1.SelectedRowsCount; int commitNum = 0;//删除记录数量 int cannotNum = 0;//不能删除记录数量 int failtNum = 0;//删除失败数量 int[] rownumber = this.gridView1.GetSelectedRows();//获取选中行号数组; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = this.gridView1.GetRowCellValue(selectedHandle, "C_ID").ToString(); Mod_TQB_ALLOY_CONSUMPTION model = bll_hjxh.GetModel(strID); model.C_ALLOYN__CODE = code; model.C_ALLOYN__NAME = name; model.C_EMP_ID = RV.UI.UserInfo.userID; model.D_MOD_DT = RV.UI.ServerTime.timeNow(); bool update = bll_hjxh.Update(model); if (update) { commitNum = commitNum + 1; } else { failtNum = failtNum + 1; } } if (selectedNum == 0) { MessageBox.Show("未选中需要转换的数据!"); } else { MessageBox.Show("选择" + selectedNum.ToString() + "条记录,转换" + commitNum.ToString() + "条记录!"); } Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "转换钢种合金代码和名称,转换成功数量:"+ commitNum.ToString()+"条!");//添加操作日志 this.txt_hjdm.Text = code; this.txt_hjmc.Text = name; btn_query_hj_Click(null, null); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TQB_ALLOY_CONSUMPTION model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TQB_ALLOY_CONSUMPTION model) { return(dal.Add(model)); }