using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DAL
|
{
|
public class ClsK3_Employee_Ctl:DBUtility.ClsGy_Base_Ctl
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
SQLHelper.ClsCNK3 oK3Cn = new SQLHelper.ClsCNK3();
|
|
public Model.ClsK3_Employee_Model oModel ;
|
//新增
|
public override bool AddNew()
|
{
|
try
|
{
|
oCn.BeginTran();
|
base.DeleteByID(oModel.HItemID);
|
oCn.RunProc("Insert into K3_Employee_Extend (" +
|
"HItemID,HNumber,HName,HShortNumber,HEmpRate,HExamRate" +
|
",HBirthday,HInsuranceDate,HContractBDate,HContractEDate" +
|
",HJobCardEDate,HCheckCardEDate,HHealthCardEDate" +
|
",HContractYear,HInsuranceStatus,HSignStatus" +
|
",HSex,HMarr" +
|
",HEmail,HNowAdd,HHomeAdd,HIDCard,HLinkPhone,HMobilePhone,HFax" +
|
",HOldCompany,HInsuranceNo,HJobCardNo,HArchivesNo,HWorkType,HDimissionReason" +
|
",HDimissionDate,HInComDate,HSignDate" +
|
",HPostID,HDormID" +
|
",HEmpType,HPayType,HOverType,HNoBrushFlag,HShiftFlag,HStopwagesFlag" +
|
",HPostalCode,HBank,HBasePay" +
|
",HOtherDeduct3,HInsurance,HMedicare,HDrydock" +
|
",HBankAccount,HGroupID,HDeptID,HWorkTypeID,HCTPrjID" +
|
") " +
|
" Values(" +oModel.HItemID + ",'" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HShortNumber + "'," + oModel.HEmpRate.ToString() + "," + oModel.HExamRate.ToString() +
|
",'" + oModel.HBirthDay.ToShortDateString() + "','" + oModel.HInsuranceDate.ToShortDateString() + "','" + oModel.HContractBDate.ToShortDateString() + "','" + oModel.HContractEDate.ToShortDateString() + "'" +
|
",'" + oModel.HJobCardEDate.ToShortDateString() + "','" + oModel.HCheckCardEDate.ToShortDateString() + "','" + oModel.HHealthCardEDate.ToShortDateString() + "'" +
|
",'" + oModel.HContractYear + "','" + oModel.HInsuranceStatus + "'," + Convert.ToString(oModel.HSignStatus ? 1 : 0) +
|
",'" + oModel.HSex + "','" + oModel.HMarr +"'"+
|
",'" + 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.ToShortDateString() + "','" + oModel.HInComDate.ToShortDateString() + "','" + oModel.HSignDate.ToShortDateString() +"'"+
|
"," + oModel.HPostID.ToString() + "," + oModel.HDormID.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.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() +
|
")");
|
//修改上级为非末级代码
|
//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 K3_Employee_Extend set " +
|
" HNumber='" + oModel.HNumber + "'" +
|
",HName='" + oModel.HName + "'" +
|
",HShortNumber='" + oModel.HShortNumber + "'" +
|
",HEmpRate=" + oModel.HEmpRate +
|
",HExamRate=" + oModel.HExamRate +
|
",HBasePay=" + oModel.HBasePay +
|
",HInsuranceStatus=" + oModel.HInsuranceStatus +
|
",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 + "'" +
|
",HContractYear='" + oModel.HContractYear + "'" +
|
",HBirthday='" + oModel.HBirthDay + "'" +
|
",HInsuranceDate='" + oModel.HInsuranceDate + "'" +
|
",HContractBDate='" + oModel.HContractBDate + "'" +
|
",HContractEDate='" + oModel.HContractEDate + "'" +
|
",HJobCardEDate='" + oModel.HJobCardEDate + "'" +
|
",HCheckCardEDate='" + oModel.HCheckCardEDate + "'" +
|
",HHealthCardEDate='" + oModel.HHealthCardEDate + "'" +
|
",HSex='" + oModel.HSex + "'" +
|
",HMarr='" + oModel.HMarr + "'" +
|
",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.ToShortDateString() + "'" +
|
",HInComDate='" + oModel.HInComDate.ToShortDateString() + "'" +
|
",HPostID =" + oModel.HPostID.ToString() +
|
",HDormID =" + oModel.HDormID.ToString() +
|
",HBank='" + oModel.HBank + "'" +
|
",HBankAccount='" + oModel.HBankAccount + "'" +
|
",HGroupID='" + oModel.HGroupID + "'" +
|
",HInsurance=" + oModel.HInsurance.ToString() + "" +
|
",HOtherDeduct3=" + oModel.HOtherDeduct3.ToString() + "" +
|
",HMedicare=" + oModel.HMedicare.ToString() + "" +
|
",HDrydock=" + oModel.HDrydock.ToString() + "" +
|
",HWorkType='" + oModel.HWorkType + "'" +
|
",HWorkTypeID='" + oModel.HWorkTypeID.ToString() + "'" +
|
",HCTPrjID='" + oModel.HCTPrjID.ToString() + "'" +
|
",HDeptID= '" + oModel.HDeptID + "' Where HItemID=" + sItemID);
|
//修改子项目代码
|
oCn.RunProc("exec h_p_Gy_UpdateNumber '" + MvarItemKey + "','" + oModel.HNumber + ".'", 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);
|
}
|
}
|
|
//K3单据新增
|
public bool AddNew_K3()
|
{
|
try
|
{
|
oK3Cn.BeginTran();
|
oK3Cn.RunProc("exec h_p_K3_Gy_AddEmployee " + oModel.HLevel.ToString() + "," + oModel.HParentID.ToString() + "," + DBUtility.ClsPub.BoolToString(oModel.HEndFlag) + ",'" + oModel.HShortNumber + "'" +
|
",'" + oModel.HName + "','" + oModel.HNumber + "'," + oModel.HDeptID.ToString() + ",'" + oModel.HBirthDay.ToShortDateString() + "','" + oModel.HLinkPhone + "'" +
|
",'" + oModel.HMobilePhone + "','" + oModel.HIDCard + "','" + oModel.HInComDate.ToShortDateString() + "','" + oModel.HDimissionDate.ToShortDateString() + "','" + oModel.HBankAccount + "'" +
|
",'" + oModel.HAddress + "','" + oModel.HEmail + "'," + oModel.HGroupID.ToString() + ",'" + oModel.HRemark + "'"
|
, ref DBUtility.ClsPub.sExeReturnInfo);
|
oK3Cn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oK3Cn.RollBack();
|
throw (e);
|
}
|
}
|
|
|
//根据代码判断信息
|
public bool HavParentCode(string sCode, ref Int64 sItemID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oK3Cn.RunProcReturn("Select FItemID from t_Item Where FDeleted=0 and fitemclassid=3 and FNumber='" + sCode + "' ", "t_Item", ref Pub_Class.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
sItemID = Convert.ToInt64(DS.Tables[0].Rows[0]["FItemID"]);
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//构造函数
|
public ClsK3_Employee_Ctl()
|
{
|
MvarItemKey = "K3_Employee_Extend";
|
MvarReportTitle = "职员设置";
|
oModel = new Model.ClsK3_Employee_Model();
|
}
|
}
|
}
|
