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