1

yangle

2024-06-26 f509889b5598089ea59ebc33705bc5fdd77b5088

1

 zymes/Config/kdapi.config

@@ -1,11 +1,12 @@
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <appSettings>
    <add key="DbId" value="6204a70eba35fc"></add>
    <add key="UserName" value="Administrator"></add>
    <add key="PassWord" value="qaz!@#123"></add>
    <add key="KDApiUrl" value="http://47.96.97.237/k3cloud/"></add>
    <add key="DataBaseName" value="AIS20210811135644"></add>
    <add key="ClientUrl" value="http://localhost:8082/LuBaoApi/"></add>
    <add key="DbId" value=""></add>
    <add key="UserName" value=""></add>
    <add key="PassWord" value=""></add>
    <add key="KDApiUrl" value=""></add>
    <add key="DataBaseName" value=""></add>
    <add key="ClientUrl" value=""></add>
    <add key="HOrganNumber" value="9010"></add>
    </appSettings>
</configuration>

 zymes/LogService.cs

@@ -5,6 +5,7 @@
using System.Data;
using System.IO;
using System.Threading.Tasks;
using zymes_Project.Utility;

namespace zymes_Project
{
@@ -72,12 +73,19 @@

        public static DataTable Get_DisPlayOrg(Context Context,string FNUMBER)
        {
            string sql = $@"
            string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");
            string sql = "";
            if (FNUMBER.Contains(HOrganNumber))
            {
                sql = $@"
/*dialect*/
select F_RCZU_MesIp ,FISNEEDPUSH from T_ORG_Organizations  
where FNUMBER='{FNUMBER}'";

            }
            DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
            LogService.Write("查询语句:" + sql);

            return dt;
        }
    }

 zymes/OperationService/zymes_RealessBillType.cs

@@ -54,10 +54,9 @@
                sql = $@"
/*dialect*/
select a.FBILLTYPEID as HBilltypeID,a.FNumber as HNumber,l.FName as HName,'' as HTemplate,'' HHeadTable,
'' HEntryTable,'' HViewName,'' HRightName,o.FNUMBER as HOrganNumber
'' HEntryTable,'' HViewName,'' HRightName
from T_BAS_BILLTYPE a with(nolock)
inner join T_BAS_BILLTYPE_L l with(nolock) on a.FBILLTYPEID=l.FBILLTYPEID and FLOCALEID=2052
left join T_ORG_Organizations o with(nolock) on a.FCREATORID=o.FORGID
Where a.FBILLTYPEID='{id}'
";

@@ -68,8 +67,11 @@
                    continue;
                }

                string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");
                LogService.Write("组织:" + HOrganNumber);

                //获取创建单据类型的创建组织
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString());
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, HOrganNumber);
                if (dataTable.Rows.Count == 0)
                    continue;


 zymes/OperationService/zymes_RealessCurrency.cs

@@ -55,10 +55,9 @@
/*dialect*/
select a.FCURRENCYID as HItemID,a.FNumber as HNumber,l.FName as HName,a.FNumber as HShortNumber,0 as HParentID
,1 as HLevel,'true' as HEndFlag,case when  a.FFORBIDSTATUS='A' then 'false' else 'true' end as HStopflag,'CLD-ERP导入' as HRemark
,'' HHelpCode,FAMOUNTDIGITS as HScale,0 as HExchangeRate,o.FNUMBER as HOrganNumber
,'' HHelpCode,FAMOUNTDIGITS as HScale,0 as HExchangeRate 
from T_BD_CURRENCY a with(nolock)
inner join T_BD_CURRENCY_L l with(nolock) on a.FCURRENCYID=l.FCURRENCYID and FLOCALEID=2052
left join T_ORG_Organizations o with(nolock) on a.FUSEORGID=o.FORGID
Where a.FCURRENCYID={id}
";
                DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
@@ -68,8 +67,11 @@
                    continue;
                }

                string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");
                LogService.Write("组织:" + HOrganNumber);

                //获取创建币别的使用组织
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString());
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, HOrganNumber);
                if (dataTable.Rows.Count == 0)
                    continue;


 zymes/OperationService/zymes_RealessPaymentCondition.cs

