智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
jhz
2022-07-26 1f49f98a07ae1c31a1967c5c36b382d6c855becd 
 WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs


@@ -27,36 +27,35 @@


        /// </summary>


        [Route("Gy_Employee/list")]


        [HttpGet]


        public object list(string sWhere)


        public object list(string sWhere,string user,string Organization)


        {


            try


            {


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_IF_EmployeeList  where  禁用标记='' ", "h_v_IF_EmployeeList");


                }


                else


                {


                    string sql1 = "select * from h_v_IF_EmployeeList where 禁用标记='' ";


                    string sql = sql1 + sWhere;


                    ds = oCN.RunProcReturn(sql, "h_v_IF_EmployeeList");


                }


                if (ds == null || ds.Tables[0].Rows.Count == 0)


                //编辑权限


                if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee", 1, false, user))


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "false！";


                    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


                {


                    objJsonResult.code = "1";


                    objJsonResult.count = 1;


                    objJsonResult.Message = "Sucess！";


                    objJsonResult.data = ds.Tables[0];


                    return objJsonResult;


                    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)


            {


@@ -68,191 +67,191 @@


            }


        }




        /// <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() + "]";


        ///// <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);


        //        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;


                string 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;


        //        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;


                }


        //        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;


            }


        }


        //        //若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。


@@ -271,9 +270,20 @@


                string msg1 = _value.ToString();


                string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);


                string msg2 = sArray[0].ToString();


                //string msg3 = sArray[1].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);


@@ -284,22 +294,22 @@


                string HShortNumber = list[0].HNumber;


                long HParentID = list[0].HParentID;


                long HLevel = 1;


                string HHelpCode = list[0].HHelpCode;


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


                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;


@@ -323,58 +333,57 @@


                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;


                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;


                string HInsuranceStatus = list[0].HInsuranceStatus;


                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;


                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;


                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;


                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;


                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;




                string HEmpRate = list[0].HEmpRate ?? "";


                string HExamRate = list[0].HExamRate ?? "";


                DateTime HHealthCardEDate = Convert.ToDateTime("1900/1/1");


                ////判断权限


                //if (!ClsPub.Security_Log(msg5, 1, true, msg4))


                //if (!ClsPub.Security_Log(msg5, 1, false, msg4))


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


@@ -429,7 +438,7 @@


                      "," + 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) +


                      "," + 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 + "'" +


@@ -450,24 +459,90 @@


                    //若MAINDI重复则重新获取


                    oCN.BeginTran();


                    oCN.RunProc("Update Gy_Employee set " +


                      "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" + "'  Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);


                    oCN.RunProc("Update Gy_Employee set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);


                    " 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";


@@ -584,7 +659,7 @@


        //                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() == "")


@@ -739,21 +814,20 @@


        /// <returns></returns>


        [Route("DeltetGy_Employee")]


        [HttpGet]


        public object DeltetGy_Employee(string HItemID)


        public object DeltetGy_Employee(string HItemID,string user)


        {


            DataSet ds;


            //string ModRightNameCheck = "Sc_ProcessReport_check";


            try


            {


                //删除权限


                //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName))


                //{


                //    objJsonResult.code = "0";


                //    objJsonResult.count = 0;


                //    objJsonResult.Message = "审核失败！无权限！";


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


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