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