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_OperatorGroupController : ApiController
|
{
|
private json objJsonResult = new json();
|
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
|
ListModels oListModels = new ListModels();
|
DataSet ds;
|
|
|
#region 业务组 金蝶云审核同步 API
|
[Route("Gy_OperatorGroup/SaveGy_OperatorGroupListApi")]
|
[HttpPost]
|
public object SaveGy_OperatorGroupListApi([FromBody] JObject sMainSub)
|
{
|
|
try
|
{
|
oCN.BeginTran();
|
LogService.Write("业务组 审核同步: " + sMainSub.ToString());
|
|
var sMain = sMainSub["model"]["FENTRY"].ToString();
|
List<Model.ClsGy_OperatorGroup> lsmain = new List<Model.ClsGy_OperatorGroup>();
|
lsmain = oListModels.getObjectByJson_Gy_OperatorGroup(sMain);
|
var sql = string.Empty;
|
foreach(var oMain in lsmain)
|
{
|
sql = $@"delete from Gy_OperatorGroup where HItemID = {oMain.HItemID}";
|
oCN.RunProc(sql);
|
|
sql = $@"insert into Gy_OperatorGroup(HItemID
|
,HNumber ,HName,HShortNumber,HParentID,HLevel,HEndFlag
|
,HStopflag,HRemark,HHelpCode,HUseFlag,HUSEORGID
|
,HOperatorGroupId,HOperatorGroupType,HIsUse)
|
values({oMain.HItemID}, '{oMain.HNumber}', '{oMain.HName}', '{oMain.HShortNumber}',
|
{oMain.HParentID}, '{oMain.HLevel}', '{oMain.HEndFlag}', '{oMain.HStopflag}'
|
'{oMain.HRemark}', '{oMain.HHelpCode}' ,'{oMain.HUseFlag}', '{oMain.HUSEORGID}',
|
'{oMain.HOperatorGroupId}','{oMain.HOperatorGroupType}', '{oMain.HIsUse}'
|
)
|
";
|
|
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
|
}
|
}
|
