| HH.WCS.Mobox3.pinggao.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| api/ApibackModel.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| api/WmsSapController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| api/WmsSpaHelper.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| api/ZSCM2_CBZX.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| models/SapRoot.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| models/TN_Outbound_Order.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| models/TN_Supplier.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| models/TN_Supplier_detial.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| wms/WMSHelper.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
HH.WCS.Mobox3.pinggao.csproj
@@ -171,6 +171,7 @@ <Compile Include="api\WmsSapController.cs" /> <Compile Include="api\WmsSpaHelper.cs" /> <Compile Include="api\ZCCM_NC.cs" /> <Compile Include="api\ZSCM2_CBZX.cs" /> <Compile Include="api\ZSCM2_SCFLJHW.cs" /> <Compile Include="App_Start\SwaggerControllerDescProvider.cs" /> <Compile Include="core\WMSCore.cs" /> @@ -194,6 +195,7 @@ <Compile Include="models\TN_Location_Ext.cs" /> <Compile Include="models\TN_Ll_detail.cs" /> <Compile Include="models\TN_Ll_Order.cs" /> <Compile Include="models\TN_Supplier_detial.cs" /> <Compile Include="models\WorkOrder.cs" /> <Compile Include="models\TN_PRICE.cs" /> <Compile Include="models\TN_WeiLi_SerialNo.cs" /> api/ApibackModel.cs
@@ -298,7 +298,7 @@ /// <summary> /// 序列号 /// </summary> public string XLH { get; set; } public List<string> XLH { get; set; } } public class ITEM @@ -342,7 +342,7 @@ /// <summary> /// /// </summary> public List<ITEM1> ITEM1 { get; set; } public ITEM1 ITEM1 { get; set; } } public class WLPZ @@ -571,7 +571,7 @@ public class CBcenterBackDto { public class ITEM { public string XLH { get; set; } public List<string> XLH { get; set; } } public class HEADItem @@ -620,7 +620,7 @@ /// <summary> /// /// </summary> public List<ITEM> ITEM { get; set; } public ITEM ITEM { get; set; } } public class ROOT api/WmsSapController.cs
@@ -22,48 +22,7 @@ { public class WmsSapController : System.Web.Http.ApiController { /// <summary> /// 生产订单信息获取 /// </summary> /// <param name="xmlData"></param> /// <returns></returns> //[HttpPost] //public Orderback.Root GYSReceiveXmlData([FromBody] GYSDto.Root xmlData) //{ // #region xml数据接收转数组 // LogHelper.Info("供应商接收接口：" + JsonConvert.SerializeObject(xmlData)); // ////接收xml数据 // //XmlDocument xmlDoc = new XmlDocument(); // //xmlDoc.LoadXml(xmlData.ToString()); // //// 将 XmlDocument 转换为 JSON 字符串 // //JObject jsonObject = JsonConvert.DeserializeObject<JObject>(JsonConvert.SerializeXmlNode(xmlDoc)); // //// 处理特定字段，强制转换为数组 // //WmsSpaHelper.EnsureArrayFormats(jsonObject, "ITEM"); // //// 反序列化为RootWithArray // //var data = JsonConvert.DeserializeObject<OrderDto.Root>(jsonObject.ToString()); // #endregion // #region 外采入库业务流程 // //Orderback.Root simpleResult = WmsSpaHelper.Mater_In(xmlData); // //接收返回参数 生成sap对接文档返回格式 // //var json = WmsSpaHelper.GetJsonResult(simpleResult.WLPZBH, simpleResult.resultCode.ToString(), simpleResult.resultMsg); // #endregion // #region 返回xml // //string xml = JsonConvert.DeserializeXmlNode(json, "root").OuterXml; // ////返回json // //var response = new HttpResponseMessage() // //{ // // Content = new StringContent(xml, Encoding.UTF8, "application/xml") // //}; // //return response; // return null; // #endregion //} /// <summary> api/WmsSpaHelper.cs
@@ -33,6 +33,7 @@ using WHTest; using System.Net; using SqlSugar; using static HH.WCS.Mobox3.pinggao.models.SapRoot.GYSDto; namespace HH.WCS.Mobox3.pinggao.api { @@ -653,6 +654,7 @@ } return simpleResults; } /// <summary> /// sap-wms生产订单信息添加SimpleResult /// </summary> @@ -706,7 +708,7 @@ iTEM.SCDDH = item.SCDDH; iTEM.GC = item.GC; iTEM.MSGCODE = "1"; iTEM.MSGDESP = $"{item.SCDDH}不存在"; iTEM.MSGDESP = $"{item.SCDDH}已存在"; tEMs.Add(iTEM); } iTEM.SCDDH = item.SCDDH; @@ -1743,7 +1745,7 @@ return result; } po.S_OUT_TYPE = "成本中心出库"; //根据不同出库类型 回调sap if (po.S_OUT_TYPE == "冲销出库") { @@ -1938,18 +1940,20 @@ ckbitem.PC = podetail?.S_BATCH_NO; List<CBcenterBackDto.ITEM> listitem1 = new List<CBcenterBackDto.ITEM>(); CBcenterBackDto.ITEM listitem1 = new CBcenterBackDto.ITEM(); // List<CBcenterBackDto.ITEM> listitem1 = new List<CBcenterBackDto.ITEM>(); //string[] xlhValues = item.S_SERIAL_NO.Split(','); //var serialNos = string.Join(",", CntrItemRels // .Where(s => s.S_ITEM_CODE == item.item_code) // .Select(s => s.S_SERIAL_NO)); //string[] xlhValues = serialNos.Split(','); string[] xlhValues = item.S_SERIAL_NO.Split(','); foreach (var xlhValue in xlhValues) { CBcenterBackDto.ITEM newItem = new CBcenterBackDto.ITEM { XLH = xlhValue }; listitem1.Add(newItem); } listitem1.XLH= podetail?.S_SERIAL_NO.Split(',').ToList(); //foreach (var xlhValue in xlhValues) //{ // CBcenterBackDto.ITEM newItem = new CBcenterBackDto.ITEM { XLH = xlhValue }; // listitem1.Add(newItem); //} ckbitem.ITEM = listitem1; iTEMs.Add(ckbitem); @@ -1964,21 +1968,37 @@ string xml = JsonConvert.DeserializeXmlNode(json, "ROOT").OuterXml; LogHelper.Info($"成本中心出库xml数据{xml}"); // 创建 StringContent 并指定媒体类型为 "text/xml" HttpContent content = new StringContent(xml, Encoding.UTF8, "application/xml"); string url = Settings.WCSSeverUrl + "/api/WmsSap/cesReceiveXmlData"; string responseXml = ""; using (HttpClient client = new HttpClient()) { // 发送 POST 请求并接收响应 HttpResponseMessage responsess = await client.PostAsync(url, content); responseXml = await responsess.Content.ReadAsStringAsync(); //// 创建 StringContent 并指定媒体类型为 "text/xml" //HttpContent content = new StringContent(xml, Encoding.UTF8, "application/xml"); //string url = Settings.WCSSeverUrl + "/api/WmsSap/cesReceiveXmlData"; //string responseXml = ""; //using (HttpClient client = new HttpClient()) //{ // // 发送 POST 请求并接收响应 // HttpResponseMessage responsess = await client.PostAsync(url, content); // responseXml = await responsess.Content.ReadAsStringAsync(); } //} #region sap回调 // 创建Web Service代理类实例 ZSCM2_CBZX service = new ZSCM2_CBZX(); // service.Credentials = new NetworkCredential("CONN_RFC", "Init.1234"); // 准备请求参数 ZfmScm2CbzxMm001 request = new ZfmScm2CbzxMm001(); request.Input = "<?xml version=\"1.0\" encoding=\"utf-8\" ?>" + xml; LogHelper.Info($"成本中心出库SAP回调"); // 调用Web Service ZfmScm2CbzxMm001Response responses = service.ZfmScm2CbzxMm001(request); // 处理响应 LogHelper.Info("SAP返回结果: " + responses.Output); // 解析Output中的凭证号等信息 #endregion XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(responseXml.ToString()); xmlDoc.LoadXml(responses.Output.ToString()); JObject jsonObject = JsonConvert.DeserializeObject<JObject>(JsonConvert.SerializeXmlNode(xmlDoc)); var data = JsonConvert.DeserializeObject<ReturnWcBcak.Root>(jsonObject.ToString()); //添加凭证记录表 @@ -2050,13 +2070,6 @@ { HEAD = new JHWBackDto.HEAD { //KEY = "KeyExample", //GZRQ = "2023-04-01", //PZZDRQ = "2023-04-02", //YHM = "Username", //PZTTWB = "HeaderText", //YDLX = "MovementType", //TSKCBS = "SpecialStock" KEY = po.S_NO, GZRQ = GZRQ, @@ -2082,9 +2095,7 @@ JHWBackDto.ITEM ckbitem = new JHWBackDto.ITEM(); ckbitem.WLBH = item.item_code; ckbitem.GC = po.S_FACTORY; //ckbitem.PH = podetail?.S_PH; //ckbitem.TSKCBS = podetail?.S_TSKCBS; ckbitem.XSDD = podetail?.S_XSDD; ckbitem.XSDDHXM = podetail?.S_XSDDXMBH; @@ -2095,7 +2106,6 @@ ckbitem.WBS = podetail?.S_WBS; ckbitem.KCDD = podetail?.S_KCDD; ckbitem.PC = podetail?.S_BATCH_NO; JHWBackDto.ITEM1 listitem1 = new JHWBackDto.ITEM1(); //string[] xlhValues = item.S_SERIAL_NO.Split(','); //var serialNos = string.Join(",", CntrItemRels @@ -2136,20 +2146,36 @@ LogHelper.Info($"出计划外发料出库xml数据{xml}"); // 创建 StringContent 并指定媒体类型为 "text/xml" HttpContent content = new StringContent(xml, Encoding.UTF8, "application/xml"); string url = Settings.WCSSeverUrl + "/api/WmsSap/cesReceiveXmlData"; string responseXml = ""; using (HttpClient client = new HttpClient()) { // 发送 POST 请求并接收响应 HttpResponseMessage responsess = await client.PostAsync(url, content); responseXml = await responsess.Content.ReadAsStringAsync(); //HttpContent content = new StringContent(xml, Encoding.UTF8, "application/xml"); //string url = Settings.WCSSeverUrl + "/api/WmsSap/cesReceiveXmlData"; //string responseXml = ""; //using (HttpClient client = new HttpClient()) //{ // // 发送 POST 请求并接收响应 // HttpResponseMessage responsess = await client.PostAsync(url, content); // responseXml = await responsess.Content.ReadAsStringAsync(); } //} #region sap回调 // 创建Web Service代理类实例 ZSCM2_SCFLJHW service = new ZSCM2_SCFLJHW(); // service.Credentials = new NetworkCredential("CONN_RFC", "Init.1234"); // 准备请求参数 ZscmScflJhw request = new ZscmScflJhw(); request.Input = "<?xml version=\"1.0\" encoding=\"utf-8\" ?>" + xml; LogHelper.Info($"计划外SAP回调"); // 调用Web Service ZscmScflJhwResponse responses = service.ZscmScflJhw(request); // 处理响应 LogHelper.Info("SAP返回结果: " + responses.Output); // 解析Output中的凭证号等信息 #endregion XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(responseXml.ToString()); xmlDoc.LoadXml(responses.Output.ToString()); JObject jsonObject = JsonConvert.DeserializeObject<JObject>(JsonConvert.SerializeXmlNode(xmlDoc)); var data = JsonConvert.DeserializeObject<ReturnWcBcak.Root>(jsonObject.ToString()); //添加凭证记录表 @@ -2391,18 +2417,18 @@ ckbitem.GC = po.S_FACTORY; ckbitem.KCDD = podetail?.S_KCDD; List<CkBcakDto.ITEM1> listitem1 = new List<CkBcakDto.ITEM1>(); CkBcakDto.ITEM1 listitem1 = new CkBcakDto.ITEM1(); //var CntrItemRels = db.Queryable<CntrItemRel>().Where(a => a.S_ITEM_CODE == item.item_code&&a.N_ROW_NO==item.N_ROW_NO).ToList(); ////string[] xlhValues = item.S_SERIAL_NO.Split(','); //var serialNos = string.Join(",", CntrItemRels // .Where(s => s.S_ITEM_CODE == item.item_code) // .Select(s => s.S_SERIAL_NO)); string[] xlhValues = item.S_SERIAL_NO.Split(','); foreach (var xlhValue in xlhValues) { CkBcakDto.ITEM1 newItem = new CkBcakDto.ITEM1 { XLH = xlhValue }; listitem1.Add(newItem); } listitem1.XLH = podetail?.S_SERIAL_NO.Split(',').ToList(); //foreach (var xlhValue in xlhValues) //{ // CkBcakDto.ITEM1 newItem = new CkBcakDto.ITEM1 { XLH = xlhValue }; // listitem1.Add(newItem); //} ckbitem.ITEM1 = listitem1; iTEMs.Add(ckbitem); @@ -3531,15 +3557,13 @@ JHWBackDto.ITEM ckbitem = new JHWBackDto.ITEM(); ckbitem.WLBH = item.S_ITEM_CODE; ckbitem.GC = po.S_FACTORY; //ckbitem.PH = podetail?.S_PH; // ckbitem.TSKCBS = podetail?.S_TSKCBS; ckbitem.XSDD = podetail?.S_XSDD; ckbitem.XSDDHXM = podetail?.S_XSDDXMBH; ckbitem.SL = item.F_QTY; ckbitem.DW = podetail?.S_UOM; ckbitem.DDH = podetail?.S_DDH; //ckbitem.PH = podetail?.S_PH; // ckbitem.TSKCBS = podetail?.S_TSKCBS; //ckbitem.DDHXM = (podetail?.N_ROW_NO); ckbitem.WBS = podetail?.S_WBS; ckbitem.KCDD = podetail?.S_KCDD; api/ZSCM2_CBZX.cs
New file @@ -0,0 +1,158 @@ //------------------------------------------------------------------------------ // <auto-generated> // 此代码由工具生成。 // 运行时版本:4.0.30319.42000 // // 对此文件的更改可能会导致不正确的行为，并且如果 // 重新生成代码，这些更改将会丢失。 // </auto-generated> //------------------------------------------------------------------------------ using System; using System.ComponentModel; using System.Diagnostics; using System.Web.Services; using System.Web.Services.Protocols; using System.Xml.Serialization; // // 此源代码由 wsdl 自动生成, Version=4.8.3928.0。 // /// <remarks/> // CODEGEN: 未处理命名空间“http://schemas.xmlsoap.org/ws/2004/09/policy”中的可选 WSDL 扩展元素“Policy”。 [System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "4.8.3928.0")] [System.Diagnostics.DebuggerStepThroughAttribute()] [System.ComponentModel.DesignerCategoryAttribute("code")] [System.Web.Services.WebServiceBindingAttribute(Name="binding", Namespace="urn:sap-com:document:sap:soap:functions:mc-style")] public partial class ZSCM2_CBZX : System.Web.Services.Protocols.SoapHttpClientProtocol { private System.Threading.SendOrPostCallback ZfmScm2CbzxMm001OperationCompleted; /// <remarks/> public ZSCM2_CBZX() { this.Url = "http://ceerptest.cee.com.cn:8000/sap/bc/srt/rfc/sap/zscm2_cbzx/110/zscm2_cbzx/bin" + "ding"; } /// <remarks/> public event ZfmScm2CbzxMm001CompletedEventHandler ZfmScm2CbzxMm001Completed; /// <remarks/> [System.Web.Services.Protocols.SoapDocumentMethodAttribute("", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Bare)] [return: System.Xml.Serialization.XmlElementAttribute("ZfmScm2CbzxMm001Response", Namespace="urn:sap-com:document:sap:soap:functions:mc-style")] public ZfmScm2CbzxMm001Response ZfmScm2CbzxMm001([System.Xml.Serialization.XmlElementAttribute("ZfmScm2CbzxMm001", Namespace="urn:sap-com:document:sap:soap:functions:mc-style")] ZfmScm2CbzxMm001 ZfmScm2CbzxMm0011) { object[] results = this.Invoke("ZfmScm2CbzxMm001", new object[] { ZfmScm2CbzxMm0011}); return ((ZfmScm2CbzxMm001Response)(results[0])); } /// <remarks/> public System.IAsyncResult BeginZfmScm2CbzxMm001(ZfmScm2CbzxMm001 ZfmScm2CbzxMm0011, System.AsyncCallback callback, object asyncState) { return this.BeginInvoke("ZfmScm2CbzxMm001", new object[] { ZfmScm2CbzxMm0011}, callback, asyncState); } /// <remarks/> public ZfmScm2CbzxMm001Response EndZfmScm2CbzxMm001(System.IAsyncResult asyncResult) { object[] results = this.EndInvoke(asyncResult); return ((ZfmScm2CbzxMm001Response)(results[0])); } /// <remarks/> public void ZfmScm2CbzxMm001Async(ZfmScm2CbzxMm001 ZfmScm2CbzxMm0011) { this.ZfmScm2CbzxMm001Async(ZfmScm2CbzxMm0011, null); } /// <remarks/> public void ZfmScm2CbzxMm001Async(ZfmScm2CbzxMm001 ZfmScm2CbzxMm0011, object userState) { if ((this.ZfmScm2CbzxMm001OperationCompleted == null)) { this.ZfmScm2CbzxMm001OperationCompleted = new System.Threading.SendOrPostCallback(this.OnZfmScm2CbzxMm001OperationCompleted); } this.InvokeAsync("ZfmScm2CbzxMm001", new object[] { ZfmScm2CbzxMm0011}, this.ZfmScm2CbzxMm001OperationCompleted, userState); } private void OnZfmScm2CbzxMm001OperationCompleted(object arg) { if ((this.ZfmScm2CbzxMm001Completed != null)) { System.Web.Services.Protocols.InvokeCompletedEventArgs invokeArgs = ((System.Web.Services.Protocols.InvokeCompletedEventArgs)(arg)); this.ZfmScm2CbzxMm001Completed(this, new ZfmScm2CbzxMm001CompletedEventArgs(invokeArgs.Results, invokeArgs.Error, invokeArgs.Cancelled, invokeArgs.UserState)); } } /// <remarks/> public new void CancelAsync(object userState) { base.CancelAsync(userState); } } /// <remarks/> [System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "4.8.3928.0")] [System.SerializableAttribute()] [System.Diagnostics.DebuggerStepThroughAttribute()] [System.ComponentModel.DesignerCategoryAttribute("code")] [System.Xml.Serialization.XmlTypeAttribute(AnonymousType=true, Namespace="urn:sap-com:document:sap:soap:functions:mc-style")] public partial class ZfmScm2CbzxMm001 { private string inputField; /// <remarks/> [System.Xml.Serialization.XmlElementAttribute(Form=System.Xml.Schema.XmlSchemaForm.Unqualified)] public string Input { get { return this.inputField; } set { this.inputField = value; } } } /// <remarks/> [System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "4.8.3928.0")] [System.SerializableAttribute()] [System.Diagnostics.DebuggerStepThroughAttribute()] [System.ComponentModel.DesignerCategoryAttribute("code")] [System.Xml.Serialization.XmlTypeAttribute(AnonymousType=true, Namespace="urn:sap-com:document:sap:soap:functions:mc-style")] public partial class ZfmScm2CbzxMm001Response { private string outputField; /// <remarks/> [System.Xml.Serialization.XmlElementAttribute(Form=System.Xml.Schema.XmlSchemaForm.Unqualified)] public string Output { get { return this.outputField; } set { this.outputField = value; } } } /// <remarks/> [System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "4.8.3928.0")] public delegate void ZfmScm2CbzxMm001CompletedEventHandler(object sender, ZfmScm2CbzxMm001CompletedEventArgs e); /// <remarks/> [System.CodeDom.Compiler.GeneratedCodeAttribute("wsdl", "4.8.3928.0")] [System.Diagnostics.DebuggerStepThroughAttribute()] [System.ComponentModel.DesignerCategoryAttribute("code")] public partial class ZfmScm2CbzxMm001CompletedEventArgs : System.ComponentModel.AsyncCompletedEventArgs { private object[] results; internal ZfmScm2CbzxMm001CompletedEventArgs(object[] results, System.Exception exception, bool cancelled, object userState) : base(exception, cancelled, userState) { this.results = results; } /// <remarks/> public ZfmScm2CbzxMm001Response Result { get { this.RaiseExceptionIfNecessary(); return ((ZfmScm2CbzxMm001Response)(this.results[0])); } } } models/SapRoot.cs
@@ -704,7 +704,7 @@ public string ZZSDJH { get; set; } } public class GYSHBItem public class GYSHB { /// <summary> /// @@ -729,7 +729,7 @@ /// <summary> /// /// </summary> public List<GYSHBItem> GYSHB { get; set; } public List<GYSHB> GYSHB { get; set; } } public class ROOT models/TN_Outbound_Order.cs
@@ -12,8 +12,8 @@ /// 出库单号 /// </summary> public string S_NO { get; set; } public DateTime? BUDAT { get; set; } public DateTime? BLDAT { get; set; } public string BUDAT { get; set; } public string BLDAT { get; set; } public string UNAME { get; set; } public string BKTXT { get; set; } public string SOBKZ { get; set; } models/TN_Supplier.cs
@@ -1,28 +1,74 @@ using HH.WCS.Mobox3.pinggao.models; using SqlSugar; using System; using System.Collections.Generic; namespace HH.WCS.Mobox3.pinggao { [SugarTable("TN_Supplier")] public class TN_Supplier : BaseModel { // 供应商或债权人的帐号 public string S_GYSBM { get; set; } public string S_NO { get; set; } public string S_NAME { get; set; } public string S_TYPE { get; set; } public string C_UNINSPECTED { get; set; } public string S_NOTE { get; set; } public string S_CONTACT_PERSON { get; set; } public string S_TEL { get; set; } public string S_PHONE { get; set; } public string S_EMAIL { get; set; } public string S_PROVINCE { get; set; } public string S_CITY { get; set; } public string S_ZONE { get; set; } public string S_ADDRESS { get; set; } // MDM供应商 public string S_MDMBM { get; set; } // 主数据接口名称 public string S_GYSMC { get; set; } // 银行国家代码 public string S_YHGJ { get; set; } // 银行代码 public string S_YHDM { get; set; } // 开户银行的简要键 public string S_KHH { get; set; } // 住宅号及街道 public string S_YHJD { get; set; } // 城市 public string S_YHCS { get; set; } // 帐户号码 public string S_KHHZH { get; set; } // 街道 public string S_DZ { get; set; } // 邮政编码 public string S_YZBM { get; set; } // 城市 public string S_CS { get; set; } // 国家代码 public string S_GJDM { get; set; } // 国家名称 public string S_GJ { get; set; } // 地区 public string S_DQDM { get; set; } // 描述 public string S_DQMC { get; set; } // 税号 public string S_SH { get; set; } // 组织机构代码 public string S_ZZSDJH { get; set; } // 根据您的要求添加的属性 public string S_STATE_PRE { get; set; } public int N_REVIEW_RESULT { get; set; } [SugarColumn(IsIgnore = true)] [Navigate(NavigateType.OneToMany, nameof(TN_Supplier_detial.S_DO_GYSBM), nameof(S_GYSBM))] public List<TN_Supplier_detial> Details { get; set; } } } models/TN_Supplier_detial.cs
New file @@ -0,0 +1,18 @@ using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace HH.WCS.Mobox3.pinggao.models { [SugarTable("TN_Supplier_Detail")] public class TN_Supplier_detial:BaseModel { public string S_CGZZ { get; set; } public string S_DO_GYSBM { get; set; } public string S_HB { get; set; } } } wms/WMSHelper.cs
@@ -135,7 +135,11 @@ var db = new SqlHelper<object>().GetInstance(); return db.Queryable<TN_Inbound_Order>().Includes(a => a.Details).Where(a => a.S_NO == no).First(); } internal static TN_Supplier GetGYSBMOrder(string no) { var db = new SqlHelper<object>().GetInstance(); return db.Queryable<TN_Supplier>().Includes(a => a.Details).Where(a => a.S_GYSBM == no).First(); } internal static TN_ASN_Order GetASNOrder(string no) { var db = new SqlHelper<object>().GetInstance();
