| New file |
| | |
| | | { |
| | | "ExpandedNodes": [ |
| | | "", |
| | | "\\zymes", |
| | | "\\zymes\\OperationService" |
| | | ], |
| | | "SelectedNode": "\\zymes\\OperationService\\zymes_RealessPurPoorder.cs", |
| | | "PreviewInSolutionExplorer": false |
| | | } |
| | |
| | | } |
| | | } |
| | | } |
| | | #pragma warning disable CS0168 // 声明了变量“ex”,但从未使用过 |
| | | catch (Exception ex) |
| | | #pragma warning restore CS0168 // 声明了变量“ex”,但从未使用过 |
| | | { |
| | | } |
| | | } |
| New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using Kingdee.BOS.Util; |
| | | using Kingdee.BOS.Core.Metadata.EntityElement; |
| | | using Kingdee.BOS.Core.DynamicForm.PlugIn; |
| | | using Kingdee.BOS.Core.DynamicForm.PlugIn.Args; |
| | | using Kingdee.BOS.Orm.DataEntity; |
| | | using System.ComponentModel; |
| | | using Kingdee.BOS.ServiceHelper; |
| | | using System.Data; |
| | | using Newtonsoft.Json.Linq; |
| | | using ZD.Cloud.WebApi; |
| | | using Newtonsoft.Json; |
| | | using Kingdee.BOS.Core.DynamicForm; |
| | | using System.Linq; |
| | | using RestSharp; |
| | | using zymes_Project.Utility; |
| | | |
| | | namespace zymes_Project.OperationService |
| | | { |
| | | [Description("[客户物料对应表-审核]服务插件]")] |
| | | [HotUpdate] |
| | | public class zymes_RealessCusMaterial : AbstractOperationServicePlugIn |
| | | { |
| | | Dictionary<string, string> dictionary = new Dictionary<string, string>(); |
| | | public override void OnPrepareOperationServiceOption(OnPrepareOperationServiceEventArgs e) |
| | | { |
| | | base.OnPrepareOperationServiceOption(e); |
| | | |
| | | //为了在BeginOperationTransaction里检查数据抛出异常时 |
| | | //只回滚当前单据的事务,这里设置为不支持批量事务,这样BOS会 |
| | | //循环为每一张单据创建事务调用操作 |
| | | e.SupportTransaction = true; |
| | | //e.SurportBatchTransaction = false; |
| | | } |
| | | public override void OnPreparePropertys(PreparePropertysEventArgs e) |
| | | { |
| | | base.OnPreparePropertys(e); |
| | | e.FieldKeys.Add("FEntity"); |
| | | e.FieldKeys.Add("FEntity_FEntryID"); |
| | | } |
| | | public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e) |
| | | { |
| | | base.AfterExecuteOperationTransaction(e); |
| | | Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息 |
| | | foreach (var billObj in e.DataEntitys) |
| | | { |
| | | var id = billObj["Id"].ToString(); |
| | | string sql = string.Empty; |
| | | sql = $@" |
| | | /*dialect*/ |
| | | SELECT |
| | | a.FID as HItemID, |
| | | a.FCREATORID as HCusID, |
| | | c.FCUSTMATNO as HCusRelationNumber, |
| | | d.FCUSTMATNAME as HCusRelationName, |
| | | 'CLD-ERP导入' HRemark, |
| | | GETDATE() AS HMakeTime, |
| | | e.FMASTERID as HMaterID, |
| | | case when c.FEFFECTIVE=1 then 'true' else 'false' end AS HUsed, |
| | | a.FCREATORID AS HCREATEORGID, |
| | | a.FUSEORGID AS HUSEORGID, |
| | | o.FNUMBER as HOrganNumber, |
| | | u.FNAME HMaker |
| | | FROM T_SAL_CUSTMATMAPPING a |
| | | INNER JOIN T_SAL_CUSTMATMAPPINGENTRY c ON a.FID = c.FID -- 客户物料表明细 |
| | | INNER JOIN T_SAL_CUSTMATMAPPINGENTRY_L d ON c.FENTRYID = d.FENTRYID -- 客户物料表明细_多语言 |
| | | INNER JOIN T_BD_MATERIAL e ON c.FMATERIALID = e.FMATERIALID -- 物料 |
| | | INNER JOIN T_SEC_USER u ON a.FCREATORID = u.FUSERID -- 用户表 |
| | | INNER JOIN T_ORG_Organizations o on a.FUSEORGID=o.FORGID |
| | | where a.FID={id} |
| | | "; |
| | | LogService.Write("查询器sql:" + sql); |
| | | |
| | | DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0]; |
| | | if (dt.Rows.Count == 0) |
| | | { |
| | | LogService.Write("客户物料对应表同步异常:" + sql); |
| | | continue; |
| | | } |
| | | //获取创建客户物料对应表的使用组织 |
| | | DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString()); |
| | | if (dataTable.Rows.Count == 0) |
| | | continue; |
| | | |
| | | if (dataTable.Rows[0]["FISNEEDPUSH"].ToString() == "0") |
| | | continue; |
| | | |
| | | string http = dataTable.Rows[0]["F_RCZU_MesIp"].ToString(); |
| | | |
| | | DataRow dr = dt.Rows[0]; |
| | | JObject model = new JObject(); |
| | | foreach (DataColumn column in dt.Columns) |
| | | { |
| | | model.Add(column.ColumnName, dr[column.ColumnName].ToString()); |
| | | } |
| | | JObject _jsonRoot = new JObject() |
| | | { |
| | | ["model"] = model |
| | | }; |
| | | |
| | | LogService.Write("客户物料对应表同步插件,JSON拼接完成:" + model); |
| | | |
| | | |
| | | var client = new RestSharp.RestClient(http); |
| | | var requestPost = new RestRequest("Gy_MateNumRelation/SaveGy_MateNumRelationAPI", Method.POST); |
| | | requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody); |
| | | IRestResponse responsePost = client.Execute(requestPost); |
| | | var contentPost = responsePost.Content; |
| | | if (!contentPost.Contains("成功")) |
| | | { |
| | | LogService.Write("客户物料对应表同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage); |
| | | LogService.Write("客户物料对应表同步异常,POST," + "Gy_MateNumRelation/SaveGy_MateNumRelationAPI"); |
| | | LogService.Write("客户物料对应表同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot)); |
| | | } |
| | | }; |
| | | |
| | | foreach (var item in dictionary) |
| | | { |
| | | ResultMessage.dataError(this.OperationResult.OperateResult, item.Key, item.Value); |
| | | } |
| | | } |
| | | public static class ResultMessage |
| | | {/// <summary> |
| | | /// 修改提示信息 |
| | | /// </summary> |
| | | /// <param name="operateResult"></param> |
| | | /// <param name="billno"></param> |
| | | public static void dataError(OperateResultCollection operateResult, string billno, string message) |
| | | { |
| | | OperateResult operate = operateResult.Where(n => n.Number == billno).First(); |
| | | operate.Message = message; |
| | | operate.SuccessStatus = false; |
| | | operate.MessageType = MessageType.FatalError; |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | ,case when isnull(q.FCHECKINCOMING,0)='1' then 1 else 0 end as HCHECKINCOMING,isnull(s.FEXPUNIT,'') as HEXPUNIT,isnull(s.FEXPPERIOD,0) as HEXPPERIOD |
| | | ,isnull(b.FBASEUNITID,0) as HBASEUNITID,isnull(ms.FSALEUNITID,0) as HSALEUNITID,isnull(ms.FSALEPRICEUNITID,0) HSALEPRICEUNITID |
| | | ,isnull(mp.FPERUNITSTANDHOUR,0) as HPERUNITSTANDHOUR,isnull(mp.FSTDLABORPREPARETIME,0) as HSTDLABORPREPARETIME,isnull(mp.FSTDMACHINEPREPARETIME,0) as HSTDMACHINEPREPARETIME |
| | | ,isnull(a.FMASTERID,0) as HMASTERID |
| | | ,isnull(a.FMASTERID,0) as HMASTERID,0 HMoneyDec |
| | | from T_BD_MATERIAL a with(nolock) |
| | | inner join T_BD_MATERIAL_L l with(nolock) on a.FMATERIALID=l.FMATERIALID |
| | | inner join T_BD_MATERIALBASE b with(nolock) on a.FMATERIALID=b.FMATERIALID |
| | |
| | | { |
| | | ["model"] = model |
| | | }; |
| | | |
| | | LogService.Write("物料同步插件,JSON拼接完成:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff")); |
| | | |
| | | var client = new RestSharp.RestClient(http); |
| | |
| | | if (!contentPost.Contains("成功")) |
| | | { |
| | | LogService.Write("物料同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage); |
| | | //LogService.Write("物料同步异常,ContentType," + responsePost.ContentType); |
| | | //LogService.Write("物料同步异常,ContentEncoding," + responsePost.ContentEncoding); |
| | | //LogService.Write("物料同步异常,Content," + responsePost.Content); |
| | | //LogService.Write("物料同步异常,StatusDescription," + responsePost.StatusDescription); |
| | | //LogService.Write("物料同步异常,Server," + responsePost.Server); |
| | | //LogService.Write("物料同步异常,ErrorMessage," + responsePost.ErrorMessage); |
| | | LogService.Write("物料同步异常,POST," + "Gy_Material/SaveGy_MaterialListApi"); |
| | | LogService.Write("物料同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot)); |
| | | } |
| New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using Kingdee.BOS.Util; |
| | | using Kingdee.BOS.Core.Metadata.EntityElement; |
| | | using Kingdee.BOS.Core.DynamicForm.PlugIn; |
| | | using Kingdee.BOS.Core.DynamicForm.PlugIn.Args; |
| | | using Kingdee.BOS.Orm.DataEntity; |
| | | using System.ComponentModel; |
| | | using Kingdee.BOS.ServiceHelper; |
| | | using System.Data; |
| | | using Newtonsoft.Json.Linq; |
| | | using ZD.Cloud.WebApi; |
| | | using Newtonsoft.Json; |
| | | using Kingdee.BOS.Core.DynamicForm; |
| | | using System.Linq; |
| | | using RestSharp; |
| | | using zymes_Project.Utility; |
| | | |
| | | namespace zymes_Project.OperationService |
| | | { |
| | | [Description("[生产领料单-审核]服务插件]")] |
| | | [HotUpdate] |
| | | public class zymes_RealessPrdReceive : AbstractOperationServicePlugIn |
| | | { |
| | | Dictionary<string, string> dictionary = new Dictionary<string, string>(); |
| | | public override void OnPrepareOperationServiceOption(OnPrepareOperationServiceEventArgs e) |
| | | { |
| | | base.OnPrepareOperationServiceOption(e); |
| | | |
| | | //为了在BeginOperationTransaction里检查数据抛出异常时 |
| | | //只回滚当前单据的事务,这里设置为不支持批量事务,这样BOS会 |
| | | //循环为每一张单据创建事务调用操作 |
| | | e.SupportTransaction = true; |
| | | // e.SurportBatchTransaction = false; |
| | | } |
| | | public override void OnPreparePropertys(PreparePropertysEventArgs e) |
| | | { |
| | | base.OnPreparePropertys(e); |
| | | e.FieldKeys.Add("FEntity"); |
| | | e.FieldKeys.Add("FEntity_FEntryID"); |
| | | } |
| | | |
| | | public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e) |
| | | { |
| | | base.AfterExecuteOperationTransaction(e); |
| | | Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息 |
| | | foreach (var billObj in e.DataEntitys) |
| | | { |
| | | var forgName = Context.CurrentOrganizationInfo.Name; |
| | | //if (!forgName.Contains("杭州斯莫尔磁性材料有限公司")) |
| | | // continue; |
| | | //var sql = $"exec zymes_RealessPurPoorder {billObj["Id"]} "; |
| | | var id = billObj["Id"].ToString(); |
| | | string sql = string.Empty; |
| | | sql = $@" |
| | | /*dialect*/ |
| | | select a.FID HInterID, a.FENTRYID HEntryID, '' as HCloseMan, '' as HEntryCloseDate, 0 as HCloseType |
| | | , 'CLOUD导入' as HRemark, 0 HSourceInterID,0 HSourceEntryID,'' HSourceBillNo,'' HSourceBillType |
| | | , 0 HRelationQty,0 HRelationMoney |
| | | , a.FMATERIALID HMaterID,a.FAUXPROPID HPropertyID,0 HSecUnitID,0 HSecUnitRate,a.FUNITID HUnitID |
| | | , 0 HQtyMust, a.FACTUALQTY HQty,isnull(a.FPrice, 0) HPrice,0 HMoney |
| | | ,a.FSTOCKID HWHID,0 HSCWHID,0 HSPID, 0 HSCSPID, 0 HSPGroupID, a.FLOT HBatchNo, 0 HPOOrderInterID |
| | | ,0 HPOOrderEntryID, '' HPOOrderBillNo, 0 HSeOrderInterID,0 HSeOrderEntryID, '' HSeOrderBillNo |
| | | from T_PRD_PICKMTRLDATA as a with(nolock) |
| | | Where a.FID={id} |
| | | select a.FID as HInterID, 1204 as HBillType, 1204 as HBillSubType, a.FBILLNO as HBillNo, case when a.FAPPROVERID=0 then 1 else 2 end HBillStatus |
| | | , a.FDATE as HDate, YEAR(a.FDATE) as HYear, MONTH(a.FDATE) as HPeriod, 'CLOUD导入' as HRemark |
| | | , a.FCREATORID as HMaker, a.FCREATEDATE as HMakeDate, 0 as HSupID, FSTOCKERID as HWHID, 0 as HSCWHID |
| | | , a.FPICKERID as HEmpID, 0 as HManagerID, a.FPICKERID as HSecManagerID, a.FSTOCKERID as HKeeperID |
| | | , 0 as HDeptID, 'CLOUD导入' as HExplanation, a.FBILLNO as HInnerBillNo, CONVERT(bit, 0) as HRedBlueFlag |
| | | ,o.FNUMBER as HOrganNumber |
| | | from T_PRD_PICKMTRL a with(nolock) |
| | | inner join T_ORG_Organizations o with (nolock) on a.FSTOCKORGID = o.FORGID |
| | | Where a.FID={id} |
| | | "; |
| | | DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql); |
| | | DataTable maindt = ds.Tables[1]; |
| | | DataTable subdt = ds.Tables[0]; |
| | | if (maindt.Rows.Count == 0 || subdt.Rows.Count == 0) |
| | | { |
| | | LogService.Write("生产领料单同步异常:" + sql); |
| | | continue; |
| | | } |
| | | |
| | | //获取创建生产领料单的使用组织 |
| | | DataTable dataTable = LogService.Get_DisPlayOrg(Context, maindt.Rows[0]["HOrganNumber"].ToString()); |
| | | if (dataTable.Rows.Count == 0) |
| | | continue; |
| | | |
| | | if (dataTable.Rows[0]["FISNEEDPUSH"].ToString() == "0") |
| | | continue; |
| | | |
| | | string http = dataTable.Rows[0]["F_RCZU_MesIp"].ToString(); |
| | | |
| | | JArray array = new JArray();//明细表 |
| | | foreach (DataRow dr in subdt.Rows) |
| | | { |
| | | JObject fentrymodel = new JObject(); |
| | | foreach (DataColumn column in subdt.Columns) |
| | | { |
| | | fentrymodel.Add(column.ColumnName, dr[column.ColumnName].ToString()); |
| | | } |
| | | array.Add(fentrymodel); |
| | | } |
| | | JObject model = new JObject();//主表 |
| | | DataRow maindr = maindt.Rows[0]; |
| | | foreach (DataColumn column in maindt.Columns) |
| | | { |
| | | model.Add(column.ColumnName, maindr[column.ColumnName].ToString()); |
| | | } |
| | | model.Add("HENTRY", array); |
| | | JObject jsonRoot = new JObject() |
| | | { |
| | | ["model"] = model |
| | | }; |
| | | |
| | | var client = new RestSharp.RestClient(http); |
| | | //新增 |
| | | var requestPost = new RestRequest("Kf_MateOutBill/Kf_MateOutBillSaveApi", Method.POST); |
| | | requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody); |
| | | IRestResponse responsePost = client.Execute(requestPost); |
| | | var contentPost = responsePost.Content; |
| | | if (!contentPost.Contains("成功")) |
| | | { |
| | | LogService.Write("生产领料单同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage); |
| | | LogService.Write("生产领料单同步异常,POST," + "Kf_MateOutBill/Kf_MateOutBillSaveApi"); |
| | | LogService.Write("生产领料单同步异常,JsonConvert.SerializeObject(jsonRoot)," + JsonConvert.SerializeObject(jsonRoot)); |
| | | } |
| | | }; |
| | | foreach (var item in dictionary) |
| | | { |
| | | ResultMessage.dataError(this.OperationResult.OperateResult, item.Key, item.Value); |
| | | } |
| | | } |
| | | public static class ResultMessage |
| | | {/// <summary> |
| | | /// 修改提示信息 |
| | | /// </summary> |
| | | /// <param name="operateResult"></param> |
| | | /// <param name="billno"></param> |
| | | public static void dataError(OperateResultCollection operateResult, string billno, string message) |
| | | { |
| | | OperateResult operate = operateResult.Where(n => n.Number == billno).First(); |
| | | operate.Message = message; |
| | | operate.SuccessStatus = false; |
| | | operate.MessageType = MessageType.FatalError; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | |
| | | left join T_SAL_ORDERFIN fin with(nolock) on a.FID=fin.FID |
| | | left join T_SAL_ORDERENTRY_LK LK with(nolock) on a.FENTRYID=LK.FENTRYID |
| | | Where a.FID={id} |
| | | select a.FID as HInterID, year(a.FDate) as HYear, month(a.FDate) as HPeriod, '1401' as HBillType, '1401' as HBillSubType, |
| | | a.FDate as HDate, a.FbillNo as HBillNo, case when isnull(a.FAPPROVERID,0)=0 then 1 else 2 end HBillStatus, |
| | | a.FRECEIVEADDRESS as HAddress, 0 as HSSID,a.FDATE as HSSDate, a.FCUSTID as HCusID, 0 as HCurID, 0 as HExRate, |
| | | a.FSALERID as HEmpID, 0 as HManagerID, isnull(a.FSALEDEPTID,0) as HDeptID, 'CLOUD导入' as HExplanation, a.FNOTE as HRemark, |
| | | ''as HInnerBillNo, a.FAPPROVERID as HChecker, a.FAPPROVEDATE as HCheckDate, a.FCREATORID as HMaker, a.FCREATEDATE as HMakeDate, |
| | | a.FCLOSERID as HCloseMan, a.FCLOSEDATE as HCloseDate, a.FID as HERPInterID, a.FBILLTYPEID as HERPBillType, a.FSALEORGID as HSALEORGID, |
| | | a.FSALEGROUPID as HSALEGROUPID, a.FRECEIVEID as HRECEIVEID, a.FSETTLEID as HSETTLEID, a.FCHARGEID as HCHARGEID, a.FHEADLOCID as HHEADLOCID, |
| | | a.FRECCONTACTID as HRECCONTACTID, isnull(a.FCORRESPONDORGID, 0) as HCORRESPONDORGID, a.FBUSINESSTYPE as HBUSINESSTYPE |
| | | ,o.FNUMBER as HOrganNumber |
| | | from T_SAL_ORDER a with(nolock) |
| | | left join T_ORG_Organizations o with(nolock) on a.FSALEORGID=o.FORGID |
| | | select a.FID as HInterID, 1204 as HBillType, 1204 as HBillSubType, a.FBILLNO as HBillNo |
| | | , a.FDATE as HDate, YEAR(a.FDATE) as HYear, MONTH(a.FDATE) as HPeriod, 'CLOUD导入' as HRemark |
| | | , a.FCREATORID as HMaker, a.FCREATEDATE as HMakeDate, 0 as HSupID, FSTOCKERID as HWHID, 0 as HSCWHID |
| | | , a.FPICKERID as HEmpID, 0 as HManagerID, a.FPICKERID as HSecManagerID, a.FSTOCKERID as HKeeperID |
| | | , 0 as HDeptID, 'CLOUD导入' as HExplanation, a.FBILLNO as HInnerBillNo, 0 as HRedBlueFlag |
| | | from T_PRD_PICKMTRL a with(nolock) |
| | | inner join T_ORG_Organizations o with (nolock) on a.FSTOCKORGID = o.FORGID |
| | | Where FID={id} |
| | | "; |
| | | DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql); |
| | |
| | | join T_BD_STOCK st on t1.FSTOCKID = st.FSTOCKID |
| | | join T_BD_STOCK_l stl on t1.FSTOCKID = stl.FSTOCKID and stl.FLOCALEID = 2052 |
| | | join T_BAS_FLEXVALUESDETAIL t2 on t1.FSTOCKLOCID = t2.FID |
| | | --SELECT * FROM T_BAS_FLEXVALUESENTRY t1--仓位值集列表明细 |
| | | --join T_BAS_FLEXVALUESENTRY_L t2 on t1.FENTRYID=t2.FENTRYID--仓位值集列表 |
| | | join T_BAS_FLEXVALUESENTRY t3 on t2.FF100006 = t3.FENTRYID--仓位值集列表明细 |
| | | join T_BAS_FLEXVALUESENTRY t3 on t2.FF100001 = t3.FENTRYID--仓位值集列表明细 |
| | | join T_BAS_FLEXVALUESENTRY_L t4 on t3.FENTRYID=t4.FENTRYID |
| | | where t1.fstockid= {0} --采购入库单选择仓库后 选择仓位 |
| | | where t1.fstockid= {0} |
| | | ", id); |
| | | //select c.HID as HItemID,c.HID as HERPItemID,c.HNumber as HNumber,c.HName as HName,c.HNumber as HShortNumber,0 as HParentID,c.HSPType as HSPType,c.HSrcSPType as HSrcSPType,c.HDesSPType as HDesSPType |
| | | //,1 as HLevel,'true' as HEndFlag,'false' as HStopflag,'CLD-ERP导入' as HRemark,a.FSTOCKID as HSPGroupID,'已使用' as HUseFlag,getdate() as HMakeTime,a.FCREATEORGID as HCREATEORGID,a.FUSEORGID as HUSEORGID |
| | | //from T_BD_STOCK A with(nolock) |
| | | //inner join T_BD_STOCK_L L with(nolock) on A.FSTOCKID = L.FSTOCKID |
| | | //inner join T_BD_FLEXVALUESCOM ST with(nolock) on a.FSTOCKID = st.FSTOCKID |
| | | //inner join(select c.FID HID, c.FF100001 HSPTypeID |
| | | //,''""FStockLocId"":{ |
| | | //""FSTOCKLOCID__FF100001"":{ |
| | | //""FNUMBER"":""'' HSPType |
| | | //,''""FSrcStockLocId"":{ |
| | | //""FSRCSTOCKLOCID__FF100001"":{ |
| | | //""FNUMBER"":""'' HSrcSPType |
| | | //,''""FDestStockLocId"":{ |
| | | //""FDESTSTOCKLOCID__FF100001"":{ |
| | | //""FNUMBER"":""'' HDesSPType |
| | | //,s.FNUMBER HNumber, sp.FName HName |
| | | //from T_BAS_FLEXVALUESDETAIL c |
| | | //inner |
| | | //join T_BAS_FLEXVALUESENTRY s on s.FENTRYID = c.FF100001 |
| | | //inner |
| | | //join T_BAS_FLEXVALUESENTRY_L sp on sp.FENTRYID = c.FF100001) c on c.HID = st.FSTOCKLOCID |
| | | //inner join T_ORG_ORGANIZATIONS_L o with(nolock) on o.FORGID = A.FUSEORGID |
| | | //where ST.FISDISABLE = '0' AND ST.FSYSDISABLE = '0' |
| | | //and l.FLOCALEID = 2052 and isnull(o.FNAME,'') <> '' |
| | | //and a.FSTOCKID = {0} |
| | | |
| | | //斯莫尔仓位集的值是 t2.FF100006 |
| | | //47测试可以用 t2.FF100001 |
| | | |
| | | LogService.Write("查询器sql:" + sql); |
| | | |
| | | DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql); |
| | | DataTable maindt = ds.Tables[0];//仓库 |
| | | DataTable subdt = ds.Tables[1];//仓位 |
| | | if (maindt.Rows.Count == 0) |
| | | if (maindt.Rows.Count == 0 && subdt.Rows.Count == 0) |
| | | { |
| | | LogService.Write("仓库仓位同步异常:" + sql); |
| | | continue; |
| | |
| | | } |
| | | |
| | | |
| | | //获取供应商的使用组织 |
| | | //获取税率的使用组织 |
| | | DataTable dataTable = LogService.Get_DisPlayOrg(Context, subdt.Rows[0]["HUSEORGID"].ToString()); |
| | | if (dataTable.Rows.Count == 0) |
| | | continue; |
| | |
| | | string FSupplier = "0";//供应商 默认值为0 |
| | | string FOrgId = "100092"; //组织(默认取值当前组织) |
| | | string FFactoryArea = ""; //厂区 |
| | | #pragma warning disable CS0219 // 变量“FBuyer”已被赋值,但从未使用过它的值 |
| | | string FBuyer = ""; //采购员 |
| | | #pragma warning restore CS0219 // 变量“FBuyer”已被赋值,但从未使用过它的值 |
| | | #pragma warning disable CS0219 // 变量“FWarehouse”已被赋值,但从未使用过它的值 |
| | | string FWarehouse = "";//仓库 |
| | | #pragma warning restore CS0219 // 变量“FWarehouse”已被赋值,但从未使用过它的值 |
| | | #pragma warning disable CS0219 // 变量“FIsMainMaterial”已被赋值,但从未使用过它的值 |
| | | bool FIsMainMaterial = false;//是否主料 |
| | | #pragma warning restore CS0219 // 变量“FIsMainMaterial”已被赋值,但从未使用过它的值 |
| | | |
| | | //5fe5d920a3f2bf |
| | | //5fe5d926a3f2c1 |
| | |
| | | string FSupplier = "0";//供应商 默认值为0 |
| | | string FOrgId = "100092"; //组织(默认取值当前组织) |
| | | string FFactoryArea = ""; //厂区 |
| | | #pragma warning disable CS0219 // 变量“FBuyer”已被赋值,但从未使用过它的值 |
| | | string FBuyer = ""; //采购员 |
| | | #pragma warning restore CS0219 // 变量“FBuyer”已被赋值,但从未使用过它的值 |
| | | #pragma warning disable CS0219 // 变量“FWarehouse”已被赋值,但从未使用过它的值 |
| | | string FWarehouse = "";//仓库 |
| | | #pragma warning restore CS0219 // 变量“FWarehouse”已被赋值,但从未使用过它的值 |
| | | #pragma warning disable CS0219 // 变量“FIsMainMaterial”已被赋值,但从未使用过它的值 |
| | | bool FIsMainMaterial = false;//是否主料 |
| | | #pragma warning restore CS0219 // 变量“FIsMainMaterial”已被赋值,但从未使用过它的值 |
| | | string saleOrderNo = "";//采购订单号 |
| | | //5fe5d920a3f2bf |
| | | //5fe5d926a3f2c1 |
| | |
| | | |
| | | return header; |
| | | |
| | | #pragma warning disable CS0162 // 检测到无法访问的代码 |
| | | return header; |
| | | #pragma warning restore CS0162 // 检测到无法访问的代码 |
| | | } |
| | | |
| | | public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName) |
| New file |
| | |
| | | // <autogenerated /> |
| | | using System; |
| | | using System.Reflection; |
| | | [assembly: global::System.Runtime.Versioning.TargetFrameworkAttribute(".NETFramework,Version=v4.7.2", FrameworkDisplayName = ".NET Framework 4.7.2")] |
| New file |
| | |
| | | // <autogenerated /> |
| | | using System; |
| | | using System.Reflection; |
| | | [assembly: global::System.Runtime.Versioning.TargetFrameworkAttribute(".NETFramework,Version=v4.5.2", FrameworkDisplayName = ".NET Framework 4.5.2")] |
| | |
| | | <OutputType>Library</OutputType> |
| | | <AppDesignerFolder>Properties</AppDesignerFolder> |
| | | <RootNamespace>zymes_Project</RootNamespace> |
| | | <AssemblyName>zymes_Project_%28V1.0%29_9010_20250812_zrg</AssemblyName> |
| | | <AssemblyName>zymes_Project</AssemblyName> |
| | | <TargetFrameworkVersion>v4.7.2</TargetFrameworkVersion> |
| | | <FileAlignment>512</FileAlignment> |
| | | <Deterministic>true</Deterministic> |
| | |
| | | <Compile Include="OperationService\zymes_MOCHANGE.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessCurrency.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessOperator.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessPrdReceive.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessRateType.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessDepartment.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessBom.cs" /> |
| | |
| | | <Compile Include="OperationService\zymes_RealessSalSeOutStock.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessSettleStyle.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessRecCondition.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessCusMaterial.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessStock.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessCustomer.cs" /> |
| | | <Compile Include="OperationService\zymes_RealessPaymentCondition.cs" /> |