派生自 MES-WEB-API
WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs
@@ -1,4 +1,5 @@ using Newtonsoft.Json.Linq; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Pub_Class; using System; using System.Collections; @@ -31,6 +32,7 @@ { try { List<object> columnNameList = new List<object>(); //编辑权限 if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee", 1, false, user)) { @@ -43,19 +45,28 @@ string sql1 = string.Format(@"select * from h_v_IF_EmployeeList where 组织名称='" + Organization + "'"); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_EmployeeList"); ds = oCN.RunProcReturn(sql1 + sWhere + " order by 职员代码", "h_v_IF_EmployeeList"); } else { string sql = sql1 + sWhere + "order by HItemID desc"; string sql = sql1 + sWhere + " order by 职员代码"; ds = oCN.RunProcReturn(sql, "h_v_IF_EmployeeList"); } //添加列名 foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { @@ -317,8 +328,8 @@ 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; DateTime HInComDate = list[0].HInComDate; //进厂日期 DateTime HDimissionDate = list[0].HDimissionDate; //离职日期 (允许NULL) bool HOverType = list[0].HOverType; string HEmpType = list[0].HEmpType; string HOtherDeduct3 = list[0].HOtherDeduct3; @@ -327,23 +338,23 @@ string HMedicare = list[0].HMedicare; bool HNoBrushFlag = list[0].HNoBrushFlag; bool HShiftFlag = list[0].HShiftFlag; DateTime HContactDate = list[0].HContactDate; //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"); DateTime HStayCardEDate = list[0].HStayCardEDate; //暂住证到期日 DateTime HCheckCardEDate = Convert.ToDateTime("1900/1/1"); //审检证到期日 string HJobCardNo = list[0].HJobCardNo ?? ""; DateTime HJobCardEDate = Convert.ToDateTime("1900/1/1"); 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; DateTime HContractBDate = list[0].HContractBDate; //合同开始日 DateTime HContractEDate = list[0].HContractEDate; //合同到期日 string HInsuranceNo = list[0].HInsuranceNo; DateTime HInsuranceDate = list[0].HInsuranceDate; DateTime HInsuranceDate = list[0].HInsuranceDate; //参保日期 bool HInsuranceStatus = list[0].HInsuranceStatus; DateTime HSignDate = list[0].HSignDate; DateTime HSignDate = Convert.ToDateTime("1900/1/1"); //签约日期 bool HSignStatus = list[0].HSignStatus; string HOldCompany = list[0].HOldCompany ?? ""; string HMarr = list[0].HMarr ?? ""; @@ -352,7 +363,7 @@ string HSpec = list[0].HSpec ?? ""; string HCompLev = list[0].HCompLev ?? ""; string HEngLev = list[0].HEngLev ?? ""; DateTime HGradDate = list[0].HGradDate; DateTime HGradDate = list[0].HGradDate; //毕业日期 string HGradSchool = list[0].HGradSchool ?? ""; string HSalaryLev = list[0].HSalaryLev ?? ""; long HDutyID = list[0].HDutyID; @@ -378,10 +389,11 @@ string HStdDayPay = list[0].HStdDayPay ?? ""; string HMinDayPay = list[0].HMinDayPay ?? ""; string HMinMonthPay = list[0].HMinMonthPay ?? ""; DateTime HMadeDate = list[0].HMadeDate; //DateTime HMadeDate = list[0].HMadeDate; //建立日期 string HEmpRate = list[0].HEmpRate ?? ""; string HExamRate = list[0].HExamRate ?? ""; DateTime HHealthCardEDate = Convert.ToDateTime("1900/1/1"); DateTime HHealthCardEDate = Convert.ToDateTime("1900/1/1"); //健康证到期日 long HUSEORGID = list[0].HUSEORGID; ////判断权限 //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) @@ -432,25 +444,25 @@ ",HEmpType,HPayType,HOverType,HNoBrushFlag,HShiftFlag,HStopwagesFlag" + ",HPostalCode,HBank,HBasePay,HExamLevPostMoney,HBSTDeptID" + ",HOtherDeduct3,HInsurance,HMedicare,HDrydock" + ",HBankAccount,HGroupID,HDeptID,HWorkTypeID,HCTPrjID,HAddress" + ",HBankAccount,HGroupID,HDeptID,HWorkTypeID,HCTPrjID,HUSEORGID,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 + "'" + " 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 + "'" + ",'" + 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); ",'" + 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() + "','" + HUSEORGID + "','" + HAddress + "')", ref DBUtility.ClsPub.sExeReturnInfo); //修改上级为非末级代码 oCN.RunProc("Update Gy_Employee set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); @@ -555,7 +567,7 @@ } catch (Exception e) { oCN.RollBack(); //oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.Message; @@ -860,7 +872,7 @@ return objJsonResult; } oCN.RunProc("update Gy_Employee set HStopflag=1 where HItemID=" + HItemID); oCN.RunProc("delete from Gy_Employee where HItemID=" + HItemID); oCN.Commit();//提交事务 objJsonResult.code = "0"; objJsonResult.count = 1;
