From 6faa5645a611136fce797047a50f94ebafb47e68 Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期五, 21 一月 2022 11:30:25 +0800
Subject: [PATCH] nothing
---
WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs | 835 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 814 insertions(+), 21 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs
index c281276..5047ff9 100644
--- a/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs
@@ -7,6 +7,8 @@
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
+using WebAPI.Service;
+
namespace WebAPI.Controllers
{
public class Gy_EmployeeController : ApiController
@@ -25,36 +27,26 @@
/// </summary>
[Route("Gy_Employee/list")]
[HttpGet]
- public object list(string sWhere)
+ public object list(string sWhere,string Organization)
{
try
{
+ string sql1 = string.Format(@"select * from h_v_IF_EmployeeList where 缁勭粐鍚嶇О='" + Organization + "'");
if (sWhere == null || sWhere.Equals(""))
{
- ds = oCN.RunProcReturn("select * from h_v_IF_EmployeeList " + sWhere, "h_v_IF_EmployeeList");
+ ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_EmployeeList");
}
else
{
- string sql1 = "select * from h_v_IF_EmployeeList where 1 = 1 ";
- string sql = sql1 + sWhere;
+ string sql = sql1 + sWhere + "order by HItemID desc";
ds = oCN.RunProcReturn(sql, "h_v_IF_EmployeeList");
}
- if (ds == null || ds.Tables[0].Rows.Count == 0)
- {
- objJsonResult.code = "0";
- objJsonResult.count = 0;
- objJsonResult.Message = "false锛�";
- objJsonResult.data = null;
- return objJsonResult;
- }
- else
- {
- objJsonResult.code = "1";
- objJsonResult.count = 1;
- objJsonResult.Message = "Sucess锛�";
- objJsonResult.data = ds.Tables[0];
- return objJsonResult;
- }
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+
}
catch (Exception e)
{
@@ -66,8 +58,809 @@
}
}
+ ///// <summary>
+ ///// 鏂板鑱屽憳-淇濆瓨鎸夐挳
+ /////鍙傛暟锛歴tring 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;
+ // }
+
+ // //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
+ // 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>
+ /// 淇濆瓨鎸夐挳
+ ///鍙傛暟锛歴tring 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();
+ //鍙嶅簭鍒楀寲
+ 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
+ {
+ //鑻AINDI閲嶅鍒欓噸鏂拌幏鍙�
+ 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();
+ // //鑾峰彇鏈�澶D鍊艰祴鍊�
+ // 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)
+ {
+ DataSet ds;
+ //string ModRightNameCheck = "Sc_ProcessReport_check";
+ try
+ {
+ //鍒犻櫎鏉冮檺
+ //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName))
+ //{
+ // 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;
+ }
+ }
+
+
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1