protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { Mod_TMO_ORDER mod = tmo_order.GetModel(Request.QueryString["ID"]); if (mod != null) { Mod_TMO_CON conmod = tmo_con.GetModel(mod.C_CON_NO); if (conmod != null) { var list = trc_roll_prodcut.Check_OrderAndRoll(mod.C_CON_NO); if (list.Result) { if (list.Flag == 0) { lbl_msg.Text = "当前合同存在排产计划,请谨慎操作!"; } else { lbl_msg.Text = "当前合同存在线材库存,请谨慎操作!"; } } ltlConNO.Text = conmod.C_CON_NO; ltlcustno.Text = conmod.C_CUST_NO; ltlcustname.Text = conmod.C_CUSTNAME; ltlarea.Text = conmod.C_AREA; } } } } }
/// <summary> /// /// </summary> /// <param name="order">合同信息</param> /// <param name="matrl">成品物料信息</param> /// <param name="item">组批信息</param> /// <param name="ssBmid">部门ID</param> /// <returns></returns> private NcRollA1 GetA1(Mod_TMO_ORDER order, Mod_TB_MATRL_MAIN matrl, Mod_TRC_ROLL_WW_MAIN item, Mod_TB_STA tBSta, Mod_TS_USER user) { var ncRollA1 = new NcRollA1 { bmid = tBSta.C_SSBMID, //部门ID jhrq = item.D_MOD_DT, //计划日期 jhxxsl = (item.N_WGT_TOTAL ?? 0).ToString(), //下限数量 jhyid = matrl.C_PLANEMP, // 计划员ID jldwid = matrl.C_PK_MEASDOC, //计量单位 memo = item.C_REMARK, //备注 pk_produce = matrl.C_PK_PRODUCE, //物料PK, scbmid = tBSta.C_SSBMID, //生产部门ID shrid = item.C_PRODUCE_EMP_ID, //操作员 shrq = DateTime.Now, //审核日期 slrq = order.D_DT ?? DateTime.Now, //需求日期 wlbmid = matrl.C_PK_INVBASDOC, // 存货档案主键 xdrq = item.D_MOD_DT, //下单日期 xqrq = order.D_DELIVERY_DT ?? DateTime.Now, //交货日期 xqsl = (item.N_WGT_TOTAL ?? 0).ToString(), //计划量 zdrq = DateTime.Now, //制单日期 zyx1 = order.C_FREE1, //自由项1 zyx2 = order.C_FREE2, //自由项2 zyx3 = order.C_PACK, //包装要求 zyx5 = item.C_ID, //PCI主键 }; return(ncRollA1); }
private NcRollA3 GetA3(Mod_TMO_ORDER order, Mod_TB_MATRL_MAIN ordMatrl, Mod_TB_MATRL_MAIN matrl, Mod_TRC_ROLL_WW_MAIN item, Mod_TB_STA tBSta, Mod_TRC_ROLL_PRODCUT xcItem) { var lineWhItem = dalLineWh.GetModelByCode(item.C_XC_LINEWH_CODE); var ncRollA3 = new NcRollA3 { ckckid = lineWhItem.C_ID, //出库仓库ID(TPB_LINEWH线材库ID) fjldwid = matrl.C_FJLDW, //辅助计量单位ID, fljcksl = (item.N_QUA_TOTAL ?? 0).ToString(), // 出库数量 flrq = DateTime.Now.ToString("yyyy-MM-dd"), freeitemvalue1 = xcItem.C_ZYX1, //order.C_FREE1,// 线材自由项1(暂认为委外与线材自由项一致) freeitemvalue2 = xcItem.C_ZYX2, //order.C_FREE2,//线材自由项2(暂认为委外与线材自由项一致) freeitemvalue3 = item.C_XC_BZYQ, // 线材包装要求 gzzxid = tBSta.C_ERP_PK, //工作中心ID hfreeitemvalue1 = order.C_FREE1, // 成品自由项1 hfreeitemvalue2 = order.C_FREE2, //成品自由项2 hfreeitemvalue3 = order.C_PACK, // 成品包装要求, hjldwid = ordMatrl.C_PK_MEASDOC, //主计量单位ID hpch = item.C_BATCH_NO, //批号 hwlbmid = ordMatrl.C_PK_INVBASDOC, //存货档案主键 hzdrid = item.C_PRODUCE_EMP_ID, //操作人 hzdrq = item.D_PRODUCE_DATE_B ?? DateTime.Now, //制单日期 jldwid = matrl.C_PK_MEASDOC, //计量单位 kgyid = item.C_PRODUCE_EMP_ID, //库管员 ljcksl = (item.N_WGT_TOTAL ?? 0).ToString(), //累计出库数量 pch = item.C_XC_BATCH_NO, //线材批号 wlbmid = matrl.C_PK_INVBASDOC, //存货档案主键 zdrq = DateTime.Now, }; return(ncRollA3); }
private NcRollA2 GetA2(Mod_TMO_ORDER order, Mod_TB_MATRL_MAIN matrl, Mod_TRC_ROLL_WW_MAIN item, Mod_TB_STA tBSta, Mod_TS_USER user) { var ncRollA2 = new NcRollA2 { bcid = item.C_SHIFT, // 班次ID bzid = item.C_GROUP, // 班组ID fjhsl = (item.N_QUA_REMOVE ?? 0).ToString(), // 辅计量数量 fjlid = matrl.C_FJLDW, // 辅计量ID freeitemvalue1 = order.C_FREE1, // 自由项1 freeitemvalue2 = order.C_FREE2, //自由项2 freeitemvalue3 = order.C_PACK, // 包装要求, freeitemvalue5 = item.C_ID, //PCI计划主键 gzzxid = tBSta.C_ERP_PK, //工作中心ID invcode = matrl.C_ID, //物料编码 jhjssj = item.D_PRODUCE_DATE_E ?? DateTime.Now, // 计划完工时间 jhkgrq = item.D_PRODUCE_DATE_B ?? DateTime.Now, //计划开工日期 jhkssj = item.D_PRODUCE_DATE_B ?? DateTime.Now, //计划开始时间 jhwgrq = item.D_PRODUCE_DATE_E ?? DateTime.Now, //计划完工日期 jhwgsl = (item.N_WGT_TOTAL ?? 0).ToString(), //计划完工数量 jldwid = matrl.C_PK_MEASDOC, //计量单位ID pch = item.C_BATCH_NO, //批次号 pk_produce = matrl.C_PK_PRODUCE, //物料PK scbmid = tBSta.C_SSBMID, //生产部门ID sjjssj = item.D_PRODUCE_DATE_E ?? DateTime.Now, //实际结束时间 sjkgrq = item.D_PRODUCE_DATE_E ?? DateTime.Now, //完工单日期 sjkssj = item.D_PRODUCE_DATE_B ?? DateTime.Now, //实际开始日期 sjwgrq = item.D_PRODUCE_DATE_E ?? DateTime.Now, //实际完工日期 sjwgsl = (item.N_WGT_REMOVE ?? 0).ToString(), //实际完工数量 wlbmid = matrl.C_PK_INVBASDOC, //存货档案主键 zdrid = user.C_ACCOUNT // "17384",//item.C_PRODUCE_EMP_ID,//操作人,用户编码工号 }; return(ncRollA2); }
private NcRollA4 GetA4(Mod_TMO_ORDER order, Mod_TB_MATRL_MAIN ordMatrl, Mod_TRC_ROLL_WW_MAIN item, Mod_TB_STA tBSta, Mod_TS_USER user) { var ncRollA4 = new NcRollA4 { ccxh = item.C_BATCH_NO, //批号 fhgsl = (item.N_QUA_REMOVE ?? 0).ToString(), //完工数量 freeitemvalue1 = order.C_FREE1, //自由项1 freeitemvalue2 = order.C_FREE2, //自由项2 freeitemvalue3 = order.C_PACK, //包装要求 gzzxbmid = tBSta.C_STA_ERPCODE, //工作中心代码 gzzxid = tBSta.C_ERP_PK, //工作中心ID hgsl = (item.N_WGT_REMOVE ?? 0).ToString(), //合格数量 jldwid = ordMatrl.C_PK_MEASDOC, //计量单位ID jsrq = item.D_PRODUCE_DATE_E ?? DateTime.Now, //生产结束日期 ksrq = item.D_PRODUCE_DATE_B ?? DateTime.Now, //生产开始日期 pch = item.C_BATCH_NO, //批次号, pk_produce = ordMatrl.C_PK_PRODUCE, //物料PK rq = item.D_PRODUCE_DATE_E ?? DateTime.Now, //完工日期 scbmid = tBSta.C_SSBMID, //生产部门ID sffsgp = "N", //是否发生改判 sflfcp = "N", //是否联产品 sj = DateTime.Now, //报告时间 wlbmid = ordMatrl.C_PK_INVBASDOC, //物料编码ID zdrid = user.C_ACCOUNT, //item.C_PRODUCE_EMP_ID,//操作人员 }; return(ncRollA4); }
private void btn_order_pj1_Click(object sender, EventArgs e) { if (DialogResult.Yes == MessageBox.Show("是否评价选中的订单?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { WaitingFrom.ShowWait("系统正在对订单进行分析,请稍候..."); int res = 0; if (lst.Count > 0) { if (lst.Where(a => a.B_check).ToList().Count > 0) { string C_TYPE = "正常"; if (rbtn_lx_type.SelectedIndex == 1) { C_TYPE = "试验"; } for (int i = 0; i < lst.Count; i++) { if (lst[i].B_check) { string c_order_id = lst[i].C_ID; Mod_TMO_ORDER mod = bll_order.GetModel(c_order_id); Cls_Order_PC.OrderPj(mod, C_TYPE); res = res + 1; } } } } MessageBox.Show("订单已成功评价" + res.ToString() + "条!"); btn_query_order_Click(null, null); WaitingFrom.CloseWait(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { ltlOrderNo.Text = Request.QueryString["ID"]; Mod_TMO_ORDER mod = tmo_order.GetModel(ltlOrderNo.Text); if (mod != null) { ltlConNO.Text = mod.C_CON_NO; ltlMatCode.Text = mod.C_MAT_CODE; ltlMatName.Text = mod.C_MAT_NAME; ltlSpec.Text = mod.C_SPEC; ltlStlGrd.Text = mod.C_STL_GRD; ltlFree1.Text = mod.C_FREE1; ltlFree2.Text = mod.C_FREE2; ltlPack.Text = mod.C_PACK; txtNum.Value = mod.N_WGT.ToString(); ltlTaxRate.Text = mod.N_TAXRATE.ToString(); ltlPrice.Text = mod.N_ORIGINALCURTAXPRICE.ToString(); } } } }
private NcRoll46 Get46(Mod_TMO_ORDER order, Mod_TB_MATRL_MAIN ordMatrl, Mod_TRC_ROLL_WW_MAIN item, Mod_TB_STA tBSta, Mod_TS_USER user) { Mod_TQB_CHECKSTATE mod_TQB_CHECKSTATE = dal_TQB_CHECKSTATE.GetModelByName(item.C_CHECKSTATE_NAME, "1001"); var lineWhItem = dalLineWh.GetModelByCode(item.C_LINEWH_CODE); var ncRoll46 = new NcRoll46 { castunitid = ordMatrl.C_FJLDW, //辅助计量单位ID ccheckstate_bid = mod_TQB_CHECKSTATE.C_ID, //"1001NC100000000052Z3",//质量等级ID cinvbasid = ordMatrl.C_PK_INVBASDOC, //存货基本ID coperatorid = user.C_ACCOUNT, //"17384",//item.C_PRODUCE_EMP_ID,//入库人 cwarehouseid = lineWhItem.C_ID, //仓库ID cworkcenterid = tBSta.C_ERP_PK, dbizdate = DateTime.Now, //入库日期 ninassistnum = (item.N_QUA_REMOVE ?? 0).ToString(), //入库件数 ninnum = (item.N_WGT_REMOVE ?? 0).ToString(), //入库数量 pk_produce = ordMatrl.C_PK_PRODUCE, //物料PK taccounttime = DateTime.Now, //入库签字时间 vbatchcode = item.C_BATCH_NO, vfree1 = order.C_FREE1, vfree2 = order.C_FREE2, vfree3 = order.C_PACK, }; return(ncRoll46); }
private void btn_pc_Click(object sender, EventArgs e) { try { DialogResult dialogResult = MessageBox.Show("是否下达该头尾炉计划?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dialogResult == DialogResult.OK)//如果点击“确定”按钮 { DataRow dr = this.gv_Order.GetDataRow(this.gv_Order.FocusedRowHandle); if (dr == null) { MessageBox.Show("请选择需要下达的计划!"); return; } Mod_TMO_ORDER mod = bll_Order.GetModel(dr["C_ID"].ToString()); Cls_APS_PC.DownOrder(mod.C_ID, mod.N_WGT); MessageBox.Show("计划已下达"); WaitingFrom.ShowWait("数据正在加载,请稍后。。。"); NewMethod(); WaitingFrom.CloseWait(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Del_Click(object sender, EventArgs e) { try { DialogResult dialogResult = MessageBox.Show("是否删除?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dialogResult == DialogResult.OK)//如果点击“确定”按钮 { DataRow dr = this.gv_Order.GetDataRow(this.gv_Order.FocusedRowHandle); if (dr == null) { MessageBox.Show("请选择需要删除的信息!"); return; } Mod_TMO_ORDER mod = bll_Order.GetModel(dr["C_ID"].ToString()); mod.N_TYPE = 11; mod.C_EMP_ID = RV.UI.UserInfo.UserID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); if (bll_Order.Update(mod)) { Mod_TRP_PLAN_ROLL modroll = bll_roll.GetModelByOrderNo(mod.C_ORDER_NO); modroll.N_STATUS = 3; bll_roll.Update(modroll); MessageBox.Show("删除成功!"); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "删除首尾炉订单");//添加操作日志 NewMethod(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 检测仓库是否重复 /// </summary> /// <param name="ckcode"></param> /// <returns></returns> private bool getck(string orderID) { bool result = true; Mod_TMO_ORDER mod = tmo_order.GetModel(orderID); #region //客户余额查询 Mod_TS_CUSTFILE modCustInfo = ts_custfile.GetModelCode(mod.C_CUST_NO); DataTable dt = ts_custfile.GetCusetMoney(modCustInfo.C_ID).Tables[0]; if (dt.Rows.Count > 0) { lblcustmoney.Text = modCustInfo.C_NAME + ",余额:" + decimal.Parse(dt.Rows[0]["KHYE"].ToString()).ToString("###,##0.00") + " 更新时间:" + Convert.ToDateTime(dt.Rows[0]["TS"].ToString()).ToString(); } else { lblcustmoney.Text = ""; } #endregion for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox chkOrder = (HtmlInputCheckBox)rptList.Items[i].FindControl("chkOrder"); Literal ltlC_STL_GRD = (Literal)rptList.Items[i].FindControl("ltlC_STL_GRD"); Literal ltlC_SPEC = (Literal)rptList.Items[i].FindControl("ltlC_SPEC"); if (ltlC_STL_GRD.Text == mod.C_STL_GRD && ltlC_SPEC.Text == mod.C_SPEC) { result = false; break; } } return(result); }
//合同变更 protected void btnConBg_Click(object sender, EventArgs e) { try { #region //新增变更合同 List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>(); #region //添加合同基本信息 int NO = Convert.ToInt32(ltlcon_bgNo.Text) + 1; Mod_TMO_CON modCon = tmo_con.GetModel(txtConNO.Text); modCon.C_CON_NO = modCon.C_CON_NO + "-" + NO.ToString(); modCon.C_CON_NAME = modCon.C_CON_NAME; modCon.N_STATUS = -1; //客户待提交 modCon.D_CONSING_DT = DateTime.Now; //合同签署日期 modCon.D_CONEFFE_DT = Convert.ToDateTime(DateTime.Now); //计划生效日期 modCon.D_CONINVALID_DT = Convert.ToDateTime(DateTime.Now).AddDays(60); //计划失效日期 modCon.C_CON_NO_OLD = txtConNO.Text; //原始合同号 modCon.N_CHANGENUM = NO; //变更次数 #endregion #region //添加合同明细 Bll_RandomNumber randomnumber = new Bll_RandomNumber(); //流水号 DataTable dtOrder = tmo_order.GetConOrderList(txtConNO.Text, "", "", "", "", "").Tables[0]; for (int i = 0; i < dtOrder.Rows.Count; i++) { Mod_TMO_ORDER modOrder = tmo_order.GetModel(dtOrder.Rows[i]["C_ID"].ToString()); //订单表 string order_no = randomnumber.CreateOrderNo(modCon.C_CON_NO); //订单号 modOrder.C_ORDER_NO = order_no; modOrder.C_CON_NO = modCon.C_CON_NO; //合同号 modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称 modOrder.C_CUST_NO = modCon.C_CUST_NO; //客户编码 modOrder.C_CUST_NAME = modCon.C_CUSTNAME; //客户名称 modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位 modOrder.N_STATUS = -1; //客户待提交 modOrder.C_SFPJ = "N"; //是否评价 modOrder.N_EXEC_STATUS = -2; //未提报 modOrder.N_WGT = modOrder.N_WGT; //原合同数量 modOrder.C_ORDER_NO_OLD = dtOrder.Rows[i]["C_ORDER_NO"].ToString(); //原合同号 orderList.Add(modOrder); } #endregion #endregion if (tmo_con.InsertConOrder(modCon, orderList)) { string url = "ConEdit_BG.aspx?ID=" + modCon.C_CON_NO + "&YID=" + txtConNO.Text; Response.Redirect(url); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
public string GetConArea(object orderID) { string str = string.Empty; Mod_TMO_ORDER mod = tmo_order.GetModel(orderID.ToString()); if (mod != null) { str = mod.C_AREA; } return(str); }
//库存订单 protected void btn_add_Click(object sender, EventArgs e) { try { List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>(); #region Insert Mod_TMO_ORDER modOrder = tmo_order.GetModel(ltlOrderNo.Text); Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetModel(modOrder.C_MAT_CODE); string order_no = randomnumber.CreateOrderNo(ltlConNO.Text);//订单号 modOrder.C_ORDER_NO = order_no; modOrder.N_USER_LEV = 0; modOrder.N_COST = 0; decimal N_WGT = Convert.ToDecimal(txtNum.Value ?? "0"); modOrder.N_WGT = N_WGT; //数量 modOrder.N_HSL = modMat.N_HSL == null ? 0 : modMat.N_HSL; //换算率 modOrder.N_FNUM = modMat.N_HSL == null ? 1 : N_WGT / modMat.N_HSL; //辅数量 #region //获取钢种单价-折扣-税率 decimal Price = Convert.ToDecimal(modOrder.N_ORIGINALCURTAXPRICE); //原币含税单价 decimal N_TAXRATE = Convert.ToDecimal(modOrder.N_TAXRATE) + 1; //税率 decimal N_ORIGINALCURPRICE = Convert.ToDecimal(Price) / N_TAXRATE; //原币无税单价 decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(Price); //原币含税单价 decimal N_ORIGINALCURMNY = decimal.Round(N_WGT * N_ORIGINALCURPRICE, 2); //原币无税金额 decimal N_ORIGINALCURSUMMNY = N_WGT * N_ORIGINALCURTAXPRICE; //原币价税合计 decimal N_ORIGINALCURTAXMNY = decimal.Round(N_ORIGINALCURSUMMNY - N_ORIGINALCURMNY, 2); //原币税额 modOrder.N_ORIGINALCURPRICE = N_ORIGINALCURPRICE; //原币无税单价 modOrder.N_ORIGINALCURTAXPRICE = N_ORIGINALCURTAXPRICE; //原币含税单价 modOrder.N_ORIGINALCURTAXMNY = N_ORIGINALCURTAXMNY; //原币税额 modOrder.N_ORIGINALCURMNY = N_ORIGINALCURMNY; //原币无税金额 modOrder.N_ORIGINALCURSUMMNY = N_ORIGINALCURSUMMNY; //原币价税合计 #endregion orderList.Add(modOrder); #endregion if (tmo_con.InsertKCFirstOrder(orderList)) { Response.Write("<script>alert('提交成功');window.parent.close();</script>"); } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
/// <summary> /// 计划重新划分连铸 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_fp_lz_Click(object sender, EventArgs e) { if (DialogResult.No == MessageBox.Show("是否确认重新分配计划连铸信息?\r\n重新分配后浇次计划将会重新生成!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } WaitingFrom.ShowWait("系统正对炼钢计划进行连铸重新分配,请稍候..."); if (this.icbo_lz1.SelectedIndex <= 0) { MessageBox.Show("请选择要分配的连铸!"); icbo_lz1.Focus(); return; } string C_CCM_ID = icbo_lz1.Properties.Items[this.icbo_lz1.SelectedIndex].Value.ToString(); Mod_TB_STA mod_sta = bll_sta.GetModel(C_CCM_ID); int[] aa = this.gv_Lg_plan_Query.GetSelectedRows(); int cou = 0; for (int i = 0; i < aa.Length; i++) { int selectedHandle = aa[i]; string C_ID = this.gv_Lg_plan_Query.GetRowCellValue(selectedHandle, "C_ID").ToString(); string C_STL_GRD = this.gv_Lg_plan_Query.GetRowCellValue(selectedHandle, "C_STL_GRD").ToString(); string C_STD_CODE = this.gv_Lg_plan_Query.GetRowCellValue(selectedHandle, "C_STD_CODE").ToString(); Mod_TRP_PLAN_ROLL mod_roll = bll_trp_plan.GetModel(C_ID); string C_ORDER_ID = mod_roll.C_INITIALIZE_ITEM_ID; Mod_TMO_ORDER mod_order = bll_order.GetModel(C_ORDER_ID); mod_order.C_CCM_NO = C_CCM_ID; mod_order.C_CCM_CODE = mod_sta.C_STA_CODE; mod_order.C_CCM_DESC = mod_sta.C_STA_DESC; if (bll_order.Update(mod_order)) { mod_roll.C_CCM_ID = C_CCM_ID; mod_roll.C_CCM_CODE = mod_sta.C_STA_CODE; mod_roll.C_CCM_DESC = mod_sta.C_STA_DESC; if (bll_trp_plan.Update(mod_roll)) { cou = cou + i; } } } MessageBox.Show("连铸划分成功!"); WaitingFrom.CloseWait(); btn_query_lc_plan_Click(null, null); }
private void simpleButton1_Click(object sender, EventArgs e) { WaitingFrom.ShowWait(""); int[] rownumber = this.gv_tmo_order.GetSelectedRows();//获取选中行号数组; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = this.gv_tmo_order.GetRowCellValue(selectedHandle, "C_ID").ToString(); Mod_TMO_ORDER modorder = bllorder.GetModel(strID); modorder.N_EXEC_STATUS = -2; bllorder.Update(modorder); } WaitingFrom.CloseWait(); btn_query_main_Click(null, null); }
private void btn_calcle_pj_Click(object sender, EventArgs e) { int selectnum = lst.Where(a => a.B_check).ToList().Count; //选中的行数 int updatenum = 0; //修改成功的行数 if (selectnum == 0) { MessageBox.Show("请选择需要取消评价的订单!"); return; } if (DialogResult.Yes == MessageBox.Show("是否将取消已评价的订单?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { WaitingFrom.ShowWait("系统正在对订单进行修改,请稍候..."); if (lst.Count > 0) { if (selectnum > 0) { for (int i = 0; i < lst.Count; i++) { if (lst[i].B_check && lst[i].N_ROLL_PROD_WGT == 0) { string C_ID = lst[i].C_ID; Mod_TMO_ORDER mod = bll_order.GetModel(C_ID); mod.C_SFPJ = "N"; mod.D_PJ_DATE = null; mod.D_SC_MOD_DT = RV.UI.ServerTime.timeNow(); bll_order.Update(mod); updatenum = updatenum + 1; Mod_TMO_ORDER_PJ_LOG modlog = new Mod_TMO_ORDER_PJ_LOG(); modlog.C_EMP_ID = RV.UI.UserInfo.userID; modlog.C_ORDER_NO = lst[i].C_ORDER_NO; modlog.C_TYPE = "取消评价"; modlog.C_RESULT = "订单已取消评价!"; modlog.C_MSG = "取消评价!"; bll_ddpj.Add(modlog); } } } } MessageBox.Show("选中" + selectnum.ToString() + "条订单取消评价,执行成功" + updatenum + "条订单!"); btn_query_order_Click(null, null); WaitingFrom.CloseWait(); } }
private void btn_Add_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(btn_mat_code.Text.Trim())) { MessageBox.Show("物料编码不能为空!"); return; } if (string.IsNullOrEmpty(txt_group.Text.Trim())) { MessageBox.Show("组号不能为空!"); return; } try { Mod_TMO_ORDER mod = new Mod_TMO_ORDER(); mod.C_ID = System.Guid.NewGuid().ToString(); mod.C_ORDER_NO = "TW" + RV.UI.ServerTime.timeNow().ToString("yyyyMMddHHmmssfff"); mod.C_MAT_CODE = btn_mat_code.Text.Trim(); mod.C_MAT_NAME = txt_mat_name.Text.Trim(); mod.C_STL_GRD = txt_Grd.Text.Trim(); mod.C_STD_CODE = txt_STD1.Text.Trim(); mod.C_FREE1 = txt_ZYX1.Text.Trim(); mod.C_FREE2 = txt_ZYX2.Text.Trim(); mod.C_SPEC = Spec; mod.N_TYPE = 10; mod.C_CUST_NAME = "TW"; mod.N_WGT = 100; mod.N_GROUP = Convert.ToInt32(txt_group.Text); mod.C_EMP_ID = RV.UI.UserInfo.UserID; mod.C_EMP_NAME = RV.UI.UserInfo.UserName; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); if (bll_Order.Add(mod)) { Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "添加头尾订单");//添加操作日志 MessageBox.Show("添加成功!"); NewMethod(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 完工,入库 /// </summary> /// <param name="item">委外计划</param> private void RuKu(Mod_TRC_ROLL_WW_MAIN item, Mod_TB_STA tBSta, Mod_TMO_ORDER contractInfo) { var xcItems = dalWWMain.GetItemList(item.C_ID); if (xcItems.Any() == false) { throw new Exception("未找到组批信息"); } List <Mod_TRC_ROLL_PRODCUT> addItems = new List <Mod_TRC_ROLL_PRODCUT>(); // 单支完工量 var singleAmt = item.N_WGT_REMOVE / item.N_QUA_REMOVE; foreach (var xcItem in xcItems) { // 如果已经满足完工支数退出 if (addItems.Count == item.N_QUA_REMOVE) { continue; } xcItem.C_ID = $"{item.C_BATCH_NO}{(addItems.Count + 1).ToString("0000")}"; xcItem.C_BATCH_NO = item.C_BATCH_NO; xcItem.N_WGT = singleAmt ?? 0; xcItem.C_MOVE_TYPE = "E"; xcItem.C_SHIFT = item.C_PRODUCE_SHIFT; xcItem.C_GROUP = item.C_PRODUCE_GROUP; xcItem.C_STA_ID = tBSta.C_ID; xcItem.C_IS_DEPOT = "Y"; xcItem.C_MAT_CODE = contractInfo.C_MAT_CODE; //item.C_MAT_XC_CODE; xcItem.C_MAT_CODE_BEFORE = string.Empty; xcItem.C_MAT_DESC = contractInfo.C_MAT_NAME; //item.C_MAT_XC_NAME; xcItem.C_CON_NO = contractInfo.C_CON_NO; xcItem.C_ORDER_NO = contractInfo.C_ORDER_NO; xcItem.C_LINEWH_CODE = item.C_LINEWH_CODE; xcItem.C_LINEWH_LOC_CODE = string.Empty; xcItem.C_WWBATCH_NO = item.C_XC_BATCH_NO; xcItem.C_JUDGE_LEV_ZH = item.C_CHECKSTATE_NAME; xcItem.C_BZYQ = contractInfo.C_PACK; xcItem.D_DP_DT = DateTime.Now; bllProduct.Add(xcItem); addItems.Add(xcItem); } }
public AjaxResult GetOldOrderAdd([FromBody] dynamic Json) { #region //参数 string ConNo = Json.ConNo; //合同号 JArray OrderList = (JArray)Json.OrderList; //.OrderNo #endregion #region 数据操作 AjaxResult result = new AjaxResult(); result.Code = DoResult.Success; List <Mod_TMO_ORDER> ListOrder = new List <Mod_TMO_ORDER>(); Mod_TMO_CON modCon = tmo_con.GetModel(ConNo); for (int i = 0; i < OrderList.Count; i++) { #region //添加订单 Mod_TMO_ORDER modOrder = tmo_order.GetOrderModel(OrderList[i]["OrderNo"].ToString()); string order_no = randomnumber.CreateOrderNo(ConNo); //订单号 modOrder.C_ORDER_NO = order_no; modOrder.C_CON_NO = ConNo; //合同号 modOrder.C_CON_NAME = modCon.C_CON_NAME; //合同名称 modOrder.C_AREA = modCon.C_AREA; //区域 //modOrder.D_NEED_DT = modCon.D_CONINVALID_DT;//需求日期 modOrder.D_DELIVERY_DT = modCon.D_CONINVALID_DT; //计划收货日期 modOrder.D_DT = DateTime.Now; //订单日期 modOrder.C_RECEIPTAREAID = modCon.C_CRECEIPTAREAID; //收货地区 modOrder.C_RECEIVEADDRESS = modCon.C_ADDRESS; //收货地址 modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位 modOrder.C_CURRENCYTYPEID = modCon.C_CURRENCYTYPEID; //货币 modOrder.N_USER_LEV = modCon.N_CUST_LEV; //客户等级 modOrder.C_REMARK = modCon.C_REAMRK; ListOrder.Add(modOrder); #endregion } result.Result = tmo_con.InsertConOrder(modCon, ListOrder) == true ? "提交成功" : "提交失败"; #endregion return(result); }
/// <summary> /// 检测每条订单是否低毛利 /// </summary> /// <param name="orderID">订单ID</param> /// <param name="date">合同生效起始日期</param> /// <returns></returns> public bool CheckMAOLI(string orderID, string matCode, string date) { Dal_TMO_ORDER dal = new Dal_TMO_ORDER(); Mod_TMO_ORDER mod = dal.GetModel(orderID); ArrayList arraySql = new ArrayList(); bool result = true; string strSql = $@"SELECT T.C_MAT_GROUP_CODE,T.C_SPEC, T.N_THK,NVL(A.C_FLAG,'N')C_FLAG FROM TB_MATRL_MAIN T LEFT JOIN TMB_MONI_STLGRD A ON A.C_STL_GRD = T.C_STL_GRD WHERE T.C_MAT_CODE = '{matCode}'"; DataRow dr = DbHelperOra.GetDataRow(strSql); if (dr != null) { string flag = dr["C_FLAG"].ToString() == "N" ? "01" : "02"; //判定是否监控钢种标识 string matgroupcode = dr["C_MAT_GROUP_CODE"].ToString(); //钢种物料组编码 decimal num = 0; //监控钢种260,其他50 decimal maoli = Convert.ToDecimal(mod.N_PROFIT); //毛利 string spec = dr["N_THK"].ToString(); //规格 //监控钢种260,其他50 string strSql2 = $"SELECT T.C_INDEX FROM TS_DIC T WHERE T.C_TYPECODE='MAOLI' AND T.C_DETAILCODE='{flag}'"; DataRow dr2 = DbHelperOra.GetDataRow(strSql2); if (dr2 != null) { num = Convert.ToDecimal(dr2["C_INDEX"]); } if (maoli < num)//订单毛利低于配置毛利进行检测 { result = GetCheckMAOLI(date, matgroupcode, spec, matCode); } } return(result); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { string id = Request.QueryString["ID"]; Mod_TMO_ORDER mod = tmo_order.GetOrderModel(id); string order = id.StartsWith("YC") == true ? "'" + id + "'" : "'" + mod?.C_ORDER_NO + "'"; if (!string.IsNullOrEmpty(mod?.C_ORDER_NO_OLD)) { order += ",'" + mod?.C_ORDER_NO_OLD + "'"; } DataTable dt = plan_xqcx.ListPlanData(order).Tables[0]; if (dt.Rows.Count > 0) { ltlNEEDWGT.Text = dt.Compute("sum(计划需求量)", "true").ToString(); ltlWGWGT.Text = dt.Compute("sum(完工数量)", "true").ToString(); ltlHGWGT.Text = dt.Compute("sum(分配量)", "true").ToString(); rptList.DataSource = dt; rptList.DataBind(); } else { ltlNEEDWGT.Text = ""; ltlWGWGT.Text = ""; ltlHGWGT.Text = ""; rptList.DataSource = null; rptList.DataBind(); } } } }
private void GetList() { Mod_TMO_ORDER mod = tmo_order.GetModel(ltlorderid.Text); string areafalg = ts_dic.GetAreaFlag(ltlarea.Text);//获取区域是否按客户发运Y/N DataTable dt = areafalg == "N" ? tmo_order.ZTWGT(ltlmatcode.Text, ltlstdcode.Text, ltlarea.Text, ltlpack.Text, ltllev.Text).Tables[0] : tmo_order.ZTWGT(ltlmatcode.Text, ltlstdcode.Text, ltlarea.Text, ltlpack.Text, ltllev.Text, mod.C_CUST_NAME, mod.C_CON_NO).Tables[0]; if (dt.Rows.Count > 0) { rptList.DataSource = dt; rptList.DataBind(); ltlsumwgt.Text = dt.Compute("sum(N_FYWGT)", "true").ToString(); } else { rptList.DataSource = null; rptList.DataBind(); ltlsumwgt.Text = "0"; } DataTable dtkcwgt = areafalg == "N" ? tmo_order.KCWGT(ltlmatcode.Text, ltlstdcode.Text, ltlarea.Text, ltlpack.Text, ltllev.Text).Tables[0] : tmo_order.KCWGT(ltlmatcode.Text, ltlstdcode.Text, ltlarea.Text, ltlpack.Text, ltllev.Text, mod.C_CUST_NAME, mod.C_CON_NO).Tables[0]; if (dtkcwgt.Rows.Count > 0) { if (!string.IsNullOrEmpty(dtkcwgt.Rows[0]["N_WGT"].ToString())) { ltlkcwgt.Text = dtkcwgt.Rows[0]["N_WGT"].ToString(); } else { ltlkcwgt.Text = "0"; } } ltlkfwgt.Text = Convert.ToString(Convert.ToDecimal(ltlkcwgt.Text) - Convert.ToDecimal(ltlsumwgt.Text)); }
private void btn_zdfz_Click(object sender, EventArgs e) { if (DialogResult.No == MessageBox.Show("是否确认强行分组混浇?\r\n重新分组后浇次计划将会重新生成!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } WaitingFrom.ShowWait("系统正对计划进行处理,请稍候..."); int[] aa = this.gv_Lg_plan_Query.GetSelectedRows(); int cou = 0; for (int i = 0; i < aa.Length; i++) { int selectedHandle = aa[i]; string C_ID = this.gv_Lg_plan_Query.GetRowCellValue(selectedHandle, "C_ID").ToString(); string C_STL_GRD = this.gv_Lg_plan_Query.GetRowCellValue(selectedHandle, "C_STL_GRD").ToString(); string C_STD_CODE = this.gv_Lg_plan_Query.GetRowCellValue(selectedHandle, "C_STD_CODE").ToString(); Mod_TRP_PLAN_ROLL mod_roll = bll_trp_plan.GetModel(C_ID); string C_ORDER_ID = mod_roll.C_INITIALIZE_ITEM_ID; Mod_TMO_ORDER mod_order = bll_order.GetModel(C_ORDER_ID); mod_order.N_GROUP = Convert.ToInt32(this.txt_zh.Text); bool res = bll_gztj.UpdateGZ(C_STL_GRD, C_STD_CODE, Convert.ToInt32(this.txt_zh.Text)); if (bll_order.Update(mod_order)) { mod_roll.N_GROUP = Convert.ToInt32(this.txt_zh.Text); if (bll_trp_plan.Update(mod_roll)) { cou = cou + i; } } } MessageBox.Show("计划分组成功!"); WaitingFrom.CloseWait(); btn_query_lc_plan_Click(null, null); }
private void btn_qr_Click(object sender, EventArgs e) { WaitingFrom.ShowWait(""); int[] rownumber = this.gv_tmo_order.GetSelectedRows();//获取选中行号数组; for (int i = 0; i < rownumber.Length; i++) { int selectedHandle = rownumber[i]; string strID = this.gv_tmo_order.GetRowCellValue(selectedHandle, "C_ID").ToString(); double wcl = Convert.ToDouble(this.gv_tmo_order.GetRowCellValue(selectedHandle, "WCL").ToString()); Mod_TMO_ORDER modorder = bllorder.GetModel(strID); if (wcl > 0.9) { modorder.N_EXEC_STATUS = -2; } else { modorder.N_EXEC_STATUS = 0; } bllorder.Update(modorder); } WaitingFrom.CloseWait(); btn_query_main_Click(null, null); }
/// <summary> /// 发送改判信息给NC /// </summary> /// <param name="xmlFileName">xml完整路径</param> /// <returns></returns> public string SendXml_DM(string xmlFileName, string fydh) { try { string name = "FYSJ" + fydh + ".xml"; xmlFileName += "\\NCXML\\" + name; Mod_TMD_DISPATCH modDispatch = dal_TMD_DISPATCH.GetModel(fydh); XmlDocument xmlDoc = new XmlDocument(); //创建类型声明节点 XmlNode node = xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", "no"); xmlDoc.AppendChild(node); //创建根节点 XmlElement root = xmlDoc.CreateElement("ufinterface"); #region//给节点属性赋值 root.SetAttribute("billtype", "7F"); root.SetAttribute("filename", name); root.SetAttribute("isexchange", "Y"); root.SetAttribute("operation", "req"); root.SetAttribute("proc", "update"); root.SetAttribute("receiver", "101"); root.SetAttribute("replace", "Y"); root.SetAttribute("roottag", "bill"); root.SetAttribute("sender", "1107"); #endregion xmlDoc.AppendChild(root); //创建子根节点 XmlElement bill = xmlDoc.CreateElement("bill"); bill.SetAttribute("id", modDispatch.C_GUID);//发运单表头主键 root.AppendChild(bill); XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "bill_head", null); #region //表头_order_head CreateNode(xmlDoc, head, "apprdate", Convert.ToDateTime(modDispatch.D_APPROVE_DT).ToString("yyy-MM-dd")); //审批日期 CreateNode(xmlDoc, head, "bconfirm", "N"); CreateNode(xmlDoc, head, "billdate", Convert.ToDateTime(modDispatch.D_CREATE_DT).ToString("yyy-MM-dd")); //制单日期 CreateNode(xmlDoc, head, "billnewaddtime", Convert.ToDateTime(modDispatch.D_CREATE_DT).ToString("yyy-MM-dd HH:mm:ss")); CreateNode(xmlDoc, head, "bisopen", ""); CreateNode(xmlDoc, head, "bmissionbill", "N"); CreateNode(xmlDoc, head, "bmustreturnbillcode", ""); CreateNode(xmlDoc, head, "btestbyinvoice", ""); CreateNode(xmlDoc, head, "clastmodifierid", modDispatch.C_EMP_ID);//最后修改人 CreateNode(xmlDoc, head, "clastmodiname", ""); CreateNode(xmlDoc, head, "curbilltype", ""); CreateNode(xmlDoc, head, "dallpacknum", "0"); CreateNode(xmlDoc, head, "dallvolumn", "0"); CreateNode(xmlDoc, head, "dallweight", "0"); CreateNode(xmlDoc, head, "dfactweight", ""); CreateNode(xmlDoc, head, "dr", "0"); CreateNode(xmlDoc, head, "dtotal", ""); CreateNode(xmlDoc, head, "employee", ""); CreateNode(xmlDoc, head, "h_confirmarrivedate", ""); CreateNode(xmlDoc, head, "iprintcount", ""); CreateNode(xmlDoc, head, "isendtype", "3");//运费类别 CreateNode(xmlDoc, head, "linkman1", ""); CreateNode(xmlDoc, head, "oprdepartname", ""); CreateNode(xmlDoc, head, "phone1", ""); CreateNode(xmlDoc, head, "pk_defdoc0", modDispatch.C_IS_WIRESALE_ID); //是否线材销售主键 CreateNode(xmlDoc, head, "pk_defdoc1", ""); CreateNode(xmlDoc, head, "pk_defdoc10", ""); CreateNode(xmlDoc, head, "pk_defdoc11", ""); CreateNode(xmlDoc, head, "pk_defdoc12", ""); CreateNode(xmlDoc, head, "pk_defdoc13", ""); CreateNode(xmlDoc, head, "pk_defdoc14", ""); CreateNode(xmlDoc, head, "pk_defdoc15", ""); CreateNode(xmlDoc, head, "pk_defdoc16", ""); CreateNode(xmlDoc, head, "pk_defdoc17", ""); CreateNode(xmlDoc, head, "pk_defdoc18", ""); CreateNode(xmlDoc, head, "pk_defdoc19", ""); CreateNode(xmlDoc, head, "pk_defdoc2", ""); CreateNode(xmlDoc, head, "pk_defdoc3", ""); CreateNode(xmlDoc, head, "pk_defdoc4", ""); CreateNode(xmlDoc, head, "pk_defdoc5", ""); CreateNode(xmlDoc, head, "pk_defdoc6", ""); CreateNode(xmlDoc, head, "pk_defdoc7", ""); CreateNode(xmlDoc, head, "pk_defdoc8", ""); CreateNode(xmlDoc, head, "pk_defdoc9", ""); CreateNode(xmlDoc, head, "pk_delivbill_h", ""); //发运单表头主键 CreateNode(xmlDoc, head, "pkapprperson", ""); CreateNode(xmlDoc, head, "pkbillperson", modDispatch.C_CREATE_ID); //制单人 CreateNode(xmlDoc, head, "pkcorpforgenoid", "1001"); CreateNode(xmlDoc, head, "pkdelivmode", modDispatch.C_SHIPVIA); //发运方式主键 CreateNode(xmlDoc, head, "pkdelivorg", "1001NC10000000006EHS"); //发运组织主键固定 CreateNode(xmlDoc, head, "pkdelivroute", "1001NC10000000006EHV"); //发运路线主键 固定 CreateNode(xmlDoc, head, "pkdriver", ""); CreateNode(xmlDoc, head, "pkoperator", modDispatch.C_BUSINESS_ID); //业务员主键 CreateNode(xmlDoc, head, "pkoprdepart", modDispatch.C_BUSINESS_DEPT); //业务部门主键 CreateNode(xmlDoc, head, "pksendperson", ""); CreateNode(xmlDoc, head, "pktrancust", modDispatch.C_COMCAR); //承运商 CreateNode(xmlDoc, head, "pktranorg", ""); CreateNode(xmlDoc, head, "pkvehicle", ""); CreateNode(xmlDoc, head, "pkvehicletype", ""); CreateNode(xmlDoc, head, "returndate", ""); CreateNode(xmlDoc, head, "returntime", ""); CreateNode(xmlDoc, head, "senddate", Convert.ToDateTime(modDispatch.D_DISP_DT).ToString("yyy-MM-dd"));//发运日期 CreateNode(xmlDoc, head, "startdate", ""); CreateNode(xmlDoc, head, "starttime", ""); CreateNode(xmlDoc, head, "taudittime", ""); CreateNode(xmlDoc, head, "tlastmodifytime", Convert.ToDateTime(modDispatch.D_MOD_DT).ToString("yyy-MM-dd HH:mm:ss")); //最后修改时间 CreateNode(xmlDoc, head, "tmaketime", Convert.ToDateTime(modDispatch.D_CREATE_DT).ToString("yyy-MM-dd HH:mm:ss")); // 制单时间 CreateNode(xmlDoc, head, "ts", Convert.ToDateTime(modDispatch.D_CREATE_DT).ToString("yyy-MM-dd HH:mm:ss")); CreateNode(xmlDoc, head, "userid", modDispatch.C_CREATE_ID); //制单人 CreateNode(xmlDoc, head, "vapprpersonname", ""); CreateNode(xmlDoc, head, "vbillpersonname", ""); CreateNode(xmlDoc, head, "vdelivbillcode", modDispatch.C_ID);//发运单单据号 CreateNode(xmlDoc, head, "vdoname", ""); CreateNode(xmlDoc, head, "vdrivername", ""); CreateNode(xmlDoc, head, "vehiclelicense", ""); CreateNode(xmlDoc, head, "vnote", ""); CreateNode(xmlDoc, head, "voldDelivbillcode", ""); CreateNode(xmlDoc, head, "vroutedescr", ""); CreateNode(xmlDoc, head, "vroutename", ""); CreateNode(xmlDoc, head, "vsendtypename", ""); CreateNode(xmlDoc, head, "vtranname", ""); CreateNode(xmlDoc, head, "vtranorgname", ""); CreateNode(xmlDoc, head, "vuserdef0", modDispatch.C_IS_WIRESALE);// 是否线材销售 是/ 否 ***** CreateNode(xmlDoc, head, "vuserdef1", ""); CreateNode(xmlDoc, head, "vuserdef10", ""); CreateNode(xmlDoc, head, "vuserdef11", ""); CreateNode(xmlDoc, head, "vuserdef12", ""); CreateNode(xmlDoc, head, "vuserdef13", ""); CreateNode(xmlDoc, head, "vuserdef14", ""); CreateNode(xmlDoc, head, "vuserdef15", ""); CreateNode(xmlDoc, head, "vuserdef16", ""); CreateNode(xmlDoc, head, "vuserdef17", ""); CreateNode(xmlDoc, head, "vuserdef18", ""); CreateNode(xmlDoc, head, "vuserdef19", ""); CreateNode(xmlDoc, head, "vuserdef2", ""); CreateNode(xmlDoc, head, "vuserdef3", "Y"); //是否已导出 CreateNode(xmlDoc, head, "vuserdef4", modDispatch.C_LIC_PLA_NO); //车牌号 CreateNode(xmlDoc, head, "vuserdef5", ""); CreateNode(xmlDoc, head, "vuserdef6", ""); CreateNode(xmlDoc, head, "vuserdef7", ""); CreateNode(xmlDoc, head, "vuserdef8", ""); CreateNode(xmlDoc, head, "vuserdef9", ""); CreateNode(xmlDoc, head, "vvehiclename", ""); CreateNode(xmlDoc, head, "vvhcltypename", ""); #endregion bill.AppendChild(head); XmlElement body = xmlDoc.CreateElement("bill_body"); bill.AppendChild(body); DataTable dt = GetZJBList(fydh).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int rowno = i + 1; Mod_TMP_DAYPLAN modDayPlan = dal_TMP_DAYPLAN.GetModel(dt.Rows[i]["C_PLAN_ID"].ToString()); if (modDayPlan != null) { #region //实体参数 Mod_TMO_ORDER modOrder = dal_TMO_ORDER.GetModel(modDayPlan.C_PKBILLB); Mod_TPB_LINEWH mbck = dal_TPB_LINEWH.GetModel_Interface_Trans(dt.Rows[i]["C_SEND_STOCK"].ToString()); //目标仓库 Mod_TPB_SLABWH slabwh = dal_TPB_SLABWH.GetModel_Interface_Trans(dt.Rows[i]["C_SEND_STOCK"].ToString()); Mod_TS_CUSTFILE modCust = dal_TS_CUSTFILE.GetCustModel(modDayPlan.C_PKCUST); //客户档案 Mod_TMB_AREA modArea = dal_TMB_AREA.GetModel(modDayPlan.C_PKARRIVEAREA); //区域 Mod_TB_MATRL_MAIN modMat = dal_TB_MATRL_MAIN.GetMatModel(modDayPlan.C_PKINV); //物料 Mod_TQB_CHECKSTATE mod_TQB_CHECKSTATE = dal_TQB_CHECKSTATE.GetModelByName(dt.Rows[i]["C_ZLDJ"].ToString(), "1001"); Mod_TMD_DISPATCHDETAILS modfyditem = dal_fyditem.GetModel(dt.Rows[i]["C_PK_NCID"].ToString()); string addrpk = ""; DataTable dtaddess = dal_TMB_AREA.GetAreaAddress(modfyditem.C_SEND_AREA).Tables[0]; if (dtaddess.Rows.Count > 0) { addrpk = dtaddess.Rows[0]["PK_ADDRESS"].ToString(); } #endregion decimal dunitprice = Convert.ToDecimal(modDayPlan.N_UNITPRICE); //含税单价 string wgt = dt.Rows[i]["N_JZ"].ToString(); //重量 string num = dt.Rows[i]["N_NUM"].ToString(); //数量 decimal dmoney = dunitprice * Convert.ToDecimal(wgt); //订单金额 XmlNode item = xmlDoc.CreateNode(XmlNodeType.Element, "item", null); #region //表体_item CreateNode(xmlDoc, item, "bappendent", ""); CreateNode(xmlDoc, item, "bcloseout", ""); CreateNode(xmlDoc, item, "bcloseout_old", ""); CreateNode(xmlDoc, item, "blargess", "N"); CreateNode(xmlDoc, item, "borderreturn", "N"); CreateNode(xmlDoc, item, "breceiveinform", ""); CreateNode(xmlDoc, item, "bsigned", ""); CreateNode(xmlDoc, item, "btestbyinvoice", ""); CreateNode(xmlDoc, item, "carrivecorpname", ""); CreateNode(xmlDoc, item, "cbiztype", modDayPlan.C_BIZTYPE); //业务类型 CreateNode(xmlDoc, item, "ccheckstate_bid", mod_TQB_CHECKSTATE.C_ID); //质量等级** CreateNode(xmlDoc, item, "ccheckstatename", ""); CreateNode(xmlDoc, item, "cfreezeid", ""); CreateNode(xmlDoc, item, "cinvmanid", ""); CreateNode(xmlDoc, item, "confirmarrivedate", ""); CreateNode(xmlDoc, item, "cquoteunitid", modDayPlan.C_UNITID);//报价计量单位ID CreateNode(xmlDoc, item, "cquoteunitname", ""); CreateNode(xmlDoc, item, "creceiptcorp", ""); CreateNode(xmlDoc, item, "creceiptcorpid", modDayPlan.C_RECEIPTCORPID);//收货单位 CreateNode(xmlDoc, item, "csendcorp", ""); CreateNode(xmlDoc, item, "csendcorpid", ""); CreateNode(xmlDoc, item, "dcancelassistnum", ""); CreateNode(xmlDoc, item, "dcancelnum", ""); CreateNode(xmlDoc, item, "dfee", ""); CreateNode(xmlDoc, item, "dfeeitem", ""); CreateNode(xmlDoc, item, "dinvassist", num); //辅数量-件数 CreateNode(xmlDoc, item, "dinvnum", wgt); //存货数量 CreateNode(xmlDoc, item, "dinvweight", ""); CreateNode(xmlDoc, item, "dmileage", ""); CreateNode(xmlDoc, item, "dmoney", dmoney.ToString());//订单金额 CreateNode(xmlDoc, item, "doutassistnum", ""); CreateNode(xmlDoc, item, "doutnum", ""); CreateNode(xmlDoc, item, "doutnummargin", ""); CreateNode(xmlDoc, item, "dpackboxnum", ""); CreateNode(xmlDoc, item, "dpacknum", ""); CreateNode(xmlDoc, item, "dpackvolumn", ""); CreateNode(xmlDoc, item, "dpackweight", ""); CreateNode(xmlDoc, item, "dr", "0"); CreateNode(xmlDoc, item, "dreturnassistnum", ""); CreateNode(xmlDoc, item, "dreturnnum", ""); CreateNode(xmlDoc, item, "dsignasnum", ""); CreateNode(xmlDoc, item, "dsignassistnum", ""); CreateNode(xmlDoc, item, "dsignnum", ""); CreateNode(xmlDoc, item, "dsourcerow", ""); CreateNode(xmlDoc, item, "dtotalout", ""); CreateNode(xmlDoc, item, "dunitprice", dunitprice.ToString());//含税单价 CreateNode(xmlDoc, item, "dvolumn", ""); CreateNode(xmlDoc, item, "dwaylossasnum", ""); CreateNode(xmlDoc, item, "dwaylossnum", ""); CreateNode(xmlDoc, item, "hsl", ""); CreateNode(xmlDoc, item, "iattitude", ""); CreateNode(xmlDoc, item, "ibatchstatus", "0"); CreateNode(xmlDoc, item, "ibetimes", ""); CreateNode(xmlDoc, item, "iloadnum", ""); CreateNode(xmlDoc, item, "ilockstatus", ""); CreateNode(xmlDoc, item, "ionroadtime", ""); CreateNode(xmlDoc, item, "ipacking", ""); CreateNode(xmlDoc, item, "irownumber", rowno.ToString());//行号 CreateNode(xmlDoc, item, "irowstatus", "0"); CreateNode(xmlDoc, item, "ischeckatp", "N"); CreateNode(xmlDoc, item, "linkman1", ""); CreateNode(xmlDoc, item, "nassistnetwgt", num); CreateNode(xmlDoc, item, "nfeedbacknum", wgt); //回写上游数量 CreateNode(xmlDoc, item, "nnetwgt", wgt); //净重 CreateNode(xmlDoc, item, "nquoteunitnum", wgt); //报价计量单位数量?-存货数量 CreateNode(xmlDoc, item, "nquoteunitrate", "1"); //报价计量单位换算率固定 CreateNode(xmlDoc, item, "ntotalshouldoutnum", ""); CreateNode(xmlDoc, item, "orderplantime", ""); CreateNode(xmlDoc, item, "packsortcode", ""); CreateNode(xmlDoc, item, "packsortname", ""); CreateNode(xmlDoc, item, "phone1", "");//****? CreateNode(xmlDoc, item, "pk_corp", ""); CreateNode(xmlDoc, item, "pk_defdoc0", ""); CreateNode(xmlDoc, item, "pk_defdoc1", ""); CreateNode(xmlDoc, item, "pk_defdoc10", ""); CreateNode(xmlDoc, item, "pk_defdoc11", ""); CreateNode(xmlDoc, item, "pk_defdoc12", ""); CreateNode(xmlDoc, item, "pk_defdoc13", ""); CreateNode(xmlDoc, item, "pk_defdoc14", ""); CreateNode(xmlDoc, item, "pk_defdoc15", ""); CreateNode(xmlDoc, item, "pk_defdoc16", ""); CreateNode(xmlDoc, item, "pk_defdoc17", ""); CreateNode(xmlDoc, item, "pk_defdoc18", ""); CreateNode(xmlDoc, item, "pk_defdoc19", ""); CreateNode(xmlDoc, item, "pk_defdoc2", ""); CreateNode(xmlDoc, item, "pk_defdoc3", ""); CreateNode(xmlDoc, item, "pk_defdoc4", ""); CreateNode(xmlDoc, item, "pk_defdoc5", ""); CreateNode(xmlDoc, item, "pk_defdoc6", ""); CreateNode(xmlDoc, item, "pk_defdoc7", ""); CreateNode(xmlDoc, item, "pk_defdoc8", ""); CreateNode(xmlDoc, item, "pk_defdoc9", ""); CreateNode(xmlDoc, item, "pk_delivbill_b", ""); //置空 CreateNode(xmlDoc, item, "pk_delivbill_h", ""); CreateNode(xmlDoc, item, "pk_invbasdoc", modOrder.C_INVBASDOCID); //存货档案主键 CreateNode(xmlDoc, item, "pk_packsort", ""); CreateNode(xmlDoc, item, "pk_transcontainer", ""); CreateNode(xmlDoc, item, "pkarriveaddress", addrpk); //到货地点 CreateNode(xmlDoc, item, "pkarrivearea", modfyditem.C_SEND_AREA); //到货地区主键 CreateNode(xmlDoc, item, "pkarrivecorp", ""); CreateNode(xmlDoc, item, "pkassistmeasure", modOrder.C_FUNITID); //辅计量单位 CreateNode(xmlDoc, item, "pkbasinv", modOrder.C_INVBASDOCID); //存货档案主键 CreateNode(xmlDoc, item, "pkbasreceiptcorp", modCust.C_NC_ID); //客户主键 CreateNode(xmlDoc, item, "pkbassendcorp", ""); CreateNode(xmlDoc, item, "pkconsign", ""); CreateNode(xmlDoc, item, "pkcorpforgenoid", modDayPlan.C_PKSALECORP); //销售公司(1001) CreateNode(xmlDoc, item, "pkcusbasdoc", modCust.C_NC_ID); //客户主键 CreateNode(xmlDoc, item, "pkcusmandoc", modDayPlan.C_PKCUST); //客户管理主键 CreateNode(xmlDoc, item, "pkcustinvoice", ""); CreateNode(xmlDoc, item, "pkdayplan", ""); CreateNode(xmlDoc, item, "pkdestrep", ""); CreateNode(xmlDoc, item, "pkdeststockorg", ""); CreateNode(xmlDoc, item, "pkinv", modOrder.C_INVENTORYID);//存货管理档案主键 CreateNode(xmlDoc, item, "pkinvoice", ""); CreateNode(xmlDoc, item, "pkitem", ""); CreateNode(xmlDoc, item, "pkitemperiod", ""); CreateNode(xmlDoc, item, "pkoperator", modDayPlan.C_PKOPERATOR); //业务员ID CreateNode(xmlDoc, item, "pkoprdepart", modDayPlan.C_PKOPRDEPART); //业务员部门 CreateNode(xmlDoc, item, "pkorder", ""); CreateNode(xmlDoc, item, "pkorderplanid", ""); CreateNode(xmlDoc, item, "pkorderrow", ""); CreateNode(xmlDoc, item, "pkpackboxtype", ""); CreateNode(xmlDoc, item, "pksalecorp", "1001"); CreateNode(xmlDoc, item, "pksalegrp", modDayPlan.C_PKSALEORG); //销售组织主键 CreateNode(xmlDoc, item, "pksendaddress", "0001AA1000000002LFNT"); //发货地点 CreateNode(xmlDoc, item, "pksendarea", "dqda0000000000000057"); //发货地区 if (mbck != null) { CreateNode(xmlDoc, item, "pksendstock", mbck.C_ID);//发货仓库 } else { CreateNode(xmlDoc, item, "pksendstock", slabwh.C_ID); //发货仓库 } CreateNode(xmlDoc, item, "pksendstockorg", "1001NC10000000000669"); //发货库存组织主键-固定 CreateNode(xmlDoc, item, "pksrccalbodyar", ""); CreateNode(xmlDoc, item, "pkunit", ""); CreateNode(xmlDoc, item, "plantime", ""); CreateNode(xmlDoc, item, "receivedate", ""); CreateNode(xmlDoc, item, "requireday", Convert.ToDateTime(modDayPlan.D_REQUIREDATE).ToString("yyy-MM-dd")); //要求到货日期 CreateNode(xmlDoc, item, "sourcebillts", ""); CreateNode(xmlDoc, item, "ts", ""); //HH:mm:ss CreateNode(xmlDoc, item, "ufdtmp", ""); CreateNode(xmlDoc, item, "userid", ""); CreateNode(xmlDoc, item, "varriveaddress", "其他地区"); CreateNode(xmlDoc, item, "vassistmeaname", ""); string batch = ""; if (modMat.C_MAT_TYPE == "6") { if (dt.Rows[i]["C_BATCH_NO"].ToString() != "") { batch = dt.Rows[i]["C_BATCH_NO"].ToString(); } else { batch = dt.Rows[i]["C_STOVE"].ToString(); } } if (modMat.C_MAT_TYPE == "8") { batch = dt.Rows[i]["C_BATCH_NO"].ToString(); } CreateNode(xmlDoc, item, "vbatchcode", batch); CreateNode(xmlDoc, item, "vbilltype", "30"); CreateNode(xmlDoc, item, "vbilltypename", ""); CreateNode(xmlDoc, item, "vcargcode", ""); CreateNode(xmlDoc, item, "vconsign", ""); CreateNode(xmlDoc, item, "vcontainername", ""); CreateNode(xmlDoc, item, "vcustcode", modCust.C_NO); //客户编码 CreateNode(xmlDoc, item, "vcustname", modCust.C_NAME); //客户名称 CreateNode(xmlDoc, item, "vdayplancode", modDayPlan.C_PLCODE); //对应日计划单据号 CreateNode(xmlDoc, item, "vdestaddress", modfyditem.C_AREA); //收货地址 CreateNode(xmlDoc, item, "vdestarea", modfyditem.C_SEND_AREA); //收货地区 CreateNode(xmlDoc, item, "vdeststoreaddre", ""); CreateNode(xmlDoc, item, "vdeststorename", ""); CreateNode(xmlDoc, item, "vdeststoreorgname", ""); CreateNode(xmlDoc, item, "vfree0", ""); CreateNode(xmlDoc, item, "vfree1", modDayPlan.C_VFREE1); //自由项1 CreateNode(xmlDoc, item, "vfree10", dt.Rows[i]["C_PK_NCID"].ToString()); //CRM发运单表体主键//C_PK_NCID CreateNode(xmlDoc, item, "vfree2", modDayPlan.C_VFREE2); //自由项2 CreateNode(xmlDoc, item, "vfree3", dt.Rows[i]["C_BZYQ"].ToString()); //包装钢坯传空 CreateNode(xmlDoc, item, "vfree4", ""); CreateNode(xmlDoc, item, "vfree5", ""); CreateNode(xmlDoc, item, "vfree6", ""); CreateNode(xmlDoc, item, "vfree7", ""); CreateNode(xmlDoc, item, "vfree8", modDayPlan.C_ID); //CRM发运日计划主键 CreateNode(xmlDoc, item, "vfree9", modDispatch.C_GUID); // CRM发运单表头主键 CreateNode(xmlDoc, item, "vfreeid1", ""); CreateNode(xmlDoc, item, "vfreeid10", ""); CreateNode(xmlDoc, item, "vfreeid2", ""); CreateNode(xmlDoc, item, "vfreeid3", ""); CreateNode(xmlDoc, item, "vfreeid4", ""); CreateNode(xmlDoc, item, "vfreeid5", ""); CreateNode(xmlDoc, item, "vfreeid6", ""); CreateNode(xmlDoc, item, "vfreeid7", ""); CreateNode(xmlDoc, item, "vfreeid8", ""); CreateNode(xmlDoc, item, "vfreeid9", ""); CreateNode(xmlDoc, item, "vfreename1", ""); CreateNode(xmlDoc, item, "vfreename10", ""); CreateNode(xmlDoc, item, "vfreename2", ""); CreateNode(xmlDoc, item, "vfreename3", ""); CreateNode(xmlDoc, item, "vfreename4", ""); CreateNode(xmlDoc, item, "vfreename5", ""); CreateNode(xmlDoc, item, "vfreename6", ""); CreateNode(xmlDoc, item, "vfreename7", ""); CreateNode(xmlDoc, item, "vfreename8", ""); CreateNode(xmlDoc, item, "vfreename9", ""); CreateNode(xmlDoc, item, "vinvcode", modMat.C_MAT_CODE); CreateNode(xmlDoc, item, "vinvname", ""); CreateNode(xmlDoc, item, "vinvoicecode", ""); CreateNode(xmlDoc, item, "vitemname", ""); CreateNode(xmlDoc, item, "vitemperiodname", ""); CreateNode(xmlDoc, item, "vnote", ""); CreateNode(xmlDoc, item, "voperatorname", ""); CreateNode(xmlDoc, item, "voprdepartname", ""); CreateNode(xmlDoc, item, "vordercode", modDayPlan.C_SALECODE);//销售单据号 CreateNode(xmlDoc, item, "vreceiptcorpname", ""); CreateNode(xmlDoc, item, "vsalecorpname", ""); CreateNode(xmlDoc, item, "vsaleorgname", ""); CreateNode(xmlDoc, item, "vsendaddr", ""); CreateNode(xmlDoc, item, "vsendaddress", ""); CreateNode(xmlDoc, item, "vsendarea", ""); CreateNode(xmlDoc, item, "vsendcorpname", ""); CreateNode(xmlDoc, item, "vsendstoreaddre", ""); CreateNode(xmlDoc, item, "vsendstorename", ""); CreateNode(xmlDoc, item, "vsendstoreorgaddre", ""); CreateNode(xmlDoc, item, "vsendstoreorgname", ""); CreateNode(xmlDoc, item, "vsignname", ""); CreateNode(xmlDoc, item, "vsignnote", ""); CreateNode(xmlDoc, item, "vspec", modMat.C_SPEC); //规格 CreateNode(xmlDoc, item, "vsrccalbodyarname", ""); CreateNode(xmlDoc, item, "vtype", modMat.C_STL_GRD); //钢种 CreateNode(xmlDoc, item, "vunit", modMat.C_ZJLDWMC); //主计量单位名称 CreateNode(xmlDoc, item, "vuserdef0", ""); CreateNode(xmlDoc, item, "vuserdef1", ""); //计量毛重日期***** CreateNode(xmlDoc, item, "vuserdef10", modDayPlan.C_CONNO); //合同号 CreateNode(xmlDoc, item, "vuserdef11", ""); CreateNode(xmlDoc, item, "vuserdef12", ""); CreateNode(xmlDoc, item, "vuserdef13", ""); CreateNode(xmlDoc, item, "vuserdef14", ""); CreateNode(xmlDoc, item, "vuserdef15", ""); CreateNode(xmlDoc, item, "vuserdef16", ""); CreateNode(xmlDoc, item, "vuserdef17", ""); CreateNode(xmlDoc, item, "vuserdef18", ""); CreateNode(xmlDoc, item, "vuserdef19", ""); CreateNode(xmlDoc, item, "vuserdef2", ""); //毛重***** CreateNode(xmlDoc, item, "vuserdef3", ""); //计量皮重日期**** CreateNode(xmlDoc, item, "vuserdef4", ""); //皮重 CreateNode(xmlDoc, item, "vuserdef5", ""); //净重 CreateNode(xmlDoc, item, "vuserdef6", ""); //计量毛重时间 CreateNode(xmlDoc, item, "vuserdef7", ""); //计量皮重时间 CreateNode(xmlDoc, item, "vuserdef8", ""); CreateNode(xmlDoc, item, "vuserdef9", ""); #endregion body.AppendChild(item); } } } xmlDoc.Save(xmlFileName); List <string> parem = dalSendNC.SendXML(xmlFileName); if (parem[0] == "1") { return("1"); } else { return(parem[1]); } } catch (Exception ex) { return(ex.ToString()); } }
/// <summary> /// 保存合同 /// </summary> /// <param name="state">状态</param> /// <returns></returns> private bool SaveCon(int state) { List <Mod_TMO_ORDER> orderList = new List <Mod_TMO_ORDER>(); #region //修改合同基本信息 Mod_TMO_CON modCon = tmo_con.GetModel(hidconno.Value); if (hidconno.Value != txtConNO.Value) { modCon.C_CON_NEW = txtConNO.Value; //合同号 } modCon.N_STATUS = state; //合同状态 modCon.C_CON_NAME = txtConName.Value; //合同名称 modCon.C_CONTYPEID = dropConType.SelectedValue; //合同类型 modCon.C_CURRENCYTYPEID = dropBiZhong.SelectedValue; //货币类型 modCon.D_CONSING_DT = Convert.ToDateTime(txtQianDanDT.Value); //签署日期 modCon.D_CONEFFE_DT = Convert.ToDateTime(txtPlanStartDT.Value); //生效日期 modCon.D_CONINVALID_DT = Convert.ToDateTime(txtPlanEndDT.Value); //失效日期 modCon.C_TRANSMODEID = dropFaYun.SelectedItem.Value; //发运方式 modCon.C_SALECORPID = dropSale.SelectedItem.Value; //销售组织- modCon.C_AREA = txtDept.Value; //合同区域 modCon.C_REAMRK = txtDESC.Value; //备注 modCon.C_STATION = txtC_STATION.Value; //站点 modCon.C_BIZTYPE = dropYeWuType.SelectedItem.Value; //业务类型- modCon.C_DEPTID = hidC_DEPT_ID.Value; //业务部门- modCon.C_EMPLOYEEID = hidC_SALESMAN.Value; //业务员 modCon.C_EDITEMPLOYEEID = ltlC_EMP_ID.Text; //修改人 modCon.D_EDITDATE = DateTime.Now; //修改时间 modCon.C_ADDRESS = dropAddr.SelectedItem?.Text ?? ""; //收货地址 string C_PCLX = dropYeWuType.SelectedItem.Text == "1001NC10000000005EI8" ? "1" : "0"; //1出口材,0普通材 modCon.C_CRECEIPTCUSTOMERID = hidC_CGID.Value; //收货单位 modCon.C_CRECEIPTCORPID = hidC_OTCID.Value; //开票单位 modCon.N_FLAG = dropClass.SelectedValue; #endregion #region //修改合同明细 for (int i = 0; i < rptList.Items.Count; i++) { DropDownList dropZL = (DropDownList)rptList.Items[i].FindControl("dropZL"); DropDownList dropzxzt = (DropDownList)rptList.Items[i].FindControl("dropzxzt"); DropDownList dropsfjk = (DropDownList)rptList.Items[i].FindControl("dropsfjk"); TextBox txtWgt = (TextBox)rptList.Items[i].FindControl("txtWgt"); //数量 TextBox txtN_ORIGINALCURTAXPRICE = (TextBox)rptList.Items[i].FindControl("txtN_ORIGINALCURTAXPRICE"); //原币含税单价 TextBox txtPack_Code = (TextBox)rptList.Items[i].FindControl("txtPack_Code"); TextBox txtRemark = (TextBox)rptList.Items[i].FindControl("txtRemark");//行备注 Literal ltlC_NO = (Literal)rptList.Items[i].FindControl("ltlC_NO"); HtmlInputText txtD_DELIVERY_DT = (HtmlInputText)rptList.Items[i].FindControl("txtD_DELIVERY_DT"); //订单交货日期 HtmlInputText txtN_TAXRATE = (HtmlInputText)rptList.Items[i].FindControl("txtN_TAXRATE"); //税率 HtmlInputText txtStd_Code = (HtmlInputText)rptList.Items[i].FindControl("txtStd_Code"); //执行标准 HtmlInputText txtC_FREE1 = (HtmlInputText)rptList.Items[i].FindControl("txtC_FREE1"); //自由项1 HtmlInputText txtC_FREE2 = (HtmlInputText)rptList.Items[i].FindControl("txtC_FREE2"); //自由项2 Mod_TMO_ORDER modOrder = tmo_order.GetModel(ltlC_NO.Text); if (hidconno.Value != txtConNO.Value) { modOrder.C_CON_NO = modCon.C_CON_NEW; //新合同号 } modOrder.C_CON_NAME = txtConName.Value; //合同名称 modOrder.C_AREA = txtDept.Value; //区域 modOrder.C_CUST_SQ = txtDESC.Value; modOrder.C_PCLX = C_PCLX; //1出口材,0普通材 modOrder.N_EXEC_STATUS = Convert.ToDecimal(dropzxzt.SelectedItem.Value); //执行状态 //modOrder.D_NEED_DT = modCon.D_NEED_DT;//需求日期 modOrder.D_DELIVERY_DT = Convert.ToDateTime(txtD_DELIVERY_DT.Value); //计划订单交货日期 modOrder.C_YWY = txtSaleUser.Value; //业务员姓名 modOrder.C_CURRENCYTYPEID = dropBiZhong.SelectedValue; //货币 modOrder.C_STD_CODE = txtStd_Code.Value; //执行标准 modOrder.C_FREE1 = txtC_FREE1.Value; //自由项1 modOrder.C_FREE2 = txtC_FREE2.Value; //自由项2 modOrder.C_PACK = txtPack_Code.Text; //包装要求 modOrder.C_LEV = ""; //等级 modOrder.C_ORDER_LEV = ""; //级别 modOrder.C_VDEF1 = dropZL.SelectedValue; //质量等级 modOrder.C_STL_GRD_CLASS = ""; //钢种大类 modOrder.C_SFJK = dropsfjk.SelectedItem.Text; //监控钢种 modOrder.C_RECEIPTAREAID = modCon.C_CRECEIPTAREAID; //收货地区 modOrder.C_RECEIVEADDRESS = modCon.C_ADDRESS; // 收货地址 modOrder.C_RECEIPTCORPID = modCon.C_CRECEIPTCUSTOMERID; //收货单位 modOrder.C_REMARK = txtRemark.Text; //行备注 decimal N_WGT = 0; if (!string.IsNullOrEmpty(txtWgt.Text)) { N_WGT = Convert.ToDecimal(txtWgt.Text); } modOrder.N_WGT = N_WGT; //数量 modOrder.N_FNUM = modOrder.N_HSL == 0 ? 1 : N_WGT / modOrder.N_HSL; //辅数量 #region //获取钢种单价-折扣-税率 if (!string.IsNullOrEmpty(txtN_ORIGINALCURTAXPRICE.Text)) { decimal shuolv = Convert.ToDecimal(txtN_TAXRATE.Value == "" ? "0" : txtN_TAXRATE.Value);//税率 if (Convert.ToDecimal(shuolv) >= 1) { shuolv = shuolv / 100; } decimal N_TAXRATE = shuolv + 1; //税率 decimal N_ORIGINALCURPRICE = Convert.ToDecimal(txtN_ORIGINALCURTAXPRICE.Text) / N_TAXRATE; //原币无税单价 decimal N_ORIGINALCURTAXPRICE = Convert.ToDecimal(txtN_ORIGINALCURTAXPRICE.Text); //原币含税单价 decimal N_ORIGINALCURMNY = decimal.Round(N_WGT * N_ORIGINALCURPRICE, 2); //原币无税金额 decimal N_ORIGINALCURSUMMNY = N_WGT * N_ORIGINALCURTAXPRICE; //原币价税合计 decimal N_ORIGINALCURTAXMNY = decimal.Round(N_ORIGINALCURSUMMNY - N_ORIGINALCURMNY, 2); //原币税额 modOrder.N_TAXRATE = shuolv; //税率 modOrder.N_ORIGINALCURPRICE = N_ORIGINALCURPRICE; //原币无税单价 modOrder.N_ORIGINALCURTAXPRICE = N_ORIGINALCURTAXPRICE; //原币含税单价 modOrder.N_ORIGINALCURTAXMNY = N_ORIGINALCURTAXMNY; //原币税额 modOrder.N_ORIGINALCURMNY = N_ORIGINALCURMNY; //原币无税金额 modOrder.N_ORIGINALCURSUMMNY = N_ORIGINALCURSUMMNY; //原币价税合计 } #endregion orderList.Add(modOrder); } #endregion return(tmo_con.UpdateConOrder(modCon, orderList)); }
/// <summary> /// NC销售合同接口 /// </summary> /// <param name="con">合同号</param> /// <param name="xmlFileName">文件名/路径</param> /// <param name="empID">操作人ID</param> /// <returns></returns> public List <string> SendXmlOrder(string con, string xmlFileName, string empID) { try { Mod_TMO_CON modCon = tmo_con.GetModel(con); Mod_TMB_FLOWINFO modFlow = tmb_flowinfo.GetModel(modCon.C_FLOWID); XmlDocument xmlDoc = new XmlDocument(); //创建类型声明节点 XmlNode node = xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", "no"); xmlDoc.AppendChild(node); //创建根节点 XmlElement root = xmlDoc.CreateElement("ufinterface"); #region//给节点属性赋值 root.SetAttribute("account", "1"); root.SetAttribute("billtype", "CTEXT"); root.SetAttribute("filename", ""); root.SetAttribute("isexchange", "Y"); root.SetAttribute("proc", "add"); root.SetAttribute("receiver", "101"); root.SetAttribute("replace", "Y"); root.SetAttribute("roottag", "bill"); root.SetAttribute("sender", "1107"); root.SetAttribute("subbilltype", ""); #endregion xmlDoc.AppendChild(root); //创建子根节点 XmlElement so_order = xmlDoc.CreateElement("bill"); #region //节点属性 so_order.SetAttribute("id", con); //主键 #endregion root.AppendChild(so_order); XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "bill_head", null); #region //表头_bill_head CreateNode(xmlDoc, head, "actualinvalidate", Convert.ToDateTime(modCon.D_CONINVALID_DT).ToString("yyy-MM-dd")); //实际终止日期 CreateNode(xmlDoc, head, "actualvalidate", Convert.ToDateTime(modCon.D_CONEFFE_DT).ToString("yyy-MM-dd")); //实际生效日期 CreateNode(xmlDoc, head, "audiid", modCon.C_APPROVEID); //审核人 CreateNode(xmlDoc, head, "auditdate", Convert.ToDateTime(modCon.D_APPROVEDATE).ToString("yyy-MM-dd")); //审核日期 CreateNode(xmlDoc, head, "bsc", "N"); //是否委外---**** CreateNode(xmlDoc, head, "ct_code", modCon.C_CON_NO); //合同编码 CreateNode(xmlDoc, head, "ct_name", modCon.C_CON_NAME); //合同名称 CreateNode(xmlDoc, head, "ctflag", modCon.N_STATUS.ToString()); //合同状态 CreateNode(xmlDoc, head, "currid", modCon.C_CURRENCYTYPEID); //币种 CreateNode(xmlDoc, head, "currrate", "1"); //折本汇率 CreateNode(xmlDoc, head, "custid", modCon.C_CUSTOMERID); //客商 CreateNode(xmlDoc, head, "custunit", ""); //对方单位说明 CreateNode(xmlDoc, head, "depid", modCon.C_DEPTID); //部门1001NC100000008KOR85 CreateNode(xmlDoc, head, "ifearly", "N"); //是否期初 CreateNode(xmlDoc, head, "invallidate", Convert.ToDateTime(modCon.D_CONINVALID_DT).ToString("yyy-MM-dd")); //计划失效日期 CreateNode(xmlDoc, head, "iprintcount", "0"); //计划失效日期 CreateNode(xmlDoc, head, "operdate", Convert.ToDateTime(modCon.D_DMAKEDATE).ToString("yyy-MM-dd")); //制单日期 CreateNode(xmlDoc, head, "operid", modCon.C_COPERATORID); //制单人1006AA1000000000NI7B CreateNode(xmlDoc, head, "payterm", ""); //收付款协议 CreateNode(xmlDoc, head, "personnelid", modCon.C_EMPLOYEEID); //人员(业务员ID)1001NC10000000000TD8 CreateNode(xmlDoc, head, "pk_corp", modCon.C_XGID); //公司 CreateNode(xmlDoc, head, "pk_ct_manage", modCon.C_CON_NO); //合同主键 CreateNode(xmlDoc, head, "pk_ct_type", modCon.C_CONTYPEID); //类型定义主键 CreateNode(xmlDoc, head, "projectid", ""); //项目号 CreateNode(xmlDoc, head, "subscribedate", Convert.ToDateTime(modCon.D_CONSING_DT).ToString("yyy-MM-dd")); //合同签订日期 CreateNode(xmlDoc, head, "valdate", Convert.ToDateTime(modCon.D_CONEFFE_DT).ToString("yyy-MM-dd")); //计划生效日期 CreateNode(xmlDoc, head, "activeflag", "0"); //激活状态 CreateNode(xmlDoc, head, "clastoperatorid", modCon.C_EDITEMPLOYEEID); //最后修改人 CreateNode(xmlDoc, head, "astcurrate", ""); //折辅汇率 CreateNode(xmlDoc, head, "nprepaylimitmny", ""); //预付款限额 CreateNode(xmlDoc, head, "nprepaymny", ""); //预付款 CreateNode(xmlDoc, head, "taudittime", Convert.ToDateTime(modCon.D_APPROVEDATE).ToString("yyy-MM-dd HH:mm:ss")); //审批时间 CreateNode(xmlDoc, head, "tlastmaketime", Convert.ToDateTime(modCon.D_EDITDATE).ToString("yyy-MM-dd HH:mm:ss")); //最后修改时间 CreateNode(xmlDoc, head, "tmaketime", Convert.ToDateTime(modCon.D_DMAKEDATE).ToString("yyy-MM-dd HH:mm:ss")); //制单时间 CreateNode(xmlDoc, head, "def1", ""); //自定义项1 CreateNode(xmlDoc, head, "def2", modFlow.C_NAME); //审批流程名称(日常合同) CreateNode(xmlDoc, head, "def3", ""); //自定义项3 CreateNode(xmlDoc, head, "def4", ""); //自定义项4 CreateNode(xmlDoc, head, "def5", modCon.C_CON_NO); //自定义项5-合同表头主键 CreateNode(xmlDoc, head, "pk_defdoc1", modCon.C_REAMRK); // 合同说明信息 CreateNode(xmlDoc, head, "pk_defdoc2", ""); // 审批流主键 CreateNode(xmlDoc, head, "pk_defdoc3", ""); // 自定义项主键3 CreateNode(xmlDoc, head, "pk_defdoc4", ""); // 自定义项主键4 CreateNode(xmlDoc, head, "pk_defdoc5", GetUserName(modCon.C_EMPLOYEEID)); // 自定义项主键5-业务员姓名 CreateNode(xmlDoc, head, "transpmode", modCon.C_TRANSMODEID); // 发运方式 #endregion so_order.AppendChild(head); XmlElement body = xmlDoc.CreateElement("bill_body"); so_order.AppendChild(body); DataTable dt = tmo_order.GetList(" C_CON_NO='" + con + "'").Tables[0]; for (int j = 0; j < dt.Rows.Count; j++) { int rowno = j + 1; Mod_TMO_ORDER modOrder = tmo_order.GetModel(dt.Rows[j]["C_ID"].ToString()); if (modOrder != null) { XmlNode entry = xmlDoc.CreateNode(XmlNodeType.Element, "item", null); #region //表体_item CreateNode(xmlDoc, entry, "amount", modOrder.N_WGT.ToString()); //数量 CreateNode(xmlDoc, entry, "invclid", ""); //存货分类 CreateNode(xmlDoc, entry, "invid", modOrder.C_INVENTORYID); //存货管理档案主键 CreateNode(xmlDoc, entry, "measid", modOrder.C_UNITID); //主计量单位 CreateNode(xmlDoc, entry, "natiprice", modOrder.N_ORIGINALCURPRICE.ToString()); //本币无税单价 CreateNode(xmlDoc, entry, "natisum", modOrder.N_ORIGINALCURMNY.ToString()); //本币无税金额 CreateNode(xmlDoc, entry, "natitaxmny", modOrder.N_ORIGINALCURTAXMNY.ToString()); //本币税额 CreateNode(xmlDoc, entry, "natitaxprice", modOrder.N_ORIGINALCURTAXPRICE.ToString()); //本币含税单价 CreateNode(xmlDoc, entry, "natitaxsummny", modOrder.N_ORIGINALCURSUMMNY.ToString()); //本币价税合计 CreateNode(xmlDoc, entry, "ordnum", ""); //订单执行累计数量 CreateNode(xmlDoc, entry, "ordprice", ""); //订单执行累计含税单价 CreateNode(xmlDoc, entry, "ordsum", ""); //订单执行累计本币价税合计 CreateNode(xmlDoc, entry, "oriprice", modOrder.N_ORIGINALCURPRICE.ToString()); //原币无税单价 CreateNode(xmlDoc, entry, "orisum", modOrder.N_ORIGINALCURMNY.ToString()); //原币无税金额 CreateNode(xmlDoc, entry, "oritaxmny", modOrder.N_ORIGINALCURTAXMNY.ToString()); //原币税额 CreateNode(xmlDoc, entry, "oritaxprice", modOrder.N_ORIGINALCURTAXPRICE.ToString()); //原币含税单价 CreateNode(xmlDoc, entry, "oritaxsummny", modOrder.N_ORIGINALCURSUMMNY.ToString()); //原币价税合计 CreateNode(xmlDoc, entry, "pk_corp", modOrder.C_XGID); //公司 CreateNode(xmlDoc, entry, "pk_ct_manage", ""); //合同主键 CreateNode(xmlDoc, entry, "pk_ct_manage_b", ""); //表体主键 CreateNode(xmlDoc, entry, "taxration", modOrder.N_TAXRATE.ToString()); //税率 CreateNode(xmlDoc, entry, "astmeasid", modOrder.C_FUNITID); //辅计量单位 CreateNode(xmlDoc, entry, "astnum", modOrder.N_FNUM.ToString()); //辅数量 CreateNode(xmlDoc, entry, "astprice", ""); //辅币无税单价 CreateNode(xmlDoc, entry, "astsum", ""); //辅币无税金额 CreateNode(xmlDoc, entry, "asttaxmny", ""); //辅币税额 CreateNode(xmlDoc, entry, "asttaxprice", ""); //辅币含税单价 CreateNode(xmlDoc, entry, "asttaxsummny", ""); //辅币价税合计 CreateNode(xmlDoc, entry, "cqpbaseschemeid", ""); //优质优价方案 CreateNode(xmlDoc, entry, "crowno", rowno.ToString()); //行号 CreateNode(xmlDoc, entry, "transrate", modOrder.N_HSL.ToString()); //主辅计量换算率 CreateNode(xmlDoc, entry, "vbatchcode", ""); //批次号 CreateNode(xmlDoc, entry, "def1", ""); //自定义项1 CreateNode(xmlDoc, entry, "def2", ""); //自定义项2 CreateNode(xmlDoc, entry, "def3", ""); //自定义项3 CreateNode(xmlDoc, entry, "def4", modOrder.C_PRO_USE); //自定义项4产品用途 CreateNode(xmlDoc, entry, "def5", ""); //自定义项5 CreateNode(xmlDoc, entry, "def6", ""); //自定义项6 CreateNode(xmlDoc, entry, "def7", ""); //自定义项7 CreateNode(xmlDoc, entry, "def8", ""); //自定义项8 CreateNode(xmlDoc, entry, "def9", ""); //自定义项9 CreateNode(xmlDoc, entry, "def10", modOrder.C_ID); //合同表体主键 CreateNode(xmlDoc, entry, "pk_defdoc1", ""); //自定义项主键1 CreateNode(xmlDoc, entry, "pk_defdoc2", ""); //自定义项主键2 CreateNode(xmlDoc, entry, "pk_defdoc3", ""); //自定义项主键3 CreateNode(xmlDoc, entry, "pk_defdoc4", ""); //自定义项主键4 CreateNode(xmlDoc, entry, "pk_defdoc5", ""); //自定义项主键5 CreateNode(xmlDoc, entry, "pk_defdoc6", ""); //自定义项主键6 CreateNode(xmlDoc, entry, "pk_defdoc7", ""); //自定义项主键7 CreateNode(xmlDoc, entry, "pk_defdoc8", ""); //自定义项主键8 CreateNode(xmlDoc, entry, "pk_defdoc9", ""); //自定义项主键9 CreateNode(xmlDoc, entry, "pk_defdoc10", ""); //自定义项主键10 CreateNode(xmlDoc, entry, "pk_defdoc11", ""); //自定义项主键11 CreateNode(xmlDoc, entry, "pk_defdoc12", ""); //自定义项主键12 CreateNode(xmlDoc, entry, "pk_defdoc13", ""); //自定义项主键13 CreateNode(xmlDoc, entry, "pk_defdoc14", ""); //自定义项主键14 CreateNode(xmlDoc, entry, "pk_defdoc15", ""); //自定义项主键15 CreateNode(xmlDoc, entry, "pk_defdoc16", modOrder.C_SPEC); //规格 CreateNode(xmlDoc, entry, "pk_defdoc17", modOrder.C_STL_GRD); //钢种 CreateNode(xmlDoc, entry, "pk_defdoc18", ""); //自定义项主键18 CreateNode(xmlDoc, entry, "pk_defdoc19", ""); //自定义项主键19 CreateNode(xmlDoc, entry, "pk_defdoc20", ""); //自定义项主键20 CreateNode(xmlDoc, entry, "vfree1", modOrder.C_FREE1); //自由项1 CreateNode(xmlDoc, entry, "vfree2", modOrder.C_FREE2); //自由项2 CreateNode(xmlDoc, entry, "vfree3", modOrder.C_PACK); //自由项3 CreateNode(xmlDoc, entry, "vfree4", ""); //自由项4 CreateNode(xmlDoc, entry, "vfree5", ""); //自由项5 CreateNode(xmlDoc, entry, "creceiptcorpid", modOrder.C_RECEIPTCORPID); //收货单位 CreateNode(xmlDoc, entry, "vreceiveaddress", modOrder.C_RECEIVEADDRESS); //收货地址 CreateNode(xmlDoc, entry, "delivdate", Convert.ToDateTime(modOrder.D_DELIVERY_DT).ToString("yyy-MM-dd")); //计划收发货日期 CreateNode(xmlDoc, entry, "creceiptareaid", modOrder.C_RECEIPTAREAID); //收货地区ID #endregion body.AppendChild(entry); } } xmlDoc.Save(xmlFileName); List <string> parem = NCSendXml.SendXML(xmlDoc); //发送NC parem.Add(con); //合同号 parem.Add(empID); parem.Add("销售合同-NC"); parem.Add(parem[0] == "1" ? "导入NC成功" : "导入NC失败"); //日志录入 AddLog(parem); return(parem); } catch (Exception ex) { throw ex; } }
/// <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>(); 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"); //行备注 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" ? "805" : 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.N_PRICE = 0; //到货地点费用 item.Add(modfyditem); } } #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; //发运量 modfyd.N_IS_EXPORT = 0; //是否包到价 modfyd.C_EXTEND2 = txtcph.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 if (tmd_dispatch.InsertFYD(modfyd, item)) { txtsendcode.Text = sendcode; return(true); } else { return(false); } }
private void BindOrderList() { if (Session[ltlempid.Text] != null) { DataTable dt = (DataTable)Session[ltlempid.Text]; for (int i = 0; i < dt.Rows.Count; i++) { //检测订单是否重复 if (getck(dt.Rows[i]["C_ID"].ToString())) { Mod_TMO_ORDER mod = tmo_order.GetModel(dt.Rows[i]["C_ID"].ToString()); if (mod != null) { ltltype.Text = mod.N_TYPE.ToString(); //发运类型 ltlcon_no.Text = mod.C_CON_NO; //合同号 ltlcustname.Text = mod.C_CUST_NAME; //客户 hidcustno.Value = mod.C_CUST_NO; //客户编码 hidmatcode.Value = mod.C_MAT_CODE; //物料编码 hidarea.Value = mod.C_AREA; //销售区域 dtOrder.Rows.Add(new object[] { dt.Rows[i]["C_ID"], mod.C_CON_NO, mod.C_STL_GRD, mod.C_SPEC, mod.C_STD_CODE, mod.C_FREE1, mod.C_FREE2, mod.C_PACK, mod.N_WGT, mod.C_VDEF1, //质量等级 mod.C_AREA, //区域 mod.C_MAT_CODE, mod.C_MAT_NAME, mod.C_CUST_NAME, //订货单位 mod.C_RECEIPTCORPID, //收货单位 mod.C_RECEIPTAREAID, //收货地区 mod.C_RECEIVEADDRESS, //收货地址 mod.N_TYPE, mod.C_CUST_NO, dt.Rows[i]["PKPLAN"], //日计划主键 dt.Rows[i]["YLXWGT"], //已履行量 dt.Rows[i]["DLXWGT"], //待履行量 }); } } } } if (dtOrder.Rows.Count > 0) { rptList.DataSource = dtOrder; rptList.DataBind(); Session[ltlempid.Text] = null; } else { rptList.DataSource = null; rptList.DataBind(); Session[ltlempid.Text] = null; txtcount.Value = ""; txtsumwgt.Value = ""; } }