| | |
| | | Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息 |
| | | foreach (var billObj in e.DataEntitys) |
| | | { |
| | | LogService.Write("物料同步插件执行开始:"+ DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff")); |
| | | //var sql = $"exec zymes_RealessMaterial {billObj["Id"]} "; |
| | | var id = billObj["Id"].ToString(); |
| | | string sql = string.Empty; |
| | |
| | | { |
| | | ["model"] = model |
| | | }; |
| | | |
| | | LogService.Write("物料同步插件,JSON拼接完成:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff")); |
| | | //string jsonRoot = JsonConvert.SerializeObject(jsonRoot); |
| | | //var client = new RestSharp.RestClient("http://47.96.97.237/api/"); |
| | | //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址 |
| | |
| | | //var json = newjson.ToString() + ";Admin;100038"; |
| | | requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody); |
| | | IRestResponse responsePost = client.Execute(requestPost); |
| | | LogService.Write("物料同步插件,post完成:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff")); |
| | | var contentPost = responsePost.Content; |
| | | if (!contentPost.Contains("成功")) { |
| | | LogService.Write("物料同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost); |
| | |
| | | using System.Linq; |
| | | using RestSharp; |
| | | using zymes_Project.Utility; |
| | | using Kingdee.BOS; |
| | | |
| | | namespace zymes_Project.OperationService |
| | | { |
| | |
| | | Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息 |
| | | foreach (var billObj in e.DataEntitys) |
| | | { |
| | | |
| | | |
| | | var sql = $"exec zymes_RealessTaxMIX {billObj["Id"]} "; |
| | | DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql); |
| | | DataTable maindt = ds.Tables[1]; |
| | |
| | | Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息 |
| | | foreach (var billObj in e.DataEntitys) |
| | | { |
| | | LogService.Write(Context.CurrentOrganizationInfo.ID); |
| | | LogService.Write(Context.CurrentOrganizationInfo.Name); |
| | | //var sql = $"exec zymes_RealessUnit {billObj["Id"]} "; |
| | | var id = billObj["Id"].ToString(); |
| | | string sql =string.Empty; |
| | | sql = $@" |
| | | /*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,'未检测' as HMakeTime,getdate() as HMakeTime,'true' as HStandard,a.FCREATEORGID as HCREATEORGID,a.FUSEORGID as HUSEORGID |
| | | ,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 |
| | | from T_BD_UNIT a with(nolock) |
| | | inner join T_BD_UNIT_L l with(nolock) on a.FUNITID=l.FUNITID |
| | | Where a.FUNITID={id} |
| | |
| | | //LogService.Write("单位同步示例:" + JsonConvert.SerializeObject(_jsonRoot)); |
| | | //LogService.Write("单位同步示例:" + _jsonRoot); |
| | | //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址 |
| | | //var client = new RestSharp.RestClient("http://47.96.97.237/API/"); |
| | | var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/"); |
| | | var requestPost = new RestRequest("Gy_Unit/SaveGy_UnitListApi", Method.POST); |
| | | requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody); |
| | |
| | | { |
| | | static void Main(string[] args) |
| | | { |
| | | CustomDemo1(); |
| | | //CustomDemo1(); |
| | | Console.WriteLine(DateTime.Now); |
| | | Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff")); |
| | | Console.WriteLine(Convert.ToDecimal(1 / 10)); |
| | | Console.WriteLine(1 % 10); |
| | | Console.WriteLine(1 % 10.0); |
| | |
| | | Console.WriteLine((double)61 / 111); |
| | | Console.WriteLine(Math.Round(((decimal)61 / 111), 2)); |
| | | Console.WriteLine(Math.Round(((decimal)61 * 100 / 111), 2)); |
| | | Console.Read(); |
| | | } |
| | | private static void CustomDemo() |
| | | { |