using System;
using System.Collections.Generic;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI.Models;
using System.Data;
using SyntacticSugar.constant;
using DBUtility;
using System.Text;

namespace WebAPI.Controllers.基础资料.基础资料
{
    public class Gy_PNLInfoController : ApiController
    {

        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        DataSet ds;

        #region 获取PNLInfo列表
        [Route("Gy_PNLInfoController/GetGy_PNLInfoList")]
        [HttpGet]
        public object GetGy_PNLInfoList(string sWhere, string user)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                if (!DBUtility.ClsPub.Security_Log("Gy_PNLInfo_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有查看权限";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                DataSet ds = oCN.RunProcReturn("select * from h_v_Gy_PNLInfoList where 1=1 " + sWhere + " order by HInterID", "h_v_Gy_PNLInfoList");

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
                return objJsonResult;

            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 获取PNLInfo列表子表
        [Route("Gy_PNLInfoController/GetGy_PNLInfoSubList")]
        [HttpGet]
        public object GetGy_PNLInfoSubList(string sWhere, string user)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                if (!DBUtility.ClsPub.Security_Log("Gy_PNLInfo_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有查看权限";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                DataSet ds = oCN.RunProcReturn("select * from h_v_Gy_PNLInfoSubList where 1=1 " + sWhere + " order by HInterID", "h_v_Gy_PNLInfoSubList");

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
                return objJsonResult;

            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 获取PNLInfo列表 分页
        [Route("Gy_PNLInfoController/GetGy_PNLInfoListPage")]
        [HttpGet]
        public object GetGy_PNLInfoListPage(string sWhere, string user, string page, string size)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                if (!DBUtility.ClsPub.Security_Log("Gy_PNLInfo_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有查看权限";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (string.IsNullOrWhiteSpace(sWhere) == false)
                {
                    sWhere = sWhere.Replace("'", "''");
                }

                string sql = "exec h_p_Gy_PNLInfo_ListPage " + page + "," + size + ",'" + sWhere + "'";

                DataSet ds = oCN.RunProcReturn(sql, "h_p_Gy_PNLInfo_ListPage");

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
                }

                objJsonResult.code = CodeConstant.SUCCEED;
                objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = CodeConstant.FAIL;
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 获取PNLInfo列表子表 分页
        [Route("Gy_PNLInfoController/GetGy_PNLInfoSubListPage")]
        [HttpGet]
        public object GetGy_PNLInfoSubListPage(string sWhere, string user, string page, string size)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                if (!DBUtility.ClsPub.Security_Log("Gy_PNLInfo_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有查看权限";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (string.IsNullOrWhiteSpace(sWhere) == false)
                {
                    sWhere = sWhere.Replace("'", "''");
                }

                string sql = "exec h_p_Gy_PNLInfoSub_ListPage " + page + "," + size + ",'" + sWhere + "'";

                DataSet ds = oCN.RunProcReturn(sql, "h_p_Gy_PNLInfoSub_ListPage");

                //添加列名
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
                }

                objJsonResult.code = CodeConstant.SUCCEED;
                objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = CodeConstant.FAIL;
                objJsonResult.count = 0;
                objJsonResult.Message = "没有返回任何记录！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 添加PNLInfo 添加子表
        [Route("Gy_PNLInfoController/AddBill")]
        [HttpPost]
        public object AddBill([FromBody] JObject oMain)
        {
            try
            {
                var _value = oMain["oMain"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString(); // 表单信息
                string msg3 = sArray[1].ToString();// 子表信息
                string msg4 = sArray[2].ToString(); // 制单人信息
                //string msg4 = sArray[2].ToString();

                //反序列化
                msg2 = "[" + msg2.ToString() + "]";
                List<ClsGy_PNLInfo> list = JsonConvert.DeserializeObject<List<ClsGy_PNLInfo>>(msg2);
                List<ClsGy_PNLInfoSub> lsmain = JsonConvert.DeserializeObject<List<ClsGy_PNLInfoSub>>(msg3);


                //判断权限
                if (!ClsPub.Security_Log("Gy_PNLInfo_Edit", 1, false, msg4))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有新增权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                oCN.BeginTran();
                DataSet ds_editCheck;
                //保存前控制=========================================
                ds_editCheck = oCN.RunProcReturn("Exec h_p_Gy_PNLInfo_BeforeSaveCtrl " + msg4 + ",'1'", "h_p_Gy_PNLInfo_BeforeSaveCtrl");
                if (ds_editCheck == null)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存前判断失败！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBackRemark"]);
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //=========================================================
                ds_editCheck = oCN.RunProcReturn("select top 1 HInterID from Gy_PNLInfo where HLayOutName=N'" + list[0].HLayOutName  + "'", "Gy_PNLInfo");
                if(ds_editCheck.Tables[0].Rows.Count > 0)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "PNL布局重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                string sql1 = "insert into Gy_PNLInfo(HLayOutName,HIcon,HRowCount,HColCount,HMaker,HMakeDate,HPNLPosition_x,HPNLPosition_y) values(" +
                    "N'" + list[0].HLayOutName + "'," +
                    "N'" + list[0].HIcon + "'," +
                    "N'" + list[0].HRowCount + "'," +
                    "N'" + list[0].HColCount + "'," +
                    "N'" + list[0].HMaker + "'," +
                    "N'" + list[0].HMakeDate + "'," +
                    "N'" + list[0].HPNLPosition_x + "'," +
                    "N'" + list[0].HPNLPosition_y + "'" +
                    ")";
                //LogService.Write("执行sql语句:" + sql1);
                DataSet ds = oCN.RunProcReturn(sql1, "Gy_PNLInfo");
                ds = oCN.RunProcReturn("Select TOP 1 HInterID from Gy_PNLInfo where HLayOutName=N'" + list[0].HLayOutName + "'", "Gy_PNLInfo");
                if(ds.Tables[0].Rows.Count < 1)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "内码不存在！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                string currHInterID = ds.Tables[0].Rows[0]["HInterID"].ToString();
                HashSet<string> HSetNoHashSet = new HashSet<string>();
                HashSet<string> HPCSNoHashSet = new HashSet<string>();
                List<string> HUpdateLangList = new List<string>();
                string insertLangTemplet = "insert into Gy_PNLInfoSub(HInterID,HLayOutName,HSetNo,HPCSNo,HPosition_x,HPosition_y" +
                    ",HSetPosition_y, HSetPosition_x ) values(  ";
                int batchNum = 100;
                StringBuilder updateLangBuilder = new StringBuilder();
                foreach (var lsone in lsmain)
                {

                    if(HPCSNoHashSet.Contains(lsone.HPCSNo) == true)
                    {
                        oCN.RollBack();
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "PCS码重复！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    HSetNoHashSet.Add(lsone.HSetNo);
                    HPCSNoHashSet.Add(lsone.HPCSNo);

                    batchNum--;
                    updateLangBuilder.Append(insertLangTemplet);
                    updateLangBuilder.Append("N'" + currHInterID + "',");
                    updateLangBuilder.Append("N'" + lsone.HLayOutName + "',");
                    updateLangBuilder.Append("N'" + lsone.HSetNo + "',");
                    updateLangBuilder.Append("N'" + lsone.HPCSNo + "',");
                    updateLangBuilder.Append("N'" + lsone.HPosition_x + "',");
                    updateLangBuilder.Append("N'" + lsone.HPosition_y + "',");
                    updateLangBuilder.Append("N'" + lsone.HSetPosition_y + "',");
                    updateLangBuilder.Append("N'" + lsone.HSetPosition_x + "'");
                    updateLangBuilder.Append(");");


                    if (batchNum == 0)
                    {
                        HUpdateLangList.Add(updateLangBuilder.ToString());
                        updateLangBuilder.Clear();
                        batchNum = 100;
                    }
                }

                HUpdateLangList.Add(updateLangBuilder.ToString());
                updateLangBuilder.Clear();

                string HSetNoInStr = "(" + string.Join(",", HSetNoHashSet.ToArray<string>()) + ")";
                string HPCSNoInStr = "(" + string.Join(",", HPCSNoHashSet.ToArray<string>()) + ")";

                // 判断是否有set码或者PCS码重复的部分
                ds = oCN.RunProcReturn("select top 1 HEntryID from Gy_PNLInfoSub where HSetNo in " + HSetNoInStr
                    + "AND HPCSNo in " + HPCSNoInStr  + "AND HInterID = " + currHInterID, "Gy_PNLInfoSub");
                //LogService.Write("执行 SQL 语句: select top 1 HEntryID from Gy_PNLInfoSub where HSetNo in " + HSetNoInStr
                //    + "AND HPCSNo in " + HPCSNoInStr);
                
                if(ds.Tables[0].Rows.Count > 0)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "Set码或者PCS码有重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                HUpdateLangList.ForEach(HUpdateLang =>
                {
                    //LogService.Write("执行 SQL 语句: " + HUpdateLang);
                    ds = oCN.RunProcReturn(HUpdateLang, "Gy_PNLInfoSub");
                });


                //保存后控制=========================================
                ds_editCheck = oCN.RunProcReturn("Exec h_p_Gy_PNLInfo_AfterSaveCtrl " + msg4 + ",'1'", "h_p_Gy_PNLInfo_AfterSaveCtrl");
                if (ds_editCheck == null)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存后判断失败！";
                    objJsonResult.data = null;
                    return objJsonResult;

                }
                if (DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "" + DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBackRemark"]);
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //=========================================================

                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "保存成功！";
                //objJsonResult.data = null;
                return objJsonResult;


            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 删除PNLInfo 删除子表
        [Route("Gy_PNLInfoController/DeleteBill")]
        [HttpGet]
        public object DeleteBill(string HInterID, string user)
        {
            try
            {
                //判断权限
                if (!ClsPub.Security_Log("Gy_PNLInfo_Drop", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有删除权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                DataSet ds_editCheck;
                oCN.BeginTran();
                //删除前控制=========================================
                ds_editCheck = oCN.RunProcReturn("Exec h_p_Gy_PNLInfo_BeforeDelCtrl " + HInterID + "," + user, "h_p_Gy_PNLInfo_BeforeDelCtrl");
                if (ds_editCheck == null)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "删除前判断失败！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBackRemark"]);
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //=========================================================
              
                ds = oCN.RunProcReturn("delete from Gy_PNLInfo where HInterID = " + HInterID, "Gy_PNLInfo");
       
                ds = oCN.RunProcReturn("delete from Gy_PNLInfoSub where HInterID = " + HInterID, "Gy_PNLInfoSub"); // 删除子表

                //删除后控制=========================================
                ds_editCheck = oCN.RunProcReturn("Exec h_p_Gy_PNLInfo_AfterDelCtrl " + HInterID + "," + user, "h_p_Gy_PNLInfo_AfterDelCtrl");
                if (ds_editCheck == null)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "删除后判断失败！";
                    objJsonResult.data = null;
                    return objJsonResult;

                }
                if (DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "删除失败" + DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBackRemark"]);
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //=========================================================

                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                //LogService.Write(e);
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }

        }
        #endregion

        #region 更新PNLInfo 更新子表
        [Route("Gy_PNLInfoController/EditBill")]
        [HttpPost]
        public object EditBill([FromBody] JObject oMain)
        {
            try
            {
                var _value = oMain["oMain"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString(); // 表单信息
                string msg3 = sArray[1].ToString();// 子表信息
                string msg4 = sArray[2].ToString(); // 制单人信息
                string msg5 = sArray[3].ToString(); // 删除表单信息(HEntryID 列表)

                //反序列化
                msg2 = "[" + msg2.ToString() + "]";
                List<ClsGy_PNLInfo> list = JsonConvert.DeserializeObject<List<ClsGy_PNLInfo>>(msg2);
                List<ClsGy_PNLInfoSub> lsmain = JsonConvert.DeserializeObject<List<ClsGy_PNLInfoSub>>(msg3);
                List<int> delEntryIDList = JsonConvert.DeserializeObject<List<int>>(msg5);


                //判断权限
                if (!ClsPub.Security_Log("Gy_PNLInfo_Edit", 1, false, msg4))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有新增权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                oCN.BeginTran();
                DataSet ds_editCheck;
                //保存前控制=========================================
                ds_editCheck = oCN.RunProcReturn("Exec h_p_Gy_PNLInfo_BeforeSaveCtrl " + msg4 + ",'2'", "h_p_Gy_PNLInfo_BeforeSaveCtrl");
                if (ds_editCheck == null)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存前判断失败！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                if (DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBackRemark"]);
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //=========================================================
                ds_editCheck = oCN.RunProcReturn("select top 1 HInterID from Gy_PNLInfo where HLayOutName=N'" + list[0].HLayOutName + "'"
                    + "AND HInterID != N'" + list[0].HInterID + "'", "Gy_PNLInfo");
                if (ds_editCheck.Tables[0].Rows.Count > 0)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "PNL布局重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                // 主表 更新
                StringBuilder sb = new StringBuilder();
                sb.Append("Update Gy_PNLInfo set ");
                sb.Append("HLayOutName=N'"+ list[0].HLayOutName + "',");
                sb.Append("HIcon=N'" + list[0].HIcon + "',");
                sb.Append("HRowCount=N'" + list[0].HRowCount + "',");
                sb.Append("HColCount=N'" + list[0].HColCount + "',");
                sb.Append("HPNLPosition_x=N'" + list[0].HPNLPosition_x + "',");
                sb.Append("HPNLPosition_y=N'" + list[0].HPNLPosition_y + "'");
                sb.Append(" where HInterID=N'" + list[0].HInterID + "'");
                string sql1 = sb.ToString();
                oCN.RunProcReturn(sql1, "Gy_PNLInfo");
                
                oCN.RunProcReturn("Update Gy_PNLInfoSub set HLayOutName = N'" + list[0].HLayOutName + "'" + 
                    " where HInterID=N'" + list[0].HInterID + "'", "Gy_PNLInfoSub"); 
                sb.Clear();
                // 构建删除 更新语句
                List<string> HUpdateLangList = new List<string>();
                int batchNum = 100;

                HashSet<string> HSetNoHashSet = new HashSet<string>();
                HashSet<string> HPCSNoHashSet = new HashSet<string>();

                foreach( var lsone in lsmain)
                {

                    batchNum--;

                    if (HPCSNoHashSet.Contains(lsone.HPCSNo) == true)
                    {
                        oCN.RollBack();
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "PCS码重复！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    HSetNoHashSet.Add(lsone.HSetNo);
                    HPCSNoHashSet.Add(lsone.HPCSNo);
                    if (lsone.HEntryID != 0)
                    {
                        delEntryIDList.Add(lsone.HEntryID);
                    }
                    sb.Append("insert into Gy_PNLInfoSub(HInterID,");
                    sb.Append("HLayOutName, HSetNo, HPCSNo, HPosition_x, HPosition_y" +
                    ",HSetPosition_y, HSetPosition_x ) values(  ");
                    sb.Append("N'" + lsone.HInterID + "',");
                    sb.Append("N'" + lsone.HLayOutName + "',");
                    sb.Append("N'" + lsone.HSetNo + "',");
                    sb.Append("N'" + lsone.HPCSNo + "',");
                    sb.Append("N'" + lsone.HPosition_x + "',");
                    sb.Append("N'" + lsone.HPosition_y + "',");
                    sb.Append("N'" + lsone.HSetPosition_y + "',");
                    sb.Append("N'" + lsone.HSetPosition_x + "'");
                    sb.Append(");");


                    if (batchNum == 0)
                    {
                        HUpdateLangList.Add(sb.ToString());
                        sb.Clear();
                        batchNum = 100;
                    }
                }

                HUpdateLangList.Add(sb.ToString());
                sb.Clear();


                // 子表删除
                string delWhereStr = "(" + string.Join(",", delEntryIDList.ToArray()) + ")";
                string sql2 = "Delete from Gy_PNLInfoSub where HEntryID in " + delWhereStr;
                //LogService.Write("执行SQL语句：" + sql2);
                oCN.RunProcReturn(sql2, "Gy_PNLInfoSub");


                // 增加前判断 当前需要新增的数据中是否有PCS码和SET码重复的部分
                string HSetNoInStr = "(" + string.Join(",", HSetNoHashSet.ToArray<string>()) + ")";
                string HPCSNoInStr = "(" + string.Join(",", HPCSNoHashSet.ToArray<string>()) + ")";

                // 判断是否有set码或者PCS码重复的部分
                ds = oCN.RunProcReturn("select top 1 HEntryID from Gy_PNLInfoSub where HSetNo in " + HSetNoInStr
                    + "AND HPCSNo in " + HPCSNoInStr, "Gy_PNLInfoSub");
                //LogService.Write("执行 SQL 语句: select top 1 HEntryID from Gy_PNLInfoSub where HSetNo in " + HSetNoInStr
                //    + "AND HPCSNo in " + HPCSNoInStr);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "set码和PCS码有重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                // 子表 新增
                HUpdateLangList.ForEach(HUpdateLang =>
                    {
                        ds = oCN.RunProcReturn(HUpdateLang, "Gy_PNLInfoSub");
                    }
                );


                //保存后控制=========================================
                ds_editCheck = oCN.RunProcReturn("Exec h_p_Gy_PNLInfo_AfterSaveCtrl " + msg4 + ",'2'", "h_p_Gy_PNLInfo_AfterSaveCtrl");
                if (ds_editCheck == null)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存后判断失败！";
                    objJsonResult.data = null;
                    return objJsonResult;

                }
                if (DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "" + DBUtility.ClsPub.isStrNull(ds_editCheck.Tables[0].Rows[0]["HBackRemark"]);
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //=========================================================

                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "保存成功！";
                //objJsonResult.data = null;
                return objJsonResult;


            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
    #endregion
    }
}