protected override void InnerPrepareParasAll(EnterpriseServiceEntity entity, ref List <TParameter> paraList)
{
List <TParameter> list = new List <TParameter>()
{
GenerateParameter("EnterpriseServiceID", entity.EnterpriseServiceID),
GenerateParameter("EnterpriseServiceGuid", entity.EnterpriseServiceGuid),
GenerateParameter("EnterpriseGuid", entity.EnterpriseGuid),
GenerateParameter("EnterpriseInfo", entity.EnterpriseInfo ?? String.Empty),
GenerateParameter("EnterpriseServiceType", entity.EnterpriseServiceType),
GenerateParameter("EnterpriseServiceStatus", (int)entity.EnterpriseServiceStatus),
GenerateParameter("EnterpriseServiceContactPerson", entity.EnterpriseServiceContactPerson ?? String.Empty),
GenerateParameter("EnterpriseServiceContactTelephone", entity.EnterpriseServiceContactTelephone ?? String.Empty),
GenerateParameter("EnterpriseServiceCreateDate", entity.EnterpriseServiceCreateDate),
GenerateParameter("EnterpriseServiceCreateUserKey", entity.EnterpriseServiceCreateUserKey ?? String.Empty),
GenerateParameter("EnterpriseServiceStartDate", entity.EnterpriseServiceStartDate),
GenerateParameter("EnterpriseServiceStopDate", entity.EnterpriseServiceStopDate),
GenerateParameter("ProviderUserGuid", entity.ProviderUserGuid),
GenerateParameter("ProviderUserName", entity.ProviderUserName ?? String.Empty),
GenerateParameter("RecommendUserGuid", entity.RecommendUserGuid),
GenerateParameter("RecommendUserName", entity.RecommendUserName ?? String.Empty),
GenerateParameter("ServiceUserGuid", entity.ServiceUserGuid),
GenerateParameter("ServiceUserName", entity.ServiceUserName ?? String.Empty),
GenerateParameter("BusinessUserGuid", entity.BusinessUserGuid),
GenerateParameter("BusinessUserName", entity.BusinessUserName ?? String.Empty),
GenerateParameter("SettleUserGuid", entity.SettleUserGuid),
GenerateParameter("SettleUserName", entity.SettleUserName ?? String.Empty),
GenerateParameter("FinanceUserGuid", entity.FinanceUserGuid),
GenerateParameter("FinanceUserName", entity.FinanceUserName ?? String.Empty)
};
paraList.AddRange(list);
}
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(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);
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <param name="entity"></param>
protected override void InnerLoad(IDataReader reader, ref EnterpriseServiceEntity entity)
{
if (reader != null && reader.IsClosed == false && entity != null)
{
EnterpriseEntity enterpriserEntity = EnterpriseCommonDAL <TTransaction, TConnection, TCommand, TDataReader, TParameter> .StaticLoad((TDataReader)reader);
entity = Converter.InheritedEntityConvert <EnterpriseEntity, EnterpriseServiceEntity>(enterpriserEntity);
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceID"))
{
entity.EnterpriseServiceID = reader.GetInt32(reader.GetOrdinal("EnterpriseServiceID"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceGuid"))
{
entity.EnterpriseServiceGuid = reader.GetGuid(reader.GetOrdinal("EnterpriseServiceGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseGuid"))
{
entity.EnterpriseGuid = reader.GetGuid(reader.GetOrdinal("EnterpriseGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseInfo"))
{
entity.EnterpriseInfo = reader.GetString(reader.GetOrdinal("EnterpriseInfo"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceType"))
{
entity.EnterpriseServiceType = reader.GetInt32(reader.GetOrdinal("EnterpriseServiceType"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceStatus"))
{
entity.EnterpriseServiceStatus = (Logics)reader.GetInt32(reader.GetOrdinal("EnterpriseServiceStatus"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceContactPerson"))
{
entity.EnterpriseServiceContactPerson = reader.GetString(reader.GetOrdinal("EnterpriseServiceContactPerson"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceContactTelephone"))
{
entity.EnterpriseServiceContactTelephone = reader.GetString(reader.GetOrdinal("EnterpriseServiceContactTelephone"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceCreateDate"))
{
entity.EnterpriseServiceCreateDate = reader.GetDateTime(reader.GetOrdinal("EnterpriseServiceCreateDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceCreateUserKey"))
{
entity.EnterpriseServiceCreateUserKey = reader.GetString(reader.GetOrdinal("EnterpriseServiceCreateUserKey"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceStartDate"))
{
entity.EnterpriseServiceStartDate = reader.GetDateTime(reader.GetOrdinal("EnterpriseServiceStartDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseServiceStopDate"))
{
entity.EnterpriseServiceStopDate = reader.GetDateTime(reader.GetOrdinal("EnterpriseServiceStopDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ProviderUserGuid"))
{
entity.ProviderUserGuid = reader.GetGuid(reader.GetOrdinal("ProviderUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ProviderUserName"))
{
entity.ProviderUserName = reader.GetString(reader.GetOrdinal("ProviderUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "RecommendUserGuid"))
{
entity.RecommendUserGuid = reader.GetGuid(reader.GetOrdinal("RecommendUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "RecommendUserName"))
{
entity.RecommendUserName = reader.GetString(reader.GetOrdinal("RecommendUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ServiceUserGuid"))
{
entity.ServiceUserGuid = reader.GetGuid(reader.GetOrdinal("ServiceUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ServiceUserName"))
{
entity.ServiceUserName = reader.GetString(reader.GetOrdinal("ServiceUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "FinanceUserGuid"))
{
entity.FinanceUserGuid = reader.GetGuid(reader.GetOrdinal("FinanceUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "FinanceUserName"))
{
entity.FinanceUserName = reader.GetString(reader.GetOrdinal("FinanceUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "BusinessUserGuid"))
{
entity.BusinessUserGuid = reader.GetGuid(reader.GetOrdinal("BusinessUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "BusinessUserName"))
{
entity.BusinessUserName = reader.GetString(reader.GetOrdinal("BusinessUserName"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "SettleUserGuid"))
{
entity.SettleUserGuid = reader.GetGuid(reader.GetOrdinal("SettleUserGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "SettleUserName"))
{
entity.SettleUserName = reader.GetString(reader.GetOrdinal("SettleUserName"));
}
}
}
