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.IO;
using System.Web;
using System.Web.Http;
using System.Windows.Forms;
using WebAPI.Models;
using WebAPI.Controllers.SCGL.日计划管理;
using System.Text.RegularExpressions;

namespace WebAPI.Controllers.工资管理.扣补项目费用单
{
    public class Pay_DuSubsidyItemBillController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
        public const string ModName = "2233";                   //单据类型
        public const string ModCaption = "扣补项目费用单";          //单据名称
        public const string ModRightName = "Pay_DuSubsidyItemBill";
        public const string ModRightNameList = ModRightName + "List";       //列表
        public const string ModRightNameEdit = ModRightName + "_Edit";      //编辑
        public const string ModRightNameCheck = ModRightName + "_Check";    //审核
        public const string ModRightNameClose = ModRightName + "_Close";    //关闭
        public const string ModRightNameDelete = ModRightName + "_Delete";  //作废
        public const string ModRightNameDrop = ModRightName + "_Drop";      //删除
        public const string ModRightNameMoney = ModRightName + "_Money";    //金额
        public const string ModRightNameQty = ModRightName + "_Qty";        //数量
        public DataSet ds = new DataSet();
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
        public DAL.ClsPay_DuSubsidyItemBill oBill = new DAL.ClsPay_DuSubsidyItemBill();
        public DAL.ClsPay_DuSubsidyItemBill BillOld = new DAL.ClsPay_DuSubsidyItemBill();
        DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
        DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();
        DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
        DAL.ClsGy_ORGANIZATIONS_View oOrg = new DAL.ClsGy_ORGANIZATIONS_View();
        DAL.ClsGy_DuSubsidyItem_View oDuSItem = new DAL.ClsGy_DuSubsidyItem_View();


        #region 扣补项目费用单列表
        /// <summary>
        /// 获取扣补项目费用单列表信息
        /// </summary>
        /// <returns></returns>
        [Route("Pay_DuSubsidyItemBillController/GetPay_DuSubsidyItemBillList_Json")]
        [HttpGet]
        public object GetPay_DuSubsidyItemBillList_Json(string sWhere, string HMaker)
        {
            try
            {
                //判断权限
                if (!DBUtility.ClsPub.Security_Log(ModRightNameList, 3, false, HMaker))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //返回列表信息
                ds = oCn.RunProcReturn("select * from h_v_Pay_DuSubsidyItemBillList where 1=1 " + sWhere + " order by hmainid desc", "h_v_Pay_DuSubsidyItemBillList");
                List<object> columnNameList = new List<object>();
                //添加列名
                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 = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "成功！";
                objJsonResult.data = ds.Tables[0];
                objJsonResult.list = columnNameList;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "查询列表信息失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 扣补项目费用单删除
        /// <summary>
        /// 删除扣补项目费用单
        /// </summary>
        /// <returns></returns>
        [Route("Pay_DuSubsidyItemBillController/GetPay_DuSubsidyItemBill_Delete_Json")]
        [HttpGet]
        public object GetPay_DuSubsidyItemBill_Delete_Json(Int64 HInterID, string HMaker)
        {
            try
            {
                //判断权限
                if (!DBUtility.ClsPub.Security_Log(ModRightNameDrop, 3, false, HMaker))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块删除功能权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //判断存在性
                if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo))
                {
                    //判断会计期是否合理
                    string s = "";
                    int sYear = 0;
                    int sPeriod = 0;
                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(oBill.omodel.HDate, ref sYear, ref sPeriod, ref s) == false)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = s;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    //删除前控制
                    DataSet BeforeDs = oCn.RunProcReturn("Exec h_p_Pay_DuSubsidyItemBill_BeforeDelCtrl " + HInterID.ToString() + ",'" + HMaker + "'", "h_p_Pay_DuSubsidyItemBill_BeforeDelCtrl");
                    if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "删除前判断失败！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]);
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //删除单据（包含删除后控制、写入日志）
                    if (!oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Pay_DuSubsidyItemBill_AfterDelCtrl", HMaker, ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "删除失败!原因:" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    else
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "删除扣补项目费用单成功！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未查询到该扣补项目费用单，请刷新数据后重新选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除扣补项目费用单失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 扣补项目费用单审核/反审核
        /// <summary>
        /// 审核/反审核扣补项目费用单
        /// </summary>
        /// <param name="HInterID">单据ID</param>
        /// <param name="Type">审核(1),反审核(2)</param>
        /// <param name="HMaker">审核人</param>
        /// <returns></returns>
        [Route("Pay_DuSubsidyItemBillController/GetPay_DuSubsidyItemBill_Check_Json")]
        [HttpGet]
        public object GetPay_DuSubsidyItemBill_Check_Json(Int64 HInterID, int Type, string HMaker)
        {
            try
            {
                //判断权限
                if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 3, false, HMaker))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块审核/反审核功能权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //判断存在性
                if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo))
                {
                    //判断会计期是否合理
                    string s = "";
                    int sYear = 0;
                    int sPeriod = 0;
                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(oBill.omodel.HDate, ref sYear, ref sPeriod, ref s) == false)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = s;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }

