/// <summary> /// 撤回开坯计划 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_canale_Click(object sender, EventArgs e) { WaitingFrom.ShowWait("计划正在撤回,请稍候..."); int[] rownumber = this.gv_KPZPJH.GetSelectedRows();//获取选中行号数组; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string c_id = gv_KPZPJH.GetRowCellValue(selectedHandle, "C_ID").ToString(); Mod_TRP_PLAN_COGDOWN mod = bll_kp.GetModel(c_id); if (mod.N_STATUS == 1 && mod.N_GROUP_WGT == 0) { string order_id = mod.C_ORDER_NO; Mod_TSP_PLAN_SMS mod_sms = bll_sms.GetModel(order_id); if (mod_sms != null) { mod_sms.N_CREAT_ZG_PLAN = 0; bll_sms.Update(mod_sms); bll_kp.Delete(c_id); } } } WaitingFrom.CloseWait(); btn_query_zg_Click(null, null); btn_query_kpplan_Click(null, null); }
/// <summary> /// 撤回开坯计划 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_canale_Click(object sender, EventArgs e) { try { WaitingFrom.ShowWait("计划正在撤回,请稍候..."); int[] rownumber = this.gv_KPZPJH.GetSelectedRows();//获取选中行号数组; int num = 0; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string c_id = gv_KPZPJH.GetRowCellValue(selectedHandle, "C_ID").ToString(); Mod_TRP_PLAN_COGDOWN mod = bll_kp.GetModel(c_id); if (mod.N_STATUS == 1 && mod.N_GROUP_WGT == 0) { if (bll_kp.Delete(c_id)) { num++; } } } if (num > 0) { MessageBox.Show("需要撤回{" + rownumber.Length + "}条计划,已成功撤回{" + num + "}条计划!"); BindKP(); BindPlan(); } else { MessageBox.Show("撤回失败!"); } WaitingFrom.CloseWait(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRP_PLAN_COGDOWN GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from TRP_PLAN_COGDOWN "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TRP_PLAN_COGDOWN model = new Mod_TRP_PLAN_COGDOWN(); 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_xf_Click(object sender, EventArgs e) { if (this.icbo_zx3.SelectedIndex < 0) { MessageBox.Show("请选择开坯线!"); this.icbo_zx3.Focus(); return; } WaitingFrom.ShowWait(""); int[] rownumber = this.gridView1.GetSelectedRows();//获取选中行号数组; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; Mod_TRP_PLAN_COGDOWN mod = new Mod_TRP_PLAN_COGDOWN(); mod.C_ID = System.Guid.NewGuid().ToString(); mod.N_STATUS = 1; mod.C_ORDER_NO = this.gridView1.GetRowCellValue(selectedHandle, "C_ID").ToString(); // mod.C_INITIALIZE_ITEM_ID = this.gridView1.GetRowCellValue(selectedHandle, "N_JC_SORT").ToString(); // mod.N_SORT = Convert.ToInt32(this.gridView1.GetRowCellValue(selectedHandle, "N_SORT").ToString()); mod.N_WGT = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_SLAB_WGT").ToString()); mod.C_MAT_CODE = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_CODE_KP").ToString(); mod.C_MAT_NAME = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NAME_KP").ToString(); mod.C_SPEC = this.gridView1.GetRowCellValue(selectedHandle, "C_KP_SIZE").ToString(); mod.C_STL_GRD = this.gridView1.GetRowCellValue(selectedHandle, "C_STL_GRD").ToString(); mod.C_STD_CODE = this.gridView1.GetRowCellValue(selectedHandle, "C_STD_CODE").ToString(); mod.N_LENTH = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_KP_LENGTH").ToString()); try { mod.D_P_START_TIME = Convert.ToDateTime(this.gridView1.GetRowCellValue(selectedHandle, "D_KP_START_TIME").ToString()); mod.D_P_END_TIME = Convert.ToDateTime(this.gridView1.GetRowCellValue(selectedHandle, "D_KP_END_TIME").ToString()); } catch (Exception) { } mod.C_STA_ID = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Value.ToString(); mod.C_CAST_NO = this.gridView1.GetRowCellValue(selectedHandle, "C_STOVE_NO").ToString(); mod.C_LINE_DESC = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Description.ToString(); mod.C_FREE1 = this.gridView1.GetRowCellValue(selectedHandle, "C_FREE1").ToString(); mod.C_FREE2 = this.gridView1.GetRowCellValue(selectedHandle, "C_FREE2").ToString(); mod.C_EMP_ID = RV.UI.UserInfo.userID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); mod.N_PW = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_KP_PW").ToString()); mod.C_MATRL_CODE_SLAB = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NO").ToString(); mod.C_MATRL_NAME_SLAB = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NAME").ToString(); mod.C_SLAB_SIZE = this.gridView1.GetRowCellValue(selectedHandle, "C_SLAB_SIZE").ToString(); mod.N_SLAB_LENGTH = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "C_SLAB_LENGTH").ToString()); mod.N_SLAB_PW = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_SLAB_PW").ToString()); Mod_TSP_PLAN_SMS mod_sms = bll_sms.GetModel(mod.C_ORDER_NO); mod_sms.N_CREAT_ZG_PLAN = 1; bll_sms.Update(mod_sms); bll_kp.Add(mod); } #region MyRegion //for (int i = 0; i < rownumber.Length; i++) //{ // int selectedHandle = rownumber[i]; // Mod_TRP_PLAN_COGDOWN mod = new Mod_TRP_PLAN_COGDOWN(); // mod.C_ID = System.Guid.NewGuid().ToString(); // mod.N_STATUS = 1; // mod.C_INITIALIZE_ITEM_ID = this.gridView1.GetRowCellValue(selectedHandle, "N_JC_SORT").ToString(); // mod.N_SORT = Convert.ToInt32(this.gridView1.GetRowCellValue(selectedHandle, "N_SORT").ToString()); // mod.N_WGT = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_SLAB_WGT").ToString()); // mod.C_MAT_CODE = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_CODE_KP").ToString(); // mod.C_MAT_NAME = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NAME_KP").ToString(); // mod.C_SPEC = this.gridView1.GetRowCellValue(selectedHandle, "C_KP_SIZE").ToString(); // mod.C_STL_GRD = this.gridView1.GetRowCellValue(selectedHandle, "C_STL_GRD").ToString(); // mod.C_STD_CODE = this.gridView1.GetRowCellValue(selectedHandle, "C_STD_CODE").ToString(); // mod.N_LENTH = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_KP_LENGTH").ToString()); // try // { // mod.D_P_START_TIME = Convert.ToDateTime(this.gridView1.GetRowCellValue(selectedHandle, "D_P_START_TIME").ToString()); // mod.D_P_END_TIME = Convert.ToDateTime(this.gridView1.GetRowCellValue(selectedHandle, "D_P_END_TIME").ToString()); // } // catch (Exception) // { // } // mod.C_STA_ID = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Value.ToString(); // mod.C_FREE1 = this.gridView1.GetRowCellValue(selectedHandle, "C_FREE1").ToString(); // mod.C_FREE2 = this.gridView1.GetRowCellValue(selectedHandle, "C_FREE2").ToString(); // mod.C_EMP_ID = RV.UI.UserInfo.userID; // mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); // mod.N_PW = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_KP_PW").ToString()); // mod.C_MATRL_CODE_SLAB = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NO").ToString(); // mod.C_MATRL_NAME_SLAB = this.gridView1.GetRowCellValue(selectedHandle, "C_MATRL_NAME").ToString(); // mod.C_SLAB_SIZE = this.gridView1.GetRowCellValue(selectedHandle, "C_SLAB_SIZE").ToString(); // mod.N_SLAB_LENGTH = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "C_SLAB_LENGTH").ToString()); // mod.N_SLAB_PW = Convert.ToDecimal(this.gridView1.GetRowCellValue(selectedHandle, "N_SLAB_PW").ToString()); // bll_sms.Down_KP(mod.C_STL_GRD, mod.C_MATRL_CODE_SLAB, mod.C_STD_CODE, mod.C_MAT_CODE, mod.C_INITIALIZE_ITEM_ID); // bll_kp.Add(mod); //} #endregion btn_query_zg_Click(null, null); btn_query_kpplan_Click(null, null); WaitingFrom.CloseWait(); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TRP_PLAN_COGDOWN DataRowToModel(DataRow row) { Mod_TRP_PLAN_COGDOWN model = new Mod_TRP_PLAN_COGDOWN(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["C_INITIALIZE_ITEM_ID"] != null) { model.C_INITIALIZE_ITEM_ID = row["C_INITIALIZE_ITEM_ID"].ToString(); } if (row["C_ORDER_NO"] != null) { model.C_ORDER_NO = row["C_ORDER_NO"].ToString(); } if (row["N_WGT"] != null && row["N_WGT"].ToString() != "") { model.N_WGT = decimal.Parse(row["N_WGT"].ToString()); } if (row["C_MAT_CODE"] != null) { model.C_MAT_CODE = row["C_MAT_CODE"].ToString(); } if (row["C_MAT_NAME"] != null) { model.C_MAT_NAME = row["C_MAT_NAME"].ToString(); } if (row["C_TECH_PROT"] != null) { model.C_TECH_PROT = row["C_TECH_PROT"].ToString(); } if (row["C_SPEC"] != null) { model.C_SPEC = row["C_SPEC"].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["N_USER_LEV"] != null && row["N_USER_LEV"].ToString() != "") { model.N_USER_LEV = decimal.Parse(row["N_USER_LEV"].ToString()); } if (row["N_STL_GRD_LEV"] != null && row["N_STL_GRD_LEV"].ToString() != "") { model.N_STL_GRD_LEV = decimal.Parse(row["N_STL_GRD_LEV"].ToString()); } if (row["N_ORDER_LEV"] != null && row["N_ORDER_LEV"].ToString() != "") { model.N_ORDER_LEV = decimal.Parse(row["N_ORDER_LEV"].ToString()); } if (row["C_QUALIRY_LEV"] != null) { model.C_QUALIRY_LEV = row["C_QUALIRY_LEV"].ToString(); } if (row["D_NEED_DT"] != null && row["D_NEED_DT"].ToString() != "") { model.D_NEED_DT = DateTime.Parse(row["D_NEED_DT"].ToString()); } if (row["D_DELIVERY_DT"] != null && row["D_DELIVERY_DT"].ToString() != "") { model.D_DELIVERY_DT = DateTime.Parse(row["D_DELIVERY_DT"].ToString()); } if (row["D_DT"] != null && row["D_DT"].ToString() != "") { model.D_DT = DateTime.Parse(row["D_DT"].ToString()); } if (row["C_LINE_DESC"] != null) { model.C_LINE_DESC = row["C_LINE_DESC"].ToString(); } if (row["C_LINE_CODE"] != null) { model.C_LINE_CODE = row["C_LINE_CODE"].ToString(); } if (row["D_P_START_TIME"] != null && row["D_P_START_TIME"].ToString() != "") { model.D_P_START_TIME = DateTime.Parse(row["D_P_START_TIME"].ToString()); } if (row["D_P_END_TIME"] != null && row["D_P_END_TIME"].ToString() != "") { model.D_P_END_TIME = DateTime.Parse(row["D_P_END_TIME"].ToString()); } if (row["N_PROD_TIME"] != null && row["N_PROD_TIME"].ToString() != "") { model.N_PROD_TIME = decimal.Parse(row["N_PROD_TIME"].ToString()); } if (row["N_SORT"] != null && row["N_SORT"].ToString() != "") { model.N_SORT = decimal.Parse(row["N_SORT"].ToString()); } if (row["N_ROLL_PROD_WGT"] != null && row["N_ROLL_PROD_WGT"].ToString() != "") { model.N_ROLL_PROD_WGT = decimal.Parse(row["N_ROLL_PROD_WGT"].ToString()); } if (row["C_ROLL_PROD_EMP_ID"] != null) { model.C_ROLL_PROD_EMP_ID = row["C_ROLL_PROD_EMP_ID"].ToString(); } if (row["C_STL_ROL_DT"] != null) { model.C_STL_ROL_DT = row["C_STL_ROL_DT"].ToString(); } if (row["N_PROD_WGT"] != null && row["N_PROD_WGT"].ToString() != "") { model.N_PROD_WGT = decimal.Parse(row["N_PROD_WGT"].ToString()); } if (row["N_WARE_WGT"] != null && row["N_WARE_WGT"].ToString() != "") { model.N_WARE_WGT = decimal.Parse(row["N_WARE_WGT"].ToString()); } if (row["N_WARE_OUT_WGT"] != null && row["N_WARE_OUT_WGT"].ToString() != "") { model.N_WARE_OUT_WGT = decimal.Parse(row["N_WARE_OUT_WGT"].ToString()); } if (row["N_FLAG"] != null && row["N_FLAG"].ToString() != "") { model.N_FLAG = decimal.Parse(row["N_FLAG"].ToString()); } if (row["N_ISSUE_WGT"] != null && row["N_ISSUE_WGT"].ToString() != "") { model.N_ISSUE_WGT = decimal.Parse(row["N_ISSUE_WGT"].ToString()); } if (row["C_CUST_NO"] != null) { model.C_CUST_NO = row["C_CUST_NO"].ToString(); } if (row["C_CUST_NAME"] != null) { model.C_CUST_NAME = row["C_CUST_NAME"].ToString(); } if (row["C_SALE_CHANNEL"] != null) { model.C_SALE_CHANNEL = row["C_SALE_CHANNEL"].ToString(); } if (row["C_PACK"] != null) { model.C_PACK = row["C_PACK"].ToString(); } if (row["C_DESIGN_NO"] != null) { model.C_DESIGN_NO = row["C_DESIGN_NO"].ToString(); } if (row["N_GROUP_WGT"] != null && row["N_GROUP_WGT"].ToString() != "") { model.N_GROUP_WGT = decimal.Parse(row["N_GROUP_WGT"].ToString()); } if (row["C_STA_ID"] != null) { model.C_STA_ID = row["C_STA_ID"].ToString(); } if (row["D_START_TIME"] != null && row["D_START_TIME"].ToString() != "") { model.D_START_TIME = DateTime.Parse(row["D_START_TIME"].ToString()); } if (row["D_END_TIME"] != null && row["D_END_TIME"].ToString() != "") { model.D_END_TIME = DateTime.Parse(row["D_END_TIME"].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_ROLL_WGT"] != null && row["N_ROLL_WGT"].ToString() != "") { model.N_ROLL_WGT = decimal.Parse(row["N_ROLL_WGT"].ToString()); } if (row["N_MACH_WGT"] != null && row["N_MACH_WGT"].ToString() != "") { model.N_MACH_WGT = decimal.Parse(row["N_MACH_WGT"].ToString()); } if (row["C_CAST_NO"] != null) { model.C_CAST_NO = row["C_CAST_NO"].ToString(); } if (row["C_INITIALIZE_ID"] != null) { model.C_INITIALIZE_ID = row["C_INITIALIZE_ID"].ToString(); } if (row["N_UPLOADSTATUS"] != null && row["N_UPLOADSTATUS"].ToString() != "") { model.N_UPLOADSTATUS = decimal.Parse(row["N_UPLOADSTATUS"].ToString()); } if (row["C_FREE1"] != null) { model.C_FREE1 = row["C_FREE1"].ToString(); } if (row["C_FREE2"] != null) { model.C_FREE2 = row["C_FREE2"].ToString(); } if (row["N_PW"] != null && row["N_PW"].ToString() != "") { model.N_PW = decimal.Parse(row["N_PW"].ToString()); } if (row["N_LENTH"] != null && row["N_LENTH"].ToString() != "") { model.N_LENTH = decimal.Parse(row["N_LENTH"].ToString()); } if (row["C_MATRL_CODE_SLAB"] != null) { model.C_MATRL_CODE_SLAB = row["C_MATRL_CODE_SLAB"].ToString(); } if (row["C_MATRL_NAME_SLAB"] != null) { model.C_MATRL_NAME_SLAB = row["C_MATRL_NAME_SLAB"].ToString(); } if (row["C_SLAB_SIZE"] != null) { model.C_SLAB_SIZE = row["C_SLAB_SIZE"].ToString(); } if (row["N_SLAB_LENGTH"] != null && row["N_SLAB_LENGTH"].ToString() != "") { model.N_SLAB_LENGTH = decimal.Parse(row["N_SLAB_LENGTH"].ToString()); } if (row["N_SLAB_PW"] != null && row["N_SLAB_PW"].ToString() != "") { model.N_SLAB_PW = decimal.Parse(row["N_SLAB_PW"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRP_PLAN_COGDOWN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TRP_PLAN_COGDOWN("); strSql.Append("C_ID,N_STATUS,C_INITIALIZE_ITEM_ID,C_ORDER_NO,N_WGT,C_MAT_CODE,C_MAT_NAME,C_TECH_PROT,C_SPEC,C_STL_GRD,C_STD_CODE,N_USER_LEV,N_STL_GRD_LEV,N_ORDER_LEV,C_QUALIRY_LEV,D_NEED_DT,D_DELIVERY_DT,D_DT,C_LINE_DESC,C_LINE_CODE,D_P_START_TIME,D_P_END_TIME,N_PROD_TIME,N_SORT,N_ROLL_PROD_WGT,C_ROLL_PROD_EMP_ID,C_STL_ROL_DT,N_PROD_WGT,N_WARE_WGT,N_WARE_OUT_WGT,N_FLAG,N_ISSUE_WGT,C_CUST_NO,C_CUST_NAME,C_SALE_CHANNEL,C_PACK,C_DESIGN_NO,N_GROUP_WGT,C_STA_ID,D_START_TIME,D_END_TIME,C_EMP_ID,D_MOD_DT,N_ROLL_WGT,N_MACH_WGT,C_CAST_NO,C_INITIALIZE_ID,N_UPLOADSTATUS,C_FREE1,C_FREE2,N_PW,N_LENTH,C_MATRL_CODE_SLAB,C_MATRL_NAME_SLAB,C_SLAB_SIZE,N_SLAB_LENGTH,N_SLAB_PW)"); strSql.Append(" values ("); strSql.Append(":C_ID,:N_STATUS,:C_INITIALIZE_ITEM_ID,:C_ORDER_NO,:N_WGT,:C_MAT_CODE,:C_MAT_NAME,:C_TECH_PROT,:C_SPEC,:C_STL_GRD,:C_STD_CODE,:N_USER_LEV,:N_STL_GRD_LEV,:N_ORDER_LEV,:C_QUALIRY_LEV,:D_NEED_DT,:D_DELIVERY_DT,:D_DT,:C_LINE_DESC,:C_LINE_CODE,:D_P_START_TIME,:D_P_END_TIME,:N_PROD_TIME,:N_SORT,:N_ROLL_PROD_WGT,:C_ROLL_PROD_EMP_ID,:C_STL_ROL_DT,:N_PROD_WGT,:N_WARE_WGT,:N_WARE_OUT_WGT,:N_FLAG,:N_ISSUE_WGT,:C_CUST_NO,:C_CUST_NAME,:C_SALE_CHANNEL,:C_PACK,:C_DESIGN_NO,:N_GROUP_WGT,:C_STA_ID,:D_START_TIME,:D_END_TIME,:C_EMP_ID,:D_MOD_DT,:N_ROLL_WGT,:N_MACH_WGT,:C_CAST_NO,:C_INITIALIZE_ID,:N_UPLOADSTATUS,:C_FREE1,:C_FREE2,:N_PW,:N_LENTH,:C_MATRL_CODE_SLAB,:C_MATRL_NAME_SLAB,:C_SLAB_SIZE,:N_SLAB_LENGTH,:N_SLAB_PW)"); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_INITIALIZE_ITEM_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_ORDER_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_MAT_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_MAT_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_TECH_PROT", OracleDbType.Varchar2, 100), new OracleParameter(":C_SPEC", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_GRD", OracleDbType.Varchar2, 100), new OracleParameter(":C_STD_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":N_USER_LEV", OracleDbType.Decimal, 5), new OracleParameter(":N_STL_GRD_LEV", OracleDbType.Decimal, 5), new OracleParameter(":N_ORDER_LEV", OracleDbType.Decimal, 5), new OracleParameter(":C_QUALIRY_LEV", OracleDbType.Varchar2, 100), new OracleParameter(":D_NEED_DT", OracleDbType.Date), new OracleParameter(":D_DELIVERY_DT", OracleDbType.Date), new OracleParameter(":D_DT", OracleDbType.Date), new OracleParameter(":C_LINE_DESC", OracleDbType.Varchar2, 100), new OracleParameter(":C_LINE_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":D_P_START_TIME", OracleDbType.Date), new OracleParameter(":D_P_END_TIME", OracleDbType.Date), new OracleParameter(":N_PROD_TIME", OracleDbType.Decimal, 5), new OracleParameter(":N_SORT", OracleDbType.Decimal, 5), new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_ROLL_PROD_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STL_ROL_DT", OracleDbType.Varchar2, 100), new OracleParameter(":N_PROD_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_WARE_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_WARE_OUT_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_FLAG", OracleDbType.Decimal, 5), new OracleParameter(":N_ISSUE_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_CUST_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_CUST_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_SALE_CHANNEL", OracleDbType.Varchar2, 100), new OracleParameter(":C_PACK", OracleDbType.Varchar2, 100), new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_GROUP_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_START_TIME", OracleDbType.Date), new OracleParameter(":D_END_TIME", OracleDbType.Date), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":N_ROLL_WGT", OracleDbType.Decimal, 5), new OracleParameter(":N_MACH_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_CAST_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_UPLOADSTATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_FREE1", OracleDbType.Varchar2, 100), new OracleParameter(":C_FREE2", OracleDbType.Varchar2, 100), new OracleParameter(":N_PW", OracleDbType.Decimal, 15), new OracleParameter(":N_LENTH", OracleDbType.Decimal, 15), new OracleParameter(":C_MATRL_CODE_SLAB", OracleDbType.Varchar2, 100), new OracleParameter(":C_MATRL_NAME_SLAB", OracleDbType.Varchar2, 100), new OracleParameter(":C_SLAB_SIZE", OracleDbType.Varchar2, 100), new OracleParameter(":N_SLAB_LENGTH", OracleDbType.Decimal, 15), new OracleParameter(":N_SLAB_PW", OracleDbType.Decimal, 15) }; parameters[0].Value = model.C_ID; parameters[1].Value = model.N_STATUS; parameters[2].Value = model.C_INITIALIZE_ITEM_ID; parameters[3].Value = model.C_ORDER_NO; parameters[4].Value = model.N_WGT; parameters[5].Value = model.C_MAT_CODE; parameters[6].Value = model.C_MAT_NAME; parameters[7].Value = model.C_TECH_PROT; parameters[8].Value = model.C_SPEC; parameters[9].Value = model.C_STL_GRD; parameters[10].Value = model.C_STD_CODE; parameters[11].Value = model.N_USER_LEV; parameters[12].Value = model.N_STL_GRD_LEV; parameters[13].Value = model.N_ORDER_LEV; parameters[14].Value = model.C_QUALIRY_LEV; parameters[15].Value = model.D_NEED_DT; parameters[16].Value = model.D_DELIVERY_DT; parameters[17].Value = model.D_DT; parameters[18].Value = model.C_LINE_DESC; parameters[19].Value = model.C_LINE_CODE; parameters[20].Value = model.D_P_START_TIME; parameters[21].Value = model.D_P_END_TIME; parameters[22].Value = model.N_PROD_TIME; parameters[23].Value = model.N_SORT; parameters[24].Value = model.N_ROLL_PROD_WGT; parameters[25].Value = model.C_ROLL_PROD_EMP_ID; parameters[26].Value = model.C_STL_ROL_DT; parameters[27].Value = model.N_PROD_WGT; parameters[28].Value = model.N_WARE_WGT; parameters[29].Value = model.N_WARE_OUT_WGT; parameters[30].Value = model.N_FLAG; parameters[31].Value = model.N_ISSUE_WGT; parameters[32].Value = model.C_CUST_NO; parameters[33].Value = model.C_CUST_NAME; parameters[34].Value = model.C_SALE_CHANNEL; parameters[35].Value = model.C_PACK; parameters[36].Value = model.C_DESIGN_NO; parameters[37].Value = model.N_GROUP_WGT; parameters[38].Value = model.C_STA_ID; parameters[39].Value = model.D_START_TIME; parameters[40].Value = model.D_END_TIME; parameters[41].Value = model.C_EMP_ID; parameters[42].Value = model.D_MOD_DT; parameters[43].Value = model.N_ROLL_WGT; parameters[44].Value = model.N_MACH_WGT; parameters[45].Value = model.C_CAST_NO; parameters[46].Value = model.C_INITIALIZE_ID; parameters[47].Value = model.N_UPLOADSTATUS; parameters[48].Value = model.C_FREE1; parameters[49].Value = model.C_FREE2; parameters[50].Value = model.N_PW; parameters[51].Value = model.N_LENTH; parameters[52].Value = model.C_MATRL_CODE_SLAB; parameters[53].Value = model.C_MATRL_NAME_SLAB; parameters[54].Value = model.C_SLAB_SIZE; parameters[55].Value = model.N_SLAB_LENGTH; parameters[56].Value = model.N_SLAB_PW; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void btn_xf_Click(object sender, EventArgs e) { if (this.icbo_zx3.SelectedIndex < 0) { MessageBox.Show("请选择开坯线!"); this.icbo_zx3.Focus(); return; } int[] rownumber = gridView1.GetSelectedRows();//获取选中行号数组; if (rownumber.Length == 0) { MessageBox.Show("请选择需要下发的计划!"); return; } DataRow row = gridView1.GetDataRow(rownumber[0]); for (int i = 0; i < rownumber.Length; i++) { DataRow dr = gridView1.GetDataRow(rownumber[i]); if (dr["C_STL_GRD"].ToString() != row["C_STL_GRD"].ToString() || dr["C_STD_CODE"].ToString() != row["C_STD_CODE"].ToString() || dr["C_MAT_CODE"].ToString() != row["C_MAT_CODE"].ToString() || dr["C_SPEC"].ToString() != row["C_SPEC"].ToString() || dr["N_LEN"].ToString() != row["N_LEN"].ToString() || dr["C_ZYX1"].ToString() != row["C_ZYX1"].ToString() || dr["C_ZYX2"].ToString() != row["C_ZYX2"].ToString()) { MessageBox.Show("选择需要下发的开坯计划信息不一致,请重新选择!"); return; } } if (string.IsNullOrEmpty(btn_mat_code.Text.Trim()) || string.IsNullOrEmpty(txt_mat_name.Text.Trim()) || string.IsNullOrEmpty(txt_Slab_Size.Text.Trim()) || string.IsNullOrEmpty(txt_Len.Text.Trim()) || string.IsNullOrEmpty(strHsl)) { MessageBox.Show("热轧坯物料编码有误!"); return; } else { if (DialogResult.No == MessageBox.Show("确认下发 物料:" + btn_mat_code.Text.Trim() + "断面:" + txt_Slab_Size.Text.Trim() + "*" + txt_Len.Text.Trim() + "的开坯计划吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } } WaitingFrom.ShowWait(""); for (int i = 0; i < rownumber.Length; i++) { DataRow dr = gridView1.GetDataRow(rownumber[i]); int i_sort = bll_kp.Get_Max_Sort() + 1; Mod_TB_MATRL_MAIN modWl = bll_wl.GetModel(btn_mat_code.Text.Trim()); if (modWl == null) { MessageBox.Show("没有找到热轧坯物料编码,不能下发!"); return; } else { if (modWl.C_STL_GRD != dr["C_STL_GRD"].ToString()) { MessageBox.Show("热轧坯钢种和大方坯钢种不一致,不能下发!"); return; } } Mod_TRP_PLAN_COGDOWN mod = new Mod_TRP_PLAN_COGDOWN(); mod.C_ID = System.Guid.NewGuid().ToString(); mod.N_STATUS = 1; mod.C_INITIALIZE_ITEM_ID = ""; mod.N_SORT = i_sort; mod.N_WGT = Convert.ToDecimal(dr["N_WGT"].ToString()); mod.C_MAT_CODE = btn_mat_code.Text.Trim(); mod.C_MAT_NAME = txt_mat_name.Text.Trim(); mod.C_SPEC = txt_Slab_Size.Text.Trim(); mod.C_STL_GRD = dr["C_STL_GRD"].ToString(); mod.C_STD_CODE = dr["C_STD_CODE"].ToString(); mod.N_LENTH = Convert.ToDecimal(txt_Len.Text.Trim()); try { mod.D_P_START_TIME = RV.UI.ServerTime.timeNow(); mod.D_P_END_TIME = Convert.ToDateTime(mod.D_P_START_TIME).AddHours(Convert.ToDouble(mod.N_WGT / 114)); } catch { } mod.C_STA_ID = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Value.ToString(); mod.C_CAST_NO = dr["C_STOVE"].ToString(); mod.C_LINE_DESC = this.icbo_zx3.Properties.Items[this.icbo_zx3.SelectedIndex].Description.ToString(); mod.C_FREE1 = dr["C_ZYX1"].ToString(); mod.C_FREE2 = dr["C_ZYX2"].ToString(); mod.C_EMP_ID = RV.UI.UserInfo.userID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); mod.N_PW = Convert.ToDecimal(strHsl); mod.C_MATRL_CODE_SLAB = dr["C_MAT_CODE"].ToString(); mod.C_MATRL_NAME_SLAB = dr["C_MAT_NAME"].ToString(); mod.C_SLAB_SIZE = dr["C_SPEC"].ToString(); mod.N_SLAB_LENGTH = Convert.ToDecimal(dr["N_LEN"].ToString()); Mod_TB_MATRL_MAIN modMaterMain = bll_wl.GetModel(dr["C_MAT_CODE"].ToString()); if (modMaterMain != null) { mod.N_SLAB_PW = modMaterMain.N_HSL; } bll_kp.Add(mod); } BindKP(); BindPlan(); WaitingFrom.CloseWait(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TRP_PLAN_COGDOWN model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TRP_PLAN_COGDOWN model) { return(dal.Add(model)); }