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
    }
}