using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DAL
|
{
|
public class ClsGy_Employee_Ctl : DBUtility.ClsGy_Base_Ctl
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//原代码 用于 替换子项目
|
public string HOldNumber;
|
public Model.ClsGy_Employee_Model oModel = new Model.ClsGy_Employee_Model();
|
//新增
|
public override bool AddNew()
|
{
|
try
|
{
|
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('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HShortNumber + "'," + oModel.HEmpRate.ToString() + "," + oModel.HExamRate.ToString() +
|
"," + oModel.HLevel + "," + oModel.HParentID + "," + Convert.ToString(oModel.HEndflag ? 1 : 0) + "," + oModel.HHighestPay.ToString() + "," + oModel.HOverPayRate.ToString() +
|
"," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "'" + ",'" + oModel.HHelpCode + "'," + oModel.HInsuranceSubsidy.ToString() + "" +
|
",'" + oModel.HBirthDay +"','" + oModel.HGradDate + "','" + oModel.HInsuranceDate + "','" + oModel.HContractBDate + "','" + oModel.HContractEDate + "'" +
|
",'" + oModel.HJobCardEDate + "','" + oModel.HCheckCardEDate + "','" + oModel.HStayCardEDate + "','" + oModel.HHealthCardEDate + "'" +
|
"," + oModel.HAge.ToString() + ",'" + oModel.HSalaryLev + "'," + oModel.HContractYear.ToString() + "," + Convert.ToString(oModel.HInsuranceStatus ? 1 : 0) + "," + Convert.ToString(oModel.HSignStatus ? 1 : 0) +
|
",'" + oModel.HSex + "','" + oModel.HMarr + "','" + oModel.HBlighty + "','" + oModel.HNation + "','" + oModel.HBlightyType + "'" +
|
",'" + oModel.HGovStatus + "','" + oModel.HBloodType + "','" + oModel.HStature + "','" + oModel.HAvoird + "','" + oModel.HKnowLev + "'" +
|
",'" + oModel.HProTitleID + "','" + oModel.HGradSchool + "','" + oModel.HEngLev + "','" + oModel.HCompLev + "','" + oModel.HSpec + "'" +
|
",'" + oModel.HEmail + "','" + oModel.HNowAdd + "','" + oModel.HHomeAdd + "','" + oModel.HIDCard + "','" + oModel.HLinkPhone + "','" + oModel.HMobilePhone + "','" + oModel.HFax + "'" +
|
",'" + oModel.HOldCompany + "','" + oModel.HInsuranceNo + "','" + oModel.HJobCardNo + "','" + oModel.HArchivesNo + "','" + oModel.HWorkType + "','" + oModel.HDimissionReason + "'" +
|
",'" + oModel.HDimissionDate + "','" + oModel.HInComDate + "','" + oModel.HSignDate + "','" + oModel.HRelDate + "'" +
|
"," + oModel.HPostID.ToString() + "," + oModel.HDormID.ToString() + "," + oModel.HDutyID.ToString() + "," + oModel.HLeftMoneyRate.ToString() +
|
",'" + oModel.HEmpType + "'" + ",'" + oModel.HPayType + "'" + "," + DBUtility.ClsPub.BoolToString(oModel.HOverType) + "" + "," + DBUtility.ClsPub.BoolToString(oModel.HNoBrushFlag) + "" + "," + DBUtility.ClsPub.BoolToString(oModel.HShiftFlag) + "" + "," + DBUtility.ClsPub.BoolToString(oModel.HStopwagesFlag) + "" +
|
",'" + oModel.HPostalCode + "','" + oModel.HBank + "'," + oModel.HBasePay.ToString() + "," + oModel.HExamLevPostMoney.ToString() + ",'" + oModel.HBSTDeptID + "'" +
|
"," + oModel.HOtherDeduct3.ToString() + "" + "," + oModel.HInsurance.ToString() + "" + "," + oModel.HMedicare.ToString() + "" + "," + oModel.HDrydock.ToString() + "" +
|
",'" + oModel.HBankAccount + "'" + "," + oModel.HGroupID.ToString() + "" + "," + oModel.HDeptID.ToString() + "," + oModel.HWorkTypeID.ToString() + "," + oModel.HCTPrjID.ToString() + ",'" + oModel.HAddress + "'" +
|
")");
|
//修改上级为非末级代码
|
oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//修改
|
public override bool ModifyByID(Int64 sItemID)
|
{
|
try
|
{
|
oCn.BeginTran();
|
oCn.RunProc("Update Gy_Employee set " +
|
" HNumber='" + oModel.HNumber + "'" +
|
",HName='" + oModel.HName + "'" +
|
",HShortNumber='" + oModel.HShortNumber + "'" +
|
",HLevel=" + oModel.HLevel +
|
",HEmpRate=" + oModel.HEmpRate +
|
",HExamRate=" + oModel.HExamRate +
|
",HBasePay=" + oModel.HBasePay +
|
",HParentID=" + oModel.HParentID +
|
",HEndflag=" + Convert.ToString(oModel.HEndflag ? 1 : 0) +
|
",HStopflag=" + Convert.ToString(oModel.HStopflag ? 1 : 0) +
|
",HNoBrushFlag=" + Convert.ToString(oModel.HNoBrushFlag ? 1 : 0) +
|
",HOverType=" + Convert.ToString(oModel.HOverType ? 1 : 0) +
|
",HShiftFlag=" + Convert.ToString(oModel.HShiftFlag ? 1 : 0) +
|
",HStopwagesFlag=" + Convert.ToString(oModel.HStopwagesFlag ? 1 : 0) +
|
",HRemark='" + oModel.HRemark + "'" +
|
",HEmpType='" + oModel.HEmpType + "'" +
|
",HPayType='" + oModel.HPayType + "'" +
|
",HHelpCode='" + oModel.HHelpCode + "'" +
|
",HAge=" + oModel.HAge.ToString() +
|
",HSalaryLev='" + oModel.HSalaryLev + "'" +
|
",HContractYear=" + oModel.HContractYear.ToString() +
|
",HInsuranceStatus=" + Convert.ToString(oModel.HInsuranceStatus ? 1 : 0) +
|
",HBirthday='" + oModel.HBirthDay + "'" +
|
",HGradDate='" + oModel.HGradDate + "'" +
|
",HInsuranceDate='" + oModel.HInsuranceDate + "'" +
|
",HContractBDate='" + oModel.HContractBDate + "'" +
|
",HContractEDate='" + oModel.HContractEDate + "'" +
|
",HJobCardEDate='" + oModel.HJobCardEDate + "'" +
|
",HCheckCardEDate='" + oModel.HCheckCardEDate + "'" +
|
",HStayCardEDate='" + oModel.HStayCardEDate + "'" +
|
",HHealthCardEDate='" + oModel.HHealthCardEDate + "'" +
|
",HSex='" + oModel.HSex + "'" +
|
",HMarr='" + oModel.HMarr + "'" +
|
",HBlighty='" + oModel.HBlighty + "'" +
|
",HNation='" + oModel.HNation + "'" +
|
",HBlightyType='" + oModel.HBlightyType + "'" +
|
",HGovStatus='" + oModel.HGovStatus + "'" +
|
",HBloodType='" + oModel.HBloodType + "'" +
|
",HStature='" + oModel.HStature + "'" +
|
",HAvoird='" + oModel.HAvoird + "'" +
|
",HKnowLev='" + oModel.HKnowLev + "'" +
|
",HProTitleID='" + oModel.HProTitleID + "'" +
|
",HGradSchool='" + oModel.HGradSchool + "'" +
|
",HEngLev='" + oModel.HEngLev + "'" +
|
",HCompLev='" + oModel.HCompLev + "'" +
|
",HSpec='" + oModel.HSpec + "'" +
|
",HEmail='" + oModel.HEmail + "'" +
|
",HNowAdd='" + oModel.HNowAdd + "'" +
|
",HHomeAdd='" + oModel.HHomeAdd + "'" +
|
",HIDCard='" + oModel.HIDCard + "'" +
|
",HPostalCode='" + oModel.HPostalCode + "'" +
|
",HLinkPhone='" + oModel.HLinkPhone + "'" +
|
",HMobilePhone='" + oModel.HMobilePhone + "'" +
|
",HFax='" + oModel.HFax + "'" +
|
",HOldCompany='" + oModel.HOldCompany + "'" +
|
",HInsuranceNo='" + oModel.HInsuranceNo + "'" +
|
",HJobCardNo='" + oModel.HJobCardNo + "'" +
|
",HArchivesNo='" + oModel.HArchivesNo + "'" +
|
",HDimissionReason='" + oModel.HDimissionReason + "'" +
|
",HDimissionDate='" + oModel.HDimissionDate + "'" +
|
",HRelDate='" + oModel.HRelDate + "'" +
|
",HInComDate='" + oModel.HInComDate + "'" +
|
",HPostID =" + oModel.HPostID.ToString() +
|
",HDutyID =" + oModel.HDutyID.ToString() +
|
",HDormID =" + oModel.HDormID.ToString() +
|
",HBank='" + oModel.HBank + "'" +
|
",HBankAccount='" + oModel.HBankAccount + "'" +
|
",HGroupID='" + oModel.HGroupID + "'" +
|
",HInsurance=" + oModel.HInsurance.ToString() + "" +
|
",HInsuranceSubsidy=" + oModel.HInsuranceSubsidy.ToString() + "" +
|
",HOtherDeduct3=" + oModel.HOtherDeduct3.ToString() + "" +
|
",HMedicare=" + oModel.HMedicare.ToString() + "" +
|
",HDrydock=" + oModel.HDrydock.ToString() + "" +
|
",HWorkType='" + oModel.HWorkType + "'" +
|
",HWorkTypeID='" + oModel.HWorkTypeID.ToString() + "'" +
|
",HHighestPay=" + oModel.HHighestPay.ToString() + "" +
|
",HOverPayRate=" + oModel.HOverPayRate.ToString() + "" +
|
",HLeftMoneyRate=" + oModel.HLeftMoneyRate.ToString() + "" +
|
",HCTPrjID='" + oModel.HCTPrjID.ToString() + "'" +
|
",HExamLevPostMoney=" + oModel.HExamLevPostMoney +
|
",HBSTDeptID='" + oModel.HBSTDeptID.ToString() + "'" +
|
|
",HAddress='" + oModel.HAddress + "'" +
|
",HDeptID= '" + oModel.HDeptID + "' Where HItemID=" + sItemID);
|
//修改子项目代码
|
oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" + oModel.HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
|
//将上级 为非末级
|
oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
|
//
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
//根据代码判断信息
|
public override bool HavParentCode(string sCode, Int64 sItemID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select * from " + MvarItemKey + " Where HStopflag=0 and HNumber='" + sCode + "' and HItemID<>" + sItemID, MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
oModel.HItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["HItemID"]);
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
//构造函数
|
public ClsGy_Employee_Ctl()
|
{
|
MvarItemKey = "Gy_Employee";
|
MvarReportTitle = "职员设置";
|
oModel = new Model.ClsGy_Employee_Model();
|
}
|
}
|
}
|