                    //Type 1 审核  2  反审核
                    if (Type == 1)
                    {
                        if (oBill.omodel.HChecker.Trim() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已审核，不能再次审核！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        if (oBill.omodel.HCloseMan.Trim() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已关闭，不能再次审核！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        if (oBill.omodel.HDeleteMan.Trim() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已作废，不能再次审核！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        //审核前控制
                        DataSet BeforeDs = oCn.RunProcReturn("Exec h_p_Pay_DuSubsidyItemBill_BeforeCheckCtrl " + HInterID.ToString() + ",'" + HMaker + "'", "h_p_Pay_DuSubsidyItemBill_BeforeCheckCtrl");
                        if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "审核前判断失败！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1)
                            {
                                objJsonResult.code = "0";
                                objJsonResult.count = 0;
                                objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]);
                                objJsonResult.data = null;
                                return objJsonResult;
                            }
                        }
                        //审核单据
                        if (!oBill.CheckBill(HInterID, oBill.omodel.HBillNo, "h_p_Pay_DuSubsidyItemBill_AfterCheckCtrl", HMaker, ref ClsPub.sExeReturnInfo))
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 1;
                            objJsonResult.Message = "单据号：" + oBill.omodel.HBillNo + " 审核成功！";
                            objJsonResult.data = null;
                            return objJsonResult; ;
                        }
                    }
                    else
                    {
                        if (oBill.omodel.HChecker.Trim() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据未审核，不需要反审核！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        //反审核前控制
                        DataSet BeforeDs = oCn.RunProcReturn("Exec h_p_Pay_DuSubsidyItemBill_BeforeUnCheckCtrl " + HInterID.ToString() + ",'" + HMaker + "'", "h_p_Pay_DuSubsidyItemBill_BeforeUnCheckCtrl");
                        if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0)
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "反审核前判断失败！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1)
                            {
                                objJsonResult.code = "0";
                                objJsonResult.count = 0;
                                objJsonResult.Message = "反审核失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]);
                                objJsonResult.data = null;
                                return objJsonResult;
                            }
                        }

                        //反审核单据
                        if (!oBill.AbandonCheck(HInterID, oBill.omodel.HBillNo, "h_p_Pay_DuSubsidyItemBill_AfterUnCheckCtrl", HMaker, ref ClsPub.sExeReturnInfo))
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "反审核失败!原因:" + ClsPub.sExeReturnInfo;
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 1;
                            objJsonResult.Message = "单据号：" + oBill.omodel.HBillNo + " 反审核成功！";
                            objJsonResult.data = null;
                            return objJsonResult; ;
                        }
                    }
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未查询到该扣补项目费用单，请刷新数据后重新选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "审核或反审核扣补项目费用单失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 扣补项目费用单关闭/反关闭
        /// <summary>
        /// 关闭/反关闭扣补项目费用单
        /// </summary>
        /// <param name="HInterID">单据ID</param>
        /// <param name="Type">关闭(1),反关闭(2)</param>
        /// <param name="HMaker">关闭人</param>
        /// <returns></returns>
        [Route("Pay_DuSubsidyItemBillController/GetPay_DuSubsidyItemBill_Close_Json")]
        [HttpGet]
        public object GetPay_DuSubsidyItemBill_Close_Json(Int64 HInterID, int Type, string HMaker)
        {
            try
            {
                //判断权限
                if (!DBUtility.ClsPub.Security_Log(ModRightNameClose, 3, false, HMaker))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块关闭/反关闭功能权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //判断存在性
                if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo))
                {
                    //判断会计期是否合理
                    string s = "";
                    int sYear = 0;
                    int sPeriod = 0;
                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(oBill.omodel.HDate, ref sYear, ref sPeriod, ref s) == false)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = s;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }

                    //Type 1 关闭  2  反关闭
                    if (Type == 1)
                    {
                        if (oBill.omodel.HCloseMan.Trim() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已关闭，不能再次关闭！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        //关闭单据
                        if (!oBill.CloseBill(HInterID, oBill.omodel.HBillNo, HMaker, ref ClsPub.sExeReturnInfo))
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 1;
                            objJsonResult.Message = "单据号：" + oBill.omodel.HBillNo + " 关闭成功！";
                            objJsonResult.data = null;
                            return objJsonResult; ;
                        }
                    }
                    else
                    {
                        if (oBill.omodel.HCloseMan.Trim() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据未关闭，不需要反关闭！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        //反关闭单据
                        if (!oBill.CancelClose(HInterID, oBill.omodel.HBillNo, HMaker, ref ClsPub.sExeReturnInfo))
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 1;
                            objJsonResult.Message = "单据号：" + oBill.omodel.HBillNo + " 反关闭成功！";
                            objJsonResult.data = null;
                            return objJsonResult; ;
                        }
                    }
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未查询到该扣补项目费用单，请刷新数据后重新选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "关闭或反关闭扣补项目费用单失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 扣补项目费用单作废/反作废
        /// <summary>
        /// 作废/反作废扣补项目费用单
        /// </summary>
        /// <param name="HInterID">单据ID</param>
        /// <param name="Type">作废(1),反作废(2)</param>
        /// <param name="HMaker">作废人</param>
        /// <returns></returns>
        [Route("Pay_DuSubsidyItemBillController/GetPay_DuSubsidyItemBill_Cancelltion_Json")]
        [HttpGet]
        public object GetPay_DuSubsidyItemBill_Cancelltion_Json(Int64 HInterID, int Type, string HMaker)
        {
            try
            {
                //判断权限
                if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 3, false, HMaker))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "您没有该模块作废/反作废功能权限,请与管理员联系！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //判断存在性
                if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo))
                {
                    //判断会计期是否合理
                    string s = "";
                    int sYear = 0;
                    int sPeriod = 0;
                    if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(oBill.omodel.HDate, ref sYear, ref sPeriod, ref s) == false)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = s;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }

                    //Type 1 作废  2  反作废
                    if (Type == 1)
                    {
                        if (oBill.omodel.HDeleteMan.Trim() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已作废，不能再次作废！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        //作废单据
                        if (!oBill.Cancelltion(HInterID, oBill.omodel.HBillNo, HMaker, ref ClsPub.sExeReturnInfo))
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo;
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 1;
                            objJsonResult.Message = "单据号：" + oBill.omodel.HBillNo + " 作废成功！";
                            objJsonResult.data = null;
                            return objJsonResult; ;
                        }
                    }
                    else
                    {
                        if (oBill.omodel.HDeleteMan.Trim() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据未作废，不需要反作废！";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        //反作废单据
                        if (!oBill.AbandonCancelltion(HInterID, oBill.omodel.HBillNo, HMaker, ref ClsPub.sExeReturnInfo))
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo;
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                        else
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 1;
                            objJsonResult.Message = "单据号：" + oBill.omodel.HBillNo + " 反作废成功！";
                            objJsonResult.data = null;
                            return objJsonResult; ;
                        }
                    }
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未查询到该扣补项目费用单，请刷新数据后重新选择！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "作废或反作废扣补项目费用单失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion




        #region 扣补项目费用单 新增/编辑
        #region 扣补项目费用单 表头数据
        public class Pay_DuSubsidyItemBillMain
        {
            public int HInterID;
            public string HBillNo;
            public string HDate;
            public string HInnerBillNo;
            public int HGroupID;
            public string HGroupName;
            public int HDeptID;
            public string HDeptName;
            public string HExplanation;
            public string HRemark;

            public string HMaker;
            public string HMakerDate;
            public string HUpdater;
            public string HUpdaterDate;
            public string HChecker;
            public string HCheckerDate;
            public string HCloseMan;
            public string HCloseManDate;
            public string HDeleteMan;
            public string HDeleteManDate;
            public string HBacker;
            public string HBackerDate;
            public string HBackRemark;
        }
        #endregion
        #region 扣补项目费用单 子表数据
        public class Pay_DuSubsidyItemBillSub
        {
            public int HEmpID;
            public string HEmpNumber;
            public string HEmpName;
            public int HDuSubsidyItemID;
            public string HDuSubsidyItemNumber;
            public string HDuSubsidyItemName;
            public double HQty;
            public double HPrice;
            public double HMoney;
            public string HRemark;
        }
        #endregion

        #region 扣补项目费用单 新增/编辑
        /// <summary>
        /// 新增单据-保存按钮
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Pay_DuSubsidyItemBill/AddDuSubsidyItemBill")]
        [HttpPost]
        public object AddBill_Pay_DuSubsidyItemBill([FromBody] JObject sMainSub)
        {
            //获取参数
            var _value = sMainSub["sMainSub"].ToString();
            string msg1 = _value.ToString();
            //开始事务
            oCn.BeginTran();
            //保存主表
            objJsonResult = AddBillMain_Pay_DuSubsidyItemBill(msg1);
            if (objJsonResult.code == "0")
            {
                oCn.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = objJsonResult.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
            oCn.Commit();
            objJsonResult.code = "1";
            objJsonResult.count = 1;
            objJsonResult.Message = "新增单据成功！";
            objJsonResult.data = ds.Tables[0];
            return objJsonResult;
        }
        #endregion
        #region 添加 扣补项目费用单 主表
        public json AddBillMain_Pay_DuSubsidyItemBill(string msg1)
        {
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();
            int OperationType = int.Parse(sArray[2].ToString());//数据类型 1添加 3修改 2 复制
            string user = sArray[3].ToString();//用户名
            string HComputerName = SystemInformation.ComputerName; //设备名称

            try
            {
                if (OperationType == 1)
                {
                    //判断是否有编辑权限
                    if (!DBUtility.ClsPub.Security_Log("Pay_DuSubsidyItemBill_Edit", 1, false, user))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "无新增权限!";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else if (OperationType == 3)
                {
                    //判断是否有编辑权限
                    if (!DBUtility.ClsPub.Security_Log("Pay_DuSubsidyItemBill_Edit", 1, false, user))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "无编辑权限!";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                msg2 = "[" + msg2.ToString() + "]";
                List<Pay_DuSubsidyItemBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Pay_DuSubsidyItemBillMain>>(msg2);


                int HYear = int.Parse(mainList[0].HDate.Split('-')[0]);
                int HPeriod = int.Parse(mainList[0].HDate.Split('-')[1]);
                string HBillType = "2233";
                string HBillSubType = "";
                int HBillStatus = 1;

                int HAutoSaveFlag = 0;


                int HInterID = mainList[0].HInterID;
                string HBillNo = mainList[0].HBillNo;
                string HDate = mainList[0].HDate;
                string HInnerBillNo = mainList[0].HInnerBillNo;
                int HGroupID = mainList[0].HGroupID;
                int HDeptID = mainList[0].HDeptID;
                string HExplanation = mainList[0].HExplanation;
                string HRemark = mainList[0].HRemark;


                string HMaker = mainList[0].HMaker;
                string HMakerDate = mainList[0].HMakerDate;
                string HUpdater = mainList[0].HUpdater;
                string HUpdaterDate = mainList[0].HUpdaterDate;
                string HChecker = mainList[0].HChecker;
                string HCheckerDate = mainList[0].HCheckerDate;
                string HCloseMan = mainList[0].HCloseMan;
                string HCloseManDate = mainList[0].HCloseManDate;
                string HDeleteMan = mainList[0].HDeleteMan;
                string HDeleteManDate = mainList[0].HDeleteManDate;
                string HBacker = mainList[0].HBacker;
                string HBackerDate = mainList[0].HBackerDate;
                string HBackRemark = mainList[0].HBackRemark;


                //if (OperationType == 2)
                //{
                //    ds = oCn.RunProcReturn("select * from PM_ProjectBillMain where HBillNo ='" + HBillNo + "'", "PM_ProjectBillMain");
                //    if (ds.Tables[0].Rows.Count > 0)
                //    {
                //        objJsonResult.code = "0";
                //        objJsonResult.count = 0;
                //        objJsonResult.Message = "单据号重复,请重新输入!";
                //        objJsonResult.data = null;
                //        return objJsonResult;
                //    }
                //}

                ds = oCn.RunProcReturn("select * from Pay_DuSubsidyItemBillMain where HInterID = " + HInterID + " and HBillNo = '" + HBillNo + "'", "Pay_DuSubsidyItemBillMain");

                if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//新增
                {
                    string sql = "insert into Pay_DuSubsidyItemBillMain" +
                        "(HYear,HPeriod,HBillType,HBillSubType,HBillStatus,HInterID,HBillNo,HDate,HInnerBillNo,HGroupID,HDeptID,HExplanation,HAutoSaveFlag,HRemark,HMaker,HMakeDate) " +
                        "values(" +
                        "" + HYear +
                        "," + HPeriod +
                        ",'" + HBillType +
                        "','" + HBillSubType +
                        "'," + HBillStatus +
                        "," + HInterID +
                        ",'" + HBillNo +
                        "','" + HDate +
                        "','" + HInnerBillNo +
                        "'," + HGroupID +
                        "," + HDeptID +
                        ",'" + HExplanation +
                        "'," + HAutoSaveFlag +
                        ",'" + HRemark +
                        "','" + HMaker +
                        "','" + HMakerDate +
                        "')";

                    //主表
                    oCn.RunProc(sql);
                    LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",新增扣补项目费用单:" + HBillNo);
                    oCn.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "新增扣补项目费用单：" + HBillNo + "','LMES-扣补项目费用单模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo);
                }
                else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0)                    //编辑
                {
                    string sql = "update Pay_DuSubsidyItemBillMain set " +
                        "HYear = " + HYear +
                        ", HPeriod = " + HPeriod +
                        ", HBillNo = '" + HBillNo +
                        "', HDate = '" + HDate +
                        "', HInnerBillNo = '" + HInnerBillNo +
                        "', HGroupID = " + HGroupID +
                        ", HDeptID = " + HDeptID +
                        ", HExplanation = '" + HExplanation +
                        "', HRemark = '" + HRemark +
                        "', HUpdater = '" + HUpdater +
                        "', HUpdateDate = '" + HUpdaterDate +
                        "' where HInterID = " + HInterID;

                    oCn.RunProc(sql);

                    //删除子表
                    oCn.RunProc("delete from Pay_DuSubsidyItemBillSub where HInterID= " + HInterID);
                    //记录日志
                    LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",修改扣补项目费用单:" + HBillNo);
                    oCn.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "修改扣补项目费用单：" + HBillNo + "','LMES-扣补项目费用单模块','" + DBUtility.ClsPub.IPAddress + "','修改单据'", ref DBUtility.ClsPub.sExeReturnInfo);
                }
                //保存子表
                objJsonResult = AddBillSub1_Pay_DuSubsidyItemBill(msg3, HInterID, HBillNo, OperationType);

                if (objJsonResult.code == "0")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = objJsonResult.Message;
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = null;
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
        #region 添加 扣补项目费用单 子表
        public json AddBillSub1_Pay_DuSubsidyItemBill(string msg3, long HInterID, string HBillNo, int OperationType)
        {
            List<Pay_DuSubsidyItemBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Pay_DuSubsidyItemBillSub>>(msg3);
            int i = 0;                                          //作为子表内码
            foreach (Pay_DuSubsidyItemBillSub oSub in DetailColl)
            {
                i++;                                            //同一个主表下的子表的内码自增

                int HEntryID = i;

                int HEmpID = oSub.HEmpID;
                int HDuSubsidyItemID = oSub.HDuSubsidyItemID;
                double HQty = oSub.HQty;
                double HPrice = oSub.HPrice;
                double HMoney = oSub.HMoney;
                string HRemark = oSub.HRemark;

                string sql = "insert into Pay_DuSubsidyItemBillSub" +
                    "(HInterID,HEntryID,HEmpID,HDuSubsidyItemID,HQty,HPrice,HMoney,HRemark) " +
                    "values(" +
                    "" + HInterID +
                    "," + HEntryID +
                    "," + HEmpID +
                    "," + HDuSubsidyItemID +
                    "," + HQty +
                    "," + HPrice +
                    "," + HMoney +
                    ",'" + HRemark +
                    "')";

                oCn.RunProc(sql);
            }

            objJsonResult.code = "1";
            objJsonResult.count = 1;
            objJsonResult.Message = null;
            objJsonResult.data = null;
            return objJsonResult;
        }
        #endregion
        #endregion

        #region 扣补项目费用单 编辑-页面赋值
        /// <summary>
        ///参数：string HInterID。
        ///返回值：object。
        /// </summary>
        [Route("Pay_DuSubsidyItemBill/editInit")]
        [HttpGet]
        public object getDuSubsidyItemBilleditInit(string HInterID, string user)
        {
            try
            {
                List<DataTable> tableList = new List<DataTable>();

                //查看权限
                if (!DBUtility.ClsPub.Security_Log("Pay_DuSubsidyItemBill_Edit", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无编辑权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (HInterID == null || HInterID.Equals(""))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HInterID不能为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ds = oCn.RunProcReturn("exec h_p_Pay_DuSubsidyItemBill_EditInit " + HInterID, "h_p_Pay_DuSubsidyItemBill_EditInit");
                tableList.Add(ds.Tables[0]);
                tableList.Add(ds.Tables[1]);

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

        #region 扣补项目费用单 数据导入
        #region 获取导入文件的数据
        [Route("Pay_DuSubsidyItemBill/Pay_DuSubsidyItemBillimport")]
        [HttpPost]
        public object Pay_DuSubsidyItemBillimport()
        {
            try
            {
                var WorkBookName = HttpContext.Current.Request["WorkBookName"];
                DBUtility.ClsPub.HOrgID = long.Parse(HttpContext.Current.Request["HOrgID"]);
                //获取文件名称
                var file = HttpContext.Current.Request.Files[0];
                //获取文件物理路径
                string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName);
                //保存文件
                file.SaveAs(ExcelPath);

                NpoiHelper np = new NpoiHelper();
                DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 2, WorkBookName);

                //删除文件
                File.Delete(ExcelPath);

                //创建临时表
                DataTable tb2 = new DataTable("dt2");
                DataTable tb3 = new DataTable("dt3");

                //添加列名
                for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++)
                {
                    tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString());
                }

                //添加数据
                for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++)
                {
                    DataRow row = tb2.NewRow();
                    for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++)
                    {
                        row[j] = ExcelDs.Tables[0].Rows[i][j].ToString();
                    }
                    tb2.Rows.Add(row);
                }
                //获取导入文件列名集合，用于前端动态列
                List<object> columnNameList = new List<object>();
                //添加列名
                foreach (DataColumn col in tb2.Columns)
                {
                    Type dataType = col.DataType;
                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
                }

                var error = "";

                //查询扣补项目费用单没有的列
                if (!tb2.Columns.Contains("日期"))
                    error += "没有找到【日期】的标题,";
                if (!tb2.Columns.Contains("年"))
                    error += "没有找到【年】的标题,";
                if (!tb2.Columns.Contains("月"))
                    error += "没有找到【月】的标题,";
                if (!tb2.Columns.Contains("组织代码"))
                    error += "没有找到【组织代码】的标题,";
                if (!tb2.Columns.Contains("组织"))
                    error += "没有找到【组织】的标题,";
                if (!tb2.Columns.Contains("部门代码"))
                    error += "没有找到【部门代码】的标题,";
                if (!tb2.Columns.Contains("部门名称"))
                    error += "没有找到【部门名称】的标题,";
                if (!tb2.Columns.Contains("班组代码"))
                    error += "没有找到【班组代码】的标题,";
                if (!tb2.Columns.Contains("班组"))
                    error += "没有找到【班组】的标题,";
                if (!tb2.Columns.Contains("表头备注"))
                    error += "没有找到【表头备注】的标题,";
                if (!tb2.Columns.Contains("职员代码"))
                    error += "没有找到【职员代码】的标题,";
                if (!tb2.Columns.Contains("职员名称"))
                    error += "没有找到【职员名称】的标题,";
                ////获取所有的扣补项目，判定导入文件中未包含的扣补项目
                //DataSet ds_DuSubsidyItem;
                //ds_DuSubsidyItem = oCn.RunProcReturn("select * from Gy_DuSubsidyItem", "Gy_DuSubsidyItem");
                //if (ds_DuSubsidyItem.Tables[0] != null)
                //{
                //    for (int i = 0; i < ds_DuSubsidyItem.Tables[0].Rows.Count; i++)
                //    {
                //        string DuSubsidyItem = ds_DuSubsidyItem.Tables[0].Rows[i]["HName"] == null ? "" : ds_DuSubsidyItem.Tables[0].Rows[i]["HName"].ToString();
                //        if (!tb2.Columns.Contains(DuSubsidyItem))
                //            error += "没有找到【" + DuSubsidyItem + "】的标题,";
                //    }
                //}

                if (error.Length > 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = $"Excel模板存在错误,{error}\r\n";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                objJsonResult = (json)Checkdata(tb2);
                if (objJsonResult.code == "0")
                {
                    return objJsonResult;
                }

                oCn.BeginTran();
                //删除临时表数据
                oCn.RunProc("delete from diyipi_Pay_DuSubsidyItemBill");

                //临时表添加数据
                for (int i = 0; i < tb2.Rows.Count; i++)
                {
                    if (tb2.Rows[i]["职员代码"].ToString() != "")
                    {
                        //根据代码获取表数据
                        oOrg.GetInfoByNumber(tb2.Rows[i]["组织代码"].ToString());
                        oDept.GetInfoByNumber(tb2.Rows[i]["部门代码"].ToString());
                        oGroup.GetInfoByNumber(tb2.Rows[i]["班组代码"].ToString());
                        oEmp.GetInfoByNumber(tb2.Rows[i]["职员代码"].ToString());

                        //获取内码
                        Int64 HOrgID = oOrg.omodel.HItemID;
                        Int64 HDeptID = oDept.omodel.HItemID;
                        Int64 HGroupID = oGroup.omodel.HItemID;
                        Int64 HEmpID = oEmp.omodel.HItemID;

                        for (int j = 12; j < tb2.Columns.Count - 1; j++)
                        {
                            oDuSItem.GetInfoByName(tb2.Columns[j].ColumnName);
                            Int64 HDuSID = oDuSItem.omodel.HItemID;
                            string HDuSNumber = oDuSItem.omodel.HNumber;
                            string HDuSName = oDuSItem.omodel.HName;
                            double HMoney = double.Parse(tb2.Rows[i][tb2.Columns[j].ColumnName].ToString());

                            string sql = "insert into diyipi_Pay_DuSubsidyItemBill(HDate,HYear,HPeriod,HOrgID,HOrgNumber,HOrgName,HDeptID,HDeptNumber,HDeptName" +
                                ",HGroupID,HGroupNumber,HGroupName,HRemarkMain,HEmpID,HEmpNumber,HEmpName,HDuSubsidyItemID,HDuSubsidyItemNumber,HDuSubsidyItemName,HMoney,HRemarkSub) " +
                                "values(" +
                                "'" + tb2.Rows[i]["日期"].ToString() +
                                "'," + int.Parse(tb2.Rows[i]["年"].ToString()) +
                                "," + int.Parse(tb2.Rows[i]["月"].ToString()) +
                                "," + HOrgID +
                                ",'" + tb2.Rows[i]["组织代码"].ToString() +
                                "','" + tb2.Rows[i]["组织"].ToString() +
                                "'," + HDeptID +
                                ",'" + tb2.Rows[i]["部门代码"].ToString() +
                                "','" + tb2.Rows[i]["部门名称"].ToString() +
                                "'," + HGroupID +
                                ",'" + tb2.Rows[i]["班组代码"].ToString() +
                                "','" + tb2.Rows[i]["班组"].ToString() +
                                "','" + tb2.Rows[i]["表头备注"].ToString() +
                                "'," + HEmpID +
                                ",'" + tb2.Rows[i]["职员代码"].ToString() +
                                "','" + tb2.Rows[i]["职员名称"].ToString() +
                                "'," + HDuSID +
                                ",'" + HDuSNumber +
                                "','" + HDuSName +
                                "'," + HMoney +
                                ",'" + tb2.Rows[i]["表体备注"] +
                                "')";
                            oCn.RunProc(sql);
                        }
                    }
                    
                }
                oCn.Commit();

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = error;
                objJsonResult.data = tb2;
                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 检查导入文件的数据
        private object Checkdata(DataTable dt)
        {
            bool b = false;
            string sErrMsg = "";
            string sMsg = "";
            for (int i = 0; i <= dt.Rows.Count - 1; i++)
            {
                string HDeptNumber = "";
                string HGroupNumber = "";
                string HEmpNumber = "";
                double HMoney = 0;

                HDeptNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["部门代码"].ToString());
                HGroupNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["班组代码"].ToString());
                HEmpNumber = DBUtility.ClsPub.isStrNull(dt.Rows[i]["职员代码"].ToString());
                if (HEmpNumber != "")
                {
                    int index = i + 1;                                                                  //记录当前检验数据位于导入文件的第几行

                    //审核代码是否合理
                    if (!DBUtility.ClsPub.AllowNumber(HDeptNumber))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "部门代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    if (!DBUtility.ClsPub.AllowNumber(HGroupNumber))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "班组代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    if (!DBUtility.ClsPub.AllowNumber(HEmpNumber))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "职员代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }

                    //得到部门内码
                    if (!oDept.GetInfoByNumber(HDeptNumber))
                    {
                        sMsg = "[" + HDeptNumber + "]部门不存在";
                        if (sErrMsg.Contains(sMsg) == false)
                        {
                            sErrMsg = sErrMsg + "[" + HDeptNumber + "]部门不存在\r\n";
                        }
                        b = true;
                    }
                    //得到班组内码
                    if (!oGroup.GetInfoByNumber(HGroupNumber))
                    {
                        sMsg = "[" + HGroupNumber + "]班组不存在";
                        if (sErrMsg.Contains(sMsg) == false)
                        {
                            sErrMsg = sErrMsg + "[" + HGroupNumber + "]班组不存在\r\n";
                        }
                        b = true;
                    }

                    //得到职员内码
                    if (!oEmp.GetInfoByNumber(HEmpNumber))
                    {
                        sMsg = "[" + HEmpNumber + "]职员不存在";
                        if (sErrMsg.Contains(sMsg) == false)
                        {
                            sErrMsg = sErrMsg + "[" + HEmpNumber + "]职员不存在\r\n";
                        }
                        b = true;
                    }
                    //检验导入文件中的扣补项目是否存在、值是否合法
                    for(int j=12; j < dt.Columns.Count-1; j++)
                    {
                        //检验导入文件中的扣补项目是否存在
                        if (!oDuSItem.GetInfoByName(dt.Columns[j].ColumnName))
                        {
                            sMsg = "[" + dt.Columns[j].ColumnName + "]扣补项目不存在";
                            if (sErrMsg.Contains(sMsg) == false)
                            {
                                sErrMsg = sErrMsg + "[" + dt.Columns[j].ColumnName + "]扣补项目不存在\r\n";
                            }
                            b = true;
                        }
                        //检验导入文件中的扣补项目值是否合法
                        if ( !Regex.IsMatch( dt.Rows[i][dt.Columns[j].ColumnName].ToString(), @"^\d+(\.\d+)?$"))
                        {
                            sMsg = "[" + dt.Columns[j].ColumnName + "]数据格式错误，请输入非负数";
                            if (sErrMsg.Contains(sMsg) == false)
                            {
                                sErrMsg = sErrMsg + "[" + dt.Columns[j].ColumnName + "]数据格式错误，请输入非负数\r\n";
                            }
                            b = true;
                        }
                    }
                }
            }
            if (b == true)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = sErrMsg;
                objJsonResult.data = null;
                return objJsonResult;
            }
            else
            {
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = sErrMsg;
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 扣补项目费用单 保存导入数据
        [Route("Pay_DuSubsidyItemBill/Pay_DuSubsidyItemBillSaveImport")]
        [HttpGet]
        public object Pay_DuSubsidyItemBillSaveImport(string user)
        {
            try
            {
                //查看权限
                if (!DBUtility.ClsPub.Security_Log("Pay_DuSubsidyItemBill_Edit", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无新增权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //获取临时表数据
                ds = oCn.RunProcReturn("select * from diyipi_Pay_DuSubsidyItemBill order by HDate desc,HYear desc,HPeriod desc,HOrgID desc,HDeptID desc,HGroupID desc,HRemarkMain desc,HEmpID desc", "diyipi_Pay_DuSubsidyItemBill");
                if (ds==null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败：数据未导入成功，请重新导入数据！！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //保存数据
                oCn.BeginTran();
                DataTable dt = ds.Tables[0];
                Pay_DuSubsidyItemBillMain mainTable = new Pay_DuSubsidyItemBillMain();
                List<Pay_DuSubsidyItemBillSub> subTable = new List<Pay_DuSubsidyItemBillSub>();
                int HOrgID = 0;
                int HYear = 0;
                int HPeriod = 0;
                string compareText = "";

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string compareText1 = dt.Rows[i]["HDate"].ToString() +
                        "" + dt.Rows[i]["HYear"].ToString() +
                        "" + dt.Rows[i]["HPeriod"].ToString() +
                        "" + dt.Rows[i]["HOrgID"].ToString() +
                        "" + dt.Rows[i]["HDeptID"].ToString() +
                        "" + dt.Rows[i]["HGroupID"].ToString() +
                        "" + dt.Rows[i]["HRemarkMain"].ToString() +
                        "" + dt.Rows[i]["HEmpID"].ToString();
                    if(compareText != compareText1)
                    {
                        if (subTable.Count>0)
                        {
                            objJsonResult = SaveImport_AddBillMain(mainTable, subTable, HOrgID, HYear, HPeriod, user);
                            if (objJsonResult.code == "0")
                            {
                                objJsonResult.code = "0";
                                objJsonResult.count = 0;
                                objJsonResult.Message = objJsonResult.Message;
                                objJsonResult.data = null;
                                return objJsonResult;
                            }
                            mainTable = new Pay_DuSubsidyItemBillMain();
                            subTable.Clear();
                        }
                        compareText = compareText1;
                        mainTable.HDate = dt.Rows[i]["HDate"].ToString();
                        mainTable.HDeptID = int.Parse(dt.Rows[i]["HDeptID"].ToString());
                        mainTable.HGroupID = int.Parse(dt.Rows[i]["HGroupID"].ToString());
                        mainTable.HRemark = dt.Rows[i]["HRemarkMain"].ToString();
                        mainTable.HMaker = user;
                        mainTable.HMakerDate = DateTime.Now.ToString("yyyy-MM-dd");
                        HOrgID = int.Parse(dt.Rows[i]["HOrgID"].ToString());
                        HYear = int.Parse(dt.Rows[i]["HYear"].ToString());
                        HPeriod = int.Parse(dt.Rows[i]["HPeriod"].ToString());
                    }

                    Pay_DuSubsidyItemBillSub oSub = new Pay_DuSubsidyItemBillSub();
                    oSub.HEmpID = int.Parse(dt.Rows[i]["HEmpID"].ToString());
                    oSub.HDuSubsidyItemID = int.Parse(dt.Rows[i]["HDuSubsidyItemID"].ToString());
                    oSub.HQty = 0;
                    oSub.HPrice = 0;
                    oSub.HMoney = double.Parse(dt.Rows[i]["HMoney"].ToString());
                    oSub.HRemark = dt.Rows[i]["HRemarkSub"].ToString();
                    subTable.Add(oSub);
                }

                //添加最后一次记录
                if (subTable.Count > 0)
                {
                    objJsonResult = SaveImport_AddBillMain(mainTable, subTable, HOrgID, HYear, HPeriod, user);
                    if (objJsonResult.code == "0")
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = objJsonResult.Message;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    mainTable = new Pay_DuSubsidyItemBillMain();
                    subTable.Clear();
                }


                oCn.Commit();

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

        #region 添加 扣补项目费用单 主表
        public json SaveImport_AddBillMain(Pay_DuSubsidyItemBillMain mainTable, List<Pay_DuSubsidyItemBillSub> subTable, int HOrgID, int Year, int Period, string user)
        {
            string HComputerName = SystemInformation.ComputerName; //设备名称

            try
            {
                List<Pay_DuSubsidyItemBillMain> mainList = new List<Pay_DuSubsidyItemBillMain>();
                mainList.Add(mainTable);


                int HYear = Year;
                int HPeriod = Period;
                string HBillType = "2233";
                string HBillSubType = "";
                int HBillStatus = 1;

                int HAutoSaveFlag = 0;


                Int64 HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo);
                string HBillNo = DBUtility.ClsPub.CreateBillCode(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
                string HDate = mainList[0].HDate;
                string HInnerBillNo = "";
                int HGroupID = mainList[0].HGroupID;
                int HDeptID = mainList[0].HDeptID;
                string HExplanation = "";
                string HRemark = mainList[0].HRemark;


                string HMaker = mainList[0].HMaker;
                string HMakerDate = mainList[0].HMakerDate;
               
                ds = oCn.RunProcReturn("select * from Pay_DuSubsidyItemBillMain where HInterID = " + HInterID + " and HBillNo = '" + HBillNo + "'", "Pay_DuSubsidyItemBillMain");

                //主表添加数据
                string sql = "insert into Pay_DuSubsidyItemBillMain" +
                    "(HYear,HPeriod,HBillType,HBillSubType,HBillStatus,HInterID,HBillNo,HDate,HInnerBillNo,HGroupID,HDeptID,HExplanation,HAutoSaveFlag,HRemark,HMaker,HMakeDate) " +
                    "values(" +
                    "" + HYear +
                    "," + HPeriod +
                    ",'" + HBillType +
                    "','" + HBillSubType +
                    "'," + HBillStatus +
                    "," + HInterID +
                    ",'" + HBillNo +
                    "','" + HDate +
                    "','" + HInnerBillNo +
                    "'," + HGroupID +
                    "," + HDeptID +
                    ",'" + HExplanation +
                    "'," + HAutoSaveFlag +
                    ",'" + HRemark +
                    "','" + HMaker +
                    "','" + HMakerDate +
                    "')";

                //主表
                oCn.RunProc(sql);
                LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",新增扣补项目费用单:" + HBillNo);
                oCn.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "新增扣补项目费用单：" + HBillNo + "','LMES-扣补项目费用单模块','" + DBUtility.ClsPub.IPAddress + "','新增单据'", ref DBUtility.ClsPub.sExeReturnInfo);
                
               
                //保存子表
                objJsonResult = SaveImport_AddBillSub(subTable, HInterID,HBillNo);

                if (objJsonResult.code == "0")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = objJsonResult.Message;
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = null;
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
        #region 添加 扣补项目费用单 子表
        public json SaveImport_AddBillSub(List<Pay_DuSubsidyItemBillSub> DetailColl, Int64 HInterID, string HBillNo)
        {
            int i = 0;                                          //作为子表内码
            foreach (Pay_DuSubsidyItemBillSub oSub in DetailColl)
            {
                i++;                                            //同一个主表下的子表的内码自增

                int HEntryID = i;

                int HEmpID = oSub.HEmpID;
                int HDuSubsidyItemID = oSub.HDuSubsidyItemID;
                double HQty = oSub.HQty;
                double HPrice = oSub.HPrice;
                double HMoney = oSub.HMoney;
                string HRemark = oSub.HRemark;

                string sql = "insert into Pay_DuSubsidyItemBillSub" +
                    "(HInterID,HEntryID,HEmpID,HDuSubsidyItemID,HQty,HPrice,HMoney,HRemark) " +
                    "values(" +
                    "" + HInterID +
                    "," + HEntryID +
                    "," + HEmpID +
                    "," + HDuSubsidyItemID +
                    "," + HQty +
                    "," + HPrice +
                    "," + HMoney +
                    ",'" + HRemark +
                    "')";

                oCn.RunProc(sql);
            }

            objJsonResult.code = "1";
            objJsonResult.count = 1;
            objJsonResult.Message = null;
            objJsonResult.data = null;
            return objJsonResult;
        }
        #endregion
        #endregion

        #region 扣补项目费用单_费用横向显示 获取扣补项目
        [Route("Pay_DuSubsidyItemBill_KS/getInitGrid_KS")]
        [HttpGet]
        public object getInitGrid_KS()
        {
            try
            {
                //获取未禁用的扣补项目
                string sql = "select * from Gy_DuSubsidyItem where HStopFlag = 0";
                ds = oCn.RunProcReturn(sql, "Gy_DuSubsidyItem");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "未找到相关扣补项目！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //处理扣补项目
                List<object> columnNameList = new List<object>();
                for(int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    string field = ds.Tables[0].Rows[i]["HItemID"].ToString();
                    string title = ds.Tables[0].Rows[i]["HName"].ToString();
                    string dataType = "decimal(18,2)";
                    string ColmString = "{\"field\":\"" + field + "\",\"title\":\"" + title + "\",\"dataType\":\"" + dataType + "\"}";
                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));
                }
                
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                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
    }
}