public static ProductPrice PopulateProductPriceFromIDataReader(IDataReader dr)
{
ProductPrice productPrice = new ProductPrice();
productPrice.PriceID = DataRecordHelper.GetInt32(dr, "PriceID");
productPrice.ProductID = DataRecordHelper.GetInt32(dr, "ProductID");
productPrice.ModelID = DataRecordHelper.GetInt32(dr, "ModelID");
productPrice.DeliverySpan = DataRecordHelper.GetString(dr, "DeliverySpan");
productPrice.WarrantySpan = DataRecordHelper.GetString(dr, "WarrantySpan");
productPrice.IncludeFreight = (PriceIncludeType)DataRecordHelper.GetInt32(dr, "IncludeFreight");
productPrice.IncludeTax = (PriceIncludeType)DataRecordHelper.GetInt32(dr, "IncludeTax");
productPrice.ApplyTaxRate = DataRecordHelper.GetDecimal(dr, "ApplyTaxRate");
productPrice.QuoteMOQ = DataRecordHelper.GetInt32(dr, "QuoteMOQ");
productPrice.PriceMarket = DataRecordHelper.GetNullableDecimal(dr, "PriceMarket");
productPrice.PricePromotion = DataRecordHelper.GetNullableDecimal(dr, "PricePromotion");
productPrice.PriceFloor = DataRecordHelper.GetNullableDecimal(dr, "PriceFloor");
productPrice.PricePurchase = DataRecordHelper.GetNullableDecimal(dr, "PricePurchase");
productPrice.PriceGradeA = DataRecordHelper.GetNullableDecimal(dr, "PriceGradeA");
productPrice.PriceGradeB = DataRecordHelper.GetNullableDecimal(dr, "PriceGradeB");
productPrice.PriceGradeC = DataRecordHelper.GetNullableDecimal(dr, "PriceGradeC");
productPrice.PriceGradeD = DataRecordHelper.GetNullableDecimal(dr, "PriceGradeD");
productPrice.PriceGradeE = DataRecordHelper.GetNullableDecimal(dr, "PriceGradeE");
productPrice.SupplyRegion = DataRecordHelper.GetInt32(dr, "SupplyRegion");
productPrice.QuoteFrom = DataRecordHelper.GetDateTime(dr, "QuoteFrom");
productPrice.QuoteEnd = DataRecordHelper.GetDateTime(dr, "QuoteEnd");
productPrice.QuoteRenewal = DataRecordHelper.GetInt32(dr, "QuoteRenewal");
productPrice.SupplyStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "SupplyStatus");
productPrice.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
productPrice.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
productPrice.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
productPrice.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
productPrice.SetSerializerData(CommonDataProvider.PopulateSerializerDataIDataRecord(dr));
return(productPrice);
}
public static User PopulateUserFromIDataReader(IDataReader dr)
{
User user = new User();
user.UserID = DataRecordHelper.GetInt32(dr, "UserID");
user.UserType = (UserType)DataRecordHelper.GetInt32(dr, "UserType");
user.CompanyID = DataRecordHelper.GetInt32(dr, "CompanyID", 0);
user.OrganizationID = DataRecordHelper.GetInt32(dr, "OrganizationID", 0);
user.IsManager = DataRecordHelper.GetInt32(dr, "IsManager", 2);
user.UserName = DataRecordHelper.GetString(dr, "LoginName");
user.Password = DataRecordHelper.GetString(dr, "Password");
user.DisplayName = DataRecordHelper.GetString(dr, "DisplayName", string.Empty);
user.Email = DataRecordHelper.GetString(dr, "UserEmail", string.Empty);
user.Mobile = DataRecordHelper.GetString(dr, "UserMobile", string.Empty);
user.Phone = DataRecordHelper.GetString(dr, "UserPhone", string.Empty);
user.Fax = DataRecordHelper.GetString(dr, "UserFax", string.Empty);
user.Department = DataRecordHelper.GetString(dr, "UserDepartment", string.Empty);
user.Title = DataRecordHelper.GetString(dr, "UserTitle", string.Empty);
user.Remark = DataRecordHelper.GetString(dr, "UserMemo", string.Empty);
user.AccountStatus = (AccountStatus)DataRecordHelper.GetInt32(dr, "UserStatus");
user.PasswordQuestion = DataRecordHelper.GetString(dr, "PasswordQuestion", string.Empty);
user.PasswordAnswer = DataRecordHelper.GetString(dr, "PasswordAnswer", string.Empty);
user.LastLockonDate = DataRecordHelper.GetDateTime(dr, "LastLockTime", GlobalSettings.MinValue);
user.LastActiveDate = DataRecordHelper.GetDateTime(dr, "LastActiveTime", GlobalSettings.MinValue);
user.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime", GlobalSettings.MinValue);
user.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser", 0);
user.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime", GlobalSettings.MinValue);
user.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser", 0);
user.SetSerializerData(PopulateSerializerDataIDataRecord(dr));
return(user);
}
public static ProductSupply PopulateProductSupplyFromIDataReader(IDataReader dr)
{
ProductSupply result = new ProductSupply();
result.ApplyTaxRate = DataRecordHelper.GetDecimal(dr, "ApplyTaxRate");
result.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
result.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
result.DeliverySpan = DataRecordHelper.GetString(dr, "DeliverySpan");
result.IncludeFreight = (FreightIncludeType?)DataRecordHelper.GetNullableInt32(dr, "IncludeFreight");
result.IncludeTax = (TaxIncludeType)DataRecordHelper.GetInt32(dr, "IncludeTax");
result.ModelID = DataRecordHelper.GetNullableInt32(dr, "ModelID");
result.ProductID = DataRecordHelper.GetInt32(dr, "ProductID");
result.QuoteEnd = DataRecordHelper.GetDateTime(dr, "QuoteEnd");
result.QuoteFrom = DataRecordHelper.GetDateTime(dr, "QuoteFrom");
result.QuoteMOQ = DataRecordHelper.GetNullableInt32(dr, "QuoteMOQ");
result.QuotePrice = DataRecordHelper.GetNullableDecimal(dr, "QuotePrice");
result.QuoteRenewal = DataRecordHelper.GetInt32(dr, "QuoteRenewal");
result.SupplierID = DataRecordHelper.GetInt32(dr, "SupplierID");
result.SupplyID = DataRecordHelper.GetInt32(dr, "SupplyID");
result.SupplyRegion = DataRecordHelper.GetNullableInt32(dr, "SupplyRegion");
result.SupplyStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "SupplyStatus");
result.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
result.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
result.WarrantySpan = DataRecordHelper.GetString(dr, "WarrantySpan");
return(result);
}
/// <summary>
/// 获取文章
/// </summary>
/// <param name="dr"></param>
public static Article ParseArticle(IDataReader dr)
{
Article result = new Article()
{
ID = DataRecordHelper.GetInt32(dr, "ArticleID"),
Title = DataRecordHelper.GetString(dr, "ArticleTitle"),
SubTitle = DataRecordHelper.GetString(dr, "ArticleSubtitle"),
Abstract = DataRecordHelper.GetString(dr, "ArticleAbstract"),
Content = DataRecordHelper.GetString(dr, "ArticleContent"),
Date = DataRecordHelper.GetDateTime(dr, "ArticleDate"),
CopyFrom = DataRecordHelper.GetString(dr, "ArticleCopyFrom"),
Author = DataRecordHelper.GetString(dr, "ArticleAuthor"),
Keywords = DataRecordHelper.GetString(dr, "ArticleKeywords"),
Image = DataRecordHelper.GetInt32(dr, "ArticleImageID"),
Category = DataRecordHelper.GetInt32(dr, "CategoryID"),
DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder"),
ArticleMemo = DataRecordHelper.GetString(dr, "ArticleMemo"),
Status = (ComponentStatus)DataRecordHelper.GetInt32(dr, "ArticleStatus"),
HitTimes = DataRecordHelper.GetInt32(dr, "HitTimes"),
CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime"),
CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser"),
UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime"),
UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser"),
};
result.SetSerializerData(CommonDataProvider.PopulateSerializerDataIDataRecord(dr));
return(result);
}
public static Tag PopulateTagFromIDataReader(IDataReader dr)
{
Tag tagCloud = new Tag();
tagCloud.Name = DataRecordHelper.GetString(dr, "TagName");
tagCloud.ItemCount = DataRecordHelper.GetInt32(dr, "TagHitCount");
tagCloud.DateCreated = DataRecordHelper.GetDateTime(dr, "CreateTime");
tagCloud.LastModified = DataRecordHelper.GetDateTime(dr, "UpdateTime");
return(tagCloud);
}
public static WordStatistic ReadStatistic(IDataReader dr)
{
return(new WordStatistic()
{
StatisticID = DataRecordHelper.GetInt32(dr, "StatisticID"),
HitCount = DataRecordHelper.GetDecimal(dr, "HitCount"),
SearchWord = DataRecordHelper.GetString(dr, "SearchWord"),
CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime"),
UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime")
});
}
public static UserActivity PopulateUserActivityFromIDataReader(IDataReader dr)
{
UserActivity userActivity = new UserActivity();
userActivity.UserActivityID = DataRecordHelper.GetInt32(dr, "UserActivityID");
userActivity.ActivityID = DataRecordHelper.GetInt32(dr, "ActivityID");
userActivity.ActivityTitle = DataRecordHelper.GetString(dr, "ActivityTitle");
userActivity.ActivityContent = DataRecordHelper.GetString(dr, "ActivityContent");
userActivity.ActivityTime = DataRecordHelper.GetDateTime(dr, "ActivityTime");
userActivity.ActivityUser = DataRecordHelper.GetInt32(dr, "ActivityUser");
return(userActivity);
}
public static LinkUrl ReadLinkUrl(IDataReader dr)
{
return(new LinkUrl()
{
ID = DataRecordHelper.GetInt32(dr, "ID"),
CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime"),
CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser"),
Desc = DataRecordHelper.GetString(dr, "Desc"),
Title = DataRecordHelper.GetString(dr, "Title"),
Url = DataRecordHelper.GetString(dr, "Url")
});
}
public static FriendLink ReadFriendLink(IDataReader dr)
{
return(new FriendLink()
{
ID = DataRecordHelper.GetInt32(dr, "ID"),
CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime"),
CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser"),
Rank = DataRecordHelper.GetInt32(dr, "Rank"),
Title = DataRecordHelper.GetString(dr, "Title"),
Url = DataRecordHelper.GetString(dr, "Url")
});
}
public static Role ConvertDataReader2RoleEntity(IDataReader reader)
{
return(new Role(DataRecordHelper.GetInt32(reader, "RoleID"),
DataRecordHelper.GetString(reader, "RoleName"),
DataRecordHelper.GetString(reader, "RoleDesc"),
DataRecordHelper.GetString(reader, "RoleMemo"),
DataRecordHelper.GetInt32(reader, "RoleStatus"),
DataRecordHelper.GetDateTime(reader, "CreateTime"),
DataRecordHelper.GetInt32(reader, "CreateUser"),
DataRecordHelper.GetDateTime(reader, "UpdateTime"),
DataRecordHelper.GetInt32(reader, "UpdateUser")));
}
public static Shopping ReadShopping(IDataReader dr)
{
return(new Shopping()
{
CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime"),
ModelID = DataRecordHelper.GetInt32(dr, "ModelID"),
ProductID = DataRecordHelper.GetInt32(dr, "ProductID"),
Quantity = DataRecordHelper.GetInt32(dr, "Quantity"),
ShoppingMemo = DataRecordHelper.GetString(dr, "ShoppingMemo"),
ShoppingID = DataRecordHelper.GetInt32(dr, "ShoppingID"),
UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime"),
UserID = DataRecordHelper.GetString(dr, "UserID"),
});
}
public static CompanyCredit ReadCompanyCredit(IDataReader dr)
{
return(new CompanyCredit()
{
CreditID = DataRecordHelper.GetInt32(dr, "CreditID"),
SupplierID = DataRecordHelper.GetInt32(dr, "SupplierID"),
CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime"),
CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser"),
CreditAmount = DataRecordHelper.GetDecimal(dr, "CreditAmount"),
CreditDate = DataRecordHelper.GetDateTime(dr, "CreditDate"),
CreditDelta = DataRecordHelper.GetDecimal(dr, "CreditDelta"),
CreditDesc = DataRecordHelper.GetString(dr, "CreditDesc"),
CreditMemo = DataRecordHelper.GetString(dr, "CreditMemo")
});
}
public static Area PopulateAreaFromIDataReader(IDataReader dr)
{
Area codeRegion = new Area();
codeRegion.RegionID = DataRecordHelper.GetInt32(dr, "RegionID");
codeRegion.RegionType = (AreaType)DataRecordHelper.GetInt32(dr, "RegionType");
codeRegion.RegionCode = DataRecordHelper.GetString(dr, "RegionCode");
codeRegion.DistrictCode = DataRecordHelper.GetString(dr, "DistrictCode");
codeRegion.RegionName = DataRecordHelper.GetString(dr, "RegionName");
codeRegion.RegionDesc = DataRecordHelper.GetString(dr, "RegionDesc");
codeRegion.RegionMemo = DataRecordHelper.GetString(dr, "RegionMemo");
codeRegion.RegionStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "RegionStatus");
codeRegion.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
codeRegion.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
return(codeRegion);
}
public static Favorite PopulateFavoriteFromIDataReader(IDataReader dr)
{
Favorite favorite = new Favorite();
favorite.FavoriteID = DataRecordHelper.GetInt32(dr, "FavoriteID");
favorite.UserID = DataRecordHelper.GetInt32(dr, "UserID");
favorite.FavoriteType = (FavoriteType)DataRecordHelper.GetInt32(dr, "FavoriteType");
favorite.FavoriteTitle = DataRecordHelper.GetString(dr, "FavoriteTitle");
favorite.RelatedID = DataRecordHelper.GetInt32(dr, "RelatedID");
favorite.FavoriteUrl = DataRecordHelper.GetString(dr, "FavoriteUrl");
favorite.FavoriteLevel = DataRecordHelper.GetInt32(dr, "FavoriteLevel");
favorite.FavoriteMemo = DataRecordHelper.GetString(dr, "FavoriteMemo");
favorite.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
favorite.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
return(favorite);
}
public static CompanyDeposit ReadCompanyDeposit(IDataReader dr)
{
return(new CompanyDeposit()
{
CompanyID = DataRecordHelper.GetInt32(dr, "CompanyID"),
CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime"),
CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser"),
DepositAmount = DataRecordHelper.GetDecimal(dr, "DepositAmount"),
DepositDate = DataRecordHelper.GetDateTime(dr, "DepositDate"),
DepositDelta = DataRecordHelper.GetDecimal(dr, "DepositDelta"),
DepositDesc = DataRecordHelper.GetString(dr, "DepositDesc"),
DepositID = DataRecordHelper.GetInt32(dr, "DepositID"),
DepositMemo = DataRecordHelper.GetString(dr, "DepositMemo"),
DepositType = (DepositType)DataRecordHelper.GetInt32(dr, "DepositType")
});
}
public static Pending ReadPending(IDataReader reader)
{
return(new Pending()
{
ID = DataRecordHelper.GetInt32(reader, "ID"),
CompanyID = DataRecordHelper.GetInt32(reader, "CompanyID"),
CompanyType = (CompanyType)DataRecordHelper.GetInt32(reader, "CompanyType"),
Status = (PendingStatus)DataRecordHelper.GetInt32(reader, "Status"),
CreateTime = DataRecordHelper.GetDateTime(reader, "CreateTime"),
CreateUser = DataRecordHelper.GetInt32(reader, "CreateUser"),
DenyReason = DataRecordHelper.GetString(reader, "DenyReason"),
Description = DataRecordHelper.GetString(reader, "Description"),
UpdateTime = DataRecordHelper.GetDateTime(reader, "UpdateTime"),
UpdateUser = DataRecordHelper.GetInt32(reader, "UpdateUser")
});
}
public static CompanyQualification PopulateQualificationFromIDataReader(IDataReader dr)
{
CompanyQualification qualification = new CompanyQualification();
qualification.QualificationID = DataRecordHelper.GetInt32(dr, "QualificationID");
qualification.CompanyID = DataRecordHelper.GetInt32(dr, "CompanyID");
qualification.QualificationFile = DataRecordHelper.GetString(dr, "QualificationFile");
qualification.QualificationName = DataRecordHelper.GetString(dr, "QualificationName");
qualification.QualificationDesc = DataRecordHelper.GetString(dr, "QualificationDesc");
qualification.QualificationMemo = DataRecordHelper.GetString(dr, "QualificationMemo");
qualification.QualificationStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "QualificationStatus");
qualification.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
qualification.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
qualification.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
qualification.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
return(qualification);
}
public static ProductPicture PopulateProductPictureFromIDataReader(IDataReader dr)
{
ProductPicture productPicture = new ProductPicture();
productPicture.PictureID = DataRecordHelper.GetInt32(dr, "PictureID");
productPicture.ProductID = DataRecordHelper.GetInt32(dr, "ProductID");
productPicture.ModelID = DataRecordHelper.GetInt32(dr, "ModelID");
productPicture.DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder");
productPicture.PictureName = DataRecordHelper.GetString(dr, "PictureName");
productPicture.PictureFile = DataRecordHelper.GetString(dr, "PictureFile");
productPicture.PictureStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "PictureStatus");
productPicture.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
productPicture.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
productPicture.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
productPicture.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
return(productPicture);
}
public static ProductCategory PopulateCategoryFromIDataReader(IDataReader dr)
{
ProductCategory category = new ProductCategory();
category.CategoryID = DataRecordHelper.GetInt32(dr, "CategoryID");
category.CategoryName = DataRecordHelper.GetString(dr, "CategoryName");
category.CategoryDesc = DataRecordHelper.GetString(dr, "CategoryDesc");
category.ParentID = DataRecordHelper.GetInt32(dr, "ParentID");
category.PropertyID = DataRecordHelper.GetInt32(dr, "PropertyID");
category.DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder");
category.CategoryStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "CategoryStatus");
category.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
category.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
category.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
category.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
return(category);
}
public ProductModel PopulateProductModelFromIDataReader(IDataReader dr)
{
ProductModel productModel = new ProductModel();
productModel.ModelID = DataRecordHelper.GetInt32(dr, "ModelID");
productModel.ProductID = DataRecordHelper.GetInt32(dr, "ProductID");
productModel.ModelCode = DataRecordHelper.GetString(dr, "ModelCode");
productModel.ModelName = DataRecordHelper.GetString(dr, "ModelName");
productModel.ModelDesc = DataRecordHelper.GetString(dr, "ModelDesc");
productModel.ModelStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "ModelStatus");
productModel.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
productModel.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
productModel.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
productModel.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
productModel.SetSerializerData(CommonDataProvider.PopulateSerializerDataIDataRecord(dr));
return(productModel);
}
/// <summary>
/// 分类
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static ArticleCategory ParseArticleCategory(IDataReader dr)
{
return(new ArticleCategory()
{
ID = DataRecordHelper.GetInt32(dr, "CategoryID"),
Name = DataRecordHelper.GetString(dr, "CategoryName"),
Description = DataRecordHelper.GetString(dr, "CategoryDesc"),
Memo = DataRecordHelper.GetString(dr, "CategoryMemo"),
ParentID = DataRecordHelper.GetNullableInt32(dr, "ParentID"),
DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder"),
Status = (ComponentStatus)DataRecordHelper.GetInt32(dr, "CategoryStatus"),
CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime"),
CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser"),
UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime"),
UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser"),
});
}
public static Organization PopulateOrganizationFromIDataReader(IDataReader dr)
{
Organization organization = new Organization();
organization.OrganizationID = DataRecordHelper.GetInt32(dr, "OrganizationID");
organization.OrganizationName = DataRecordHelper.GetString(dr, "OrganizationName");
organization.OrganizationDesc = DataRecordHelper.GetString(dr, "OrganizationDesc");
organization.OrganizationMemo = DataRecordHelper.GetString(dr, "OrganizationMemo");
organization.ParentID = DataRecordHelper.GetInt32(dr, "ParentID");
organization.DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder");
organization.OrganizationStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "OrganizationStatus");
organization.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
organization.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
organization.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
organization.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
organization.SetSerializerData(PopulateSerializerDataIDataRecord(dr));
return(organization);
}
public static CustomerGrade PopulateCustomerGradeFromIDataReader(IDataReader dr)
{
CustomerGrade customerGrade = new CustomerGrade();
customerGrade.GradeID = DataRecordHelper.GetInt32(dr, "GradeID");
customerGrade.CompanyID = DataRecordHelper.GetInt32(dr, "CustomerID");
customerGrade.GradeLevel = (UserLevel)DataRecordHelper.GetInt32(dr, "GradeLevel");
customerGrade.GradeLimit = DataRecordHelper.GetString(dr, "GradeLimit");
customerGrade.GradeName = DataRecordHelper.GetString(dr, "GradeName");
customerGrade.GradeDesc = DataRecordHelper.GetString(dr, "GradeDesc");
customerGrade.GradeMemo = DataRecordHelper.GetString(dr, "GradeMemo");
customerGrade.GradeStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "GradeStatus");
customerGrade.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
customerGrade.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
customerGrade.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
customerGrade.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
return(customerGrade);
}
public static ProductProperty PopulatePropertyFromIDataReader(IDataReader dr)
{
ProductProperty property = new ProductProperty();
property.PropertyID = DataRecordHelper.GetInt32(dr, "PropertyID");
property.PropertyName = DataRecordHelper.GetString(dr, "PropertyName");
property.PropertyDesc = DataRecordHelper.GetString(dr, "PropertyDesc");
property.CategoryID = DataRecordHelper.GetInt32(dr, "CategoryID");
property.DimensionEnabled = (ComponentStatus)DataRecordHelper.GetInt32(dr, "DimensionEnabled");
property.SubCategoryHidden = (SubCategoryHiddenType)DataRecordHelper.GetInt32(dr, "SubCategoryHidden");
property.DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder");
property.PropertyStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "PropertyStatus");
property.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
property.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
property.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
property.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
return(property);
}
public ProductIndustry PopulateIndustryFromIDataReader(IDataReader dr)
{
ProductIndustry industry = new ProductIndustry();
industry.IndustryID = DataRecordHelper.GetInt32(dr, "IndustryID");
industry.IndustryName = DataRecordHelper.GetString(dr, "IndustryName");
industry.IndustryLogo = DataRecordHelper.GetString(dr, "IndustryLogo");
industry.IndustryTitle = DataRecordHelper.GetString(dr, "IndustryTitle");
industry.IndustryAbstract = DataRecordHelper.GetString(dr, "IndustryAbstract");
industry.IndustryContent = DataRecordHelper.GetString(dr, "IndustryContent");
industry.ParentID = DataRecordHelper.GetInt32(dr, "ParentID");
industry.DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder");
industry.IndustryStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "IndustryStatus");
industry.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
industry.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
industry.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
industry.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
industry.SetSerializerData(CommonDataProvider.PopulateSerializerDataIDataRecord(dr));
return(industry);
}
public static ProductBrand PopulateBrandFromIDataReader(IDataReader dr)
{
ProductBrand brand = new ProductBrand();
brand.BrandID = DataRecordHelper.GetInt32(dr, "BrandID");
brand.BrandName = DataRecordHelper.GetString(dr, "BrandName");
brand.BrandLogo = DataRecordHelper.GetString(dr, "BrandLogo");
brand.BrandTitle = DataRecordHelper.GetString(dr, "BrandTitle");
brand.BrandGroup = DataRecordHelper.GetString(dr, "BrandGroup");
brand.BrandAbstract = DataRecordHelper.GetString(dr, "BrandAbstract");
brand.BrandContent = DataRecordHelper.GetString(dr, "BrandContent");
brand.DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder");
brand.BrandStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "BrandStatus");
brand.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
brand.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
brand.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
brand.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
brand.SetSerializerData(CommonDataProvider.PopulateSerializerDataIDataRecord(dr));
return(brand);
}
public static ProductFocus PopulateProductFocusFromIDataReader(IDataReader dr)
{
ProductFocus productFocus = new ProductFocus();
productFocus.FocusID = DataRecordHelper.GetInt32(dr, "FocusID");
productFocus.FocusType = (FocusType)DataRecordHelper.GetInt32(dr, "FocusType");
productFocus.FocusFrom = DataRecordHelper.GetDateTime(dr, "FocusFrom");
productFocus.FocusEnd = DataRecordHelper.GetDateTime(dr, "FocusEnd");
productFocus.ProductID = DataRecordHelper.GetInt32(dr, "ProductID");
productFocus.ModelID = DataRecordHelper.GetInt32(dr, "ModelID");
productFocus.DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder");
productFocus.FocusMemo = DataRecordHelper.GetString(dr, "FocusMemo");
productFocus.FocusStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "FocusStatus");
productFocus.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
productFocus.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
productFocus.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
productFocus.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
productFocus.SetSerializerData(CommonDataProvider.PopulateSerializerDataIDataRecord(dr));
return(productFocus);
}
public static Product PopulateProductFromIDataReader(IDataReader dr)
{
Product product = new Product();
product.ProductID = DataRecordHelper.GetInt32(dr, "ProductID");
product.ProductCode = DataRecordHelper.GetString(dr, "ProductCode");
product.ProductName = DataRecordHelper.GetString(dr, "ProductName");
product.ProductDesc = DataRecordHelper.GetString(dr, "ProductDesc");
product.ProductAbstract = DataRecordHelper.GetString(dr, "ProductAbstract");
product.ProductContent = DataRecordHelper.GetString(dr, "ProductContent");
product.BrandID = DataRecordHelper.GetInt32(dr, "BrandID");
product.ProductKeywords = DataRecordHelper.GetString(dr, "ProductKeywords");
product.ProductStatus = (ComponentStatus)DataRecordHelper.GetInt32(dr, "ProductStatus");
product.DisplayOrder = DataRecordHelper.GetInt32(dr, "DisplayOrder");
product.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
product.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
product.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
product.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
product.SetSerializerData(CommonDataProvider.PopulateSerializerDataIDataRecord(dr));
return(product);
}
/// <summary>
/// 资源
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static ArticleAttachment ParseArticleAttachment(IDataReader dr)
{
ArticleAttachment result = new ArticleAttachment();
result.ID = DataRecordHelper.GetInt32(dr, "AttachmentID");
result.FileName = DataRecordHelper.GetString(dr, "AttachmentFile");
result.Name = DataRecordHelper.GetString(dr, "AttachmentName");
result.ContentType = DataRecordHelper.GetString(dr, "ContentType");
result.ContentSize = DataRecordHelper.GetInt32(dr, "ContentSize");
result.IsRemote = DataRecordHelper.GetInt32(dr, "IsRemote") > 0;
result.ImageWidth = DataRecordHelper.GetNullableInt32(dr, "ImageWidth");
result.ImageHeight = DataRecordHelper.GetNullableInt32(dr, "ImageHeight");
result.Desc = DataRecordHelper.GetString(dr, "AttachmentDesc");
result.Memo = DataRecordHelper.GetString(dr, "AttachmentMemo");
result.Status = (ComponentStatus)DataRecordHelper.GetInt32(dr, "AttachmentStatus");
result.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
result.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
result.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
result.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
return(result);
}
public static Company PopulateCompanyFromIDataReader(IDataReader dr)
{
Company company = new Company();
company.CompanyID = DataRecordHelper.GetInt32(dr, "CompanyID");
company.CompanyType = (CompanyType)DataRecordHelper.GetInt32(dr, "CompanyType", 1);
company.CompanyRegion = DataRecordHelper.GetInt32(dr, "CompanyRegion", 0);
company.CompanyName = DataRecordHelper.GetString(dr, "CompanyName", string.Empty);
company.Address = DataRecordHelper.GetString(dr, "CompanyAddress", string.Empty);
company.Zipcode = DataRecordHelper.GetString(dr, "CompanyZipcode");
company.Phone = DataRecordHelper.GetString(dr, "CompanyPhone");
company.Fax = DataRecordHelper.GetString(dr, "CompanyFax");
company.Website = DataRecordHelper.GetString(dr, "CompanyWebsite");
company.Orgcode = DataRecordHelper.GetString(dr, "CompanyOrgcode");
company.Regcode = DataRecordHelper.GetString(dr, "CompanyRegcode");
company.Remark = DataRecordHelper.GetString(dr, "CompanyMemo");
company.CompanyStatus = (CompanyStatus)DataRecordHelper.GetInt32(dr, "CompanyStatus");
company.CreateTime = DataRecordHelper.GetDateTime(dr, "CreateTime");
company.CreateUser = DataRecordHelper.GetInt32(dr, "CreateUser");
company.UpdateTime = DataRecordHelper.GetDateTime(dr, "UpdateTime");
company.UpdateUser = DataRecordHelper.GetInt32(dr, "UpdateUser");
company.SetSerializerData(PopulateSerializerDataIDataRecord(dr));
return(company);
}