using DBUtility;
|
using Model;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Net;
|
using System.Net.Http;
|
using System.Web.Http;
|
using WebAPI.Models;
|
|
namespace WebAPI.Controllers.基础资料.基础资料
|
{
|
public class Gy_DiscountListController : ApiController
|
{
|
|
private json objJsonResult = new json();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
ListModels oListModels = new ListModels();
|
DataSet ds;
|
|
|
#region 折扣表 金蝶云审核同步 API
|
[Route("Gy_DiscountList/SaveGy_DiscountListApi")]
|
[HttpPost]
|
public object SaveGy_DiscountListApi([FromBody] JObject sMainSub)
|
{
|
|
try
|
{
|
oCN.BeginTran();
|
LogService.Write("折扣表 审核同步: " + sMainSub.ToString());
|
|
// foreach (var oSub in sMainSub["model"]["FENTRY"])
|
// {
|
// oSub["hendflag"] = string.Equals(oSub["hendflag"].ToString(), "1");
|
// oSub["hstopflag"] = string.Equals(oSub["hstopflag"].ToString(), "1");
|
// oSub["hisuse"] = string.Equals(oSub["hisuse"].ToString(), "1");
|
// }
|
|
sMainSub["model"]["hendflag"] = string.Equals(sMainSub["model"]["hendflag"].ToString(), "1");
|
sMainSub["model"]["hstopflag"] = string.Equals(sMainSub["model"]["hstopflag"].ToString(), "1");
|
// sMainSub["model"]["hisuse"] = string.Equals(sMainSub["model"]["hisuse"].ToString(), "1");
|
|
var sMain = "[" + sMainSub["model"].ToString() + "]";
|
|
List<Model.ClsGy_DiscountList> lsmain = new List<Model.ClsGy_DiscountList>();
|
lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_DiscountList>>(sMain);
|
// lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_DiscountList>>(sMain);
|
var sql = string.Empty;
|
foreach (var oMain in lsmain)
|
{
|
sql = $@"delete from Gy_DiscountList where HItemID = {oMain.HItemID}";
|
oCN.RunProc(sql);
|
|
sql = $@"
|
set identity_insert Gy_DiscountList on
|
insert into Gy_DiscountList
|
(HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
|
,HEndFlag,HStopflag,HRemark,HUseFlag,HCREATEORGID,HUSEORGID
|
,HMakeEmp,HMakeTime,HCheckEmp,HCheckTime
|
,HModifyEmp,HModifyTime,HStopEmp,HStopTime
|
,HPURCHASEORGID,HSupID,HCurID,HPRICELISTID,HPRICETYPE,HDISCOUNTOBJECT
|
,HDISCOUNTREASON,HDEFDISCOUNTLISTID
|
)
|
values({oMain.HItemID}, '{oMain.HNumber}', '{oMain.HName}', '{oMain.HShortNumber}',
|
{oMain.HParentID}, '{oMain.HLevel}', '{oMain.HEndFlag}', '{oMain.HStopflag}',
|
'{oMain.HRemark}', '{oMain.HUseFlag}', {oMain.HCREATEORGID}, '{oMain.HUSEORGID}',
|
'{oMain.HMakeEmp}', '{oMain.HMakeTime}', '{oMain.HCheckEmp}', '{oMain.HCheckTime}',
|
'{oMain.HModifyEmp}', '{oMain.HModifyTime}', '{oMain.HStopEmp}', '{oMain.HStopTime}',
|
{oMain.HPURCHASEORGID}, {oMain.HSupID}, {oMain.HCurID}, {oMain.HPRICELISTID},
|
'{oMain.HPRICETYPE}', '{oMain.HDISCOUNTOBJECT}', '{oMain.HDISCOUNTREASON}',
|
{oMain.HDEFDISCOUNTLISTID}
|
)
|
|
set identity_insert Gy_DiscountList off
|
";
|
LogService.Write(sql);
|
oCN.RunProc(sql);
|
|
}
|
|
oCN.Commit();
|
objJsonResult.code = "1";
|
objJsonResult.count = 1;
|
objJsonResult.Message = "保存成功！";
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
catch (Exception e)
|
{
|
oCN.RollBack();
|
objJsonResult.code = "0";
|
objJsonResult.count = 0;
|
objJsonResult.Message = "保存失败！" + e.ToString();
|
objJsonResult.data = 1;
|
return objJsonResult;
|
}
|
}
|
#endregion
|
}
|
}
|
