/// <summary> /// 连铸调整 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_fp_lz_Click(object sender, EventArgs e) { int[] rownumber = this.gv_ini_order.GetSelectedRows();//获取选中行号数组; if (rownumber.Length > 0) { for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strId = gv_ini_order.GetRowCellValue(selectedHandle, "C_ID").ToString(); Mod_TPP_INITIALIZE_ORDER mod = bll_ini_order.GetModel(strId); mod.C_CCM_STA_ID = this.cbo_lz3.Properties.Items[this.cbo_lz3.SelectedIndex].Value.ToString(); bll_ini_order.Update(mod); } btn_query_ycsh_Click(null, null); MessageBox.Show("连铸调整成功!"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TPP_INITIALIZE_ORDER GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_INITIALIZE_ID,C_ORDER_ID,N_WGT,N_MACH_WGT,C_DESIGN_NO,N_STATUS,N_FLAG,C_RH,C_LF,C_KP,N_HL_TIME,C_HL,N_DFP_HL_TIME,C_DFP_HL,C_XM,C_ROLL_STA_ID,C_CCM_STA_ID,N_MACH_WGT_CCM,N_LGPC_STATUS,N_EXEC_STATUS,N_ROLL_PROD_WGT,N_SMS_PROD_WGT,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_MATRL_CODE_SLAB,C_MATRL_NAME_SLAB,C_SLAB_SIZE,N_SLAB_LENGTH,N_SLAB_PW,C_MATRL_CODE_KP,C_MATRL_NAME_KP,C_KP_SIZE,N_KP_LENGTH,N_KP_PW,C_ROUTE,N_GROUP,N_SORT,C_XC,C_SL,C_WL,C_ORDERNO,C_CONNO from TPP_INITIALIZE_ORDER "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TPP_INITIALIZE_ORDER model = new Mod_TPP_INITIALIZE_ORDER(); 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 Add(Mod_TPP_INITIALIZE_ORDER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TPP_INITIALIZE_ORDER("); strSql.Append("C_INITIALIZE_ID,C_ORDER_ID,N_WGT,N_MACH_WGT,C_DESIGN_NO,C_RH,C_LF,C_KP,N_HL_TIME,C_HL,N_DFP_HL_TIME,C_DFP_HL,C_XM,C_ROLL_STA_ID,C_CCM_STA_ID,N_MACH_WGT_CCM,N_LGPC_STATUS,N_EXEC_STATUS,N_ROLL_PROD_WGT,N_SMS_PROD_WGT,C_REMARK,C_EMP_ID,C_EMP_NAME,C_MATRL_CODE_SLAB,C_MATRL_NAME_SLAB,C_SLAB_SIZE,N_SLAB_LENGTH,N_SLAB_PW,C_MATRL_CODE_KP,C_MATRL_NAME_KP,C_KP_SIZE,N_KP_LENGTH,N_KP_PW,C_ROUTE,N_GROUP,N_SORT,C_XC,C_SL,C_WL,C_ORDERNO,C_CONNO)"); strSql.Append(" values ("); strSql.Append(":C_INITIALIZE_ID,:C_ORDER_ID,:N_WGT,:N_MACH_WGT,:C_DESIGN_NO,:C_RH,:C_LF,:C_KP,:N_HL_TIME,:C_HL,:N_DFP_HL_TIME,:C_DFP_HL,:C_XM,:C_ROLL_STA_ID,:C_CCM_STA_ID,:N_MACH_WGT_CCM,:N_LGPC_STATUS,:N_EXEC_STATUS,:N_ROLL_PROD_WGT,:N_SMS_PROD_WGT,:C_REMARK,:C_EMP_ID,:C_EMP_NAME,:C_MATRL_CODE_SLAB,:C_MATRL_NAME_SLAB,:C_SLAB_SIZE,:N_SLAB_LENGTH,:N_SLAB_PW,:C_MATRL_CODE_KP,:C_MATRL_NAME_KP,:C_KP_SIZE,:N_KP_LENGTH,:N_KP_PW,:C_ROUTE,:N_GROUP,:N_SORT,:C_XC,:C_SL,:C_WL,:C_ORDERNO,:C_CONNO)"); OracleParameter[] parameters = { new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_MACH_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100), new OracleParameter(":C_RH", OracleDbType.Varchar2, 100), new OracleParameter(":C_LF", OracleDbType.Varchar2, 100), new OracleParameter(":C_KP", OracleDbType.Varchar2, 100), new OracleParameter(":N_HL_TIME", OracleDbType.Decimal, 4), new OracleParameter(":C_HL", OracleDbType.Varchar2, 100), new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Decimal, 4), new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100), new OracleParameter(":C_XM", OracleDbType.Varchar2, 100), new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Decimal, 15), new OracleParameter(":N_LGPC_STATUS", OracleDbType.Decimal, 4), new OracleParameter(":N_EXEC_STATUS", OracleDbType.Decimal, 4), new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100), 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), new OracleParameter(":C_MATRL_CODE_KP", OracleDbType.Varchar2, 100), new OracleParameter(":C_MATRL_NAME_KP", OracleDbType.Varchar2, 100), new OracleParameter(":C_KP_SIZE", OracleDbType.Varchar2, 100), new OracleParameter(":N_KP_LENGTH", OracleDbType.Decimal, 15), new OracleParameter(":N_KP_PW", OracleDbType.Decimal, 15), new OracleParameter(":C_ROUTE", OracleDbType.Varchar2, 100), new OracleParameter(":N_GROUP", OracleDbType.Decimal, 4), new OracleParameter(":N_SORT", OracleDbType.Decimal, 4), new OracleParameter(":C_XC", OracleDbType.Varchar2, 10), new OracleParameter(":C_SL", OracleDbType.Varchar2, 10), new OracleParameter(":C_WL", OracleDbType.Varchar2, 10), new OracleParameter(":C_ORDERNO", OracleDbType.Varchar2, 100), new OracleParameter(":C_CONNO", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_INITIALIZE_ID; parameters[1].Value = model.C_ORDER_ID; parameters[2].Value = model.N_WGT; parameters[3].Value = model.N_MACH_WGT; parameters[4].Value = model.C_DESIGN_NO; parameters[5].Value = model.C_RH; parameters[6].Value = model.C_LF; parameters[7].Value = model.C_KP; parameters[8].Value = model.N_HL_TIME; parameters[9].Value = model.C_HL; parameters[10].Value = model.N_DFP_HL_TIME; parameters[11].Value = model.C_DFP_HL; parameters[12].Value = model.C_XM; parameters[13].Value = model.C_ROLL_STA_ID; parameters[14].Value = model.C_CCM_STA_ID; parameters[15].Value = model.N_MACH_WGT_CCM; parameters[16].Value = model.N_LGPC_STATUS; parameters[17].Value = model.N_EXEC_STATUS; parameters[18].Value = model.N_ROLL_PROD_WGT; parameters[19].Value = model.N_SMS_PROD_WGT; parameters[20].Value = model.C_REMARK; parameters[21].Value = model.C_EMP_ID; parameters[22].Value = model.C_EMP_NAME; parameters[23].Value = model.C_MATRL_CODE_SLAB; parameters[24].Value = model.C_MATRL_NAME_SLAB; parameters[25].Value = model.C_SLAB_SIZE; parameters[26].Value = model.N_SLAB_LENGTH; parameters[27].Value = model.N_SLAB_PW; parameters[28].Value = model.C_MATRL_CODE_KP; parameters[29].Value = model.C_MATRL_NAME_KP; parameters[30].Value = model.C_KP_SIZE; parameters[31].Value = model.N_KP_LENGTH; parameters[32].Value = model.N_KP_PW; parameters[33].Value = model.C_ROUTE; parameters[34].Value = model.N_GROUP; parameters[35].Value = model.N_SORT; parameters[36].Value = model.C_XC; parameters[37].Value = model.C_SL; parameters[38].Value = model.C_WL; parameters[39].Value = model.C_ORDERNO; parameters[40].Value = model.C_CONNO; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TPP_INITIALIZE_ORDER DataRowToModel(DataRow row) { Mod_TPP_INITIALIZE_ORDER model = new Mod_TPP_INITIALIZE_ORDER(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_INITIALIZE_ID"] != null) { model.C_INITIALIZE_ID = row["C_INITIALIZE_ID"].ToString(); } if (row["C_ORDER_ID"] != null) { model.C_ORDER_ID = row["C_ORDER_ID"].ToString(); } if (row["N_WGT"] != null && row["N_WGT"].ToString() != "") { model.N_WGT = decimal.Parse(row["N_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_DESIGN_NO"] != null) { model.C_DESIGN_NO = row["C_DESIGN_NO"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["N_FLAG"] != null && row["N_FLAG"].ToString() != "") { model.N_FLAG = decimal.Parse(row["N_FLAG"].ToString()); } if (row["C_RH"] != null) { model.C_RH = row["C_RH"].ToString(); } if (row["C_LF"] != null) { model.C_LF = row["C_LF"].ToString(); } if (row["C_KP"] != null) { model.C_KP = row["C_KP"].ToString(); } if (row["N_HL_TIME"] != null && row["N_HL_TIME"].ToString() != "") { model.N_HL_TIME = decimal.Parse(row["N_HL_TIME"].ToString()); } if (row["C_HL"] != null) { model.C_HL = row["C_HL"].ToString(); } if (row["N_DFP_HL_TIME"] != null && row["N_DFP_HL_TIME"].ToString() != "") { model.N_DFP_HL_TIME = decimal.Parse(row["N_DFP_HL_TIME"].ToString()); } if (row["C_DFP_HL"] != null) { model.C_DFP_HL = row["C_DFP_HL"].ToString(); } if (row["C_XM"] != null) { model.C_XM = row["C_XM"].ToString(); } if (row["C_ROLL_STA_ID"] != null) { model.C_ROLL_STA_ID = row["C_ROLL_STA_ID"].ToString(); } if (row["C_CCM_STA_ID"] != null) { model.C_CCM_STA_ID = row["C_CCM_STA_ID"].ToString(); } if (row["N_MACH_WGT_CCM"] != null && row["N_MACH_WGT_CCM"].ToString() != "") { model.N_MACH_WGT_CCM = decimal.Parse(row["N_MACH_WGT_CCM"].ToString()); } if (row["N_LGPC_STATUS"] != null && row["N_LGPC_STATUS"].ToString() != "") { model.N_LGPC_STATUS = decimal.Parse(row["N_LGPC_STATUS"].ToString()); } if (row["N_EXEC_STATUS"] != null && row["N_EXEC_STATUS"].ToString() != "") { model.N_EXEC_STATUS = decimal.Parse(row["N_EXEC_STATUS"].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["N_SMS_PROD_WGT"] != null && row["N_SMS_PROD_WGT"].ToString() != "") { model.N_SMS_PROD_WGT = decimal.Parse(row["N_SMS_PROD_WGT"].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["C_EMP_NAME"] != null) { model.C_EMP_NAME = row["C_EMP_NAME"].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_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()); } if (row["C_MATRL_CODE_KP"] != null) { model.C_MATRL_CODE_KP = row["C_MATRL_CODE_KP"].ToString(); } if (row["C_MATRL_NAME_KP"] != null) { model.C_MATRL_NAME_KP = row["C_MATRL_NAME_KP"].ToString(); } if (row["C_KP_SIZE"] != null) { model.C_KP_SIZE = row["C_KP_SIZE"].ToString(); } if (row["N_KP_LENGTH"] != null && row["N_KP_LENGTH"].ToString() != "") { model.N_KP_LENGTH = decimal.Parse(row["N_KP_LENGTH"].ToString()); } if (row["N_KP_PW"] != null && row["N_KP_PW"].ToString() != "") { model.N_KP_PW = decimal.Parse(row["N_KP_PW"].ToString()); } if (row["C_ROUTE"] != null) { model.C_ROUTE = row["C_ROUTE"].ToString(); } if (row["N_GROUP"] != null && row["N_GROUP"].ToString() != "") { model.N_GROUP = decimal.Parse(row["N_GROUP"].ToString()); } if (row["N_SORT"] != null && row["N_SORT"].ToString() != "") { model.N_SORT = decimal.Parse(row["N_SORT"].ToString()); } if (row["C_XC"] != null) { model.C_XC = row["C_XC"].ToString(); } if (row["C_SL"] != null) { model.C_SL = row["C_SL"].ToString(); } if (row["C_WL"] != null) { model.C_WL = row["C_WL"].ToString(); } if (row["C_ORDERNO"] != null) { model.C_ORDERNO = row["C_ORDERNO"].ToString(); } if (row["C_CONNO"] != null) { model.C_CONNO = row["C_CONNO"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TPP_INITIALIZE_ORDER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TPP_INITIALIZE_ORDER set "); strSql.Append("C_INITIALIZE_ID=:C_INITIALIZE_ID,"); strSql.Append("C_ORDER_ID=:C_ORDER_ID,"); strSql.Append("N_WGT=:N_WGT,"); strSql.Append("N_MACH_WGT=:N_MACH_WGT,"); strSql.Append("C_DESIGN_NO=:C_DESIGN_NO,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("N_FLAG=:N_FLAG,"); strSql.Append("C_RH=:C_RH,"); strSql.Append("C_LF=:C_LF,"); strSql.Append("C_KP=:C_KP,"); strSql.Append("N_HL_TIME=:N_HL_TIME,"); strSql.Append("C_HL=:C_HL,"); strSql.Append("N_DFP_HL_TIME=:N_DFP_HL_TIME,"); strSql.Append("C_DFP_HL=:C_DFP_HL,"); strSql.Append("C_XM=:C_XM,"); strSql.Append("C_ROLL_STA_ID=:C_ROLL_STA_ID,"); strSql.Append("C_CCM_STA_ID=:C_CCM_STA_ID,"); strSql.Append("N_MACH_WGT_CCM=:N_MACH_WGT_CCM,"); strSql.Append("N_LGPC_STATUS=:N_LGPC_STATUS,"); strSql.Append("N_EXEC_STATUS=:N_EXEC_STATUS,"); strSql.Append("N_ROLL_PROD_WGT=:N_ROLL_PROD_WGT,"); strSql.Append("N_SMS_PROD_WGT=:N_SMS_PROD_WGT,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("C_EMP_NAME=:C_EMP_NAME,"); strSql.Append("D_MOD_DT=:D_MOD_DT,"); strSql.Append("C_MATRL_CODE_SLAB=:C_MATRL_CODE_SLAB,"); strSql.Append("C_MATRL_NAME_SLAB=:C_MATRL_NAME_SLAB,"); strSql.Append("C_SLAB_SIZE=:C_SLAB_SIZE,"); strSql.Append("N_SLAB_LENGTH=:N_SLAB_LENGTH,"); strSql.Append("N_SLAB_PW=:N_SLAB_PW,"); strSql.Append("C_MATRL_CODE_KP=:C_MATRL_CODE_KP,"); strSql.Append("C_MATRL_NAME_KP=:C_MATRL_NAME_KP,"); strSql.Append("C_KP_SIZE=:C_KP_SIZE,"); strSql.Append("N_KP_LENGTH=:N_KP_LENGTH,"); strSql.Append("N_KP_PW=:N_KP_PW,"); strSql.Append("C_ROUTE=:C_ROUTE,"); strSql.Append("N_GROUP=:N_GROUP,"); strSql.Append("N_SORT=:N_SORT,"); strSql.Append("C_XC=:C_XC,"); strSql.Append("C_SL=:C_SL,"); strSql.Append("C_WL=:C_WL,"); strSql.Append("C_ORDERNO=:C_ORDERNO,"); strSql.Append("C_CONNO=:C_CONNO"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_MACH_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 4), new OracleParameter(":N_FLAG", OracleDbType.Decimal, 4), new OracleParameter(":C_RH", OracleDbType.Varchar2, 100), new OracleParameter(":C_LF", OracleDbType.Varchar2, 100), new OracleParameter(":C_KP", OracleDbType.Varchar2, 100), new OracleParameter(":N_HL_TIME", OracleDbType.Decimal, 4), new OracleParameter(":C_HL", OracleDbType.Varchar2, 100), new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Decimal, 4), new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100), new OracleParameter(":C_XM", OracleDbType.Varchar2, 100), new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Decimal, 15), new OracleParameter(":N_LGPC_STATUS", OracleDbType.Decimal, 4), new OracleParameter(":N_EXEC_STATUS", OracleDbType.Decimal, 4), new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Decimal, 15), new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Decimal, 15), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), 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), new OracleParameter(":C_MATRL_CODE_KP", OracleDbType.Varchar2, 100), new OracleParameter(":C_MATRL_NAME_KP", OracleDbType.Varchar2, 100), new OracleParameter(":C_KP_SIZE", OracleDbType.Varchar2, 100), new OracleParameter(":N_KP_LENGTH", OracleDbType.Decimal, 15), new OracleParameter(":N_KP_PW", OracleDbType.Decimal, 15), new OracleParameter(":C_ROUTE", OracleDbType.Varchar2, 100), new OracleParameter(":N_GROUP", OracleDbType.Decimal, 4), new OracleParameter(":N_SORT", OracleDbType.Decimal, 4), new OracleParameter(":C_XC", OracleDbType.Varchar2, 10), new OracleParameter(":C_SL", OracleDbType.Varchar2, 10), new OracleParameter(":C_WL", OracleDbType.Varchar2, 10), new OracleParameter(":C_ORDERNO", OracleDbType.Varchar2, 100), new OracleParameter(":C_CONNO", OracleDbType.Varchar2, 100), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_INITIALIZE_ID; parameters[1].Value = model.C_ORDER_ID; parameters[2].Value = model.N_WGT; parameters[3].Value = model.N_MACH_WGT; parameters[4].Value = model.C_DESIGN_NO; parameters[5].Value = model.N_STATUS; parameters[6].Value = model.N_FLAG; parameters[7].Value = model.C_RH; parameters[8].Value = model.C_LF; parameters[9].Value = model.C_KP; parameters[10].Value = model.N_HL_TIME; parameters[11].Value = model.C_HL; parameters[12].Value = model.N_DFP_HL_TIME; parameters[13].Value = model.C_DFP_HL; parameters[14].Value = model.C_XM; parameters[15].Value = model.C_ROLL_STA_ID; parameters[16].Value = model.C_CCM_STA_ID; parameters[17].Value = model.N_MACH_WGT_CCM; parameters[18].Value = model.N_LGPC_STATUS; parameters[19].Value = model.N_EXEC_STATUS; parameters[20].Value = model.N_ROLL_PROD_WGT; parameters[21].Value = model.N_SMS_PROD_WGT; parameters[22].Value = model.C_REMARK; parameters[23].Value = model.C_EMP_ID; parameters[24].Value = model.C_EMP_NAME; parameters[25].Value = model.D_MOD_DT; parameters[26].Value = model.C_MATRL_CODE_SLAB; parameters[27].Value = model.C_MATRL_NAME_SLAB; parameters[28].Value = model.C_SLAB_SIZE; parameters[29].Value = model.N_SLAB_LENGTH; parameters[30].Value = model.N_SLAB_PW; parameters[31].Value = model.C_MATRL_CODE_KP; parameters[32].Value = model.C_MATRL_NAME_KP; parameters[33].Value = model.C_KP_SIZE; parameters[34].Value = model.N_KP_LENGTH; parameters[35].Value = model.N_KP_PW; parameters[36].Value = model.C_ROUTE; parameters[37].Value = model.N_GROUP; parameters[38].Value = model.N_SORT; parameters[39].Value = model.C_XC; parameters[40].Value = model.C_SL; parameters[41].Value = model.C_WL; parameters[42].Value = model.C_ORDERNO; parameters[43].Value = model.C_CONNO; parameters[44].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TPP_INITIALIZE_ORDER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TPP_INITIALIZE_ORDER("); strSql.Append("C_INITIALIZE_ID,C_ORDER_ID,N_WGT,N_MACH_WGT,C_DESIGN_NO,N_STATUS,N_FLAG,C_REMARK,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_RH,C_LF,C_KP,N_HL_TIME,C_HL,N_DFP_HL_TIME,C_DFP_HL,C_XM,C_ROLL_STA_ID,C_CCM_STA_ID,N_MACH_WGT_CCM,N_LGPC_STATUS,N_EXEC_STATUS,N_ROLL_PROD_WGT,N_SMS_PROD_WGT)"); strSql.Append(" values ("); strSql.Append(":C_INITIALIZE_ID,:C_ORDER_ID,:N_WGT,:N_MACH_WGT,:C_DESIGN_NO,:N_STATUS,:N_FLAG,:C_REMARK,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT,:C_RH,:C_LF,:C_KP,:N_HL_TIME,:C_HL,:N_DFP_HL_TIME,:C_DFP_HL,:C_XM,:C_ROLL_STA_ID,:C_CCM_STA_ID,:N_MACH_WGT_CCM,:N_LGPC_STATUS,:N_EXEC_STATUS,:N_ROLL_PROD_WGT,:N_SMS_PROD_WGT)"); OracleParameter[] parameters = { new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_WGT", OracleDbType.Int16, 15), new OracleParameter(":N_MACH_WGT", OracleDbType.Int16, 15), new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Int16, 2), new OracleParameter(":N_FLAG", OracleDbType.Int16, 2), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_RH", OracleDbType.Varchar2, 100), new OracleParameter(":C_LF", OracleDbType.Varchar2, 100), new OracleParameter(":C_KP", OracleDbType.Varchar2, 100), new OracleParameter(":N_HL_TIME", OracleDbType.Int16, 10), new OracleParameter(":C_HL", OracleDbType.Varchar2, 100), new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Int16, 10), new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100), new OracleParameter(":C_XM", OracleDbType.Varchar2, 100), new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Int16, 15), new OracleParameter(":N_LGPC_STATUS", OracleDbType.Int16, 2), new OracleParameter(":N_EXEC_STATUS", OracleDbType.Int16, 2), new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Int16, 15), new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Int16, 15) }; parameters[0].Value = model.C_INITIALIZE_ID; parameters[1].Value = model.C_ORDER_ID; parameters[2].Value = model.N_WGT; parameters[3].Value = model.N_MACH_WGT; parameters[4].Value = model.C_DESIGN_NO; parameters[5].Value = model.N_STATUS; parameters[6].Value = model.N_FLAG; parameters[7].Value = model.C_REMARK; parameters[8].Value = model.C_EMP_ID; parameters[9].Value = model.C_EMP_NAME; parameters[10].Value = model.D_MOD_DT; parameters[11].Value = model.C_RH; parameters[12].Value = model.C_LF; parameters[13].Value = model.C_KP; parameters[14].Value = model.N_HL_TIME; parameters[15].Value = model.C_HL; parameters[16].Value = model.N_DFP_HL_TIME; parameters[17].Value = model.C_DFP_HL; parameters[18].Value = model.C_XM; parameters[19].Value = model.C_ROLL_STA_ID; parameters[20].Value = model.C_CCM_STA_ID; parameters[21].Value = model.N_MACH_WGT_CCM; parameters[22].Value = model.N_LGPC_STATUS; parameters[23].Value = model.N_EXEC_STATUS; parameters[24].Value = model.N_ROLL_PROD_WGT; parameters[25].Value = model.N_SMS_PROD_WGT; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TPP_INITIALIZE_ORDER model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TPP_INITIALIZE_ORDER set "); strSql.Append("C_INITIALIZE_ID=:C_INITIALIZE_ID,"); strSql.Append("C_ORDER_ID=:C_ORDER_ID,"); strSql.Append("N_WGT=:N_WGT,"); strSql.Append("N_MACH_WGT=:N_MACH_WGT,"); strSql.Append("C_DESIGN_NO=:C_DESIGN_NO,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("N_FLAG=:N_FLAG,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("C_EMP_NAME=:C_EMP_NAME,"); strSql.Append("D_MOD_DT=:D_MOD_DT,"); strSql.Append("C_RH=:C_RH,"); strSql.Append("C_LF=:C_LF,"); strSql.Append("C_KP=:C_KP,"); strSql.Append("N_HL_TIME=:N_HL_TIME,"); strSql.Append("C_HL=:C_HL,"); strSql.Append("N_DFP_HL_TIME=:N_DFP_HL_TIME,"); strSql.Append("C_DFP_HL=:C_DFP_HL,"); strSql.Append("C_XM=:C_XM,"); strSql.Append("C_ROLL_STA_ID=:C_ROLL_STA_ID,"); strSql.Append("C_CCM_STA_ID=:C_CCM_STA_ID,"); strSql.Append("N_MACH_WGT_CCM=:N_MACH_WGT_CCM,"); strSql.Append("N_LGPC_STATUS=:N_LGPC_STATUS,"); strSql.Append("N_EXEC_STATUS=:N_EXEC_STATUS,"); strSql.Append("N_ROLL_PROD_WGT=:N_ROLL_PROD_WGT,"); strSql.Append("N_SMS_PROD_WGT=:N_SMS_PROD_WGT"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_ORDER_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_WGT", OracleDbType.Int16, 15), new OracleParameter(":N_MACH_WGT", OracleDbType.Int16, 15), new OracleParameter(":C_DESIGN_NO", OracleDbType.Varchar2, 100), new OracleParameter(":N_STATUS", OracleDbType.Int16, 2), new OracleParameter(":N_FLAG", OracleDbType.Int16, 2), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_RH", OracleDbType.Varchar2, 100), new OracleParameter(":C_LF", OracleDbType.Varchar2, 100), new OracleParameter(":C_KP", OracleDbType.Varchar2, 100), new OracleParameter(":N_HL_TIME", OracleDbType.Int16, 10), new OracleParameter(":C_HL", OracleDbType.Varchar2, 100), new OracleParameter(":N_DFP_HL_TIME", OracleDbType.Int16, 10), new OracleParameter(":C_DFP_HL", OracleDbType.Varchar2, 100), new OracleParameter(":C_XM", OracleDbType.Varchar2, 100), new OracleParameter(":C_ROLL_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_CCM_STA_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_MACH_WGT_CCM", OracleDbType.Int16, 15), new OracleParameter(":N_LGPC_STATUS", OracleDbType.Int16, 2), new OracleParameter(":N_EXEC_STATUS", OracleDbType.Int16, 2), new OracleParameter(":N_ROLL_PROD_WGT", OracleDbType.Int16, 15), new OracleParameter(":N_SMS_PROD_WGT", OracleDbType.Int16, 15), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_INITIALIZE_ID; parameters[1].Value = model.C_ORDER_ID; parameters[2].Value = model.N_WGT; parameters[3].Value = model.N_MACH_WGT; parameters[4].Value = model.C_DESIGN_NO; parameters[5].Value = model.N_STATUS; parameters[6].Value = model.N_FLAG; parameters[7].Value = model.C_REMARK; parameters[8].Value = model.C_EMP_ID; parameters[9].Value = model.C_EMP_NAME; parameters[10].Value = model.D_MOD_DT; parameters[11].Value = model.C_RH; parameters[12].Value = model.C_LF; parameters[13].Value = model.C_KP; parameters[14].Value = model.N_HL_TIME; parameters[15].Value = model.C_HL; parameters[16].Value = model.N_DFP_HL_TIME; parameters[17].Value = model.C_DFP_HL; parameters[18].Value = model.C_XM; parameters[19].Value = model.C_ROLL_STA_ID; parameters[20].Value = model.C_CCM_STA_ID; parameters[21].Value = model.N_MACH_WGT_CCM; parameters[22].Value = model.N_LGPC_STATUS; parameters[23].Value = model.N_EXEC_STATUS; parameters[24].Value = model.N_ROLL_PROD_WGT; parameters[25].Value = model.N_SMS_PROD_WGT; parameters[26].Value = model.C_ID; 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_reset_area_Click(object sender, EventArgs e) { try { if (DialogResult.No == MessageBox.Show("是否确认撤回?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } DataRow dr = gv_ZGJH.GetDataRow(gv_ZGJH.FocusedRowHandle); Mod_TPP_INITIALIZE_ORDER mod = bll_ini_order.GetModel(dr["C_INITIALIZE_ITEM_ID"].ToString()); if (mod != null) { mod.N_ROLL_PROD_WGT = mod.N_ROLL_PROD_WGT - Convert.ToDecimal(dr["N_WGT"].ToString()); if (mod.N_ROLL_PROD_WGT == 0) { mod.N_EXEC_STATUS = 0; } bll_TRP_PLAN_ROLL.Delete(dr["C_ID"].ToString()); #region 重新计算顺序 bll_TRP_PLAN_ROLL.Update(dr["C_STA_ID"].ToString(), dr["C_INITIALIZE_ID"].ToString(), Convert.ToInt32(dr["N_SORT"].ToString())); #endregion #region 重新计算计划时间 int count = bll_TRP_PLAN_ROLL.GetFACount(cbo_FA.EditValue.ToString(), dr["C_STA_ID"].ToString());//该方案下该工位计划数量 int startNum = 1; startNum = Convert.ToInt32(dr["N_SORT"].ToString()); mod.N_ROLL_PROD_WGT = mod.N_WGT - Convert.ToDecimal(dr["N_ROLL_PROD_WGT"]); mod.N_EXEC_STATUS = 0; bll_ini_order.Update(mod); for (int i = startNum; i <= count; i++) { Mod_TRP_PLAN_ROLL mod_TRP_PLAN_ROLL = bll_TRP_PLAN_ROLL.GetModel(i, dr["C_INITIALIZE_ID"].ToString(), dr["C_STA_ID"].ToString()); if (i > 1) { DataTable bdt = bll_TRP_PLAN_ROLL.GetList(Convert.ToInt32(mod_TRP_PLAN_ROLL.N_SORT - 1), mod_TRP_PLAN_ROLL.C_INITIALIZE_ITEM_ID, mod_TRP_PLAN_ROLL.C_STA_ID).Tables[0]; DateTime enddt = Convert.ToDateTime(bdt.Rows[0]["D_P_END_TIME"]);//上一计划结束时间 DataTable hggdt = bll_TPB_CHANGESPEC_TIME.GetList(1, mod_TRP_PLAN_ROLL.C_STA_ID, bdt.Rows[0]["C_SPEC"].ToString(), mod_TRP_PLAN_ROLL.C_SPEC).Tables[0]; if (hggdt.Rows.Count > 0) { mod_TRP_PLAN_ROLL.D_P_START_TIME = enddt.AddMinutes(Convert.ToDouble(hggdt.Rows[0]["N_TIME"])); } else { mod_TRP_PLAN_ROLL.D_P_START_TIME = enddt; } } else { mod_TRP_PLAN_ROLL.D_P_START_TIME = Convert.ToDateTime(bll_TPP_INITIALIZE_ITEM.GetListByNAME(cbo_FA.Text).Tables[0].Rows[0]["D_ROLL_START_TIME"]); } DataTable dataTable = bll_TPB_STATION_CAPACITY.GetList(1, "", mod_TRP_PLAN_ROLL.C_STA_ID, mod_TRP_PLAN_ROLL.C_STL_GRD, mod_TRP_PLAN_ROLL.C_SPEC, mod_TRP_PLAN_ROLL.C_STD_CODE).Tables[0]; string cn = ""; if (dataTable.Rows.Count > 0) { cn = dataTable.Rows[0]["N_CAPACITY"].ToString(); } else { cn = "60"; } double db = Convert.ToDouble(mod_TRP_PLAN_ROLL.N_WGT) / Convert.ToDouble(cn); DateTime dt = Convert.ToDateTime(mod_TRP_PLAN_ROLL.D_P_START_TIME); dt = dt.AddHours(Convert.ToDouble(db)); mod_TRP_PLAN_ROLL.D_P_END_TIME = dt; bll_TRP_PLAN_ROLL.Update(mod_TRP_PLAN_ROLL); } MessageBox.Show("撤销成功!"); Query(); Query1(); gv_DDFA_Click(); #endregion } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void PLANADD(int item) { DataRow dr = gv_DDFA.GetDataRow(item); int count = bll_TRP_PLAN_ROLL.GetFACount(cbo_FA.EditValue.ToString(), cbo_GW1.EditValue.ToString());//该方案下该工位计划数量 Mod_TRP_PLAN_ROLL mod_TRP_PLAN_ROLL = new Mod_TRP_PLAN_ROLL(); mod_TRP_PLAN_ROLL.C_INITIALIZE_ID = cbo_FA.EditValue.ToString(); mod_TRP_PLAN_ROLL.C_INITIALIZE_ITEM_ID = dr["C_ID"].ToString(); mod_TRP_PLAN_ROLL.N_SORT = count + 1; mod_TRP_PLAN_ROLL.C_SPEC = dr["C_SPEC"].ToString(); mod_TRP_PLAN_ROLL.C_STD_CODE = dr["C_STD_CODE"].ToString(); mod_TRP_PLAN_ROLL.C_STL_GRD = dr["C_STL_GRD"].ToString(); mod_TRP_PLAN_ROLL.C_ORDER_NO = dr["C_ORDER_NO"].ToString(); mod_TRP_PLAN_ROLL.C_MAT_NAME = dr["C_MAT_NAME"].ToString(); mod_TRP_PLAN_ROLL.C_MAT_CODE = dr["C_MAT_CODE"].ToString(); mod_TRP_PLAN_ROLL.N_WGT = Convert.ToDecimal(dr["N_WGT"]); if (dr["C_ROLL_STA_ID"] == null || dr["C_ROLL_STA_ID"].ToString() == "") { MessageBox.Show(mod_TRP_PLAN_ROLL.C_STL_GRD + "未分配产线!"); return; } mod_TRP_PLAN_ROLL.C_STA_ID = dr["C_ROLL_STA_ID"].ToString(); if (txt_wgt1.Enabled == true) { mod_TRP_PLAN_ROLL.N_ROLL_PROD_WGT = Convert.ToDecimal(txt_wgt1.Text); } else { mod_TRP_PLAN_ROLL.N_ROLL_PROD_WGT = Convert.ToDecimal(dr["N_WGT"]) - Convert.ToDecimal(dr["N_ROLL_PROD_WGT"]); } if (mod_TRP_PLAN_ROLL.N_WGT <= 0) { return; } if (count > 0) { DataTable bdt = bll_TRP_PLAN_ROLL.GetList(Convert.ToInt32(mod_TRP_PLAN_ROLL.N_SORT - 1), mod_TRP_PLAN_ROLL.C_INITIALIZE_ID, mod_TRP_PLAN_ROLL.C_STA_ID).Tables[0]; if (bdt.Rows.Count > 0) { DateTime enddt = Convert.ToDateTime(bdt.Rows[0]["D_P_END_TIME"]);//上一计划结束时间 DataTable hggdt = bll_TPB_CHANGESPEC_TIME.GetList(1, mod_TRP_PLAN_ROLL.C_STA_ID, bdt.Rows[0]["C_SPEC"].ToString(), mod_TRP_PLAN_ROLL.C_SPEC).Tables[0]; if (hggdt.Rows.Count > 0) { mod_TRP_PLAN_ROLL.D_P_START_TIME = enddt.AddMinutes(Convert.ToDouble(hggdt.Rows[0]["N_TIME"])); } else { mod_TRP_PLAN_ROLL.D_P_START_TIME = enddt; } } } else { mod_TRP_PLAN_ROLL.D_P_START_TIME = DateTime.Now; } int cn = 0; if (!string.IsNullOrEmpty(dr["N_MACH_WGT"].ToString())) { cn = Convert.ToInt32(dr["N_MACH_WGT"].ToString()); } if (cn == 0) { cn = 50; } double db = Convert.ToDouble(mod_TRP_PLAN_ROLL.N_WGT) / Convert.ToDouble(cn); DateTime dt = Convert.ToDateTime(mod_TRP_PLAN_ROLL.D_P_START_TIME); dt = dt.AddHours(Convert.ToDouble(db)); mod_TRP_PLAN_ROLL.D_P_END_TIME = dt; Mod_TPP_INITIALIZE_ORDER mod_TPP_INITIALIZE_ORDER = bll_ini_order.GetModel(mod_TRP_PLAN_ROLL.C_INITIALIZE_ITEM_ID); mod_TPP_INITIALIZE_ORDER.N_EXEC_STATUS = 1; mod_TPP_INITIALIZE_ORDER.N_ROLL_PROD_WGT += mod_TRP_PLAN_ROLL.N_WGT; bll_ini_order.Update(mod_TPP_INITIALIZE_ORDER); //变更方案计划表数据 bll_TRP_PLAN_ROLL.Add(mod_TRP_PLAN_ROLL); //变更计划表 //DataTable itemdt = bll_TPP_INITIALIZE_ITEM.GetListByNAME(cbo_FA.Text).Tables[0]; ////Mod_TPP_INITIALIZE_ITEM mod_TPP_INITIALIZE_ITEM = bll_TPP_INITIALIZE_ITEM.GetModel(itemdt.Rows[0]["C_ID"].ToString()); ////mod_TPP_INITIALIZE_ITEM.N_Z_WGT = (mod_TPP_INITIALIZE_ITEM.N_Z_WGT.ToString() == DBNull.Value.ToString() ? 0 : mod_TPP_INITIALIZE_ITEM.N_Z_WGT) + mod_TRP_PLAN_ROLL.N_WGT; ////mod_TPP_INITIALIZE_ITEM.D_ROLL_END_TIME = mod_TRP_PLAN_ROLL.D_P_END_TIME; ////bll_TPP_INITIALIZE_ITEM.Update(mod_TPP_INITIALIZE_ITEM);//变更方案表 //bll_TPP_INITIALIZE_STA.UpdateBySTAFID(cbo_FA.Text, cbo_GW1.EditValue.ToString(), Convert.ToInt32(txt_wgt1.Text)); }
/// <summary> /// 初始化订单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_csh_Click(object sender, EventArgs e) { if (this.rbtn_type.SelectedIndex == 0) { DataTable dtdchs = dtwchs.Clone(); //将选中的订单复制到当前DataTable int[] rownumber = this.gv_wini_order.GetSelectedRows(); //获取选中行号数组; if (rownumber.Length > 0) { for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; DataRow dr = dtdchs.NewRow(); dr.ItemArray = this.gv_wini_order.GetDataRow(i).ItemArray; dtdchs.Rows.Add(dr); } dtdchs.DefaultView.Sort = " D_DELIVERY_DT, C_LEV "; //将选中的订单按照排产目标进行排序 dtdchs = dtdchs.DefaultView.ToTable(); //获取的需要初始化的表 #region 初始化订单 if (dtdchs.Rows.Count == 0) { MessageBox.Show("没有待处理订单!"); return; } //将初始化的订单信息添加到表TPP_INITIALIZE_ORDER(初始化订单表) for (int j = 0; j < dtdchs.Rows.Count; j++) { //获取当前方案排产的工位 TPP_INITIALIZE_STA //自动分配轧线 TPB_LINE_SPEC TPB_N_GRD //自动分配到连铸 V_GZ_CCM(钢种连铸匹配数据) //匹配轧线及时产量 //匹配连铸机时产量 Mod_TPP_INITIALIZE_ORDER mod = new Mod_TPP_INITIALIZE_ORDER(); mod.C_INITIALIZE_ID = this.lbl_fazj.Text; mod.C_ORDER_ID = dtdchs.Rows[j]["C_ID"].ToString(); mod.N_WGT = Convert.ToDecimal(dtdchs.Rows[j]["N_WGT"].ToString()); mod.C_EMP_NAME = RV.UI.UserInfo.userName; string strSpec = dtdchs.Rows[j]["C_SPEC"].ToString(); //订单规格 string strGZ = dtdchs.Rows[j]["C_STL_GRD"].ToString(); //订单规格 string strBZ = dtdchs.Rows[j]["C_STD_CODE"].ToString(); //订单标准 //自动分配轧钢产线 DataTable dtsta = bll_line_spec.GetLineByWhere(strSpec, this.lbl_fazj.Text, strGZ, strBZ); if (dtsta.Rows.Count > 0) { mod.C_ROLL_STA_ID = dtsta.Rows[0]["C_STA_ID"].ToString();// mod.N_MACH_WGT = Convert.ToDecimal(dtsta.Rows[0]["N_CAPACITY"].ToString()); } //自动分配连铸产线 DataTable dtccm = bll_slab_spec.GetOrderCCM(strGZ, strBZ, this.lbl_fazj.Text); if (dtccm.Rows.Count > 0) { mod.C_CCM_STA_ID = dtccm.Rows[0]["C_STA_ID"].ToString(); mod.N_MACH_WGT_CCM = Convert.ToDecimal(dtccm.Rows[0]["N_CAPACITY"].ToString()); #region 获取钢坯物料信息 DataTable dt = bllslabmatch.GetOrderSlabSize(strGZ, strBZ, "").Tables[0]; if (dt.Rows.Count > 0) { mod.C_SLAB_SIZE = dt.Rows[0]["C_SLAB_SIZE"].ToString(); mod.N_SLAB_LENGTH = Convert.ToDecimal(dt.Rows[0]["C_COLD_LEN"].ToString()); mod.N_SLAB_PW = Convert.ToDecimal(dt.Rows[0]["C_THE_WEIGHT"].ToString().Trim() == ""?"0": dt.Rows[0]["C_THE_WEIGHT"].ToString()); mod.C_KP_SIZE = dt.Rows[0]["C_SLAB_SIZE_KP"].ToString(); mod.N_KP_LENGTH = Convert.ToDecimal(dt.Rows[0]["C_COLD_LEN_KP"].ToString()); mod.N_KP_PW = Convert.ToDecimal(dt.Rows[0]["C_THE_WEIGHT_KP"].ToString().Trim() == ""?"0": dt.Rows[0]["C_THE_WEIGHT_KP"].ToString().Trim()); } #endregion #region 匹配开坯物料信息 #endregion } bll_ini_order.Add(mod); } btn_query_order_wcsh_Click(null, null); MessageBox.Show("订单已初始化!"); #endregion } else { MessageBox.Show("您没有选择需要初始化的订单!"); return; } } else { MessageBox.Show("当前订单已初始化!"); return; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TPP_INITIALIZE_ORDER model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TPP_INITIALIZE_ORDER model) { return(dal.Add(model)); }
/// <summary> /// 添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Save2_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(cbo_FA.Text.Trim())) { MessageBox.Show("请选择方案号!"); return; } if (string.IsNullOrEmpty(btnEdit_Std.Text.Trim())) { MessageBox.Show("请选择执行标准!"); return; } if (string.IsNullOrEmpty(txt_Std_Grd.Text.Trim())) { MessageBox.Show("请填写钢种!"); return; } if (string.IsNullOrEmpty(cbo_CC.Text.Trim()) || cbo_CC.Text == "全部") { MessageBox.Show("请选择连铸!"); return; } if (string.IsNullOrEmpty(txt_Wgt.Text.Trim())) { MessageBox.Show("请填写重量!"); return; } else { double result = 0; if (!double.TryParse(txt_Wgt.Text.Trim(), out result)) { MessageBox.Show("填写的重量不符合规范!"); return; } } Mod_TMO_ORDER modeOrder = new Mod_TMO_ORDER(); modeOrder.C_ORDER_NO = "SD-" + DateTime.Now.ToString("yyyyMMddHHmmss"); //订单号 modeOrder.C_CON_NO = "SD-" + DateTime.Now.ToString("yyyyMMddHHmmss"); //合同号 modeOrder.C_STL_GRD = txt_Std_Grd.Text.Trim(); //钢种 modeOrder.C_STD_CODE = btnEdit_Std.Text.Trim(); //执行标准 modeOrder.N_STATUS = 2; //订单状态 modeOrder.N_WGT = Convert.ToDecimal(txt_Wgt.Text.Trim()); //订单重量 modeOrder.N_TYPE = 6; //6钢坯;8线材 modeOrder.C_EMP_ID = RV.UI.UserInfo.userID; modeOrder.C_MAT_CODE = txt_MatCode.Text.Trim(); //物料编码 modeOrder.C_MAT_NAME = txt_MatName.Text.Trim(); //物料名称 modeOrder.C_SPEC = txt_Spec.Text.Trim(); //断面 if (bll_TMO_ORDER.Add(modeOrder)) { string s_id = bll_TMO_ORDER.Get_ID(modeOrder.C_ORDER_NO, modeOrder.C_CON_NO, modeOrder.C_STL_GRD, modeOrder.C_STD_CODE); Mod_TPP_INITIALIZE_ORDER modINITIALIZEORDER = new Mod_TPP_INITIALIZE_ORDER(); modINITIALIZEORDER.C_INITIALIZE_ID = cbo_FA.EditValue.ToString(); modINITIALIZEORDER.C_ORDER_ID = s_id; modINITIALIZEORDER.N_WGT = Convert.ToDecimal(txt_Wgt.Text.Trim());//订单重量 modINITIALIZEORDER.C_CCM_STA_ID = cbo_CC.EditValue.ToString(); modINITIALIZEORDER.C_EMP_ID = RV.UI.UserInfo.userID; bll_ini_order.Add(modINITIALIZEORDER); MessageBox.Show("订单手动增加成功!"); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "手动添加订单");//添加操作日志 } }