public override bool Update(EnterpriseJobEntity entity) { string commandText = string.Format(@"Update [XQYCEnterpriseJob] Set [EnterpriseJobGuid] = {0}EnterpriseJobGuid, [EnterpriseJobTitle] = {0}EnterpriseJobTitle, [EnterpriseKey] = {0}EnterpriseKey, [EnterpriseName] = {0}EnterpriseName, [EnterpriseAreaCode] = {0}EnterpriseAreaCode, [EnterpriseAddress] = {0}EnterpriseAddress, [EnterpriseContackInfo] = {0}EnterpriseContackInfo, [EnterpriseDesc] = {0}EnterpriseDesc, [EnterpriseJobLaborCount] = {0}EnterpriseJobLaborCount, [InterviewDateInfo] = {0}InterviewDateInfo, [EnterpriseJobDemand] = {0}EnterpriseJobDemand, [EnterpriseJobTreadment] = {0}EnterpriseJobTreadment, [EnterpriseJobOther] = {0}EnterpriseJobOther, [EnterpriseJobDesc] = {0}EnterpriseJobDesc, [EnterpriseJobStatus] = {0}EnterpriseJobStatus, [EnterpriseJobType] = {0}EnterpriseJobType, [EnterpriseJobStation] = {0}EnterpriseJobStation, [CreateTime] = {0}CreateTime, [CreateUserKey] = {0}CreateUserKey, [RefreshTime] = {0}RefreshTime, [CanUsable] = {0}CanUsable, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [EnterpriseJobID] = {0}EnterpriseJobID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(EnterpriseContractEntity entity) { string commandText = string.Format(@"Update [XQYCEnterpriseContract] Set [ContractGuid] = {0}ContractGuid, [EnterpriseGuid] = {0}EnterpriseGuid, [EnterpriseInfo] = {0}EnterpriseInfo, [ContractTitle] = {0}ContractTitle, [ContractDetails] = {0}ContractDetails, [ContractStartDate] = {0}ContractStartDate, [ContractStopDate] = {0}ContractStopDate, [ContractCreateDate] = {0}ContractCreateDate, [ContractCreateUserKey] = {0}ContractCreateUserKey, [ContractLaborCount] = {0}ContractLaborCount, [ContractLaborAddon] = {0}ContractLaborAddon, [ContractStatus]= {0}ContractStatus, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [ContractID] = {0}ContractID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(SalaryDetailsEntity entity) { //在创建实体时如果实体的Guid尚未指定,那么给其赋初值 if (entity.SalaryDetailsGuid == Guid.Empty) { entity.SalaryDetailsGuid = GuidHelper.NewGuid(); } string commandText = string.Format(@"Insert Into [XQYCSalaryDetails] ( [SalaryDetailsGuid], [SalarySummaryKey], [SalaryItemKey], [SalaryItemValue], [SalaryItemKind], [SalaryItemCashDate], [PropertyNames], [PropertyValues] ) Values ( {0}SalaryDetailsGuid, {0}SalarySummaryKey, {0}SalaryItemKey, {0}SalaryItemValue, {0}SalaryItemKind, {0}SalaryItemCashDate, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(InformationBrokerEntity entity) { string commandText = string.Format(@"Update [XQYCInformationBroker] Set [InformationBrokerGuid] = {0}InformationBrokerGuid, [InformationBrokerName] = {0}InformationBrokerName, [InformationBrokerNameShort] = {0}InformationBrokerNameShort, [HigherOrganization] = {0}HigherOrganization, [CanUsable] = {0}CanUsable, [AreaCode] = {0}AreaCode, [IndustryKey] = {0}IndustryKey, [IndustryType] = {0}IndustryType, [InformationBrokerType] = {0}InformationBrokerType, [InformationBrokerKind] = {0}InformationBrokerKind, [PrincipleAddress] = {0}PrincipleAddress, [ContactPerson] = {0}ContactPerson, [PostCode] = {0}PostCode, [Telephone] = {0}Telephone, [Fax] = {0}Fax, [Email] = {0}Email, [InformationBrokerWWW] = {0}InformationBrokerWWW, [InformationBrokerLevel] = {0}InformationBrokerLevel, [InformationBrokerRank] = {0}InformationBrokerRank, [InformationBrokerDescription] = {0}InformationBrokerDescription, [InformationBrokerMemo] = {0}InformationBrokerMemo, [ProviderUserGuid] = {0}ProviderUserGuid, [ProviderUserName] = {0}ProviderUserName, [RecommendUserGuid] = {0}RecommendUserGuid, [RecommendUserName] = {0}RecommendUserName, [ServiceUserGuid] = {0}ServiceUserGuid, [ServiceUserName] = {0}ServiceUserName, [FinanceUserGuid] = {0}FinanceUserGuid, [FinanceUserName] = {0}FinanceUserName, [BusinessUserGuid] = {0}BusinessUserGuid, [BusinessUserName] = {0}BusinessUserName, [SettleUserGuid] = {0}SettleUserGuid, [SettleUserName] = {0}SettleUserName, [CreateUserKey] = {0}CreateUserKey, [CreateUserName] = {0}CreateUserName, [CreateDate] = {0}CreateDate, [LastUpdateUserKey] = {0}LastUpdateUserKey, [LastUpdateUserName] = {0}LastUpdateUserName, [LastUpdateDate] = {0}LastUpdateDate, [IsProtectedByOwner] = {0}IsProtectedByOwner, [CooperateStatus] = {0}CooperateStatus, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [InformationBrokerID] = {0}InformationBrokerID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(EmployeeEntity entity) { string commandText = string.Format(@"Update [XQYCEmployee] Set [Foo] = {0}Foo Where [UserGuid] = {0}UserGuid", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
/// <summary> /// 移除劳务人员所有合同的当前状态 /// </summary> /// <param name="laborGuid">劳务人员Guid</param> /// <param name="contractGuidExclude">取消当前状态时,需要排除在外的合同Guid</param> /// <returns></returns> public virtual void RemoveCurrentStatusOfLaborContract(Guid laborGuid, Guid contractGuidExclude) { string commandText = string.Format(@"Update [XQYCLaborContract] Set [LaborContractIsCurrent]={0}LaborContractIsCurrent Where [LaborUserGuid] = {0}LaborUserGuid AND [LaborContractGuid] != {0}LaborContractGuid", ParameterNamePrefix); TParameter[] sqlParas = new TParameter[] { GenerateParameter("LaborContractIsCurrent", Logics.False), GenerateParameter("LaborUserGuid", laborGuid), GenerateParameter("LaborContractGuid", contractGuidExclude) }; HelperExInstance.ExecuteNonQuery(commandText, sqlParas); }
public override bool Create(EnterpriseContractEntity entity) { //在创建实体时如果实体的Guid尚未指定,那么给其赋初值 if (entity.ContractGuid == Guid.Empty) { entity.ContractGuid = GuidHelper.NewGuid(); } string commandText = string.Format(@"Insert Into [XQYCEnterpriseContract] ( [ContractGuid], [EnterpriseGuid], [EnterpriseInfo], [ContractTitle], [ContractDetails], [ContractStartDate], [ContractStopDate], [ContractCreateDate], [ContractCreateUserKey], [ContractLaborCount], [ContractLaborAddon], [ContractStatus], [PropertyNames], [PropertyValues] ) Values ( {0}ContractGuid, {0}EnterpriseGuid, {0}EnterpriseInfo, {0}ContractTitle, {0}ContractDetails, {0}ContractStartDate, {0}ContractStopDate, {0}ContractCreateDate, {0}ContractCreateUserKey, {0}ContractLaborCount, {0}ContractLaborAddon, {0}ContractStatus, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(EmployeeEntity entity) { string commandText = string.Format(@"Insert Into [XQYCEmployee] ( [UserGuid], [Foo] ) Values ( {0}UserGuid, {0}Foo )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(SalaryDetailsEntity entity) { string commandText = string.Format(@"Update [XQYCSalaryDetails] Set [SalaryDetailsGuid] = {0}SalaryDetailsGuid, [SalarySummaryKey] = {0}SalarySummaryKey, [SalaryItemKey] = {0}SalaryItemKey, [SalaryItemValue] = {0}SalaryItemValue, [SalaryItemKind] = {0}SalaryItemKind, [SalaryItemCashDate] = {0}SalaryItemCashDate, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [SalaryDetailsID] = {0}SalaryDetailsID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(LaborContractEntity entity) { string commandText = string.Format(@"Update [XQYCLaborContract] Set [LaborContractGuid] = {0}LaborContractGuid, [LaborUserGuid] = {0}LaborUserGuid, [LaborCode] = {0}LaborCode, [EnterpriseGuid] = {0}EnterpriseGuid, [EnterpriseContractGuid] = {0}EnterpriseContractGuid, [LaborContractStatus] = {0}LaborContractStatus, [LaborDepartment] = {0}LaborDepartment, [LaborWorkShop] = {0}LaborWorkShop, [LaborContractStartDate] = {0}LaborContractStartDate, [LaborContractStopDate] = {0}LaborContractStopDate, [LaborContractDetails] = {0}LaborContractDetails, [LaborContractDiscontinueDate] = {0}LaborContractDiscontinueDate, [LaborContractDiscontinueDesc] = {0}LaborContractDiscontinueDesc, [LaborContractIsCurrent] = {0}LaborContractIsCurrent, [EnterpriseInsuranceFormularKey] = {0}EnterpriseInsuranceFormularKey, [EnterpriseReserveFundFormularKey] = {0}EnterpriseReserveFundFormularKey, [EnterpriseManageFeeFormularKey] = {0}EnterpriseManageFeeFormularKey, [EnterpriseMixCostFormularKey] = {0}EnterpriseMixCostFormularKey, [EnterpriseOtherCostFormularKey] = {0}EnterpriseOtherCostFormularKey, [PersonInsuranceFormularKey] = {0}PersonInsuranceFormularKey, [PersonReserveFundFormularKey] = {0}PersonReserveFundFormularKey, [PersonManageFeeFormularKey] = {0}PersonManageFeeFormularKey, [PersonMixCostFormularKey] = {0}PersonMixCostFormularKey, [PersonOtherCostFormularKey] = {0}PersonOtherCostFormularKey, [EnterpriseOtherInsuranceFormularKey] = {0}EnterpriseOtherInsuranceFormularKey, [EnterpriseTaxFeeFormularKey] = {0}EnterpriseTaxFeeFormularKey, [OperateUserGuid] = {0}OperateUserGuid, [OperateDate] = {0}OperateDate, [DispatchType] = {0}DispatchType, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [LaborContractID] = {0}LaborContractID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(CostFormularEntity entity) { //在创建实体时如果实体的Guid尚未指定,那么给其赋初值 if (entity.CostFormularGuid == Guid.Empty) { entity.CostFormularGuid = GuidHelper.NewGuid(); } string commandText = string.Format(@"Insert Into [XQYCCostFormular] ( [CostFormularGuid], [CostFormularName], [CostFormularValue], [EnterpriseKey], [CostType], [CostKind], [ReferanceGuid], [CostFormularDesc], [CanUsable], [PropertyNames], [PropertyValues] ) Values ( {0}CostFormularGuid, {0}CostFormularName, {0}CostFormularValue, {0}EnterpriseKey, {0}CostType, {0}CostKind, {0}ReferanceGuid, {0}CostFormularDesc, {0}CanUsable, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(CostFormularEntity entity) { string commandText = string.Format(@"Update [XQYCCostFormular] Set [CostFormularGuid] = {0}CostFormularGuid, [CostFormularName] = {0}CostFormularName, [CostFormularValue] = {0}CostFormularValue, [EnterpriseKey] = {0}EnterpriseKey, [CostType] = {0}CostType, [CostKind] = {0}CostKind, [ReferanceGuid] = {0}ReferanceGuid, [CostFormularDesc] = {0}CostFormularDesc, [CanUsable] = {0}CanUsable, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [CostFormularID] = {0}CostFormularID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(EnterpriseServiceEntity entity) { string commandText = string.Format(@"Update [XQYCEnterpriseService] Set [EnterpriseServiceGuid] = {0}EnterpriseServiceGuid, [EnterpriseGuid] = {0}EnterpriseGuid, [EnterpriseInfo] = {0}EnterpriseInfo, [EnterpriseServiceType] = {0}EnterpriseServiceType, [EnterpriseServiceStatus] = {0}EnterpriseServiceStatus, [EnterpriseServiceContactPerson] = {0}EnterpriseServiceContactPerson, [EnterpriseServiceContactTelephone] = {0}EnterpriseServiceContactTelephone, [EnterpriseServiceCreateDate] = {0}EnterpriseServiceCreateDate, [EnterpriseServiceCreateUserKey] = {0}EnterpriseServiceCreateUserKey, [EnterpriseServiceStartDate] = {0}EnterpriseServiceStartDate, [EnterpriseServiceStopDate] = {0}EnterpriseServiceStopDate, [ProviderUserGuid] = {0}ProviderUserGuid, [ProviderUserName] = {0}ProviderUserName, [RecommendUserGuid] = {0}RecommendUserGuid, [RecommendUserName] = {0}RecommendUserName, [ServiceUserGuid] = {0}ServiceUserGuid, [ServiceUserName] = {0}ServiceUserName, [FinanceUserGuid] = {0}FinanceUserGuid, [FinanceUserName] = {0}FinanceUserName, [BusinessUserGuid] = {0}BusinessUserGuid, [BusinessUserName] = {0}BusinessUserName, [SettleUserGuid] = {0}SettleUserGuid, [SettleUserName] = {0}SettleUserName, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [EnterpriseServiceID] = {0}EnterpriseServiceID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(InformationBrokerEntity entity) { if (entity.InformationBrokerGuid == Guid.Empty) { entity.InformationBrokerGuid = GuidHelper.NewGuid(); } string commandText = string.Format(@"Insert Into [XQYCInformationBroker] ( [InformationBrokerGuid], [InformationBrokerName], [InformationBrokerNameShort], [HigherOrganization], [CanUsable], [AreaCode], [IndustryKey], [IndustryType], [InformationBrokerType], [InformationBrokerKind], [PrincipleAddress], [ContactPerson], [PostCode], [Telephone], [Fax], [Email], [InformationBrokerWWW], [InformationBrokerLevel], [InformationBrokerRank], [InformationBrokerDescription], [InformationBrokerMemo], [ProviderUserGuid], [ProviderUserName], [RecommendUserGuid], [RecommendUserName], [ServiceUserGuid], [ServiceUserName], [FinanceUserGuid], [FinanceUserName], [BusinessUserGuid], [BusinessUserName], [SettleUserGuid], [SettleUserName], [CreateUserKey], [CreateUserName], [CreateDate], [LastUpdateUserKey], [LastUpdateUserName], [LastUpdateDate], [IsProtectedByOwner], [CooperateStatus], [PropertyNames], [PropertyValues] ) Values ( {0}InformationBrokerGuid, {0}InformationBrokerName, {0}InformationBrokerNameShort, {0}HigherOrganization, {0}CanUsable, {0}AreaCode, {0}IndustryKey, {0}IndustryType, {0}InformationBrokerType, {0}InformationBrokerKind, {0}PrincipleAddress, {0}ContactPerson, {0}PostCode, {0}Telephone, {0}Fax, {0}Email, {0}InformationBrokerWWW, {0}InformationBrokerLevel, {0}InformationBrokerRank, {0}InformationBrokerDescription, {0}InformationBrokerMemo, {0}ProviderUserGuid, {0}ProviderUserName, {0}RecommendUserGuid, {0}RecommendUserName, {0}ServiceUserGuid, {0}ServiceUserName, {0}FinanceUserGuid, {0}FinanceUserName, {0}BusinessUserGuid, {0}BusinessUserName, {0}SettleUserGuid, {0}SettleUserName, {0}CreateUserKey, {0}CreateUserName, {0}CreateDate, {0}LastUpdateUserKey, {0}LastUpdateUserName, {0}LastUpdateDate, {0}IsProtectedByOwner, {0}CooperateStatus, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(SalarySummaryEntity entity) { //在创建实体时如果实体的Guid尚未指定,那么给其赋初值 if (entity.SalarySummaryGuid == Guid.Empty) { entity.SalarySummaryGuid = GuidHelper.NewGuid(); } string commandText = string.Format(@"Insert Into [XQYCSalarySummary] ( [SalarySummaryGuid], [SalaryDate], [LaborKey], [LaborName], [LaborCode], [EnterpriseKey], [EnterpriseContractKey], [CreateUserKey], [CreateDate], [SalaryPayStatus], [SalaryGrossPay], [SalaryRebate], [SalaryRebateBeforeTax], [PersonBorrow], [IsCostCalculated], [SalaryCashDate], [InsuranceCashDate], [ReserveFundCashDate], [EnterpriseManageFeeReal], [EnterpriseManageFeeCalculated], [EnterpriseManageFeeCalculatedFix], [EnterpriseManageFeeCashDate], [EnterpriseGeneralRecruitFeeReal], [EnterpriseGeneralRecruitFeeCalculated], [EnterpriseGeneralRecruitFeeCalculatedFix], [EnterpriseGeneralRecruitFeeCashDate], [EnterpriseOnceRecruitFeeReal], [EnterpriseOnceRecruitFeeCalculated], [EnterpriseOnceRecruitFeeCalculatedFix], [EnterpriseOnceRecruitFeeCashDate], [EnterpriseInsuranceReal], [EnterpriseInsuranceCalculated], [EnterpriseInsuranceCalculatedFix], [EnterpriseReserveFundReal], [EnterpriseReserveFundCalculated], [EnterpriseReserveFundCalculatedFix], [PersonManageFeeReal], [PersonManageFeeCalculated], [PersonManageFeeCalculatedFix], [PersonInsuranceReal], [PersonInsuranceCalculated], [PersonInsuranceCalculatedFix], [PersonReserveFundReal], [PersonReserveFundCalculated], [PersonReserveFundCalculatedFix], [EnterpriseMixCostReal], [EnterpriseMixCostCalculated], [EnterpriseMixCostCalculatedFix], [PersonMixCostReal], [PersonMixCostCalculated], [PersonMixCostCalculatedFix], [EnterpriseOtherCostReal], [EnterpriseOtherCostCalculated], [EnterpriseOtherCostCalculatedFix], [PersonOtherCostReal], [PersonOtherCostCalculated], [PersonOtherCostCalculatedFix], [EnterpriseTaxFeeReal], [EnterpriseTaxFeeCalculated], [EnterpriseTaxFeeCalculatedFix], [EnterpriseTaxFeeCashDate], [EnterpriseOtherInsuranceReal], [EnterpriseOtherInsuranceCalculated], [EnterpriseOtherInsuranceCalculatedFix], [EnterpriseOtherInsuranceCashDate], [SalaryTaxReal], [SalaryTaxCalculated], [SalaryMemo], [IsCheckPast], [CheckMemo], [IsLocked], [SalarySettlementStartDate], [SalarySettlementEndDate], [IsFirstCash], [IsAdvanceCash], [PropertyNames], [PropertyValues] ) Values ( {0}SalarySummaryGuid, {0}SalaryDate, {0}LaborKey, {0}LaborName, {0}LaborCode, {0}EnterpriseKey, {0}EnterpriseContractKey, {0}CreateUserKey, {0}CreateDate, {0}SalaryPayStatus, {0}SalaryGrossPay, {0}SalaryRebate, {0}SalaryRebateBeforeTax, {0}PersonBorrow, {0}IsCostCalculated, {0}SalaryCashDate, {0}InsuranceCashDate, {0}ReserveFundCashDate, {0}EnterpriseManageFeeReal, {0}EnterpriseManageFeeCalculated, {0}EnterpriseManageFeeCalculatedFix, {0}EnterpriseManageFeeCashDate, {0}EnterpriseGeneralRecruitFeeReal, {0}EnterpriseGeneralRecruitFeeCalculated, {0}EnterpriseGeneralRecruitFeeCalculatedFix, {0}EnterpriseGeneralRecruitFeeCashDate, {0}EnterpriseOnceRecruitFeeReal, {0}EnterpriseOnceRecruitFeeCalculated, {0}EnterpriseOnceRecruitFeeCalculatedFix, {0}EnterpriseOnceRecruitFeeCashDate, {0}EnterpriseInsuranceReal, {0}EnterpriseInsuranceCalculated, {0}EnterpriseInsuranceCalculatedFix, {0}EnterpriseReserveFundReal, {0}EnterpriseReserveFundCalculated, {0}EnterpriseReserveFundCalculatedFix, {0}PersonManageFeeReal, {0}PersonManageFeeCalculated, {0}PersonManageFeeCalculatedFix, {0}PersonInsuranceReal, {0}PersonInsuranceCalculated, {0}PersonInsuranceCalculatedFix, {0}PersonReserveFundReal, {0}PersonReserveFundCalculated, {0}PersonReserveFundCalculatedFix, {0}EnterpriseMixCostReal, {0}EnterpriseMixCostCalculated, {0}EnterpriseMixCostCalculatedFix, {0}PersonMixCostReal, {0}PersonMixCostCalculated, {0}PersonMixCostCalculatedFix, {0}EnterpriseOtherCostReal, {0}EnterpriseOtherCostCalculated, {0}EnterpriseOtherCostCalculatedFix, {0}PersonOtherCostReal, {0}PersonOtherCostCalculated, {0}PersonOtherCostCalculatedFix, {0}EnterpriseTaxFeeReal, {0}EnterpriseTaxFeeCalculated, {0}EnterpriseTaxFeeCalculatedFix, {0}EnterpriseTaxFeeCashDate, {0}EnterpriseOtherInsuranceReal, {0}EnterpriseOtherInsuranceCalculated, {0}EnterpriseOtherInsuranceCalculatedFix, {0}EnterpriseOtherInsuranceCashDate, {0}SalaryTaxReal, {0}SalaryTaxCalculated, {0}SalaryMemo, {0}IsCheckPast, {0}CheckMemo, {0}IsLocked, {0}SalarySettlementStartDate, {0}SalarySettlementEndDate, {0}IsFirstCash, {0}IsAdvanceCash, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(SalarySummaryEntity entity) { string commandText = string.Format(@"Update [XQYCSalarySummary] Set [SalarySummaryGuid] = {0}SalarySummaryGuid, [SalaryDate] = {0}SalaryDate, [LaborKey] = {0}LaborKey, [LaborName] = {0}LaborName, [LaborCode] = {0}LaborCode, [EnterpriseKey] = {0}EnterpriseKey, [EnterpriseContractKey] = {0}EnterpriseContractKey, [CreateUserKey] = {0}CreateUserKey, [CreateDate] = {0}CreateDate, [SalaryPayStatus] = {0}SalaryPayStatus, [SalaryGrossPay] = {0}SalaryGrossPay, [SalaryRebate] = {0}SalaryRebate, [SalaryRebateBeforeTax] = {0}SalaryRebateBeforeTax, [PersonBorrow] = {0}PersonBorrow, [IsCostCalculated] = {0}IsCostCalculated, [SalaryCashDate] = {0}SalaryCashDate, [InsuranceCashDate] = {0}InsuranceCashDate, [ReserveFundCashDate] = {0}ReserveFundCashDate, [EnterpriseManageFeeReal] = {0}EnterpriseManageFeeReal, [EnterpriseManageFeeCalculated] = {0}EnterpriseManageFeeCalculated, [EnterpriseManageFeeCalculatedFix] = {0}EnterpriseManageFeeCalculatedFix, [EnterpriseManageFeeCashDate] = {0}EnterpriseManageFeeCashDate, [EnterpriseGeneralRecruitFeeReal] = {0}EnterpriseGeneralRecruitFeeReal, [EnterpriseGeneralRecruitFeeCalculated] = {0}EnterpriseGeneralRecruitFeeCalculated, [EnterpriseGeneralRecruitFeeCalculatedFix] = {0}EnterpriseGeneralRecruitFeeCalculatedFix, [EnterpriseGeneralRecruitFeeCashDate] = {0}EnterpriseGeneralRecruitFeeCashDate, [EnterpriseOnceRecruitFeeReal] = {0}EnterpriseOnceRecruitFeeReal, [EnterpriseOnceRecruitFeeCalculated] = {0}EnterpriseOnceRecruitFeeCalculated, [EnterpriseOnceRecruitFeeCalculatedFix] = {0}EnterpriseOnceRecruitFeeCalculatedFix, [EnterpriseOnceRecruitFeeCashDate] = {0}EnterpriseOnceRecruitFeeCashDate, [EnterpriseInsuranceReal] = {0}EnterpriseInsuranceReal, [EnterpriseInsuranceCalculated] = {0}EnterpriseInsuranceCalculated, [EnterpriseInsuranceCalculatedFix] = {0}EnterpriseInsuranceCalculatedFix, [EnterpriseReserveFundReal] = {0}EnterpriseReserveFundReal, [EnterpriseReserveFundCalculated] = {0}EnterpriseReserveFundCalculated, [EnterpriseReserveFundCalculatedFix] = {0}EnterpriseReserveFundCalculatedFix, [PersonManageFeeReal] = {0}PersonManageFeeReal, [PersonManageFeeCalculated] = {0}PersonManageFeeCalculated, [PersonManageFeeCalculatedFix] = {0}PersonManageFeeCalculatedFix, [PersonInsuranceReal] = {0}PersonInsuranceReal, [PersonInsuranceCalculated] = {0}PersonInsuranceCalculated, [PersonInsuranceCalculatedFix] = {0}PersonInsuranceCalculatedFix, [PersonReserveFundReal] = {0}PersonReserveFundReal, [PersonReserveFundCalculated] = {0}PersonReserveFundCalculated, [PersonReserveFundCalculatedFix] = {0}PersonReserveFundCalculatedFix, [EnterpriseMixCostReal] = {0}EnterpriseMixCostReal, [EnterpriseMixCostCalculated] = {0}EnterpriseMixCostCalculated, [EnterpriseMixCostCalculatedFix] = {0}EnterpriseMixCostCalculatedFix, [PersonMixCostReal] = {0}PersonMixCostReal, [PersonMixCostCalculated] = {0}PersonMixCostCalculated, [PersonMixCostCalculatedFix] = {0}PersonMixCostCalculatedFix, [EnterpriseOtherCostReal] = {0}EnterpriseOtherCostReal, [EnterpriseOtherCostCalculated] = {0}EnterpriseOtherCostCalculated, [EnterpriseOtherCostCalculatedFix] = {0}EnterpriseOtherCostCalculatedFix, [PersonOtherCostReal] = {0}PersonOtherCostReal, [PersonOtherCostCalculated] = {0}PersonOtherCostCalculated, [PersonOtherCostCalculatedFix] = {0}PersonOtherCostCalculatedFix, [EnterpriseTaxFeeReal] = {0}EnterpriseTaxFeeReal, [EnterpriseTaxFeeCalculated] = {0}EnterpriseTaxFeeCalculated, [EnterpriseTaxFeeCalculatedFix] = {0}EnterpriseTaxFeeCalculatedFix, [EnterpriseTaxFeeCashDate] = {0}EnterpriseTaxFeeCashDate, [EnterpriseOtherInsuranceReal] = {0}EnterpriseOtherInsuranceReal, [EnterpriseOtherInsuranceCalculated] = {0}EnterpriseOtherInsuranceCalculated, [EnterpriseOtherInsuranceCalculatedFix] = {0}EnterpriseOtherInsuranceCalculatedFix, [EnterpriseOtherInsuranceCashDate] = {0}EnterpriseOtherInsuranceCashDate, [SalaryTaxReal] = {0}SalaryTaxReal, [SalaryTaxCalculated] = {0}SalaryTaxCalculated, [SalaryMemo] = {0}SalaryMemo, [IsCheckPast] = {0}IsCheckPast, [CheckMemo] = {0}CheckMemo, [IsLocked] = {0}IsLocked, [SalarySettlementStartDate] = {0}SalarySettlementStartDate, [SalarySettlementEndDate] = {0}SalarySettlementEndDate, [IsFirstCash] = {0}IsFirstCash, [IsAdvanceCash] = {0}IsAdvanceCash, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [SalarySummaryID] = {0}SalarySummaryID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(EnterpriseServiceEntity entity) { //在创建实体时如果实体的Guid尚未指定,那么给其赋初值 if (entity.EnterpriseServiceGuid == Guid.Empty) { entity.EnterpriseServiceGuid = GuidHelper.NewGuid(); } string commandText = string.Format(@"Insert Into [XQYCEnterpriseService] ( [EnterpriseServiceGuid], [EnterpriseGuid], [EnterpriseInfo], [EnterpriseServiceType], [EnterpriseServiceStatus], [EnterpriseServiceContactPerson], [EnterpriseServiceContactTelephone], [EnterpriseServiceCreateDate], [EnterpriseServiceCreateUserKey], [EnterpriseServiceStartDate], [EnterpriseServiceStopDate], [ProviderUserGuid], [ProviderUserName], [RecommendUserGuid], [RecommendUserName], [ServiceUserGuid], [ServiceUserName], [FinanceUserGuid], [FinanceUserName], [BusinessUserGuid], [BusinessUserName], [SettleUserGuid], [SettleUserName], [PropertyNames], [PropertyValues] ) Values ( {0}EnterpriseServiceGuid, {0}EnterpriseGuid, {0}EnterpriseInfo, {0}EnterpriseServiceType, {0}EnterpriseServiceStatus, {0}EnterpriseServiceContactPerson, {0}EnterpriseServiceContactTelephone, {0}EnterpriseServiceCreateDate, {0}EnterpriseServiceCreateUserKey, {0}EnterpriseServiceStartDate, {0}EnterpriseServiceStopDate, {0}ProviderUserGuid, {0}ProviderUserName, {0}RecommendUserGuid, {0}RecommendUserName, {0}ServiceUserGuid, {0}ServiceUserName, {0}FinanceUserGuid, {0}FinanceUserName, {0}BusinessUserGuid, {0}BusinessUserName, {0}SettleUserGuid, {0}SettleUserName, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(LaborContractEntity entity) { //在创建实体时如果实体的Guid尚未指定,那么给其赋初值 if (entity.LaborContractGuid == Guid.Empty) { entity.LaborContractGuid = GuidHelper.NewGuid(); } string commandText = string.Format(@"Insert Into [XQYCLaborContract] ( [LaborContractGuid], [LaborUserGuid], [LaborCode], [EnterpriseGuid], [EnterpriseContractGuid], [LaborContractStatus], [LaborDepartment], [LaborWorkShop], [LaborContractStartDate], [LaborContractStopDate], [LaborContractDetails], [LaborContractDiscontinueDate], [LaborContractDiscontinueDesc], [LaborContractIsCurrent], [EnterpriseInsuranceFormularKey], [EnterpriseReserveFundFormularKey], [EnterpriseManageFeeFormularKey], [EnterpriseMixCostFormularKey], [EnterpriseOtherCostFormularKey], [PersonInsuranceFormularKey], [PersonReserveFundFormularKey], [PersonManageFeeFormularKey], [PersonMixCostFormularKey], [PersonOtherCostFormularKey], [EnterpriseOtherInsuranceFormularKey], [EnterpriseTaxFeeFormularKey], [OperateUserGuid], [OperateDate], [DispatchType], [PropertyNames], [PropertyValues] ) Values ( {0}LaborContractGuid, {0}LaborUserGuid, {0}LaborCode, {0}EnterpriseGuid, {0}EnterpriseContractGuid, {0}LaborContractStatus, {0}LaborDepartment, {0}LaborWorkShop, {0}LaborContractStartDate, {0}LaborContractStopDate, {0}LaborContractDetails, {0}LaborContractDiscontinueDate, {0}LaborContractDiscontinueDesc, {0}LaborContractIsCurrent, {0}EnterpriseInsuranceFormularKey, {0}EnterpriseReserveFundFormularKey, {0}EnterpriseManageFeeFormularKey, {0}EnterpriseMixCostFormularKey, {0}EnterpriseOtherCostFormularKey, {0}PersonInsuranceFormularKey, {0}PersonReserveFundFormularKey, {0}PersonManageFeeFormularKey, {0}PersonMixCostFormularKey, {0}PersonOtherCostFormularKey, {0}EnterpriseOtherInsuranceFormularKey, {0}EnterpriseTaxFeeFormularKey, {0}OperateUserGuid, {0}OperateDate, {0}DispatchType, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(LaborEntity entity) { if (entity.CreateDate == DateTimeHelper.Min) { entity.CreateDate = DateTime.Now; } if (string.IsNullOrEmpty(entity.CreateUserKey)) { entity.CreateUserKey = BusinessUserBLL.CurrentUserGuid.ToString(); entity.CreateUserName = BusinessUserBLL.CurrentUser.UserNameDisplay; } string commandText = string.Format(@"Insert Into [XQYCLabor] ( [UserGuid], [LaborCode], [NativePlace], [CurrentPlace], [IDCardPlace], [HouseHoldType], [WorkSkill], [WorkSkillPaper], [WorkSituation], [PreWorkSituation], [HopeWorkSituation], [HopeWorkSalary], [UrgentLinkMan], [UrgentTelephone], [UrgentRelationship], [InformationComeFrom], [ProviderUserGuid], [ProviderUserName], [RecommendUserGuid], [RecommendUserName], [ServiceUserGuid], [ServiceUserName], [FinanceUserGuid], [FinanceUserName], [BusinessUserGuid], [BusinessUserName], [SettleUserGuid], [SettleUserName], [InformationBrokerUserGuid], [InformationBrokerUserName], [InsureType], [LaborWorkStatus], [CurrentLaborDepartment], [CurrentLaborWorkShop], [CurrentContractStartDate], [CurrentContractStopDate], [CurrentContractDesc], [CurrentContractDiscontinueDate], [CurrentContractDiscontinueDesc], [CurrentEnterpriseKey], [CurrentEnterpriseName], [CurrentContractKey], [Memo1], [Memo2], [Memo3], [Memo4], [Memo5], [CreateUserKey], [CreateUserName], [CreateDate], [LastUpdateUserKey], [LastUpdateUserName], [LastUpdateDate], [IsProtectedByOwner], [CurrentDispatchType], [ComeFromType], [PropertyNames], [PropertyValues] ) Values ( {0}UserGuid, {0}LaborCode, {0}NativePlace, {0}CurrentPlace, {0}IDCardPlace, {0}HouseHoldType, {0}WorkSkill, {0}WorkSkillPaper, {0}WorkSituation, {0}PreWorkSituation, {0}HopeWorkSituation, {0}HopeWorkSalary, {0}UrgentLinkMan, {0}UrgentTelephone, {0}UrgentRelationship, {0}InformationComeFrom, {0}ProviderUserGuid, {0}ProviderUserName, {0}RecommendUserGuid, {0}RecommendUserName, {0}ServiceUserGuid, {0}ServiceUserName, {0}FinanceUserGuid, {0}FinanceUserName, {0}BusinessUserGuid, {0}BusinessUserName, {0}SettleUserGuid, {0}SettleUserName, {0}InformationBrokerUserGuid, {0}InformationBrokerUserName, {0}InsureType, {0}LaborWorkStatus, {0}CurrentLaborDepartment, {0}CurrentLaborWorkShop, {0}CurrentContractStartDate, {0}CurrentContractStopDate, {0}CurrentContractDesc, {0}CurrentContractDiscontinueDate, {0}CurrentContractDiscontinueDesc, {0}CurrentEnterpriseKey, {0}CurrentEnterpriseName, {0}CurrentContractKey, {0}Memo1, {0}Memo2, {0}Memo3, {0}Memo4, {0}Memo5, {0}CreateUserKey, {0}CreateUserName, {0}CreateDate, {0}LastUpdateUserKey, {0}LastUpdateUserName, {0}LastUpdateDate, {0}IsProtectedByOwner, {0}CurrentDispatchType, {0}ComeFromType, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Update(LaborEntity entity) { entity.LastUpdateDate = DateTime.Now; entity.LastUpdateUserKey = BusinessUserBLL.CurrentUserGuid.ToString(); entity.LastUpdateUserName = BusinessUserBLL.CurrentUser.UserNameDisplay; string commandText = string.Format(@"Update [XQYCLabor] Set [UserGuid] = {0}UserGuid, [LaborCode]={0}LaborCode, [NativePlace] = {0}NativePlace, [CurrentPlace] = {0}CurrentPlace, [IDCardPlace] = {0}IDCardPlace, [HouseHoldType] = {0}HouseHoldType, [WorkSkill] = {0}WorkSkill, [WorkSkillPaper] = {0}WorkSkillPaper, [WorkSituation] = {0}WorkSituation, [PreWorkSituation] = {0}PreWorkSituation, [HopeWorkSituation] = {0}HopeWorkSituation, [HopeWorkSalary] = {0}HopeWorkSalary, [UrgentLinkMan] = {0}UrgentLinkMan, [UrgentTelephone] = {0}UrgentTelephone, [UrgentRelationship] = {0}UrgentRelationship, [InformationComeFrom] = {0}InformationComeFrom, [ProviderUserGuid] = {0}ProviderUserGuid, [ProviderUserName] = {0}ProviderUserName, [RecommendUserGuid] = {0}RecommendUserGuid, [RecommendUserName] = {0}RecommendUserName, [ServiceUserGuid] = {0}ServiceUserGuid, [ServiceUserName] = {0}ServiceUserName, [FinanceUserGuid] = {0}FinanceUserGuid, [FinanceUserName] = {0}FinanceUserName, [BusinessUserGuid] = {0}BusinessUserGuid, [BusinessUserName] = {0}BusinessUserName, [SettleUserGuid] = {0}SettleUserGuid, [SettleUserName] = {0}SettleUserName, [InformationBrokerUserGuid] = {0}InformationBrokerUserGuid, [InformationBrokerUserName] = {0}InformationBrokerUserName, [InsureType] = {0}InsureType, [LaborWorkStatus] = {0}LaborWorkStatus, [CurrentLaborDepartment] = {0}CurrentLaborDepartment, [CurrentLaborWorkShop] = {0}CurrentLaborWorkShop, [CurrentContractStartDate] = {0}CurrentContractStartDate, [CurrentContractStopDate] = {0}CurrentContractStopDate, [CurrentContractDesc] = {0}CurrentContractDesc, [CurrentContractDiscontinueDate] = {0}CurrentContractDiscontinueDate, [CurrentContractDiscontinueDesc] = {0}CurrentContractDiscontinueDesc, [CurrentEnterpriseKey] = {0}CurrentEnterpriseKey, [CurrentEnterpriseName]= {0}CurrentEnterpriseName, [CurrentContractKey] = {0}CurrentContractKey, [Memo1] = {0}Memo1, [Memo2] = {0}Memo2, [Memo3] = {0}Memo3, [Memo4] = {0}Memo4, [Memo5] = {0}Memo5, [CreateUserKey] = {0}CreateUserKey, [CreateUserName] = {0}CreateUserName, [CreateDate] = {0}CreateDate, [LastUpdateUserKey] = {0}LastUpdateUserKey, [LastUpdateUserName] = {0}LastUpdateUserName, [LastUpdateDate] = {0}LastUpdateDate, [IsProtectedByOwner] = {0}IsProtectedByOwner, [CurrentDispatchType] = {0}CurrentDispatchType, [ComeFromType] = {0}ComeFromType, [PropertyNames] = {0}PropertyNames, [PropertyValues] = {0}PropertyValues Where [LaborID] = {0}LaborID", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }
public override bool Create(EnterpriseJobEntity entity) { //在创建实体时如果实体的Guid尚未指定,那么给其赋初值 if (entity.EnterpriseJobGuid == Guid.Empty) { entity.EnterpriseJobGuid = GuidHelper.NewGuid(); } string commandText = string.Format(@"Insert Into [XQYCEnterpriseJob] ( [EnterpriseJobGuid], [EnterpriseJobTitle], [EnterpriseKey], [EnterpriseName], [EnterpriseAreaCode], [EnterpriseAddress], [EnterpriseContackInfo], [EnterpriseDesc], [EnterpriseJobLaborCount], [InterviewDateInfo], [EnterpriseJobDemand], [EnterpriseJobTreadment], [EnterpriseJobOther], [EnterpriseJobDesc], [EnterpriseJobStatus], [EnterpriseJobType], [EnterpriseJobStation], [CreateTime], [CreateUserKey], [RefreshTime], [CanUsable], [PropertyNames], [PropertyValues] ) Values ( {0}EnterpriseJobGuid, {0}EnterpriseJobTitle, {0}EnterpriseKey, {0}EnterpriseName, {0}EnterpriseAreaCode, {0}EnterpriseAddress, {0}EnterpriseContackInfo, {0}EnterpriseDesc, {0}EnterpriseJobLaborCount, {0}InterviewDateInfo, {0}EnterpriseJobDemand, {0}EnterpriseJobTreadment, {0}EnterpriseJobOther, {0}EnterpriseJobDesc, {0}EnterpriseJobStatus, {0}EnterpriseJobType, {0}EnterpriseJobStation, {0}CreateTime, {0}CreateUserKey, {0}RefreshTime, {0}CanUsable, {0}PropertyNames, {0}PropertyValues )", ParameterNamePrefix); TParameter[] sqlParas = PrepareParasAll(entity); bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas); return(isSuccessful); }