@@ -69,8 +69,11 @@
                    continue;
                }

                string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");
                LogService.Write("组织:" + HOrganNumber);

                //获取创建付款条件的使用组织
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString());
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, HOrganNumber);
                if (dataTable.Rows.Count == 0)
                    continue;


 zymes/OperationService/zymes_RealessRecCondition.cs

@@ -68,8 +68,11 @@
                    continue;
                }

                string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");
                LogService.Write("组织:" + HOrganNumber);

                //获取创建收款条件的使用组织
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString());
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, HOrganNumber);
                if (dataTable.Rows.Count == 0)
                    continue;


 zymes/OperationService/zymes_RealessStock.cs

@@ -110,6 +110,8 @@
                    continue;
                }

                //string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");

                //获取创建仓库仓位的使用组织
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, maindt.Rows[0]["HOrganNumber"].ToString());
                if (dataTable.Rows.Count == 0)
@@ -143,6 +145,7 @@
                };
                //LogService.Write("仓库仓位同步示例：" + JsonConvert.SerializeObject(jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                LogService.Write("仓库仓位同步示例,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                var client = new RestSharp.RestClient(http);
                var requestPost = new RestRequest("Gy_Warehouse/SaveGy_WarehouseListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);

 zymes/OperationService/zymes_RealessStockStatus.cs

@@ -69,8 +69,11 @@
                    continue;
                }

                string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");
                LogService.Write("组织:" + HOrganNumber);

                //获取库存状态的使用组织
                DataTable dataTable= LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString());
                DataTable dataTable= LogService.Get_DisPlayOrg(Context, HOrganNumber);
                if(dataTable.Rows.Count==0)
                    continue;


 zymes/OperationService/zymes_RealessTaxRate.cs

@@ -68,8 +68,11 @@
                    continue;
                }

                string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");
                LogService.Write("组织:" + HOrganNumber);

                //获取税率的使用组织
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString());
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, HOrganNumber);
                if (dataTable.Rows.Count == 0)
                    continue;


 zymes/OperationService/zymes_RealessUnit.cs

@@ -55,10 +55,9 @@
/*dialect*/
select a.FUNITID as HItemID,a.FUNITID as HERPItemID,a.FNumber as HNumber,l.FName as HName,a.FNumber as HShortNumber,0 as HParentID
,1 as HLevel,'true' as HEndFlag,case when     a.FFORBIDSTATUS='A' then 'false' else 'true' end as HStopflag,'CLD-ERP导入' as HRemark,getdate() as HMakeTime
,'true' as HStandard,a.FCREATEORGID as HCREATEORGID,a.FUSEORGID as HUSEORGID,o.FNUMBER as HOrganNumber
,'true' as HStandard,a.FCREATEORGID as HCREATEORGID,a.FUSEORGID as HUSEORGID
from T_BD_UNIT a with(nolock)
inner join T_BD_UNIT_L l with(nolock) on a.FUNITID=l.FUNITID 
left join T_ORG_Organizations o with(nolock) on a.FUSEORGID=o.FORGID
Where a.FUNITID={id}
";
                DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
@@ -68,8 +67,12 @@
                    continue;
                }

                string HOrganNumber = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "HOrganNumber");

                LogService.Write("组织:" + HOrganNumber);

                //获取单位的使用组织
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, dt.Rows[0]["HOrganNumber"].ToString());
                DataTable dataTable = LogService.Get_DisPlayOrg(Context, HOrganNumber);
                if (dataTable.Rows.Count == 0)
                    continue;


 zymes/zymes_Project.csproj

@@ -8,7 +8,7 @@
    <OutputType>Library</OutputType>
    <AppDesignerFolder>Properties</AppDesignerFolder>
    <RootNamespace>zymes_Project</RootNamespace>
    <AssemblyName>zymes_Project_%28V1.0%29_9010_20240423_yangle</AssemblyName>
    <AssemblyName>zymes_Project_%28V1.0%29_9010_20240626_yangle</AssemblyName>
    <TargetFrameworkVersion>v4.7.2</TargetFrameworkVersion>
    <FileAlignment>512</FileAlignment>
    <Deterministic>true</Deterministic>