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();
        } 
    }
}