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_AssistantDataEntryController : ApiController
    {
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        ListModels oListModels = new ListModels();
        DataSet ds;

        #region 销售退货原因/退货类型 金蝶云审核同步 API
        [Route("Gy_AssistantDataEntry/SaveGy_AssistantDataEntryApi")]
        [HttpPost]
        public object SaveGy_AssistantDataEntryApi([FromBody] JObject sMainSub)
        {

            try
            {
                oCN.BeginTran();
                LogService.Write("销售退货原因/退货类型 审核同步: " + sMainSub.ToString());
                foreach (var oSub in sMainSub["model"]["FENTRY"])
                {
                    oSub["hstopflag"] = string.Equals(oSub["hstopflag"].ToString(), "1");
                }
                var sMain = sMainSub["model"].ToString();
                var sSub = sMainSub["model"]["FENTRY"].ToString();

                List<Model.ClsGy_AssistantData> lsmain = new List<Model.ClsGy_AssistantData>();
                List<Model.ClsGy_AssistantDataEntry> lssub = new List<Model.ClsGy_AssistantDataEntry>();
                lsmain = oListModels.getObjectByJson_Gy_AssistantData(sMain);
                lssub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_AssistantDataEntry>>(sSub);
                var sql = string.Empty;
                foreach (var oMain in lsmain)
                {
                    // 删除主表数据
                    sql = $@"delete from Gy_AssistantData where HID = '{oMain.HID}'";
                    oCN.RunProc(sql);
                    // 删除子表数据
                    sql = $@"delete from Gy_AssistantDataEntry where HID = '{oMain.HID}'";
                    oCN.RunProc(sql);

                    sql = $@"insert into Gy_AssistantData
                        (HID,HNumber,HName,HRemark,HLOCALEID)
                        values('{oMain.HID}', '{oMain.HNumber}', '{oMain.HName}', '{oMain.HRemark}',
                                '{oMain.HLOCALEID}'
                        )
                    ";
                    oCN.RunProc(sql);

                    foreach (var oSub in lssub)
                    {
                        sql = $@"insert into Gy_AssistantDataEntry
                        (HID,HEntryID,HNumber,HName,HStopflag,HRemark
                        ,HMakeTime,HMakeEmp,HCheckTime,HCheckEmp,HModifyTime,HModifyEmp
                        ,HLOCALEID,HUSEORGID,HCREATEORGID)
                        values('{oSub.HID}', '{oSub.HEntryID}', '{oSub.HNumber}', '{oSub.HName}',
                                '{oSub.HStopflag}',  '{oSub.HRemark}', '{oSub.HMakeTime}',
                                '{oSub.HMakeEmp}', '{oSub.HCheckTime}',  '{oSub.HCheckEmp}', 
                                '{oSub.HModifyTime}',  '{oSub.HModifyEmp}','{oSub.HLOCALEID}',
                                '{oSub.HUSEORGID}', '{oSub.HCREATEORGID}'
                        )
                        ";

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