using Newtonsoft.Json.Linq;
using Pub_Class;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
using WebAPI.Service;

namespace WebAPI.Controllers
{
    public class Gy_EmployeeController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;

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


        /// <summary>
        /// 返回职员列表
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_Employee/list")]
        [HttpGet]
        public object list(string sWhere,string user,string Organization)
        {
            try
            {
                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无查看权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                string sql1 = string.Format(@"select * from h_v_IF_EmployeeList where 组织名称='" + Organization + "'");
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn(sql1 + sWhere + " order by 职员代码", "h_v_IF_EmployeeList");
                }
                else
                {
                    string sql = sql1 + sWhere + " order by 职员代码";
                    ds = oCN.RunProcReturn(sql, "h_v_IF_EmployeeList");
                }
                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;
            }
        }

        ///// <summary>
        ///// 新增职员-保存按钮
        /////参数：string sql。
        /////返回值：object。
        ///// </summary>
        //[Route("Gy_Employee/AddNew")]
        //[HttpPost]
        //public object AddNew([FromBody] JObject oMain)
        //{
        //    try
        //    {
        //        var _value = oMain["oMain"].ToString();
        //        string msg1 = _value.ToString();
        //        //反序列化
        //        msg1 = "[" + msg1.ToString() + "]";

        //        DAL.ClsGy_Employee_Ctl oDept = new DAL.ClsGy_Employee_Ctl();
        //        DAL.ClsGy_Employee_View oDeptHlp = new DAL.ClsGy_Employee_View();
        //        List<Gy_Employee> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Employee>>(msg1);

        //        long HItemID = list[0].HItemID;
        //        string HNumber = list[0].HNumber;
        //        string HName = list[0].HName;
        //        string HShortNumber = list[0].HNumber;
        //        long HParentID = list[0].HParentID;
        //        long HLevel = 1;
        //        string HHelpCode = list[0].HHelpCode;
        //        bool HEndFlag = list[0].HEndFlag;
        //        bool HStopflag = list[0].HStopflag;
        //        string HRemark = list[0].HRemark;
        //        string HUseFlag = list[0].HUseFlag;
        //        string HSex = list[0].HSex;
        //        string HIDCard = list[0].HIDCard;
        //        string HBirthDay = list[0].HBirthDay;
        //        string HAddress = list[0].HAddress;
        //        string HLinkPhone = list[0].HLinkPhone;
        //        string HMobilePhone = list[0].HMobilePhone;
        //        string HFax = list[0].HFax;
        //        string HPostalCode = list[0].HPostalCode;
        //        string HEmail = list[0].HEmail;
        //        string HBank = list[0].HBank;
        //        string HBankAccount = list[0].HBankAccount;
        //        long HGroupID = list[0].HGroupID;
        //        long HDeptID = list[0].HDeptID;
        //        long HPostID = list[0].HPostID;
        //        long HWorkTypeID = list[0].HWorkTypeID;
        //        long HCTPrjID = list[0].HCTPrjID;
        //        long HProcID = list[0].HProcID;
        //        string HBasePay = list[0].HBasePay;
        //        DateTime HInComDate = list[0].HInComDate;
        //        DateTime HDimissionDate = list[0].HDimissionDate;
        //        bool HOverType = list[0].HOverType;
        //        string HEmpType = list[0].HEmpType;
        //        string HOtherDeduct3 = list[0].HOtherDeduct3;
        //        string HDrydock = list[0].HDrydock;
        //        string HInsurance = list[0].HInsurance;
        //        string HMedicare = list[0].HMedicare;
        //        bool HNoBrushFlag = list[0].HNoBrushFlag;
        //        bool HShiftFlag = list[0].HShiftFlag;
        //        DateTime HContactDate = list[0].HContactDate;
        //        bool HStopwagesFlag = list[0].HStopwagesFlag;
        //        string HDimissionReason = list[0].HDimissionReason;
        //        long HDormID = list[0].HDormID;
        //        string HArchivesNo = list[0].HArchivesNo;
        //        DateTime HStayCardEDate = list[0].HStayCardEDate;
        //        DateTime HCheckCardEDate = list[0].HCheckCardEDate;
        //        string HJobCardNo = list[0].HJobCardNo;
        //        DateTime HJobCardEDate = list[0].HJobCardEDate;
        //        string HWorkType = list[0].HWorkType;
        //        long HContractYear = list[0].HContractYear;
        //        DateTime HContractBDate = list[0].HContractBDate;
        //        DateTime HContractEDate = list[0].HContractEDate;
        //        string HInsuranceNo = list[0].HInsuranceNo;
        //        DateTime HInsuranceDate = list[0].HInsuranceDate;
        //        bool HInsuranceStatus = list[0].HInsuranceStatus;
        //        DateTime HSignDate = list[0].HSignDate;
        //        bool HSignStatus = list[0].HSignStatus;
        //        string HOldCompany = list[0].HOldCompany;
        //        string HMarr = list[0].HMarr;
        //        string HHomeAdd = list[0].HHomeAdd;
        //        string HNowAdd = list[0].HNowAdd;
        //        string HSpec = list[0].HSpec;
        //        string HCompLev = list[0].HCompLev;
        //        string HEngLev = list[0].HEngLev;
        //        DateTime HGradDate = list[0].HGradDate;
        //        string HGradSchool = list[0].HGradSchool;
        //        string HSalaryLev = list[0].HSalaryLev;
        //        long HDutyID = list[0].HDutyID;
        //        string HProTitleID = list[0].HProTitleID;
        //        string HKnowLev = list[0].HKnowLev;
        //        string HAvoird = list[0].HAvoird;
        //        string HStature = list[0].HStature;
        //        string HBloodType = list[0].HBloodType;
        //        string HBlightyType = list[0].HBlightyType;
        //        string HGovStatus = list[0].HGovStatus;
        //        string HNation = list[0].HNation;
        //        string HBlighty = list[0].HBlighty;
        //        long HAge = list[0].HAge;
        //        string HExamLevPostMoney = list[0].HExamLevPostMoney;
        //        string HBSTDeptID = list[0].HBSTDeptID;
        //        string HRelDate = list[0].HRelDate;
        //        string HHighestPay = list[0].HHighestPay;
        //        string HOverPayRate = list[0].HOverPayRate;
        //        string HLeftMoneyRate = list[0].HLeftMoneyRate;
        //        string HInsuranceSubsidy = list[0].HInsuranceSubsidy;
        //        string HPayType = list[0].HPayType;
        //        string HStdDayTimes = list[0].HStdDayTimes;
        //        string HStdDayPay = list[0].HStdDayPay;
        //        string HMinDayPay = list[0].HMinDayPay;
        //        string HMinMonthPay = list[0].HMinMonthPay;
        //        DateTime HMadeDate = list[0].HMadeDate;
        //        string HEmpRate = list[0].HEmpRate;
        //        string HExamRate = list[0].HExamRate;
        //        DateTime HHealthCardEDate = list[0].HHealthCardEDate;



        //        if (!DBUtility.ClsPub.AllowNumber(HNumber))
        //        {
        //            objJsonResult.code = "0";
        //            objJsonResult.count = 0;
        //            objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
        //            objJsonResult.data = null;
        //            return objJsonResult;
        //        }

        //        //若MAINDI重复则重新获取
        //        oCN.BeginTran();
        //        oCN.RunProc("Insert into Gy_Employee (" +
        //              "HNumber,HName,HShortNumber,HEmpRate,HExamRate" +
        //              ",HLevel,HParentID,HEndflag,HHighestPay,HOverPayRate" +
        //              ",HStopflag,HRemark,HHelpCode,HInsuranceSubsidy" +
        //              ",HBirthday,HGradDate,HInsuranceDate,HContractBDate,HContractEDate" +
        //              ",HJobCardEDate,HCheckCardEDate,HStayCardEDate,HHealthCardEDate" +
        //              ",HAge,HSalaryLev,HContractYear,HInsuranceStatus,HSignStatus" +
        //              ",HSex,HMarr,HBlighty,HNation,HBlightyType" +
        //              ",HGovStatus,HBloodType,HStature,HAvoird,HKnowLev" +
        //              ",HProTitleID,HGradSchool,HEngLev,HCompLev,HSpec" +
        //              ",HEmail,HNowAdd,HHomeAdd,HIDCard,HLinkPhone,HMobilePhone,HFax" +
        //              ",HOldCompany,HInsuranceNo,HJobCardNo,HArchivesNo,HWorkType,HDimissionReason" +
        //              ",HDimissionDate,HInComDate,HSignDate,HRelDate" +
        //              ",HPostID,HDormID,HDutyID,HLeftMoneyRate" +
        //              ",HEmpType,HPayType,HOverType,HNoBrushFlag,HShiftFlag,HStopwagesFlag" +
        //              ",HPostalCode,HBank,HBasePay,HExamLevPostMoney,HBSTDeptID" +
        //              ",HOtherDeduct3,HInsurance,HMedicare,HDrydock" +
        //              ",HBankAccount,HGroupID,HDeptID,HWorkTypeID,HCTPrjID,HAddress" +
        //              ") " +
        //              " Values('" + HNumber + "','" + HName + "','" + HShortNumber + "'," + HEmpRate.ToString() + "," + HExamRate.ToString() +
        //              "," + HLevel + "," + HParentID + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + HHighestPay.ToString() + "," + HOverPayRate.ToString() +
        //              "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'" + ",'" + HHelpCode + "'," + HInsuranceSubsidy.ToString() + "" +
        //              ",'" + HBirthDay + "','" + HGradDate + "','" + HInsuranceDate + "','" + HContractBDate + "','" + HContractEDate + "'" +
        //              ",'" + HJobCardEDate + "','" + HCheckCardEDate + "','" + HStayCardEDate + "','" + HHealthCardEDate + "'" +
        //              "," + HAge.ToString() + ",'" + HSalaryLev + "'," + HContractYear.ToString() + "," + HInsuranceStatus + "," + Convert.ToString(HSignStatus ? 1 : 0) +
        //              ",'" + HSex + "','" + HMarr + "','" + HBlighty + "','" + HNation + "','" + HBlightyType + "'" +
        //              ",'" + HGovStatus + "','" + HBloodType + "','" + HStature + "','" + HAvoird + "','" + HKnowLev + "'" +
        //              ",'" + HProTitleID + "','" + HGradSchool + "','" + HEngLev + "','" + HCompLev + "','" + HSpec + "'" +
        //              ",'" + HEmail + "','" + HNowAdd + "','" + HHomeAdd + "','" + HIDCard + "','" + HLinkPhone + "','" + HMobilePhone + "','" + HFax + "'" +
        //              ",'" + HOldCompany + "','" + HInsuranceNo + "','" + HJobCardNo + "','" + HArchivesNo + "','" + HWorkType + "','" + HDimissionReason + "'" +
        //              ",'" + HDimissionDate + "','" + HInComDate + "','" + HSignDate + "','" + HRelDate + "'" +
        //              "," + HPostID.ToString() + "," + HDormID.ToString() + "," + HDutyID.ToString() + "," + HLeftMoneyRate.ToString() +
        //              ",'" + HEmpType + "'" + ",'" + HPayType + "'" + "," + DBUtility.ClsPub.BoolToString(HOverType) + "" + "," + DBUtility.ClsPub.BoolToString(HNoBrushFlag) + "" + "," + DBUtility.ClsPub.BoolToString(HShiftFlag) + "" + "," + DBUtility.ClsPub.BoolToString(HStopwagesFlag) + "" +
        //              ",'" + HPostalCode + "','" + HBank + "'," + HBasePay.ToString() + "," + HExamLevPostMoney.ToString() + ",'" + HBSTDeptID + "'" +
        //              "," + HOtherDeduct3.ToString() + "" + "," + HInsurance.ToString() + "" + "," + HMedicare.ToString() + "" + "," + HDrydock.ToString() + "" +
        //              ",'" + HBankAccount + "'" + "," + HGroupID.ToString() + "" + "," + HDeptID.ToString() + "," + HWorkTypeID.ToString() + "," + HCTPrjID.ToString() + ",'" + HAddress + "'" +
        //              ")");
        //        //修改上级为非末级代码
        //        oCN.RunProc("Update Gy_Employee  set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);

        //        oCN.Commit();
        //        objJsonResult.code = "1";
        //        objJsonResult.count = 1;
        //        objJsonResult.Message = "新增单据成功！";
        //        //objJsonResult.data = null;
        //        return objJsonResult;
        //    }
        //    catch (Exception e)
        //    {
        //        oCN.RollBack();
        //        objJsonResult.code = "0";
        //        objJsonResult.count = 0;
        //        objJsonResult.Message = "Exception！" + e.Message;
        //        objJsonResult.data = null;
        //        return objJsonResult;
        //    }
        //}
        /// <summary>
        /// 保存按钮
        ///参数：string sql。
        ///返回值：object。
        /// </summary>
        [Route("Gy_Employee/ModifyByID")]
        [HttpPost]
        public object ModifyByID([FromBody] JObject oMain)
        {
            try
            {
                DAL.ClsGy_Employee_Ctl oDept = new DAL.ClsGy_Employee_Ctl();
                DAL.ClsGy_Employee_View oDeptHlp = new DAL.ClsGy_Employee_View();

                var _value = oMain["oMain"].ToString();
                string msg1 = _value.ToString();
                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
                string msg2 = sArray[0].ToString();
                string msg3 = sArray[1].ToString();
                //string msg4 = sArray[2].ToString();
                //string msg5 = sArray[3].ToString();

                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee_Edit", 1, false, msg3))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无保存权限！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //反序列化
                msg2 = "[" + msg2.ToString() + "]";
                List<Gy_Employee> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Employee>>(msg2);

                long HItemID = list[0].HItemID;
                string HNumber = list[0].HNumber;
                string HName = list[0].HName;
                string HShortNumber = list[0].HNumber;
                long HParentID = list[0].HParentID;
                long HLevel = 1;
                string HHelpCode = list[0].HHelpCode ?? "";
                bool HEndFlag = list[0].HEndFlag;
                bool HStopflag = list[0].HStopflag;
                string HRemark = list[0].HRemark;
                string HUseFlag = list[0].HUseFlag ?? "";
                string HSex = list[0].HSex;
                string HIDCard = list[0].HIDCard;
                string HBirthDay = list[0].HBirthDay;
                string HAddress = list[0].HAddress ?? "";
                string HLinkPhone = list[0].HLinkPhone;
                string HMobilePhone = list[0].HMobilePhone;
                string HFax = list[0].HFax;
                string HPostalCode = list[0].HPostalCode;
                string HEmail = list[0].HEmail;
                string HBank = list[0].HBank ?? "";
                string HBankAccount = list[0].HBankAccount ?? "";
                long HGroupID = list[0].HGroupID;
                long HDeptID = list[0].HDeptID;
                long HPostID = list[0].HPostID;
                long HWorkTypeID = list[0].HWorkTypeID;
                long HCTPrjID = list[0].HCTPrjID;
                long HProcID = list[0].HProcID;
                string HBasePay = list[0].HBasePay;
                DateTime HInComDate = list[0].HInComDate;
                DateTime HDimissionDate = list[0].HDimissionDate;
                bool HOverType = list[0].HOverType;
                string HEmpType = list[0].HEmpType;
                string HOtherDeduct3 = list[0].HOtherDeduct3;
                string HDrydock = list[0].HDrydock;
                string HInsurance = list[0].HInsurance;
                string HMedicare = list[0].HMedicare;
                bool HNoBrushFlag = list[0].HNoBrushFlag;
                bool HShiftFlag = list[0].HShiftFlag;
                DateTime HContactDate = list[0].HContactDate;
                bool HStopwagesFlag = list[0].HStopwagesFlag;
                string HDimissionReason = list[0].HDimissionReason;
                long HDormID = list[0].HDormID;
                string HArchivesNo = list[0].HArchivesNo;
                DateTime HStayCardEDate = list[0].HStayCardEDate;
                DateTime HCheckCardEDate = Convert.ToDateTime("1900/1/1");
                string HJobCardNo = list[0].HJobCardNo ?? "";
                DateTime HJobCardEDate = Convert.ToDateTime("1900/1/1");
                string HWorkType = list[0].HWorkType;
                long HContractYear = list[0].HContractYear;
                DateTime HContractBDate = list[0].HContractBDate;
                DateTime HContractEDate = list[0].HContractEDate;
                string HInsuranceNo = list[0].HInsuranceNo;
                DateTime HInsuranceDate = list[0].HInsuranceDate;
                bool HInsuranceStatus = list[0].HInsuranceStatus;
                DateTime HSignDate = list[0].HSignDate;
                bool HSignStatus = list[0].HSignStatus;
                string HOldCompany = list[0].HOldCompany ?? "";
                string HMarr = list[0].HMarr ?? "";
                string HHomeAdd = list[0].HHomeAdd ?? "";
                string HNowAdd = list[0].HNowAdd ?? "";
                string HSpec = list[0].HSpec ?? "";
                string HCompLev = list[0].HCompLev ?? "";
                string HEngLev = list[0].HEngLev ?? "";
                DateTime HGradDate = list[0].HGradDate;
                string HGradSchool = list[0].HGradSchool ?? "";
                string HSalaryLev = list[0].HSalaryLev ?? "";
                long HDutyID = list[0].HDutyID;
                string HProTitleID = list[0].HProTitleID ?? "";
                string HKnowLev = list[0].HKnowLev ?? "";
                string HAvoird = list[0].HAvoird ?? "";
                string HStature = list[0].HStature ?? "";
                string HBloodType = list[0].HBloodType ?? "";
                string HBlightyType = list[0].HBlightyType ?? "";
                string HGovStatus = list[0].HGovStatus ?? "";
                string HNation = list[0].HNation ?? "";
                string HBlighty = list[0].HBlighty ?? "";
                long HAge = list[0].HAge;
                string HExamLevPostMoney = list[0].HExamLevPostMoney ?? "";
                string HBSTDeptID = list[0].HBSTDeptID ?? "";
                string HRelDate = list[0].HRelDate ?? "";
                string HHighestPay = list[0].HHighestPay ?? "";
                string HOverPayRate = list[0].HOverPayRate ?? "";
                string HLeftMoneyRate = list[0].HLeftMoneyRate ?? "";
                string HInsuranceSubsidy = list[0].HInsuranceSubsidy ?? "";
                string HPayType = list[0].HPayType ?? "";
                string HStdDayTimes = list[0].HStdDayTimes ?? "";
                string HStdDayPay = list[0].HStdDayPay ?? "";
                string HMinDayPay = list[0].HMinDayPay ?? "";
                string HMinMonthPay = list[0].HMinMonthPay ?? "";
                DateTime HMadeDate = list[0].HMadeDate;
                string HEmpRate = list[0].HEmpRate ?? "";
                string HExamRate = list[0].HExamRate ?? "";
                DateTime HHealthCardEDate = Convert.ToDateTime("1900/1/1");

                ////判断权限
                //if (!ClsPub.Security_Log(msg5, 1, false, msg4))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "没有找到该功能模块！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                //if (!DBUtility.ClsPub.AllowNumber(HNumber))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                //if (oDept.HavSameNumber(HItemID, HNumber))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "代码重复！";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                //保存
                //保存完毕后处理
                if (HItemID == 0)
                {
                    oCN.BeginTran();
                    oCN.RunProc("Insert into Gy_Employee (" +
                      "HNumber,HName,HShortNumber,HEmpRate,HExamRate" +
                      ",HLevel,HParentID,HEndflag,HHighestPay,HOverPayRate" +
                      ",HStopflag,HRemark,HHelpCode,HInsuranceSubsidy" +
                      ",HBirthday,HGradDate,HInsuranceDate,HContractBDate,HContractEDate" +
                      ",HJobCardEDate,HCheckCardEDate,HStayCardEDate,HHealthCardEDate" +
                      ",HAge,HSalaryLev,HContractYear,HInsuranceStatus,HSignStatus" +
                      ",HSex,HMarr,HBlighty,HNation,HBlightyType" +
                      ",HGovStatus,HBloodType,HStature,HAvoird,HKnowLev" +
                      ",HProTitleID,HGradSchool,HEngLev,HCompLev,HSpec" +
                      ",HEmail,HNowAdd,HHomeAdd,HIDCard,HLinkPhone,HMobilePhone,HFax" +
                      ",HOldCompany,HInsuranceNo,HJobCardNo,HArchivesNo,HWorkType,HDimissionReason" +
                      ",HDimissionDate,HInComDate,HSignDate,HRelDate" +
                      ",HPostID,HDormID,HDutyID,HLeftMoneyRate" +
                      ",HEmpType,HPayType,HOverType,HNoBrushFlag,HShiftFlag,HStopwagesFlag" +
                      ",HPostalCode,HBank,HBasePay,HExamLevPostMoney,HBSTDeptID" +
                      ",HOtherDeduct3,HInsurance,HMedicare,HDrydock" +
                      ",HBankAccount,HGroupID,HDeptID,HWorkTypeID,HCTPrjID,HAddress" +
                      ") " +
                    " Values('" + HNumber + "','" + HName + "','" + HShortNumber + "'," + HEmpRate.ToString() + "," + HExamRate.ToString() +
                      "," + HLevel + "," + HParentID + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + HHighestPay.ToString() + "," + HOverPayRate.ToString() +
                      "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'" + ",'" + HHelpCode + "'," + HInsuranceSubsidy.ToString() + "" +
                      ",'" + HBirthDay + "','" + HGradDate + "','" + HInsuranceDate + "','" + HContractBDate + "','" + HContractEDate + "'" +
                      ",'" + HJobCardEDate + "','" + HCheckCardEDate + "','" + HStayCardEDate + "','" + HHealthCardEDate + "'" +
                      "," + HAge.ToString() + ",'" + HSalaryLev + "'," + HContractYear.ToString() + "," + Convert.ToString(HInsuranceStatus ? 1 : 0) + "," + Convert.ToString(HSignStatus ? 1 : 0) +
                      ",'" + HSex + "','" + HMarr + "','" + HBlighty + "','" + HNation + "','" + HBlightyType + "'" +
                      ",'" + HGovStatus + "','" + HBloodType + "','" + HStature + "','" + HAvoird + "','" + HKnowLev + "'" +
                      ",'" + HProTitleID + "','" + HGradSchool + "','" + HEngLev + "','" + HCompLev + "','" + HSpec + "'" +
                      ",'" + HEmail + "','" + HNowAdd + "','" + HHomeAdd + "','" + HIDCard + "','" + HLinkPhone + "','" + HMobilePhone + "','" + HFax + "'" +
                      ",'" + HOldCompany + "','" + HInsuranceNo + "','" + HJobCardNo + "','" + HArchivesNo + "','" + HWorkType + "','" + HDimissionReason + "'" +
                      ",'" + HDimissionDate + "','" + HInComDate + "','" + HSignDate + "','" + HRelDate + "'" +
                      "," + HPostID.ToString() + "," + HDormID.ToString() + "," + HDutyID.ToString() + "," + HLeftMoneyRate.ToString() +
                      ",'" + HEmpType + "'" + ",'" + HPayType + "'" + "," + DBUtility.ClsPub.BoolToString(HOverType) + "" + "," + DBUtility.ClsPub.BoolToString(HNoBrushFlag) + "" + "," + DBUtility.ClsPub.BoolToString(HShiftFlag) + "" + "," + DBUtility.ClsPub.BoolToString(HStopwagesFlag) + "" +
                      ",'" + HPostalCode + "','" + HBank + "'," + HBasePay.ToString() + "," + HExamLevPostMoney.ToString() + ",'" + HBSTDeptID + "'" +
                      "," + HOtherDeduct3.ToString() + "" + "," + HInsurance.ToString() + "" + "," + HMedicare.ToString() + "" + "," + HDrydock.ToString() + "" +
                      ",'" + HBankAccount + "'" + "," + HGroupID.ToString() + "" + "," + HDeptID.ToString() + "," + HWorkTypeID.ToString() + "," + HCTPrjID.ToString() + ",'" + HAddress + "'" + "')", ref DBUtility.ClsPub.sExeReturnInfo);
                    //修改上级为非末级代码
                    oCN.RunProc("Update Gy_Employee set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                    oCN.Commit();
                }
                else
                {
                    //若MAINDI重复则重新获取
                    oCN.BeginTran();
                    oCN.RunProc("Update Gy_Employee set " +
                    " HNumber='" +  HNumber + "'" +
                    ",HName='" +  HName + "'" +
                    ",HShortNumber='" +  HShortNumber + "'" +
                    ",HLevel=" +  HLevel +
                    ",HEmpRate=" +  HEmpRate +
                    ",HExamRate=" +  HExamRate +
                    ",HBasePay=" +  HBasePay +
                    ",HParentID=" +  HParentID +
                    ",HEndflag=" + Convert.ToString(HEndFlag ? 1 : 0) +
                    ",HStopflag=" + Convert.ToString( HStopflag ? 1 : 0) +
                    ",HNoBrushFlag=" + Convert.ToString( HNoBrushFlag ? 1 : 0) +
                    ",HOverType=" + Convert.ToString( HOverType ? 1 : 0) +
                    ",HShiftFlag=" + Convert.ToString( HShiftFlag ? 1 : 0) +
                    ",HStopwagesFlag=" + Convert.ToString( HStopwagesFlag ? 1 : 0) +
                    ",HRemark='" +  HRemark.ToString() + "'" +
                    ",HEmpType='" +  HEmpType.ToString() + "'" +
                    ",HPayType='" +  HPayType.ToString() + "'" +
                    ",HHelpCode='" +  HHelpCode.ToString() + "'" +
                    ",HAge=" +  HAge.ToString() +
                    ",HSalaryLev='" +  HSalaryLev.ToString() + "'" +
                    ",HContractYear=" +  HContractYear.ToString() +
                    ",HInsuranceStatus=" + Convert.ToString(HInsuranceStatus ? 1 : 0) +
                    ",HBirthday='" +  HBirthDay.ToString() + "'" +
                    ",HGradDate='" +  HGradDate.ToString() + "'" +
                    ",HInsuranceDate='" +  HInsuranceDate + "'" +
                    ",HContractBDate='" +  HContractBDate + "'" +
                    ",HContractEDate='" +  HContractEDate + "'" +
                    ",HJobCardEDate='" +  HJobCardEDate + "'" +
                    ",HCheckCardEDate='" +  HCheckCardEDate + "'" +
                    ",HStayCardEDate='" +  HStayCardEDate + "'" +
                    ",HHealthCardEDate='" +  HHealthCardEDate + "'" +
                    ",HSex='" +  HSex + "'" +
                    ",HMarr='" +  HMarr + "'" +
                    ",HBlighty='" +  HBlighty + "'" +
                    ",HNation='" +  HNation + "'" +
                    ",HBlightyType='" +  HBlightyType.ToString() + "'" +
                    ",HGovStatus='" +  HGovStatus.ToString() + "'" +
                    ",HBloodType='" +  HBloodType.ToString() + "'" +
                    ",HStature='" +  HStature.ToString() + "'" +
                    ",HAvoird='" +  HAvoird.ToString() + "'" +
                    ",HKnowLev='" +  HKnowLev.ToString() + "'" +
                    ",HProTitleID='" +  HProTitleID.ToString() + "'" +
                    ",HGradSchool='" +  HGradSchool.ToString() + "'" +
                    ",HEngLev='" +  HEngLev.ToString() + "'" +
                    ",HCompLev='" +  HCompLev.ToString() + "'" +
                    ",HSpec='" +  HSpec.ToString() + "'" +
                    ",HEmail='" +  HEmail.ToString() + "'" +
                    ",HNowAdd='" +  HNowAdd.ToString() + "'" +
                    ",HHomeAdd='" +  HHomeAdd.ToString() + "'" +
                    ",HIDCard='" +  HIDCard.ToString() + "'" +
                    ",HPostalCode='" +  HPostalCode.ToString() + "'" +
                    ",HLinkPhone='" +  HLinkPhone.ToString() + "'" +
                    ",HMobilePhone='" +  HMobilePhone.ToString() + "'" +
                    ",HFax='" +  HFax.ToString() + "'" +
                    ",HOldCompany='" +  HOldCompany.ToString() + "'" +
                    ",HInsuranceNo='" +  HInsuranceNo.ToString() + "'" +
                    ",HJobCardNo='" +  HJobCardNo.ToString() + "'" +
                    ",HArchivesNo='" +  HArchivesNo.ToString() + "'" +
                    ",HDimissionReason='" +  HDimissionReason.ToString() + "'" +
                    ",HDimissionDate='" +  HDimissionDate.ToString() + "'" +
                    ",HRelDate='" +  HRelDate.ToString() + "'" +
                    ",HInComDate='" +  HInComDate.ToString() + "'" +
                    ",HPostID =" +  HPostID.ToString() +
                    ",HDutyID =" +  HDutyID.ToString() +
                    ",HDormID =" +  HDormID.ToString() +
                    ",HBank='" +  HBank.ToString() + "'" +
                    ",HBankAccount='" +  HBankAccount.ToString() + "'" +
                    ",HGroupID='" +  HGroupID.ToString() + "'" +
                    ",HInsurance=" +  HInsurance.ToString() + "" +
                    ",HInsuranceSubsidy=" +  HInsuranceSubsidy.ToString() + "" +
                    ",HOtherDeduct3=" +  HOtherDeduct3.ToString() + "" +
                    ",HMedicare=" +  HMedicare.ToString() + "" +
                    ",HDrydock=" +  HDrydock.ToString() + "" +
                    ",HWorkType='" +  HWorkType.ToString() + "'" +
                    ",HWorkTypeID='" +  HWorkTypeID.ToString() + "'" +
                    ",HHighestPay=" +  HHighestPay.ToString() + "" +
                    ",HOverPayRate=" +  HOverPayRate.ToString() + "" +
                    ",HLeftMoneyRate=" +  HLeftMoneyRate.ToString() + "" +
                    ",HCTPrjID='" +  HCTPrjID.ToString() + "'" +
                    ",HExamLevPostMoney=" +  HExamLevPostMoney.ToString() +
                    ",HBSTDeptID='" +  HBSTDeptID.ToString() + "'" +

                    ",HAddress='" +  HAddress.ToString() + "'" +
                    ",HDeptID= '" +  HDeptID + "' Where HItemID=" + HItemID);
                    oCN.Commit();
                }
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "保存成功！";
                //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
                objJsonResult.data = 1;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.Message;
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        ///// <summary>
        ///// 保存职员
        ///// </summary>
        ///// <param name="msg"></param>
        ///// <returns></returns>
        //[Route("SaveGy_EmployeeList")]
        //[HttpPost]
        //public object SaveGy_EmployeeList([FromBody] JObject msg)
        //{
        //    DataSet ds;
        //    var _value = msg["msg"].ToString();
        //    string msg1 = _value.ToString();
        //    //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
        //    //string msg2 = sArray[0].ToString();
        //    //string msg3 = sArray[1].ToString();
        //    Int64 HItemID = 0;
        //    SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        //    //获取最大ID值赋值
        //    DataSet Maxds = oCN.RunProcReturn("select MAX(HItemID) HItemID from Gy_Employee ", "Gy_Employee");
        //    if (Maxds != null || Maxds.Tables[0].Rows.Count > 0)
        //    {
        //        //HItemID= Maxds.Tables[0].Rows[0]["HItemID"]
        //        var maxid = Convert.ToInt32(Maxds.Tables[0].Rows[0]["HItemID"]);
        //        maxid += 1;
        //        HItemID = maxid;
        //    }
        //    ListModels oListModels = new ListModels();
        //    try
        //    {
        //        DAL.ClsGy_Employee_Ctl oBill = new DAL.ClsGy_Employee_Ctl();
        //        List<Model.ClsGy_Employee_Model> lsmain = new List<Model.ClsGy_Employee_Model>();
        //        msg1 = msg1.Replace("\\", "");
        //        msg1 = msg1.Replace("\n", "");  //\n
        //        lsmain = oListModels.getObjectByJson_Gy_Employee(msg1);
        //        foreach (Model.ClsGy_Employee_Model oItem in lsmain)
        //        {
        //            if (oItem.HNumber.Trim() == "")
        //            {
        //                objJsonResult.code = "0";
        //                objJsonResult.count = 0;
        //                objJsonResult.Message = "保存失败！代码不能为空！";
        //                objJsonResult.data = 1;
        //                return objJsonResult;
        //            }
        //            if (oItem.HName.Trim() == "")
        //            {
        //                objJsonResult.code = "0";
        //                objJsonResult.count = 0;
        //                objJsonResult.Message = "保存失败！名称不能为空！";
        //                objJsonResult.data = 1;
        //                return objJsonResult;
        //            }
        //            //txtHInsuranceDate
        //            if (oItem.HInsuranceDate.Trim() != "")
        //            {
        //                if (DBUtility.ClsPub.isStrNull(DBUtility.ClsPub.isDate(oItem.HInsuranceDate.Trim())) == "1900-01-01 0:00:00")
        //                {
        //                    objJsonResult.code = "0";
        //                    objJsonResult.count = 0;
        //                    objJsonResult.Message = "保存失败！参保日期格式不对！";
        //                    objJsonResult.data = 1;
        //                    return objJsonResult;
        //                }
        //            }
        //            //txtHDimissionDate
        //            if (oItem.HDimissionDate.Trim() != "")
        //            {
        //                if (DBUtility.ClsPub.isStrNull(DBUtility.ClsPub.isDate(oItem.HDimissionDate.Trim())) == "1900-01-01 0:00:00")
        //                {
        //                    objJsonResult.code = "0";
        //                    objJsonResult.count = 0;
        //                    objJsonResult.Message = "保存失败！离职日期格式不对!！";
        //                    objJsonResult.data = 1;
        //                    return objJsonResult;
        //                }
        //            }
        //            //txtHStayCardEDate
        //            if (oItem.HStayCardEDate.Trim() != "")
        //            {
        //                if (DBUtility.ClsPub.isStrNull(DBUtility.ClsPub.isDate(oItem.HStayCardEDate.Trim())) == "1900-01-01 0:00:00")
        //                {
        //                    objJsonResult.code = "0";
        //                    objJsonResult.count = 0;
        //                    objJsonResult.Message = "保存失败！暂住证到期日格式不对!！";
        //                    objJsonResult.data = 1;
        //                    return objJsonResult;
        //                }
        //            }

        //            if (!DBUtility.ClsPub.AllowNumber(oItem.HNumber.Trim()))
        //            {
        //                objJsonResult.code = "0";
        //                objJsonResult.count = 0;
        //                objJsonResult.Message = "保存失败！代码中不能出现连续‘.’并且首位末位不能为‘.’！";
        //                objJsonResult.data = 1;
        //                return objJsonResult;
        //            }

        //            //查询数据中是否存在重复代码
        //            ds = oCN.RunProcReturn("select * from  Gy_Employee where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Gy_Employee");
        //            if (oItem.HNumber.Trim() == "")
        //            {
        //                objJsonResult.code = "0";
        //                objJsonResult.count = 0;
        //                objJsonResult.Message = "保存失败！代码为空！";
        //                objJsonResult.data = 1;
        //                return objJsonResult;
        //            }
        //            //新增时判断
        //            if (oItem.HItemID == 0)
        //            {
        //                if (ds == null || ds.Tables[0].Rows.Count == 0)
        //                {

        //                }
        //                else
        //                {
        //                    objJsonResult.code = "0";
        //                    objJsonResult.count = 0;
        //                    objJsonResult.Message = "保存失败！代码重复！";
        //                    objJsonResult.data = 1;
        //                    return objJsonResult;
        //                }
        //                //检查父级是否存在
        //                string sParent;
        //                sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
        //                if (sParent.Trim() == "")
        //                {
        //                    oBill.oModel.HParentID = 0;
        //                }
        //                else
        //                {
        //                    if (oBill.HavParentCode(sParent.Trim(), HItemID))
        //                    {
        //                        oBill.oModel.HParentID = oBill.oModel.HItemID;
        //                    }
        //                    else
        //                    {
        //                        objJsonResult.code = "0";
        //                        objJsonResult.count = 0;
        //                        objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
        //                        objJsonResult.data = 1;
        //                        return objJsonResult;
        //                    }
        //                }
        //            }
        //            else//编辑时判断
        //            {
        //                //检查父级是否存在
        //                string sParent;
        //                sParent = DBUtility.ClsPub.GetParentCode(oItem.HNumber.Trim());
        //                if (sParent.Trim() == "")
        //                {
        //                    oBill.oModel.HParentID = 0;
        //                }
        //                else
        //                {
        //                    if (oBill.HavParentCode(sParent.Trim(), oItem.HItemID))
        //                    {
        //                        oBill.oModel.HParentID = oBill.oModel.HItemID;
        //                    }
        //                    else
        //                    {
        //                        objJsonResult.code = "0";
        //                        objJsonResult.count = 0;
        //                        objJsonResult.Message = "保存失败！上级代码不存在或被禁用！";
        //                        objJsonResult.data = 1;
        //                        return objJsonResult;
        //                    }
        //                }
        //            }
        //            //得到短代码
        //            string sShortNumber;
        //            sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim());
        //            if (sShortNumber.Trim() == "")
        //            {
        //                objJsonResult.code = "0";
        //                objJsonResult.count = 0;
        //                objJsonResult.Message = "保存失败！短代码为空！";
        //                objJsonResult.data = 1;
        //                return objJsonResult;
        //            }
        //            if (DBUtility.ClsPub.isDate(oBill.oModel.HDimissionDate) < Convert.ToDateTime("1950-01-01"))
        //            {
        //                oBill.oModel.HDimissionDate = "2050-01-01";
        //            }
        //            oItem.HShortNumber = sShortNumber;//短代码
        //            oItem.HEndFlag = true;//末级标志
        //            oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //等级
        //            oBill.oModel = oItem;
        //        }

        //        //保存
        //        //保存完毕后处理
        //        bool bResult;
        //        if (oBill.oModel.HItemID == 0)
        //        {
        //            // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
        //            bResult = oBill.AddNew();
        //        }
        //        else
        //        {
        //            bResult = oBill.ModifyByID(oBill.oModel.HItemID);
        //        }
        //        if (bResult)
        //        {
        //            objJsonResult.code = "0";
        //            objJsonResult.count = 1;
        //            objJsonResult.Message = "保存成功！";
        //            //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
        //            objJsonResult.data = 1;
        //            return objJsonResult;
        //        }
        //        else
        //        {
        //            objJsonResult.code = "0";
        //            objJsonResult.count = 0;
        //            objJsonResult.Message = "保存失败！" + DBUtility.ClsPub.sExeReturnInfo;
        //            objJsonResult.data = 1;
        //            return objJsonResult;
        //        }
        //    }
        //    catch (Exception e)
        //    {
        //        objJsonResult.code = "0";
        //        objJsonResult.count = 0;
        //        objJsonResult.Message = "保存失败！" + e.ToString();
        //        objJsonResult.data = 1;
        //        return objJsonResult;
        //    }
        //}



        /// <summary>
        /// 职员设置获取信息
        /// </summary>
        /// <returns></returns>
        [Route("GetGy_EmployeeDetail")]
        [HttpGet]
        public ApiResult<DataSet> GetGy_EmployeeDetail(string HID)
        {
            var model = LuBaoSevice.GetGy_EmployeeBillDetail(HID);
            return model;
        }

        /// <summary>
        /// 职员设置删除功能
        /// </summary>
        /// <returns></returns>
        [Route("DeltetGy_Employee")]
        [HttpGet]
        public object DeltetGy_Employee(string HItemID,string user)
        {
            DataSet ds;
            try
            {
                //删除权限
                if (!DBUtility.ClsPub.Security_Log("Gy_Employee_Delete", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "无删除权限";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                if (string.IsNullOrWhiteSpace(HItemID))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "HItemID为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                oCN.BeginTran();//开始事务
                ds = oCN.RunProcReturn("select * from Gy_Employee where HItemID=" + HItemID, "Gy_Employee");
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "没有数据，无法删除！";
                    objJsonResult.data = null;
                    return objJsonResult; ;
                }
                var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]);
                if (HStopflag)
                {
                    oCN.RollBack();//回滚事务
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "数据已删除无法再次删除！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                oCN.RunProc("update Gy_Employee set HStopflag=1 where HItemID=" + HItemID);
                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;
            }
        }



    }
}