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());

                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");
                }
                var sMain = sMainSub["model"]["FENTRY"].ToString() ;
                List<Model.ClsGy_OperatorGroup> lsmain = new List<Model.ClsGy_OperatorGroup>();
                lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_OperatorGroup>>(sMain);
                var sql = string.Empty;
                sql = $@"delete from Gy_OperatorGroup where HItemID = {lsmain[0].HItemID}";
                oCN.RunProc(sql);
                foreach (var oMain in lsmain)
                {
                    sql = $@"
                    set identity_insert Gy_OperatorGroup on
                    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}'
                    )
                    set identity_insert Gy_OperatorGroup off
                    ";
                    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
    }
}