protected void btndel_Click(object sender, EventArgs e) { try { bool res = false; for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect"); if (cbxselect.Checked) { var mod = new Mod_TMC_TRAIN_ITEM() { C_ID = cbxselect.Value }; res = tmc_train_item.Del(mod); } } if (res) { WebMsg.MessageBox("删除成功"); BindList(); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
/// <summary> /// 火运报备计划添加 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool Add(Mod_TMC_TRAIN_ITEM mod) { string strSql = $@"INSERT INTO TMC_TRAIN_ITEM (C_EMPNAME, C_PKID, C_AREA, C_CONNO, C_DH_COMPANY, C_SH_COMPANY, C_STATION, N_TRAIN_NUM, C_CUSTNO, C_CUSTNAME, C_KH_BANK, C_TAXNO, C_ADDRESS, C_TEL, C_ACCOUNT, C_FLAG, C_BILLCODE, D_MONTH, C_LINE ) VALUES("; strSql += $"'{mod.C_EMPNAME}',"; strSql += $"'{mod.C_PKID}',"; strSql += $"'{mod.C_AREA}',"; strSql += $"'{mod.C_CONNO}',"; strSql += $"'{mod.C_DH_COMPANY}',"; strSql += $"'{mod.C_SH_COMPANY}',"; strSql += $"'{mod.C_STATION}',"; strSql += $"{mod.N_TRAIN_NUM},"; strSql += $"'{mod.C_CUSTNO}',"; strSql += $"'{mod.C_CUSTNAME}',"; strSql += $"'{mod.C_KH_BANK}',"; strSql += $"'{mod.C_TAXNO}',"; strSql += $"'{mod.C_ADDRESS}',"; strSql += $"'{mod.C_TEL}',"; strSql += $"'{mod.C_ACCOUNT}',"; strSql += $"'{mod.C_FLAG}',"; strSql += $"'{mod.C_BILLCODE}',"; strSql += $"to_date('{mod.D_MONTH}','YYYY-MM-DD HH24:MI:SS'),"; strSql += $"'{mod.C_LINE}'"; strSql += ")"; return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false); }
//删除行 protected void btndelrow_Click(object sender, EventArgs e) { var list = new List <Mod_TMC_TRAIN_ITEM>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect"); if (cbxselect.Checked) { var mod = new Mod_TMC_TRAIN_ITEM(); mod.C_ID = cbxselect.Value; list.Add(mod); } } if (tmc_train_main.Del_ITEM(list)) { BindList(); } }
protected void btnsave_Click(object sender, EventArgs e) { try { var list = new List <Mod_TMC_TRAIN_ITEM>(); var mod = new Mod_TMC_TRAIN_MAIN() { C_ID = txtcode.Text, C_STATION = txtstation.Text, C_PLANNO = txtplanno.Text, C_LINE = txtline.Text, N_TRAIN_NUM = Convert.ToDecimal(txtnum.Text == "" ? "0" : txtnum.Text), D_EDIT_DT = DateTime.Now, C_REMARK = txtshdw.Text, D_DT = Convert.ToDateTime(txtdate.Value) }; for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect"); TextBox txtwgt = (TextBox)rptList.Items[i].FindControl("txtwgt"); TextBox txtremark = (TextBox)rptList.Items[i].FindControl("txtremark"); var moditem = new Mod_TMC_TRAIN_ITEM() { C_ID = cbxselect.Value, N_WGT = Convert.ToDecimal(txtwgt.Text == "" ? "0" : txtwgt.Text), C_REMARK = txtremark.Text }; list.Add(moditem); } if (tmc_train_main.UpdateTrainDay(mod, list)) { WebMsg.MessageBox("保存成功", "train_day_apply.aspx"); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
protected void btSave_Click(object sender, EventArgs e) { try { var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; var mod = new Mod_TMC_TRAIN_ITEM() { C_EMPNAME = vUser.Name, C_PKID = vUser.Id, C_AREA = droparea.SelectedItem.Text, C_CONNO = txtC_CONNO.Text, C_DH_COMPANY = txtC_DH_COMPANY.Text, C_SH_COMPANY = txtC_SH_COMPANY.Text, C_STATION = txtC_STATION.Text, N_TRAIN_NUM = Convert.ToDecimal(txtN_TRAIN_NUM.Text), C_CUSTNO = txtC_CUSTNO.Text, C_CUSTNAME = txtC_CUSTNAME.Text, C_KH_BANK = txtC_KH_BANK.Text, C_TAXNO = txtC_TAXNO.Text, C_ADDRESS = txtC_ADDRESS.Text, C_TEL = txtC_TEL.Text, C_ACCOUNT = txtC_ACCOUNT.Text, C_FLAG = dropflag.SelectedValue, C_BILLCODE = randomnumber.GetTrainCode(), D_MONTH = Convert.ToDateTime(txtStart.Value + "-1"), C_LINE = txtLine.Text }; if (tmc_train_item.Add(mod)) { WebMsg.MessageBox("保存成功"); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
/// <summary> /// 删除火运计划 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool Del(Mod_TMC_TRAIN_ITEM mod) { string strSql = $"DELETE FROM TMC_TRAIN_ITEM WHERE C_ID='{mod.C_ID}'"; return(DbHelperOra.ExecuteSql(strSql) > 0 ? true : false); }
protected void btnsave_Click(object sender, EventArgs e) { try { var list = new List <Mod_TMC_TRAIN_ITEM>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect"); if (cbxselect.Checked) { //Literal ltlC_AREA = (Literal)rptList.Items[i].FindControl("ltlC_AREA"); //Literal ltlC_CONNO = (Literal)rptList.Items[i].FindControl("ltlC_CONNO"); TextBox txtdhdw = (TextBox)rptList.Items[i].FindControl("txtdhdw"); //TextBox txtC_SH_COMPANY = (TextBox)rptList.Items[i].FindControl("txtC_SH_COMPANY"); //Literal ltlC_SPEC = (Literal)rptList.Items[i].FindControl("ltlC_SPEC"); //Literal ltlC_STL_GRD = (Literal)rptList.Items[i].FindControl("ltlC_STL_GRD"); TextBox txtN_WGT = (TextBox)rptList.Items[i].FindControl("txtN_WGT"); TextBox txtRemark = (TextBox)rptList.Items[i].FindControl("txtRemark"); TextBox txtC_CUSTNO = (TextBox)rptList.Items[i].FindControl("txtC_CUSTNO"); TextBox txtC_CUSTNAME = (TextBox)rptList.Items[i].FindControl("txtC_CUSTNAME"); TextBox txtC_KH_BANK = (TextBox)rptList.Items[i].FindControl("txtC_KH_BANK"); TextBox txtC_TAXNO = (TextBox)rptList.Items[i].FindControl("txtC_TAXNO"); TextBox txtC_ACCOUNT = (TextBox)rptList.Items[i].FindControl("txtC_ACCOUNT"); TextBox txtC_TEL = (TextBox)rptList.Items[i].FindControl("txtC_TEL"); TextBox txtC_ADDRESS = (TextBox)rptList.Items[i].FindControl("txtC_ADDRESS"); var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; var mod = new Mod_TMC_TRAIN_ITEM() { C_EMPNAME = vUser.Name, C_PKID = ltlID.Text, C_AREA = "副产品销售部", C_CONNO = "", C_DH_COMPANY = txtdhdw.Text, C_SH_COMPANY = "", C_CUSTNO = txtC_CUSTNO.Text, C_CUSTNAME = txtC_CUSTNAME.Text, C_KH_BANK = txtC_KH_BANK.Text, C_TAXNO = txtC_TAXNO.Text, C_ADDRESS = txtC_ADDRESS.Text, C_TEL = txtC_TEL.Text, C_ACCOUNT = txtC_ACCOUNT.Text, C_FLAG = "1", C_BILLCODE = cbxselect.Value, C_SPEC = "", C_STL_GRD = "", N_WGT = Convert.ToDecimal(txtN_WGT.Text == "" ? "0" : txtN_WGT.Text), C_REMARK = txtRemark.Text }; list.Add(mod); } } if (tmc_train_item.AddTrain(list)) { Response.Write("<script>window.parent.document.getElementById('imgbtnJz').click();window.parent.close();</script>"); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
/// <summary> /// 添加发运单 /// </summary> /// <returns></returns> private bool InsertFyd() { decimal fyzs = 0; decimal fywgt = 0; string sendcode = randomnumber.CreateDispID(); //发运单据号 #region //表体 List <Mod_TMD_DISPATCHDETAILS> item = new List <Mod_TMD_DISPATCHDETAILS>(); //发运明显 List <Mod_TMC_TRAIN_ITEM> trainList = new List <Mod_TMC_TRAIN_ITEM>(); //火运计划申请明显 for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox chkOrder = (HtmlInputCheckBox)rptList.Items[i].FindControl("chkOrder"); //订单主键 HtmlInputText txtfyzs = (HtmlInputText)rptList.Items[i].FindControl("txtfyzs"); //发运支数 HtmlInputText txtjhfyl = (HtmlInputText)rptList.Items[i].FindControl("txtjhfyl"); //发运数量 HtmlInputHidden hidC_CGID = (HtmlInputHidden)rptList.Items[i].FindControl("hidC_CGID"); //收货单位 HtmlInputHidden hidshdq = (HtmlInputHidden)rptList.Items[i].FindControl("hidshdq"); //收货地区 TextBox txtPack_Code = (TextBox)rptList.Items[i].FindControl("txtPack_Code"); //包装要求 DropDownList dropzldj = (DropDownList)rptList.Items[i].FindControl("dropzldj"); //质量等级 DropDownList dropshdz = (DropDownList)rptList.Items[i].FindControl("dropshdz"); //收货地址 Literal ltlpkplan = (Literal)rptList.Items[i].FindControl("ltlpkplan"); //日计划主键 Literal ltlcustno = (Literal)rptList.Items[i].FindControl("ltlcustno"); //客户编码 HtmlInputHidden hidckid = (HtmlInputHidden)rptList.Items[i].FindControl("hidckid"); //仓库ID HtmlInputText txtckname = (HtmlInputText)rptList.Items[i].FindControl("txtckname"); //仓库名称 HtmlInputText txtqtyq = (HtmlInputText)rptList.Items[i].FindControl("txtqtyq"); //其他要求 HtmlInputText txtremark = (HtmlInputText)rptList.Items[i].FindControl("txtremark"); //行备注 HtmlInputText txtaddr = (HtmlInputText)rptList.Items[i].FindControl("txtaddr"); //到货地点 HtmlInputText txtprice = (HtmlInputText)rptList.Items[i].FindControl("txtprice"); //费用 TextBox txtStd_Code = (TextBox)rptList.Items[i].FindControl("txtStd_Code"); //执行标准 TextBox txtC_FREE1 = (TextBox)rptList.Items[i].FindControl("txtC_FREE1"); //自由项1 TextBox txtC_FREE2 = (TextBox)rptList.Items[i].FindControl("txtC_FREE2"); //自由项2 Mod_TMO_ORDER modOrder = tmo_order.GetModel(chkOrder.Value); if (modOrder != null) { fyzs += Convert.ToDecimal(txtfyzs.Value ?? "0"); fywgt += Convert.ToDecimal(txtjhfyl.Value ?? "0"); Mod_TMD_DISPATCHDETAILS modfyditem = new Mod_TMD_DISPATCHDETAILS(); modfyditem.C_DISPATCH_ID = sendcode; //发运单单据号 modfyditem.C_MAT_CODE = modOrder.C_MAT_CODE; //物料编码 modfyditem.C_MAT_NAME = modOrder.C_MAT_NAME; //物料名称 modfyditem.C_SPEC = modOrder.C_SPEC; //规格 modfyditem.C_STL_GRD = modOrder.C_STL_GRD; //钢种 modfyditem.C_QUALIRY_LEV = dropzldj.SelectedItem.Value; //质量等级主键-发运单 modfyditem.C_JUDGE_LEV_ZH = dropzldj.SelectedItem.Text; //质量等级编码 modfyditem.C_FREE_TERM = txtC_FREE1.Text; //自由项 modfyditem.C_FREE_TERM2 = txtC_FREE2.Text; //自由项 modfyditem.C_PACK = txtPack_Code.Text; //包装要求 modfyditem.C_STD_CODE = txtStd_Code.Text; //执行标准 modfyditem.C_ELSENEED = txtqtyq.Value; //其他要求? modfyditem.C_REMARK = txtremark.Value; //行备注***** modfyditem.N_COM_AMOUNT_WGT = modOrder.N_FNUM; //原始订单辅数量 modfyditem.N_WGT = modOrder.N_WGT; //原始订单数量 modfyditem.C_EQUATION_FACTOR = modOrder.N_HSL.ToString(); //换算率 modfyditem.C_UNITIS = modOrder.C_UNITID; //主计量单位ID modfyditem.C_ORGO_CUST = modOrder.C_CUST_NAME; //订货客户 modfyditem.C_CGC = hidC_CGID.Value; //收货单位-发运单 modfyditem.C_ORDER_TYPE = modOrder.N_TYPE.ToString(); //订单类型 8线材 6钢坯 831废乱材 841焦化产品 851渣 modfyditem.C_SEND_AREA = hidshdq.Value; //到货地区-发运单 modfyditem.C_AREA = dropshdz.SelectedItem?.Value ?? ""; //到货地址-发运单 modfyditem.C_EMP_ID = ltlempid.Text; modfyditem.C_EMP_NAME = ltlempname.Text; modfyditem.C_CON_NO = modOrder.C_CON_NO; //合同号 modfyditem.C_PLAN_ID = ltlpkplan.Text; //日计划主键 modfyditem.C_NO = modOrder.C_ORDER_NO; //订单号 modfyditem.C_ORDERPK = modOrder.C_ID; //订单主键 modfyditem.C_CUSTNO = ltlcustno.Text; //客户编码 modfyditem.N_FYZS = Convert.ToDecimal(txtfyzs.Value == "" ? "0" : txtfyzs.Value); //发运支数 modfyditem.N_FYWGT = Convert.ToDecimal(txtjhfyl.Value == "" ? "0" : txtjhfyl.Value); //发运数量 modfyditem.C_SEND_STOCK = txtckname.Value; //发运仓库名称 modfyditem.C_SEND_STOCK_PK = hidckid.Value; //发运仓库ID modfyditem.C_PRODUCT_ID = ""; //库存产品ID modfyditem.C_AU_UNITIS = modOrder.C_FUNITID; //辅单位 modfyditem.C_AOG_SITE = txtaddr.Value; //到货地点 modfyditem.N_PRICE = Convert.ToDecimal(txtprice.Value == "" ? "0" : txtprice.Value); //到货地点费用 item.Add(modfyditem); #region //火运计划明细 Mod_TS_CUSTFILE modCustInfo = ts_custfile.GetCustInfo(txtkpdwcode.Text == "" ? modOrder.C_CUST_NO : txtkpdwcode.Text); var modTrainItem = new Mod_TMC_TRAIN_ITEM() { C_EMPNAME = ltlempname.Text, //提报人 C_PKID = sendcode, //发运单号 C_AREA = modOrder.C_AREA, //区域 C_CONNO = modOrder.C_CON_NO, //合同号 C_DH_COMPANY = modOrder.C_CUST_NAME, //订货单位 C_SH_COMPANY = txtshdw.Text == "" ? modOrder.C_CUST_NAME : txtshdw.Text, //收货单位 C_CUSTNO = modCustInfo.C_NO, //客户编码 C_CUSTNAME = modCustInfo.C_NAME, //客户名称 C_KH_BANK = modCustInfo.C_EXTEND1, //开户行 C_TAXNO = modCustInfo.C_TAXPAYERNO, //税号 C_ADDRESS = modCustInfo.C_EXTEND3, //地址 C_TEL = modCustInfo.C_EXTEND4, //电话 C_ACCOUNT = modCustInfo.C_EXTEND2, //账号 C_FLAG = "1", C_BILLCODE = modOrder.C_ORDER_NO, //订单号 C_SPEC = modOrder.C_SPEC, //规格 C_STL_GRD = modOrder.C_STL_GRD, //钢种 N_WGT = Convert.ToDecimal(txtjhfyl.Value == "" ? "0" : txtjhfyl.Value), //发运量 C_REMARK = txtremark.Value //行备注 }; trainList.Add(modTrainItem); #endregion } } #endregion #region//发运表头 Mod_TMD_DISPATCH modfyd = new Mod_TMD_DISPATCH(); modfyd.C_ID = sendcode; //发运单单据号 modfyd.C_GPS_NO = txtgps.Text; //GPS号 modfyd.D_DISP_DT = Convert.ToDateTime(txtfydt.Text); //发运日期 modfyd.C_SHIPVIA = dropfyfs.SelectedItem.Value; //发运方式 modfyd.C_COMCAR = dropcys.SelectedItem.Value; //承运商 modfyd.C_IS_WIRESALE = dropsfxc.SelectedItem.Text; //汉字是否线材 modfyd.C_IS_WIRESALE_ID = dropsfxc.SelectedItem.Value; //是否线材主键 modfyd.C_LIC_PLA_NO = txtcph.Text; //车牌号 modfyd.C_ATSTATION = txtdz.Text; //到站 modfyd.C_CREATE_ID = ltlempid.Text; //制单人 modfyd.C_EMP_ID = ltlempid.Text; //修改人ID modfyd.C_EMP_NAME = ltlempname.Text; //修改人 modfyd.C_EXTEND5 = ltltype.Text; //订单类型 8线材 6钢坯 831废乱材 841焦化产品 851渣 modfyd.C_CUSTNAME = ltlcustname.Text; //客户 modfyd.C_CON_NO = ltlcon_no.Text; //合同号 modfyd.N_QUA = fyzs; //发运支数 modfyd.N_WGT = fywgt; //发运量 //0001NC10000000003ILQ-火运代垫,0001NC10000000003ILR-汽运代垫,0001NC10000000003ILV-自提运输 modfyd.N_IS_EXPORT = dropfyfs.SelectedValue == "0001NC10000000003ILQ" ? 1 : Convert.ToDecimal(dropsfbdj.SelectedValue); //是否包到价 modfyd.C_EXTEND2 = txtxnch.Text == "" ? txtcph.Text : txtxnch.Text; //虚拟车号 modfyd.C_EXTEND4 = txtcust_tel.Text; //客户姓名/电话 modfyd.C_EXTEND3 = txtsjtel.Text; //司机姓名/电话 Mod_TMO_CON modCon = tmo_con.GetModel(ltlcon_no.Text); if (modCon != null) { modfyd.C_BUSINESS_DEPT = modCon.C_DEPTID; //业务部门 modfyd.C_BUSINESS_ID = modCon.C_EMPLOYEEID; //业务员 } #endregion #region //火运计划表头 string fyfalg = ts_dic.GetDicFlag("ShipVia", dropfyfs.SelectedItem.Text); //获取是否下发审核(泰翔)Y/N var modtrain = new Mod_TMC_TRAIN_MAIN() { C_ID = sendcode, C_EMPID = modfyd.C_CREATE_ID, C_EMPNAME = modfyd.C_EMP_NAME, C_STATION = modfyd.C_ATSTATION, C_PLANNO = txtplanno.Text, C_LINE = txtline.Text, C_REMARK = txtshdw.Text, N_TRAIN_NUM = 1, C_SHIPVIA = dropfyfs.SelectedItem.Text, C_ISCHECK = fyfalg == "N" ? "Y" : "N"//Y通过/N未通过 }; #endregion if (tmd_dispatch.InsertFYD(modfyd, item)) { txtsendcode.Text = sendcode; //汽运代垫自动生成汽运计划/火运计划 if (dropfyfs.SelectedValue == "0001NC10000000003ILR" || cbx_sftrain.Checked == true) { #region //自动生成火运/汽运日计划申请 try { tmd_dispatch.AddTrainPlan(modtrain, trainList); } catch (Exception) { return(true); } #endregion } return(true); } else { return(false); } }
/// <summary> /// 火运计划(内/外)申请 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool Add(Mod_TMC_TRAIN_ITEM mod) { return(dal.Add(mod)); }
public bool Del(Mod_TMC_TRAIN_ITEM mod) { return(dal.Del(mod)); }