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.Web;
using System.Web.Http;
using System.Windows.Forms;
using WebAPI.Models;

namespace WebAPI.Controllers.项目管理.工作任务
{
    public class HR_EmpEngageRequestBillController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;//单据状态（新增，修改，浏览，更新单价，变更）
        private json objJsonResult = new json();
        public DataSet ds = new DataSet();
        public SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        public DAL.ClsSc_ICMOBill BillOld = new DAL.ClsSc_ICMOBill();
        string user_LongShan = "";
        string HName_LongShan = "";

        #region 入职申请单 新增/编辑
        #region 入职申请单 表头数据
        public class HR_EmpEngageRequestBillMain
        {
            public int HInterID;
            public string HBillNo;
            public string HDate;
            public string HName;
            public string HSex;
            public string HMarr;
            public string HBirthday;
            public int HAge;
            public string HBlighty;
            public string HNation;
            public string HBlightyType;
            public string HGovStatus;
            public string HBloodType;
            public string HStature;
            public string HAvoird;
            public string HKnowLev;
            public string HProTitleID;
            public double HWantPay;
            public string HGradSchool;
            public string HGradDate;
            public string HSpec;
            public string HEngLev;
            public string HCompLev;
            public string HLinkPhone;
            public string HEmail;
            public string HNowAdd;
            public string HHomeAdd;
            public string HIDCard;
            public string HPostalCode;
            public string HOldCompany;
            public bool HInsuranceStatus;
            public string HInsuranceDate;
            public string HInsuranceNo;
            public string HContractBDate;
            public int HContractYear;
            public string HContractEDate;
            public string HJobCardEDate;
            public string HJobCardNo;
            public string HCheckCardEDate;
            public string HStayCardEDate;
            public string HHealthCardEDate;
            public string HArchivesNo;

            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 入职申请单 新增/编辑
        /// <summary>
        /// 新增单据-保存按钮
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("HR_EmpEngageRequestBill/AddEmpEngageRequestBill")]
        [HttpPost]
        public object AddEmpEngageRequestBill([FromBody] JObject sMainSub)
        {
            //获取参数
            var _value = sMainSub["sMainSub"].ToString();
            string msg1 = _value.ToString();
            //开始事务
            oCN.BeginTran();
            //保存主表
            objJsonResult = AddEmpEngageRequestBillMain(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 AddEmpEngageRequestBillMain(string msg1)
        {
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            int OperationType = int.Parse(sArray[1].ToString());//数据类型 1添加 3修改 2 复制
            string user = sArray[2].ToString();//用户名
            string HComputerName = SystemInformation.ComputerName; //设备名称
            user_LongShan = sArray[2].ToString();//用户名

            try
            {
                if(OperationType == 1)
                {
                    //判断是否有新增权限
                    if (!DBUtility.ClsPub.Security_Log("HR_EmpEngageRequestBill_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("HR_EmpEngageRequestBill_Edit", 1, false, user))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "无编辑权限!";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                
                msg2 = "[" + msg2.ToString() + "]";
                List<HR_EmpEngageRequestBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<HR_EmpEngageRequestBillMain>>(msg2);

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

                int HInterID = mainList[0].HInterID;
                string HBillNo = mainList[0].HBillNo;
                string HDate = mainList[0].HDate;
                string HName = mainList[0].HName;
                string HSex = mainList[0].HSex;
                string HMarr = mainList[0].HMarr;
                string HBirthday = mainList[0].HBirthday;
                int HAge = mainList[0].HAge;
                string HBlighty = mainList[0].HBlighty;
                string HNation = mainList[0].HNation;
                string HBlightyType = mainList[0].HBlightyType;
                string HGovStatus = mainList[0].HGovStatus;
                string HBloodType = mainList[0].HBloodType;
                string HStature = mainList[0].HStature;
                string HAvoird = mainList[0].HAvoird;
                string HKnowLev = mainList[0].HKnowLev;
                string HProTitleID = mainList[0].HProTitleID;
                double HWantPay = mainList[0].HWantPay;
                string HGradSchool = mainList[0].HGradSchool;
                string HGradDate = mainList[0].HGradDate;
                string HSpec = mainList[0].HSpec;
                string HEngLev = mainList[0].HEngLev;
                string HCompLev = mainList[0].HCompLev;
                string HLinkPhone = mainList[0].HLinkPhone;
                string HEmail = mainList[0].HEmail;
                string HNowAdd = mainList[0].HNowAdd;
                string HHomeAdd = mainList[0].HHomeAdd;
                string HIDCard = mainList[0].HIDCard;
                string HPostalCode = mainList[0].HPostalCode;
                string HOldCompany = mainList[0].HOldCompany;
                int HInsuranceStatus = mainList[0].HInsuranceStatus?1:0;
                string HInsuranceDate = mainList[0].HInsuranceDate;
                string HInsuranceNo = mainList[0].HInsuranceNo;
                string HContractBDate = mainList[0].HContractBDate;
                int HContractYear = mainList[0].HContractYear;
                string HContractEDate = mainList[0].HContractEDate;
                string HJobCardEDate = mainList[0].HJobCardEDate;
                string HJobCardNo = mainList[0].HJobCardNo;
                string HCheckCardEDate = mainList[0].HCheckCardEDate;
                string HStayCardEDate = mainList[0].HStayCardEDate;
                string HHealthCardEDate = mainList[0].HHealthCardEDate;
                string HArchivesNo = mainList[0].HArchivesNo;

                string HRemark = "";
                string HMaker = mainList[0].HMaker;
                string HMakerDate = mainList[0].HMakerDate;
                string HUpdater = mainList[0].HUpdater;
                string HUpdaterDate = mainList[0].HUpdaterDate;


                //if (OperationType == 2)
                //{
                //    ds = oCN.RunProcReturn("select * from PM_WorkTaskBillMain where HBillNo ='" + HBillNo + "'", "PM_WorkTaskBillMain");
                //    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 HR_EmpEngageRequestBillMain where HInterID = " + HInterID + " and HBillNo = '" + HBillNo + "'", "HR_EmpEngageRequestBillMain");

                if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//新增
                {
                    string sql = "insert into HR_EmpEngageRequestBillMain" +
                        "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HDate,HName,HSex,HMarr,HBirthday,HAge,HBlighty,HNation,HBlightyType,HGovStatus,HBloodType,HStature" +
                        ",HAvoird,HKnowLev,HProTitleID,HWantPay,HGradSchool ,HGradDate,HSpec,HEngLev,HCompLev,HLinkPhone ,HEmail,HNowAdd,HHomeAdd" +
                        ",HIDCard,HPostalCode,HOldCompany,HInsuranceStatus,HInsuranceDate,HInsuranceNo,HContractBDate,HContractYear,HContractEDate" +
                        ",HJobCardEDate,HJobCardNo,HCheckCardEDate,HStayCardEDate,HHealthCardEDate,HArchivesNo,HRemark,HMaker,HMakeDate)" +
                        "values(" +
                        "" + HYear +
                        "," + HPeriod +
                        ",'" + HBillType +
                        "','" + HBillSubType +
                        "'," + HInterID +
                        ",'" + HBillNo +
                        "','" + HDate +
                        "','" + HName +
                        "','" + HSex +
                        "','" + HMarr +
                        "','" + HBirthday +
                        "'," + HAge +
                        ",'" + HBlighty +
                        "','" + HNation +
                        "','" + HBlightyType +
                        "','" + HGovStatus +
                        "','" + HBloodType +
                        "','" + HStature +
                        "','" + HAvoird +
                        "','" + HKnowLev +
                        "','" + HProTitleID +
                        "'," + HWantPay +
                        ",'" + HGradSchool +
                        "','" + HGradDate +
                        "','" + HSpec +
                        "','" + HEngLev +
                        "','" + HCompLev +
                        "','" + HLinkPhone +
                        "','" + HEmail +
                        "','" + HNowAdd +
                        "','" + HHomeAdd +
                        "','" + HIDCard +
                        "','" + HPostalCode +
                        "','" + HOldCompany +
                        "'," + HInsuranceStatus +
                        ",'" + HInsuranceDate +
                        "','" + HInsuranceNo +
                        "','" + HContractBDate +
                        "'," + HContractYear +
                        ",'" + HContractEDate +
                        "','" + HJobCardEDate +
                        "','" + HJobCardNo +
                        "','" + HCheckCardEDate +
                        "','" + HStayCardEDate +
                        "','" + HHealthCardEDate +
                        "','" + HArchivesNo +
                        "','" + 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 HR_EmpEngageRequestBillMain set " +
                        "HYear = " + HYear +
                        ",HPeriod = " + HPeriod +
                        ",HBillType = '" + HBillType +
                        "',HBillSubType = '" + HBillSubType +
                        "', HBillNo = '" + HBillNo +
                        "', HDate = '" + HDate +
                        "', HName = '" + HName +
                        "', HSex = '" + HSex +
                        "', HMarr = '" + HMarr +
                        "', HBirthday = '" + HBirthday +
                        "', HAge = " + HAge +
                        ", HBlighty = '" + HBlighty +
                        "', HNation = '" + HNation +
                        "', HBlightyType = '" + HBlightyType +
                        "', HGovStatus = '" + HGovStatus +
                        "', HBloodType = '" + HBloodType +
                        "', HStature = '" + HStature +
                        "', HAvoird = '" + HAvoird +
                        "', HKnowLev = '" + HKnowLev +
                        "', HProTitleID = '" + HProTitleID +
                        "', HWantPay = " + HWantPay +
                        ", HGradSchool  = '" + HGradSchool +
                        "', HGradDate = '" + HGradDate +
                        "', HSpec = '" + HSpec +
                        "', HEngLev = '" + HEngLev +
                        "', HCompLev = '" + HCompLev +
                        "', HLinkPhone  = '" + HLinkPhone +
                        "', HEmail = '" + HEmail +
                        "', HNowAdd = '" + HNowAdd +
                        "', HHomeAdd = '" + HHomeAdd +
                        "', HIDCard = '" + HIDCard +
                        "', HPostalCode = '" + HPostalCode +
                        "', HOldCompany = '" + HOldCompany +
                        "', HInsuranceStatus = " + HInsuranceStatus +
                        ", HInsuranceDate = '" + HInsuranceDate +
                        "', HInsuranceNo = '" + HInsuranceNo +
                        "', HContractBDate = '" + HContractBDate +
                        "', HContractYear = " + HContractYear +
                        ", HContractEDate = '" + HContractEDate +
                        "', HJobCardEDate = '" + HJobCardEDate +
                        "', HJobCardNo = '" + HJobCardNo +
                        "', HCheckCardEDate = '" + HCheckCardEDate +
                        "', HStayCardEDate = '" + HStayCardEDate +
                        "', HHealthCardEDate = '" + HHealthCardEDate +
                        "', HArchivesNo = '" + HArchivesNo +
                        "',HUpdater = '" + HUpdater +
                        "',HUpdateDate = '" + HUpdaterDate +
                        "' where HInterID = " + HInterID;

                    oCN.RunProc(sql);

                    //删除子表
                    oCN.RunProc("delete from HR_EmpEngageRequestBillSub 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 = AddEmpEngageRequestBillSub(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 AddEmpEngageRequestBillSub(long HInterID, string HBillNo, int OperationType)
        {
            string sql = "insert into HR_EmpEngageRequestBillSub" +
                "(HInterID,HEntryID,HRemark) " +
                "values(" +
                "" + HInterID +
                "," + 1 +
                ",'" + "" +
                "')";

            oCN.RunProc(sql);

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

        #region 入职申请单列表 查询
        /// <summary>
        /// 返回项目阶段列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("HR_EmpEngageRequestBill/list")]
        [HttpGet]
        public object getEmpEngageRequestBill(string sWhere, string user)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                //查看权限
                //if (!DBUtility.ClsPub.Security_Log("Gy_ProjectStage_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "无查看权限！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_HR_EmpEngageRequestBillList order by 单据号 ", "h_v_HR_EmpEngageRequestBillList");
                }
                else
                {
                    string sql1 = "select * from h_v_HR_EmpEngageRequestBillList where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by 单据号 ";
                    ds = oCN.RunProcReturn(sql, "h_v_HR_EmpEngageRequestBillList");
                }

                //添加列名
                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 入职申请单 编辑-页面赋值
        /// <summary>
        ///参数：string HInterID。
        ///返回值：object。
        /// </summary>
        [Route("HR_EmpEngageRequestBill/editInit")]
        [HttpGet]
        public object getEmpEngageRequestBilleditInit(string HInterID, string user)
        {
            try
            {
                //查看权限
                if (!DBUtility.ClsPub.Security_Log("HR_EmpEngageRequestBill_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_HR_EmpEngageRequestBill_EditInit " + HInterID, "h_p_HR_EmpEngageRequestBill_EditInit");

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

        #region 入职申请单 删除
        /// <summary>
        ///参数：string HInterID。
        ///返回值：object。
        /// </summary>
        [Route("HR_EmpEngageRequestBill/delete")]
        [HttpGet]
        public object deleteEmpEngageRequestBill(string HInterID, string user)
        {
            try
            {
                //查看权限
                if (!DBUtility.ClsPub.Security_Log("HR_EmpEngageRequestBill_Drop", 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;
                }

                oCN.BeginTran();

                oCN.RunProc("delete from HR_EmpEngageRequestBillMain where HInterID = " + HInterID);
                oCN.RunProc("delete from HR_EmpEngageRequestBillSub where HInterID= " + HInterID);

                oCN.Commit();

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                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 入职申请单 审核/反审核
        /// <summary>
        /// 
        /// </summary>
        /// <param name="HInterID">单据ID</param>
        /// <param name="IsAudit">审核(0),反审核(1)</param>
        /// <param name="CurUserName">审核人</param>
        /// <returns></returns>
        [Route("HR_EmpEngageRequestBill/AuditHR_EmpEngageRequestBill")]
        [HttpGet]
        public object AuditHR_EmpEngageRequestBill(string HInterID, int Type, string user)
        {
            try
            {
                //判断是否有审核权限
                if (!DBUtility.ClsPub.Security_Log("HR_EmpEngageRequestBill_Check", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无权限审核!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (string.IsNullOrWhiteSpace(HInterID))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HInterID为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ClsPub.CurUserName = user;
                BillOld.MvarItemKey = "HR_EmpEngageRequestBillMain";
                oCN.BeginTran();//开始事务

                //Type 1 审核  2  反审核
                if (Type == 1)
                {
                    //判断单据是否已经审核
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已审核!不需要再审核!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //审核单据
                    if (!BillOld.CheckBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    //判断单据是否已经反审核
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HChecker"] == null || ds.Tables[0].Rows[0]["HChecker"].ToString() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已反审核!不需要再反审核!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //反审核单据
                    if (!BillOld.AbandonCheck(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "反审核失败!原因:" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                oCN.Commit();//提交事务

                objJsonResult.code = "0";
                objJsonResult.count = 1;
                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 入职申请单 关闭/反关闭功能
        [Route("HR_EmpEngageRequestBill/CloseHR_EmpEngageRequestBill")]
        [HttpGet]
        public object CloseHR_EmpEngageRequestBill(string HInterID, int Type, string user)
        {
            try
            {
                //判断是否有删除权限
                if (!DBUtility.ClsPub.Security_Log("HR_EmpEngageRequestBill_Close", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无权限关闭!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (string.IsNullOrWhiteSpace(HInterID))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HInterID为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ClsPub.CurUserName = user;
                BillOld.MvarItemKey = "HR_EmpEngageRequestBillMain";
                oCN.BeginTran();//开始事务

                //Type 1 关闭  2  反关闭
                if (Type == 1)
                {
                    //判断单据是否已经关闭
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已关闭!不需要再关闭!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //关闭单据
                    if (!BillOld.CloseBill(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "关闭失败!原因:" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    //判断单据是否已经反关闭
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HCloseMan"] == null || ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已反关闭!不需要再反关闭!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //反关闭单据
                    if (!BillOld.CancelClose(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "反关闭失败!原因:" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                oCN.Commit();//提交事务

                objJsonResult.code = "0";
                objJsonResult.count = 1;
                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 入职申请单 作废/反作废功能
        [Route("HR_EmpEngageRequestBill/DropHR_EmpEngageRequestBill")]
        [HttpGet]
        public object DropHR_EmpEngageRequestBill(string HInterID, int Type, string user)
        {
            try
            {
                //判断是否有作废权限
                if (!DBUtility.ClsPub.Security_Log("HR_EmpEngageRequestBill_Delete", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无权限作废!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (string.IsNullOrWhiteSpace(HInterID))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HInterID为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ClsPub.CurUserName = user;
                BillOld.MvarItemKey = "HR_EmpEngageRequestBillMain";
                oCN.BeginTran();//开始事务

                //Type 1 作废  2  反作废
                if (Type == 1)
                {
                    //判断单据是否已经作废
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已作废!不需要再作废!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //作废单据
                    if (!BillOld.Cancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "作废失败!原因:" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }
                else
                {
                    //判断单据是否已经反作废
                    DataSet ds;
                    string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID;
                    ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey);
                    if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
                    {
                        if (ds.Tables[0].Rows[0]["HDeleteMan"] == null || ds.Tables[0].Rows[0]["HDeleteMan"].ToString() == "")
                        {
                            objJsonResult.code = "0";
                            objJsonResult.count = 0;
                            objJsonResult.Message = "单据已反作废!不需要再反作废!";
                            objJsonResult.data = null;
                            return objJsonResult;
                        }
                    }
                    //反作废单据
                    if (!BillOld.AbandonCancelltion(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo))
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "反作废失败!原因:" + ClsPub.sExeReturnInfo;
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                }

                oCN.Commit();//提交事务

                objJsonResult.code = "0";
                objJsonResult.count = 1;
                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
    }
}