public List <string> SendXmlDayPlan(string dayplcode, string xmlFileName, string empID) { try { Mod_TMP_DAYPLAN modPlan = tmp_dayplan.GetModel(dayplcode); 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", "DMDP"); root.SetAttribute("filename", "" + dayplcode + ".xml"); root.SetAttribute("isexchange", "Y"); root.SetAttribute("proc", "add"); root.SetAttribute("receiver", "101"); root.SetAttribute("replace", "Y"); root.SetAttribute("roottag", "bill"); root.SetAttribute("sender", "1107"); #endregion xmlDoc.AppendChild(root); //创建子根节点 XmlElement so_order = xmlDoc.CreateElement("bill"); so_order.SetAttribute("id", modPlan.C_ID); root.AppendChild(so_order); XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "bill_head", null); #region //表头_order_head CreateNode(xmlDoc, head, "vdelivdayplcode", modPlan.C_PLCODE); //日计划单据号 CreateNode(xmlDoc, head, "vbilltype", "30"); //来源单据类型 CreateNode(xmlDoc, head, "pkbillb", modPlan.C_PKBILLB); //来源单据子表ID CreateNode(xmlDoc, head, "pkbillh", modPlan.C_PKBILLH); //来源单据主表ID CreateNode(xmlDoc, head, "vsrcbillnum", modPlan.C_SALECODE); //来源销售主表单据号 CreateNode(xmlDoc, head, "iplanstatus", "0"); CreateNode(xmlDoc, head, "plandate", Convert.ToDateTime(modPlan.D_PLANDATE).ToString("yyy-MM-dd")); //日计划日期 CreateNode(xmlDoc, head, "ordsndate", Convert.ToDateTime(modPlan.D_ORDSNDATE).ToString("yyy-MM-dd")); //定单要求发货日期 CreateNode(xmlDoc, head, "requiredate", Convert.ToDateTime(modPlan.D_REQUIREDATE).ToString("yyy-MM-dd")); //定单要求到货日期 CreateNode(xmlDoc, head, "snddate", Convert.ToDateTime(modPlan.D_SNDDATE).ToString("yyy-MM-dd")); //实际发货日期 CreateNode(xmlDoc, head, "pkinv", modPlan.C_PKINV); //存货主键 CreateNode(xmlDoc, head, "pkassistmeasure", modPlan.C_PKASSISTMEASURE); //辅计量单位 CreateNode(xmlDoc, head, "dassistnum", modPlan.N_ASSISTNUM.ToString()); //辅数量 CreateNode(xmlDoc, head, "dnum", modPlan.N_NUM.ToString()); //主数量 CreateNode(xmlDoc, head, "pkcust", modPlan.C_PKCUST); //客户主键 CreateNode(xmlDoc, head, "pksendtype", modPlan.C_PKSENDTYPE); //发运方式 CreateNode(xmlDoc, head, "vbatchcode", ""); CreateNode(xmlDoc, head, "ibatchstatus", "0"); CreateNode(xmlDoc, head, "pkdeststoreorg", ""); CreateNode(xmlDoc, head, "pkdeststore", ""); CreateNode(xmlDoc, head, "pksalecorp", modPlan.C_PKSALECORP); //销售公司主键 CreateNode(xmlDoc, head, "pksaleorg", modPlan.C_PKSALEORG); //销售组织主键 CreateNode(xmlDoc, head, "pksendstoreorg", modPlan.C_PKSENDSTOREORG); //发货库存组织主键 CreateNode(xmlDoc, head, "pksendstore", "N"); CreateNode(xmlDoc, head, "dweight", ""); CreateNode(xmlDoc, head, "dvolumn", ""); CreateNode(xmlDoc, head, "dunitprice", modPlan.N_UNITPRICE.ToString()); //单价 CreateNode(xmlDoc, head, "dmoney", modPlan.N_MONEY.ToString()); //订单金额 CreateNode(xmlDoc, head, "bpresent", "N"); CreateNode(xmlDoc, head, "dsendnum", ""); CreateNode(xmlDoc, head, "dsignnum", ""); CreateNode(xmlDoc, head, "doutnum", ""); CreateNode(xmlDoc, head, "dbacknum", ""); CreateNode(xmlDoc, head, "pkitem", ""); CreateNode(xmlDoc, head, "pkitemperiod", ""); CreateNode(xmlDoc, head, "pkoperator", modPlan.C_PKOPERATOR); //业务员主键 CreateNode(xmlDoc, head, "pkoprdepart", modPlan.C_PKOPRDEPART); //业务部门主键 CreateNode(xmlDoc, head, "pkplanperson", modPlan.C_PKPLANPERSON); //计划人 CreateNode(xmlDoc, head, "pkapprperson", modPlan.C_PKAPPRPERSON); //审批人 CreateNode(xmlDoc, head, "apprdate", Convert.ToDateTime(modPlan.D_APPRDATE).ToString("yyy-MM-dd")); //审批日期 CreateNode(xmlDoc, head, "pkarrivearea", modPlan.C_PKARRIVEAREA); //到货地区主键 CreateNode(xmlDoc, head, "vdestaddress", modPlan.C_DESTADDRESS); //到货地址 CreateNode(xmlDoc, head, "cfreezeid", ""); CreateNode(xmlDoc, head, "creceiptcorpid", modPlan.C_RECEIPTCORPID); //收货单位 CreateNode(xmlDoc, head, "cbiztype", modPlan.C_BIZTYPE); //业务类型 CreateNode(xmlDoc, head, "vnote", modPlan.C_REMARK); CreateNode(xmlDoc, head, "dwaylossnum", ""); CreateNode(xmlDoc, head, "bisdelivend", ""); CreateNode(xmlDoc, head, "bisoutend", ""); CreateNode(xmlDoc, head, "pkarrivecorp", ""); CreateNode(xmlDoc, head, "pksendarea", modPlan.C_PKSENDAREA);//发货地区 CreateNode(xmlDoc, head, "cplansendtime", ""); CreateNode(xmlDoc, head, "crequiretime", ""); CreateNode(xmlDoc, head, "pkarriveaddress", ""); CreateNode(xmlDoc, head, "pksendaddress", ""); CreateNode(xmlDoc, head, "pkdelivorg", modPlan.C_PKDELIVORG);//发运组织固定 CreateNode(xmlDoc, head, "pkorderplanid", ""); CreateNode(xmlDoc, head, "borderreturn", "N"); CreateNode(xmlDoc, head, "csendcorpid", ""); CreateNode(xmlDoc, head, "vsendaddr", ""); CreateNode(xmlDoc, head, "ntotalshouldoutnum", ""); CreateNode(xmlDoc, head, "nfeedbacknum", modPlan.N_NUM.ToString()); //回写上游数量--发运单 CreateNode(xmlDoc, head, "iprintcount", ""); CreateNode(xmlDoc, head, "cquoteunitid", modPlan.C_UNITID); //报价计量单位ID CreateNode(xmlDoc, head, "nquoteunitnum", "1"); CreateNode(xmlDoc, head, "nquoteunitrate", "1"); CreateNode(xmlDoc, head, "taudittime", ""); CreateNode(xmlDoc, head, "tmaketime", ""); CreateNode(xmlDoc, head, "tlastmodifytime", ""); CreateNode(xmlDoc, head, "clastmodifierid", ""); CreateNode(xmlDoc, head, "vfree1", modPlan.C_VFREE1); //自由项1 CreateNode(xmlDoc, head, "vfree2", modPlan.C_VFREE2); //自由项2 CreateNode(xmlDoc, head, "vfree3", modPlan.C_VFREE3); //包装要求 CreateNode(xmlDoc, head, "vfree4", ""); CreateNode(xmlDoc, head, "vfree5", ""); CreateNode(xmlDoc, head, "vfree6", ""); CreateNode(xmlDoc, head, "vfree7", ""); CreateNode(xmlDoc, head, "vfree8", ""); CreateNode(xmlDoc, head, "vfree9", ""); CreateNode(xmlDoc, head, "vfree10", ""); CreateNode(xmlDoc, head, "vuserdef0", ""); CreateNode(xmlDoc, head, "vuserdef1", ""); CreateNode(xmlDoc, head, "vuserdef2", ""); CreateNode(xmlDoc, head, "vuserdef3", ""); CreateNode(xmlDoc, head, "vuserdef4", ""); CreateNode(xmlDoc, head, "vuserdef5", ""); CreateNode(xmlDoc, head, "vuserdef6", ""); CreateNode(xmlDoc, head, "vuserdef7", ""); CreateNode(xmlDoc, head, "vuserdef8", ""); CreateNode(xmlDoc, head, "vuserdef9", ""); 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, "pk_defdoc0", ""); CreateNode(xmlDoc, head, "pk_defdoc1", ""); 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_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, "vuserdef_b_0", ""); CreateNode(xmlDoc, head, "vuserdef_b_1", ""); CreateNode(xmlDoc, head, "vuserdef_b_2", ""); CreateNode(xmlDoc, head, "vuserdef_b_3", ""); CreateNode(xmlDoc, head, "vuserdef_b_4", ""); CreateNode(xmlDoc, head, "vuserdef_b_5", ""); CreateNode(xmlDoc, head, "vuserdef_b_6", ""); CreateNode(xmlDoc, head, "vuserdef_b_7", ""); CreateNode(xmlDoc, head, "vuserdef_b_8", ""); CreateNode(xmlDoc, head, "vuserdef_b_9", ""); CreateNode(xmlDoc, head, "vuserdef_b_10", modPlan.C_CONNO); //合同号 CreateNode(xmlDoc, head, "vuserdef_b_11", modPlan.C_VFREE4); //质量等级 CreateNode(xmlDoc, head, "vuserdef_b_12", ""); CreateNode(xmlDoc, head, "vuserdef_b_13", ""); CreateNode(xmlDoc, head, "vuserdef_b_14", ""); CreateNode(xmlDoc, head, "vuserdef_b_15", ""); CreateNode(xmlDoc, head, "vuserdef_b_16", ""); CreateNode(xmlDoc, head, "vuserdef_b_17", ""); CreateNode(xmlDoc, head, "vuserdef_b_18", ""); CreateNode(xmlDoc, head, "vuserdef_b_19", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_0", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_1", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_2", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_3", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_4", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_5", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_6", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_7", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_8", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_9", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_10", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_11", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_12", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_13", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_14", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_15", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_16", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_17", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_18", ""); CreateNode(xmlDoc, head, "pk_defdoc_b_19", ""); #endregion so_order.AppendChild(head); xmlDoc.Save(xmlFileName); List <string> parem = NCSendXml.SendXML(xmlDoc);//发送NC parem.Add(dayplcode); parem.Add(empID); parem.Add("日计划-NC"); parem.Add(parem[0] == "1" ? "导入NC成功" : "导入NC失败"); //日志录入 AddLog(parem); return(parem); } catch (Exception ex) { throw ex; } }
/// <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> /// NC订单维护接口 /// </summary> /// <param name="saleCode">销售单据号列表</param> /// <param name="xmlFileName">路径/文件名.xml</param> /// <param name="empID">操作人ID</param> /// <returns>返回结果集</returns> public List <string> SendXmlOrder(List <ApiOrderDto> orderDto, string xmlFileName, string empID) { try { Mod_TMO_CON modCon = tmo_con.GetModel(orderDto[0].ConNO); 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", "30ext"); root.SetAttribute("filename", "" + orderDto[0].SaleCode + ".xml");//单据号 root.SetAttribute("isexchange", "Y"); root.SetAttribute("proc", "add"); root.SetAttribute("receiver", "101"); root.SetAttribute("replace", "Y"); root.SetAttribute("roottag", "so_order"); root.SetAttribute("sender", "1107"); #endregion xmlDoc.AppendChild(root); //创建子根节点 XmlElement so_order = xmlDoc.CreateElement("so_order"); #region //节点属性 so_order.SetAttribute("id", orderDto[0].NC_ID); //主键 #endregion root.AppendChild(so_order); XmlNode head = xmlDoc.CreateNode(XmlNodeType.Element, "so_order_head", null); #region //表头_order_head CreateNode(xmlDoc, head, "pk_corp", "1001"); CreateNode(xmlDoc, head, "vreceiptcode", orderDto[0].SaleCode); //销售单据号 CreateNode(xmlDoc, head, "creceipttype", "30"); CreateNode(xmlDoc, head, "cbiztype", modCon.C_BIZTYPE); //业务类型 CreateNode(xmlDoc, head, "vaccountyear", ""); CreateNode(xmlDoc, head, "binitflag", "N"); CreateNode(xmlDoc, head, "dbilldate", Convert.ToDateTime(orderDto[0].D_NC_DATE).ToString("yyy-MM-dd")); //单据日期 CreateNode(xmlDoc, head, "ccustomerid", modCon.C_CUSTOMERID); //客户ID CreateNode(xmlDoc, head, "cdeptid", modCon.C_DEPTID); //部门ID CreateNode(xmlDoc, head, "cemployeeid", modCon.C_EMPLOYEEID); //业务员ID CreateNode(xmlDoc, head, "coperatorid", modCon.C_COPERATORID); //制单人 CreateNode(xmlDoc, head, "ctermprotocolid", ""); CreateNode(xmlDoc, head, "csalecorpid", modCon.C_SALECORPID); //销售组织 CreateNode(xmlDoc, head, "ccalbodyid", "1001NC10000000000669"); //库存组织 CreateNode(xmlDoc, head, "creceiptcustomerid", modCon.C_CRECEIPTCUSTOMERID); //收货单位 CreateNode(xmlDoc, head, "vreceiveaddress", modCon.C_ADDRESS); //收货地址 CreateNode(xmlDoc, head, "creceiptareaid", ""); CreateNode(xmlDoc, head, "creceiptcorpid", modCon.C_CRECEIPTCORPID); //开票单位 CreateNode(xmlDoc, head, "ccustbankid", ""); CreateNode(xmlDoc, head, "ctransmodeid", modCon.C_TRANSMODEID); //发运方式 CreateNode(xmlDoc, head, "ndiscountrate", "100"); CreateNode(xmlDoc, head, "cwarehouseid", ""); CreateNode(xmlDoc, head, "veditreason", ""); CreateNode(xmlDoc, head, "bfreecustflag", "N"); CreateNode(xmlDoc, head, "cfreecustid", ""); CreateNode(xmlDoc, head, "ibalanceflag", ""); CreateNode(xmlDoc, head, "nsubscription", ""); CreateNode(xmlDoc, head, "nevaluatecarriage", "0"); CreateNode(xmlDoc, head, "dmakedate", Convert.ToDateTime(modCon.D_DMAKEDATE).ToString("yyy-MM-dd")); //制单日期 CreateNode(xmlDoc, head, "capproveid", modCon.C_APPROVEID); //审批人 CreateNode(xmlDoc, head, "dapprovedate", Convert.ToDateTime(modCon.D_APPROVEDATE).ToString("yyy-MM-dd")); //审批日期 CreateNode(xmlDoc, head, "fstatus", "1"); CreateNode(xmlDoc, head, "vnote", modCon.C_CON_NAME); //合同名称 CreateNode(xmlDoc, head, "vdef1", ""); CreateNode(xmlDoc, head, "vdef2", ""); CreateNode(xmlDoc, head, "vdef3", ""); CreateNode(xmlDoc, head, "vdef4", ""); CreateNode(xmlDoc, head, "vdef5", ""); CreateNode(xmlDoc, head, "vdef6", ""); CreateNode(xmlDoc, head, "vdef7", ""); CreateNode(xmlDoc, head, "vdef8", ""); CreateNode(xmlDoc, head, "vdef9", ""); CreateNode(xmlDoc, head, "vdef10", ""); CreateNode(xmlDoc, head, "bretinvflag", "N"); CreateNode(xmlDoc, head, "boutendflag", "N"); CreateNode(xmlDoc, head, "binvoicendflag", "N"); CreateNode(xmlDoc, head, "breceiptendflag", "N"); CreateNode(xmlDoc, head, "bpayendflag", "N"); CreateNode(xmlDoc, head, "bdeliver", "Y"); #endregion so_order.AppendChild(head); XmlElement body = xmlDoc.CreateElement("so_order_body"); so_order.AppendChild(body); DataTable dt = tmo_order.GetSaleOrder(orderDto[0].SaleCode).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, "entry", null); #region //表体_entry string[] arr = { "6", "8" }; CreateNode(xmlDoc, entry, "pk_corp", modOrder.C_XGID);//邢钢公司'1001' CreateNode(xmlDoc, entry, "creceipttype", ""); CreateNode(xmlDoc, entry, "csourcebillid", ""); CreateNode(xmlDoc, entry, "csourcebillbodyid", ""); CreateNode(xmlDoc, entry, "cinvbasdocid", modOrder.C_INVBASDOCID); //存货档案主键 CreateNode(xmlDoc, entry, "cinventoryid", modOrder.C_INVENTORYID); //存货管理档案主键 CreateNode(xmlDoc, entry, "cunitid", modOrder.C_UNITID); //主计量单位 if (arr.Contains(modOrder.N_TYPE.ToString())) { CreateNode(xmlDoc, entry, "cpackunitid", modOrder.C_FUNITID);//辅单位 } else { CreateNode(xmlDoc, entry, "cpackunitid", "");//辅单位 } CreateNode(xmlDoc, entry, "cbatchid", ""); CreateNode(xmlDoc, entry, "nnumber", modOrder.N_WGT.ToString());//数量 if (arr.Contains(modOrder.N_TYPE.ToString())) { CreateNode(xmlDoc, entry, "npacknumber", modOrder.N_FNUM.ToString());//辅数量 } else { CreateNode(xmlDoc, entry, "npacknumber", ""); //辅数量 } CreateNode(xmlDoc, entry, "cconsigncorpid", modOrder.C_XGID); //发货公司 CreateNode(xmlDoc, entry, "cadvisecalbodyid", "1001NC10000000000669"); //发货库存组织 CreateNode(xmlDoc, entry, "cbodywarehouseid", ""); CreateNode(xmlDoc, entry, "creccalbodyid", ""); CreateNode(xmlDoc, entry, "crecwarehouseid", "a"); CreateNode(xmlDoc, entry, "dconsigndate", Convert.ToDateTime(modOrder.D_DELIVERY_DT).ToString("yyy-MM-dd")); //发货日期 CreateNode(xmlDoc, entry, "ddeliverdate", Convert.ToDateTime(modOrder.D_DELIVERY_DT).ToString("yyy-MM-dd")); //交货日期 CreateNode(xmlDoc, entry, "blargessflag", "N"); CreateNode(xmlDoc, entry, "ceditsaleid", ""); CreateNode(xmlDoc, entry, "beditflag", "N"); CreateNode(xmlDoc, entry, "veditreason", ""); CreateNode(xmlDoc, entry, "ccurrencytypeid", modOrder.C_CURRENCYTYPEID);//原币 CreateNode(xmlDoc, entry, "nitemdiscountrate", "100"); CreateNode(xmlDoc, entry, "ndiscountrate", "100"); CreateNode(xmlDoc, entry, "nexchangeotobrate", "1"); CreateNode(xmlDoc, entry, "nexchangeotoarate", ""); CreateNode(xmlDoc, entry, "ntaxrate", Convert.ToString(modOrder.N_TAXRATE * 100)); //税率 CreateNode(xmlDoc, entry, "noriginalcurprice", modOrder.N_ORIGINALCURPRICE.ToString()); //原币无税单价 CreateNode(xmlDoc, entry, "noriginalcurtaxprice", modOrder.N_ORIGINALCURTAXPRICE.ToString()); //原币含税单价 CreateNode(xmlDoc, entry, "noriginalcurnetprice", modOrder.N_ORIGINALCURPRICE.ToString()); //原币无税净价 CreateNode(xmlDoc, entry, "noriginalcurtaxnetprice", modOrder.N_ORIGINALCURTAXPRICE.ToString()); //原币含税净价 CreateNode(xmlDoc, entry, "noriginalcurtaxmny", modOrder.N_ORIGINALCURTAXMNY.ToString()); //原币税额 CreateNode(xmlDoc, entry, "noriginalcurmny", modOrder.N_ORIGINALCURMNY.ToString()); //原币无税金额 CreateNode(xmlDoc, entry, "noriginalcursummny", modOrder.N_ORIGINALCURSUMMNY.ToString()); //原币价税合计 CreateNode(xmlDoc, entry, "noriginalcurdiscountmny", "0"); CreateNode(xmlDoc, entry, "nprice", modOrder.N_ORIGINALCURPRICE.ToString()); //本币无税单价 CreateNode(xmlDoc, entry, "ntaxprice", modOrder.N_ORIGINALCURTAXPRICE.ToString()); //本币含税单价 CreateNode(xmlDoc, entry, "nnetprice", modOrder.N_ORIGINALCURPRICE.ToString()); //本币无税净价 CreateNode(xmlDoc, entry, "ntaxnetprice", modOrder.N_ORIGINALCURTAXPRICE.ToString()); //本币含税净价 CreateNode(xmlDoc, entry, "ntaxmny", modOrder.N_ORIGINALCURTAXMNY.ToString()); //本币税额 CreateNode(xmlDoc, entry, "nmny", modOrder.N_ORIGINALCURMNY.ToString()); //本币无税金额 CreateNode(xmlDoc, entry, "nsummny", modOrder.N_ORIGINALCURSUMMNY.ToString()); //本币价税合计 CreateNode(xmlDoc, entry, "ndiscountmny", "0"); CreateNode(xmlDoc, entry, "coperatorid", ""); //制单人 CreateNode(xmlDoc, entry, "frowstatus", "1"); CreateNode(xmlDoc, entry, "frownote", ""); CreateNode(xmlDoc, entry, "fbatchstatus", "0"); CreateNode(xmlDoc, entry, "ct_manageid", ""); CreateNode(xmlDoc, entry, "cfactoryid", ""); //合同表头主键 CreateNode(xmlDoc, entry, "cfreezeid", ""); //合同表体主键 CreateNode(xmlDoc, entry, "cbomorderid", modOrder.C_ID); //销售订单表体主键 CreateNode(xmlDoc, entry, "boosflag", "N"); CreateNode(xmlDoc, entry, "bsupplyflag", "N"); CreateNode(xmlDoc, entry, "creceiptareaid", modOrder.C_RECEIPTAREAID); //收货地区 CreateNode(xmlDoc, entry, "vreceiveaddress", modOrder.C_RECEIVEADDRESS); //收货地址 CreateNode(xmlDoc, entry, "creceiptcorpid", modOrder.C_RECEIPTCORPID); //收货单位 CreateNode(xmlDoc, entry, "crowno", rowno.ToString()); //行号 CreateNode(xmlDoc, entry, "ntotalpaymny", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalreceiptnumber", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalinvoicenumber", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalinvoicemny", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalinventorynumber", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalbalancenumber", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalsignnumber", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalcostmny", "0.00000000"); CreateNode(xmlDoc, entry, "bifinvoicefinish", "N"); CreateNode(xmlDoc, entry, "bifreceiptfinish", "N"); CreateNode(xmlDoc, entry, "bifinventoryfinish", "N"); CreateNode(xmlDoc, entry, "bifpayfinish", "N"); CreateNode(xmlDoc, entry, "bifpaybalance", "N"); CreateNode(xmlDoc, entry, "bifpaysign", "N"); CreateNode(xmlDoc, entry, "nassistcurdiscountmny", "0.00000000"); CreateNode(xmlDoc, entry, "nassistcursummny", "0.00000000"); CreateNode(xmlDoc, entry, "nassistcurtaxmny", "0.00000000"); CreateNode(xmlDoc, entry, "nassistcurtaxnetprice", "0.00000000"); CreateNode(xmlDoc, entry, "nassistcurnetprice", "0.00000000"); CreateNode(xmlDoc, entry, "nassistcurtaxprice", "0.00000000"); CreateNode(xmlDoc, entry, "nassistcurprice", "0.00000000"); CreateNode(xmlDoc, entry, "cprojectid", ""); CreateNode(xmlDoc, entry, "cprojectphaseid", ""); CreateNode(xmlDoc, entry, "vfree1", modOrder.C_FREE1); //自由项1 CreateNode(xmlDoc, entry, "vfree2", modOrder.C_FREE2); //自由项2 CreateNode(xmlDoc, entry, "vfree3", modOrder.C_PACK); //包装 CreateNode(xmlDoc, entry, "vfree4", ""); CreateNode(xmlDoc, entry, "vfree5", ""); CreateNode(xmlDoc, entry, "vdef1", ""); CreateNode(xmlDoc, entry, "vdef2", ""); CreateNode(xmlDoc, entry, "vdef3", ""); CreateNode(xmlDoc, entry, "vdef4", ""); CreateNode(xmlDoc, entry, "vdef5", ""); CreateNode(xmlDoc, entry, "vdef6", ""); CreateNode(xmlDoc, entry, "vdef11", modOrder.C_CON_NO); //合同号 CreateNode(xmlDoc, entry, "vdef12", modOrder.C_VDEF1); //质量等级主键 CreateNode(xmlDoc, entry, "ntotalreturnnumber", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalcarrynumber", "0.00000000"); CreateNode(xmlDoc, entry, "ntotalplanreceiptnumber", "0.00000000"); #endregion body.AppendChild(entry); } } xmlDoc.Save(xmlFileName); List <string> parem = NCSendXml.SendXML(xmlDoc); //发送NC parem.Add(orderDto[0].SaleCode); //销售单据号 parem.Add(empID); parem.Add("销售订单-NC"); parem.Add(parem[0] == "1" ? "导入NC成功" : "导入NC失败"); //日志录入 AddLog(parem); return(parem); } catch (Exception ex) { throw ex; } }
/// <summary> /// 发送实绩给NC /// </summary> /// <param name="xmlFileName">xml完整路径</param> /// <returns></returns> public bool SendXml_DM(string xmlFileName, string code) { try { Mod_TMD_DISPATCH modDispatch = tmd_dispatch.GetModel(code); 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", "" + code + ".xml"); 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", ""); //发运单表头主键modDispatch.C_GUID 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", modDispatch.C_ATSTATION); //到站 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 = tmd_dispatchdetails.GetList(code).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int rowno = i + 1; Mod_TMP_DAYPLAN modDayPlan = tmp_dayplan.GetModelID(dt.Rows[i]["C_PLAN_ID"].ToString()); if (modDayPlan != null) { #region //实体参数 Mod_TMO_ORDER modOrder = tmo_order.GetModel(modDayPlan.C_PKBILLB); Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(modDayPlan.C_PKCUST); //客户档案 //Mod_TMB_AREA modArea = tmb_area.GetModel(modDayPlan.C_PKARRIVEAREA);//区域 Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetMatModel(modDayPlan.C_PKINV); //物料 Mod_TMD_DISPATCHDETAILS modFYD = tmd_dispatchdetails.GetModel(dt.Rows[i]["C_ID"].ToString()); string pkstock = modFYD.C_SEND_STOCK_PK;//仓库编码 string addrpk = ""; DataTable dtaddress = tmb_area.GetAreaAddress(modFYD.C_SEND_AREA).Tables[0]; if (dtaddress.Rows.Count > 0) { addrpk = dtaddress.Rows[0]["PK_ADDRESS"].ToString(); } #endregion string NCCHECKID = modFYD.C_QUALIRY_LEV; //质量等级 string C_BATCH_NO = string.Empty; //批号 //if (!string.IsNullOrEmpty(dt.Rows[i]["C_BATCH_NO"].ToString())) //{ // C_BATCH_NO = dt.Rows[i]["C_BATCH_NO"].ToString();//批号 //} //else //{ // C_BATCH_NO = dt.Rows[i]["C_STOVE"].ToString();//炉号 //} decimal dunitprice = Convert.ToDecimal(modDayPlan.N_UNITPRICE); //含税单价 decimal N_JZ = Convert.ToDecimal(modFYD.N_JWGT); //净重 string wgt = Convert.ToString(modFYD.N_WGT); //计划重量 string num = Convert.ToString(modFYD.N_FYZS); //件数 decimal dmoney = dunitprice * N_JZ; //订单金额 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", NCCHECKID); //实绩质量等级 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", GetCust(modFYD.C_CGC)); //收货单位名称 CreateNode(xmlDoc, item, "creceiptcorpid", modFYD.C_CGC); //收货单位 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", N_JZ.ToString()); //净重 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", modFYD.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"); //发货地区 CreateNode(xmlDoc, item, "pksendstock", pkstock); //仓库 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", ""); CreateNode(xmlDoc, item, "vbatchcode", C_BATCH_NO);//批号 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", modFYD.C_AREA); //收货地址 CreateNode(xmlDoc, item, "vdestarea", modFYD.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", modFYD.C_ID); //CRM发运单表体主键//C_PK_NCID CreateNode(xmlDoc, item, "vfree2", modDayPlan.C_VFREE2); //自由项2 CreateNode(xmlDoc, item, "vfree3", ""); //包装 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", ""); 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", modFYD.C_MZDATE); //计量毛重日期***** 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", Convert.ToString(modFYD.N_MWGT)); //毛重***** CreateNode(xmlDoc, item, "vuserdef3", Convert.ToString(modFYD.C_PZDATE)); //计量皮重日期**** CreateNode(xmlDoc, item, "vuserdef4", Convert.ToString(modFYD.N_PWGT)); //皮重 CreateNode(xmlDoc, item, "vuserdef5", Convert.ToString(modFYD.N_JWGT)); // 净重 CreateNode(xmlDoc, item, "vuserdef6", Convert.ToString(modFYD.N_MZTIME)); //计量毛重时间 CreateNode(xmlDoc, item, "vuserdef7", Convert.ToString(modFYD.N_PZTIME)); //计量皮重时间 CreateNode(xmlDoc, item, "vuserdef8", ""); CreateNode(xmlDoc, item, "vuserdef9", ""); #endregion body.AppendChild(item); } } } xmlDoc.Save(xmlFileName); List <string> parem = NCSendXml.SendXML(xmlDoc); if (parem[0] == "1") { //更新发运单状态 tmd_dispatchdetails.UpdateFydStatus(code, 9); #region //添加日志 try { Bll_TMB_INTERFACE_LOG tmb_interface_log = new Bll_TMB_INTERFACE_LOG(); Mod_TMB_INTERFACE_LOG mod = new Mod_TMB_INTERFACE_LOG(); mod.D_SENDTIME = DateTime.Now; mod.C_RESULTCODE = parem[0]; //返回结果 mod.C_RESULTDESC = parem[1]; //返回结果描述 mod.C_CONTENT = parem[2]; //返回成功或空 mod.C_PKID = code; //主键 mod.C_FLAG = "WL-NC"; //标识 mod.C_REMARK = "物流实绩导入NC成功"; //备注 tmb_interface_log.Add(mod); } catch (Exception e) { throw e; } #endregion return(true); } else { #region //添加日志 try { Bll_TMB_INTERFACE_LOG tmb_interface_log = new Bll_TMB_INTERFACE_LOG(); Mod_TMB_INTERFACE_LOG mod = new Mod_TMB_INTERFACE_LOG(); mod.D_SENDTIME = DateTime.Now; mod.C_RESULTCODE = parem[0]; //返回结果 mod.C_RESULTDESC = parem[1]; //返回结果描述 mod.C_CONTENT = parem[2]; //返回成功或空 mod.C_PKID = code; //主键 mod.C_FLAG = "WL-NC"; //标识 mod.C_REMARK = "物流实绩导入NC失败"; //备注 tmb_interface_log.Add(mod); } catch (Exception e) { throw e; } #endregion return(false); } } catch (Exception ex) { throw ex; } }
/// <summary> /// NC发运单 /// </summary> /// <param name="code">发运单单据号</param> /// <param name="xmlFileName">路径/文件.xml</param> /// <param name="empID">操作ID</param> /// <param name="flag">8线材,6钢坯</param> /// <returns></returns> public List <string> SendXmlApiDispatchOrder(string code, string xmlFileName, string empID, int flag) { try { List <apiPkDto> listPk = new List <apiPkDto>(); Mod_TMD_DISPATCH modDispatch = tmd_dispatch.GetModel(code); 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", "" + code + ".xml"); root.SetAttribute("isexchange", "Y"); root.SetAttribute("operation", "req"); root.SetAttribute("proc", "add"); 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", modDispatch.C_ATSTATION); //到站 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 = tmd_dispatchdetails.GetList(code).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int rowno = i + 1; Mod_TMD_DISPATCHDETAILS moditem = tmd_dispatchdetails.GetModel(dt.Rows[i]["C_ID"].ToString()); Mod_TMP_DAYPLAN modDayPlan = tmp_dayplan.GetModelID(dt.Rows[i]["C_PLAN_ID"].ToString()); if (modDayPlan != null) { #region //实体参数 Mod_TMO_ORDER modOrder = tmo_order.GetModel(modDayPlan.C_PKBILLB); Mod_TS_CUSTFILE modCust = ts_custfile.GetCustModel(modDayPlan.C_PKCUST); //客户档案 Mod_TB_MATRL_MAIN modMat = tb_matrl_main.GetMatModel(modDayPlan.C_PKINV); //物料 //Mod_TMB_AREA modArea = tmb_area.GetModel(dt.Rows[i]["C_SEND_AREA"].ToString());//区域 string addrpk = ""; if (!string.IsNullOrEmpty(moditem.C_AOG_SITE)) { DataTable dtname = tmb_area.GetAddrNCPK(moditem.C_AOG_SITE).Tables[0]; if (dtname.Rows.Count > 0) { addrpk = dtname.Rows[0]["C_ADDR_NCPK"].ToString(); } } else { DataTable dtaddress = tmb_area.GetAreaAddress(dt.Rows[i]["C_SEND_AREA"].ToString()).Tables[0]; if (dtaddress.Rows.Count > 0) { addrpk = dtaddress.Rows[0]["PK_ADDRESS"].ToString(); } } #endregion decimal dunitprice = Convert.ToDecimal(modDayPlan.N_UNITPRICE); //含税单价 decimal num = Convert.ToDecimal(moditem.N_FYWGT); //数量 decimal dmoney = dunitprice * num; //订单金额 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", moditem.C_QUALIRY_LEV); //质量等级主键 CreateNode(xmlDoc, item, "ccheckstatename", ""); CreateNode(xmlDoc, item, "cfreezeid", ""); CreateNode(xmlDoc, item, "cinvmanid", ""); CreateNode(xmlDoc, item, "confirmarrivedate", ""); CreateNode(xmlDoc, item, "cquoteunitid", modOrder.C_UNITID); //报价计量单位主键 CreateNode(xmlDoc, item, "cquoteunitname", ""); CreateNode(xmlDoc, item, "creceiptcorp", GetCust(moditem.C_CGC)); //收货单位名称 CreateNode(xmlDoc, item, "creceiptcorpid", moditem.C_CGC); //收货单位主键 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", moditem.N_FYZS.ToString()); //辅数量-件数 CreateNode(xmlDoc, item, "dinvnum", moditem.N_FYWGT.ToString()); //存货数量 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", ""); //辅数量 CreateNode(xmlDoc, item, "nfeedbacknum", ""); //回写上游数量 CreateNode(xmlDoc, item, "nnetwgt", ""); // 净重 CreateNode(xmlDoc, item, "nquoteunitnum", ""); //报价计量单位数量?-存货数量 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", moditem.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"); //发货地区-邢台市区 CreateNode(xmlDoc, item, "pksendstock", moditem.C_SEND_STOCK_PK); //仓库主键 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", ""); CreateNode(xmlDoc, item, "vbatchcode", ""); 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", moditem.C_AREA); //到货地址 CreateNode(xmlDoc, item, "vdestarea", moditem.C_SEND_AREA); //到货地区 CreateNode(xmlDoc, item, "vdeststoreaddre", ""); CreateNode(xmlDoc, item, "vdeststorename", ""); CreateNode(xmlDoc, item, "vdeststoreorgname", ""); CreateNode(xmlDoc, item, "vfree0", ""); CreateNode(xmlDoc, item, "vfree1", moditem.C_FREE_TERM); //自由项1 CreateNode(xmlDoc, item, "vfree10", moditem.C_ID); //CRM发运单表体主键 CreateNode(xmlDoc, item, "vfree2", moditem.C_FREE_TERM2); //自由项2 CreateNode(xmlDoc, item, "vfree3", modOrder.N_TYPE == 8 ? moditem.C_PACK : ""); //包装8线材 CreateNode(xmlDoc, item, "vfree4", ""); CreateNode(xmlDoc, item, "vfree5", ""); CreateNode(xmlDoc, item, "vfree6", modDispatch.N_IS_EXPORT == 0 ? "否" : "是"); //是否包到 CreateNode(xmlDoc, item, "vfree7", moditem.N_PRICE.ToString()); //运费 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", modOrder.C_MAT_CODE);//存货编码 CreateNode(xmlDoc, item, "vinvname", ""); CreateNode(xmlDoc, item, "vinvoicecode", ""); CreateNode(xmlDoc, item, "vitemname", ""); CreateNode(xmlDoc, item, "vitemperiodname", ""); CreateNode(xmlDoc, item, "vnote", moditem.C_REMARK);//行备注 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", moditem.C_ELSENEED); //其它要求 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 = NCSendXml.SendXML(xmlDoc); parem.Add(code); parem.Add(empID); parem.Add("发运单-NC"); parem.Add(parem[0] == "1" ? "导入NC成功" : "导入NC失败"); //日志 AddLog(parem); return(parem); } catch (Exception ex) { throw ex; } }