/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static ProductDataEntity GetEntityFromrdr(NullableDataReader rdr)
{
ProductDataEntity info = new ProductDataEntity();
info.ID = rdr.GetInt32("ID");
info.ProductID = rdr.GetInt32("ProductID");
info.TableName = rdr.GetString("TableName");
info.PropertyValue = rdr.GetString("PropertyValue");
info.Stocks = rdr.GetInt32("Stocks");
info.OrderNum = rdr.GetInt32("OrderNum");
info.AlarmNum = rdr.GetInt32("AlarmNum");
info.BuyTimes = rdr.GetInt32("BuyTimes");
info.Weight = rdr.GetDouble("Weight");
info.Volume = rdr.GetDouble("Volume");
info.Price = rdr.GetDecimal("Price");
info.Price_Market = rdr.GetDecimal("Price_Market");
info.Price_Activity = rdr.GetDecimal("Price_Activity");
info.Price_Settlement = rdr.GetDecimal("Price_Settlement");
info.Price_Member = rdr.GetDecimal("Price_Member");
info.Price_Agent = rdr.GetDecimal("Price_Agent");
info.Price_Wholesale1 = rdr.GetDecimal("Price_Wholesale1");
info.Price_Wholesale2 = rdr.GetDecimal("Price_Wholesale2");
info.Price_Wholesale3 = rdr.GetDecimal("Price_Wholesale3");
info.Number_Wholesale1 = rdr.GetInt32("Number_Wholesale1");
info.Number_Wholesale2 = rdr.GetInt32("Number_Wholesale2");
info.Number_Wholesale3 = rdr.GetInt32("Number_Wholesale3");
info.IsValid = rdr.GetBoolean("IsValid");
return(info);
}
private static void DeliverChargeInfoFromrdr(DeliverChargeInfo deliverChargeInfo, NullableDataReader rdr)
{
deliverChargeInfo.ChargeMin = rdr.GetDecimal("Charge_Min");
deliverChargeInfo.WeightMin = rdr.GetDouble("Weight_Min");
deliverChargeInfo.ChargePerUnit = rdr.GetDecimal("ChargePerUnit");
deliverChargeInfo.WeightPerUnit = rdr.GetDouble("WeightPerUnit");
deliverChargeInfo.ChargeMax = rdr.GetDecimal("Charge_Max");
deliverChargeInfo.ArrArea = rdr.GetString("arrArea");
}
private static ShoppingCartInfo ShoppingCartFromrdr(NullableDataReader rdr, bool isDetail)
{
ShoppingCartInfo info = new ShoppingCartInfo();
info.UserName = rdr.GetString("UserName");
info.CartId = rdr.GetString("CartID");
info.ProductId = rdr.GetInt32("ProductID");
info.Quantity = rdr.GetInt32("Quantity");
info.IsPresent = rdr.GetBoolean("IsPresent");
info.UpdateTime = rdr.GetDateTime("UpdateTime");
info.TableName = rdr.GetString("TableName");
info.Property = rdr.GetString("Property");
info.InformResult = rdr.GetInt32("InformResult");
if (isDetail)
{
info.ProductInfomation.ProductName = rdr.GetString("ProductName");
info.ProductInfomation.ProductType = (ProductType)rdr.GetInt32("ProductType");
info.ProductInfomation.ProductPic = rdr.GetString("ProductPic");
info.ProductInfomation.ProductThumb = rdr.GetString("ProductThumb");
info.ProductInfomation.Unit = rdr.GetString("Unit");
info.ProductInfomation.ServiceTermUnit = (ServiceTermUnit)rdr.GetInt32("ServiceTermUnit");
info.ProductInfomation.ServiceTerm = rdr.GetInt32("ServiceTerm");
info.ProductInfomation.PriceInfo.Price = rdr.GetDecimal("Price");
info.ProductInfomation.PriceMarket = rdr.GetDecimal("Price_Market");
info.ProductInfomation.PriceInfo.PriceMember = rdr.GetDecimal("Price_Member");
info.ProductInfomation.PriceInfo.PriceAgent = rdr.GetDecimal("Price_Agent");
info.ProductInfomation.EnableWholesale = rdr.GetBoolean("EnableWholesale");
info.ProductInfomation.PriceInfo.PriceWholesale1 = rdr.GetDecimal("Price_Wholesale1");
info.ProductInfomation.PriceInfo.PriceWholesale2 = rdr.GetDecimal("Price_Wholesale2");
info.ProductInfomation.PriceInfo.PriceWholesale3 = rdr.GetDecimal("Price_Wholesale3");
info.ProductInfomation.PriceInfo.NumberWholesale1 = rdr.GetInt32("Number_Wholesale1");
info.ProductInfomation.PriceInfo.NumberWholesale2 = rdr.GetInt32("Number_Wholesale2");
info.ProductInfomation.PriceInfo.NumberWholesale3 = rdr.GetInt32("Number_Wholesale3");
info.ProductInfomation.PresentId = rdr.GetInt32("PresentID");
info.ProductInfomation.PresentNumber = rdr.GetInt32("PresentNumber");
info.ProductInfomation.PresentPoint = rdr.GetInt32("PresentPoint");
info.ProductInfomation.PresentExp = rdr.GetInt32("PresentExp");
info.ProductInfomation.PresentMoney = rdr.GetDecimal("PresentMoney");
info.ProductInfomation.StocksProject = (StocksProject)rdr.GetInt32("StocksProject");
info.ProductInfomation.SalePromotionType = rdr.GetInt32("SalePromotionType");
info.ProductInfomation.MinNumber = rdr.GetInt32("MinNumber");
info.ProductInfomation.Discount = rdr.GetDouble("Discount");
info.ProductInfomation.IncludeTax = (TaxRateType)rdr.GetInt32("IncludeTax");
info.ProductInfomation.TaxRate = rdr.GetDouble("TaxRate");
info.ProductInfomation.Properties = rdr.GetString("Properties");
info.ProductInfomation.Weight = rdr.GetDouble("Weight");
info.ProductInfomation.LimitNum = rdr.GetInt32("LimitNum");
info.ProductInfomation.EnableSingleSell = rdr.GetBoolean("EnableSingleSell");
info.ProductInfomation.DependentProducts = rdr.GetString("DependentProducts");
info.ProductInfomation.ProductKind = (ProductKind)rdr.GetInt32("ProductKind");
info.ProductInfomation.TableName = rdr.GetString("TableName");
info.ProductInfomation.ProductId = rdr.GetInt32("ProductID");
info.ProductInfomation.Stocks = rdr.GetInt32("Stocks");
info.ProductInfomation.OrderNum = rdr.GetInt32("OrderNum");
}
return(info);
}
private static StatIPInfo StatIPInfoListFromrdr(NullableDataReader rdr)
{
StatIPInfo info = new StatIPInfo();
info.StartIP = rdr.GetDouble("StartIp");
info.EndIP = rdr.GetDouble("EndIp");
info.Address = rdr.GetString("Address");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static StatIpInfoEntity GetEntityFromrdr(NullableDataReader rdr)
{
StatIpInfoEntity info = new StatIpInfoEntity();
info.ID = rdr.GetInt32("ID");
info.StartIp = rdr.GetDouble("StartIp");
info.EndIp = rdr.GetDouble("EndIp");
info.Address = rdr.GetString("Address");
return(info);
}
private static PackageInfo PackageFromrdr(NullableDataReader rdr)
{
PackageInfo info = new PackageInfo();
info.PackageId = rdr.GetInt32("PackageId");
info.PackageName = rdr.GetString("PackageName");
info.PackageWeight = rdr.GetDouble("PackageWeight");
info.GoodsWeightMin = rdr.GetDouble("GoodsWeightMin");
info.GoodsWeightMax = rdr.GetDouble("GoodsWeightMax");
return(info);
}
private static DeliverChargeInfo CreateInfo(NullableDataReader rdr)
{
DeliverChargeInfo info = new DeliverChargeInfo();
info.Id = rdr.GetInt32("Id");
info.DeliverTypeId = rdr.GetInt32("DeliverTypeId");
info.AreaType = rdr.GetInt32("AreaType");
info.ArrArea = rdr["arrArea"].ToString();
info.ChargeMin = rdr.GetDecimal("Charge_Min");
info.WeightMin = rdr.GetDouble("Weight_Min");
info.ChargePerUnit = rdr.GetDecimal("ChargePerUnit");
info.WeightPerUnit = rdr.GetDouble("WeightPerUnit");
info.ChargeMax = rdr.GetDecimal("Charge_Max");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static DeliverChargeEntity GetEntityFromrdr(NullableDataReader rdr)
{
DeliverChargeEntity info = new DeliverChargeEntity();
info.ID = rdr.GetInt32("ID");
info.DeliverTypeID = rdr.GetInt32("DeliverTypeID");
info.AreaType = rdr.GetInt32("AreaType");
info.ArrArea = rdr.GetString("arrArea");
info.Charge_Min = rdr.GetDecimal("Charge_Min");
info.Weight_Min = rdr.GetDouble("Weight_Min");
info.ChargePerUnit = rdr.GetDecimal("ChargePerUnit");
info.WeightPerUnit = rdr.GetDouble("WeightPerUnit");
info.Charge_Max = rdr.GetDecimal("Charge_Max");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static PresentEntity GetEntityFromrdr(NullableDataReader rdr)
{
PresentEntity info = new PresentEntity();
info.PresentID = rdr.GetInt32("PresentID");
info.PresentName = rdr.GetString("PresentName");
info.PresentPic = rdr.GetString("PresentPic");
info.Unit = rdr.GetString("Unit");
info.PresentNum = rdr.GetString("PresentNum");
info.ServiceTermUnit = rdr.GetInt32("ServiceTermUnit");
info.ServiceTerm = rdr.GetInt32("ServiceTerm");
info.Price = rdr.GetDecimal("Price");
info.Price_Market = rdr.GetDecimal("Price_Market");
info.Weight = rdr.GetDouble("Weight");
info.Stocks = rdr.GetInt32("Stocks");
info.StocksProject = rdr.GetInt32("StocksProject");
info.OrderNum = rdr.GetInt32("OrderNum");
info.AlarmNum = rdr.GetInt32("AlarmNum");
info.ProductCharacter = rdr.GetInt32("ProductCharacter");
info.DownloadUrl = rdr.GetString("DownloadUrl");
info.Remark = rdr.GetString("Remark");
info.PresentThumb = rdr.GetString("PresentThumb");
info.PresentIntro = rdr.GetString("PresentIntro");
info.PresentExplain = rdr.GetString("PresentExplain");
return(info);
}
private static OrderItemInfo OrderItemFromrdr(NullableDataReader rdr)
{
OrderItemInfo info = new OrderItemInfo();
info.ItemId = rdr.GetInt32("ItemID");
info.OrderId = rdr.GetInt32("OrderID");
info.ProductId = rdr.GetInt32("ProductID");
info.TableName = rdr.GetString("TableName");
info.Property = rdr.GetString("Property");
info.SaleType = rdr.GetInt32("SaleType");
info.PriceMarket = rdr.GetDecimal("Price_Market");
info.Price = rdr.GetDecimal("Price");
info.TruePrice = rdr.GetDecimal("TruePrice");
info.Amount = rdr.GetInt32("Amount");
info.SubTotal = rdr.GetDecimal("SubTotal");
info.BeginDate = rdr.GetDateTime("BeginDate");
info.ServiceTerm = rdr.GetInt32("ServiceTerm");
info.Remark = rdr.GetString("Remark");
info.PresentMoney = rdr.GetDecimal("PresentMoney");
info.PresentPoint = rdr.GetInt32("PresentPoint");
info.PresentExp = rdr.GetInt32("PresentExp");
info.ServiceTermUnit = (ServiceTermUnit)rdr.GetInt32("ServiceTermUnit");
info.ProductCharacter = (ProductCharacter)rdr.GetInt32("ProductCharacter");
info.ProductName = rdr.GetString("ProductName");
info.Unit = rdr.GetString("Unit");
info.Weight = rdr.GetDouble("Weight");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static DeliverTypeEntity GetEntityFromrdr(NullableDataReader rdr)
{
DeliverTypeEntity info = new DeliverTypeEntity();
info.TypeID = rdr.GetInt32("TypeID");
info.TypeName = rdr.GetString("TypeName");
info.Intro = rdr.GetString("Intro");
info.ChargeType = rdr.GetInt32("ChargeType");
info.IsDefault = rdr.GetBoolean("IsDefault");
info.IsDisabled = rdr.GetBoolean("IsDisabled");
info.OrderSort = rdr.GetInt32("OrderSort");
info.ReleaseType = rdr.GetInt32("ReleaseType");
info.MinMoney1 = rdr.GetDecimal("MinMoney1");
info.ReleaseCharge = rdr.GetDecimal("ReleaseCharge");
info.Minmoney2 = rdr.GetDecimal("Minmoney2");
info.MaxCharge = rdr.GetDecimal("MaxCharge");
info.MinMoney3 = rdr.GetDecimal("MinMoney3");
info.Charge_Min = rdr.GetDecimal("Charge_Min");
info.Charge_Max = rdr.GetDecimal("Charge_Max");
info.Charge_Percent = rdr.GetInt16("Charge_Percent");
info.IncludeTax = rdr.GetInt32("IncludeTax");
info.TaxRate = rdr.GetDouble("TaxRate");
info.StoreID = rdr.GetInt32("StoreID");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static U_AwardEntity GetEntityFromrdr(NullableDataReader rdr)
{
U_AwardEntity info = new U_AwardEntity();
info.ID = rdr.GetInt32("ID");
info.Weight = rdr.GetDouble("Weight");
info.Number = rdr.GetString("Number");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static OrderItemEntity GetEntityFromrdr(NullableDataReader rdr)
{
OrderItemEntity info = new OrderItemEntity();
info.ItemID = rdr.GetInt32("ItemID");
info.OrderID = rdr.GetInt32("OrderID");
info.ProductID = rdr.GetInt32("ProductID");
info.TableName = rdr.GetString("TableName");
info.Property = rdr.GetString("Property");
info.SaleType = rdr.GetInt32("SaleType");
info.Price_Market = rdr.GetDecimal("Price_Market");
info.Price = rdr.GetDecimal("Price");
info.Price_Activity = rdr.GetDecimal("Price_Activity");
info.Price_Settlement = rdr.GetDecimal("Price_Settlement");
info.TruePrice = rdr.GetDecimal("TruePrice");
info.Amount = rdr.GetInt32("Amount");
info.SubTotal = rdr.GetDecimal("SubTotal");
info.BeginDate = rdr.GetNullableDateTime("BeginDate");
info.ServiceTerm = rdr.GetDouble("ServiceTerm");
info.ServiceTermUnit = rdr.GetInt32("ServiceTermUnit");
info.Remark = rdr.GetString("Remark");
info.PresentMoney = rdr.GetDecimal("PresentMoney");
info.PresentPoint = rdr.GetInt32("PresentPoint");
info.PresentExp = rdr.GetInt32("PresentExp");
info.ProductCharacter = rdr.GetInt32("ProductCharacter");
info.ProductName = rdr.GetString("ProductName");
info.Unit = rdr.GetString("Unit");
info.Weight = rdr.GetDouble("Weight");
info.ChargeDeliverItem = rdr.GetDecimal("ChargeDeliverItem");
info.DeliverStatusItem = rdr.GetInt32("DeliverStatusItem");
info.PayStatusItem = rdr.GetInt32("PayStatusItem");
info.DownPayment = rdr.GetDecimal("DownPayment");
info.YearRate = rdr.GetDecimal("YearRate");
info.Fee = rdr.GetDecimal("Fee");
info.MerchantRebate = rdr.GetDecimal("MerchantRebate");
info.Deadline = rdr.GetInt32("Deadline");
info.SubTotalHP = rdr.GetDecimal("SubTotalHP");
return(info);
}
private static PayPlatformInfo PayPlatformFromDataReader(NullableDataReader rdr)
{
PayPlatformInfo info = new PayPlatformInfo();
info.PayPlatformId = rdr.GetInt32("PayPlatformID");
info.PayPlatformName = rdr.GetString("PayPlatformName");
info.Rate = rdr.GetDouble("Rate");
info.MD5 = rdr.GetString("MD5");
info.AccountsId = rdr.GetString("AccountsId");
info.OrderId = rdr.GetInt32("OrderID");
info.IsDisabled = rdr.GetBoolean("IsDisabled");
info.IsDefault = rdr.GetBoolean("IsDefault");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static PayPlatFormEntity GetEntityFromrdr(NullableDataReader rdr)
{
PayPlatFormEntity info = new PayPlatFormEntity();
info.PayPlatformID = rdr.GetInt32("PayPlatformID");
info.PayPlatformName = rdr.GetString("PayPlatformName");
info.AccountsID = rdr.GetString("AccountsID");
info.MD5 = rdr.GetString("MD5");
info.Rate = rdr.GetDouble("Rate");
info.OrderSort = rdr.GetInt32("OrderSort");
info.IsDisabled = rdr.GetBoolean("IsDisabled");
info.IsDefault = rdr.GetBoolean("IsDefault");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static PaymentTypeEntity GetEntityFromrdr(NullableDataReader rdr)
{
PaymentTypeEntity info = new PaymentTypeEntity();
info.TypeID = rdr.GetInt32("TypeID");
info.TypeName = rdr.GetString("TypeName");
info.Intro = rdr.GetString("Intro");
info.Discount = rdr.GetDouble("Discount");
info.OrderSort = rdr.GetInt32("OrderSort");
info.IsDefault = rdr.GetBoolean("IsDefault");
info.IsDisabled = rdr.GetBoolean("IsDisabled");
info.Category = rdr.GetInt32("Category");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static U_ArticleEntity GetEntityFromrdr(NullableDataReader rdr)
{
U_ArticleEntity info = new U_ArticleEntity();
info.ID = rdr.GetInt32("ID");
info.Intro = rdr.GetString("Intro");
info.PaginationType = rdr.GetString("PaginationType");
info.MaxCharPerPage = rdr.GetDouble("MaxCharPerPage");
info.Content = rdr.GetString("Content");
info.SEO_Keyword = rdr.GetString("SEO_Keyword");
info.SEO_Desc = rdr.GetString("SEO_Desc");
info.SEO_Title = rdr.GetString("SEO_Title");
return(info);
}
/// <summary>
/// 通过数据读取器生成实体类
/// </summary>
/// <param name="rdr"></param>
/// <returns></returns>
private static U_UserTextEntity GetEntityFromrdr(NullableDataReader rdr)
{
U_UserTextEntity info = new U_UserTextEntity();
info.ID = rdr.GetInt32("ID");
info.Nominate = rdr.GetString("Nominate");
info.RegIP = rdr.GetString("RegIP");
info.QQOpenID = rdr.GetString("QQOpenID");
info.QQWeiboOpenID = rdr.GetString("QQWeiboOpenID");
info.RenrenOpenID = rdr.GetString("RenrenOpenID");
info.SinaOpenID = rdr.GetString("SinaOpenID");
info.SharingRatio = rdr.GetDouble("SharingRatio");
info.WxOpenID = rdr.GetString("WxOpenID");
return(info);
}
public IList <CompareHitsOrderNumberInfo> GetCompareHitsOrderNumberList(int startRowIndexId, int maxNumberRows, int orderType)
{
string str;
Database database = DatabaseFactory.CreateDatabase();
DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Shop_Statistics_GetList");
switch (orderType)
{
case 1:
str = "SUM(M.Hits)";
break;
case 2:
str = "SUM(P.BuyTimes)";
break;
default:
str = "(SUM(P.BuyTimes)*1.0)/(SUM(M.Hits))";
break;
}
database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, str);
database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "Max(P.ProductName) AS ProductName, SUM(M.Hits) AS Hits, SUM(P.BuyTimes) AS BuyTimes, CONVERT(float,(SUM(P.BuyTimes)*1.0)/(SUM(M.Hits))) AS CompareRate");
database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonProduct P INNER JOIN PE_CommonModel M ON P.TableName = M.TableName AND P.ProductID = M.ItemID");
database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "M.Hits > 0");
database.AddInParameter(storedProcCommand, "@ID", DbType.String, "P.ProductID");
database.AddInParameter(storedProcCommand, "@Group", DbType.String, "Group by P.ProductID");
database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
IList <CompareHitsOrderNumberInfo> list = new List <CompareHitsOrderNumberInfo>();
using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
{
while (reader.Read())
{
CompareHitsOrderNumberInfo item = new CompareHitsOrderNumberInfo();
item.ProductName = reader.GetString("ProductName");
item.Hits = reader.GetInt32("Hits");
item.OrderNumber = reader.GetInt32("BuyTimes");
item.CompareRate = reader.GetDouble("CompareRate");
list.Add(item);
}
}
this.m_TotalOfCompareHitsOrderNumber = (int)database.GetParameterValue(storedProcCommand, "@Total");
return(list);
}
private static OrderInfo OrderFromrdr(NullableDataReader rdr, string action)
{
OrderInfo info = new OrderInfo();
info.OrderId = rdr.GetInt32("OrderID");
info.OrderNum = rdr.GetString("OrderNum");
info.UserName = rdr.GetString("UserName");
info.ClientId = rdr.GetInt32("ClientID");
info.ClientName = rdr.GetString("ClientName");
info.MoneyTotal = rdr.GetDecimal("MoneyTotal");
info.NeedInvoice = rdr.GetBoolean("NeedInvoice");
info.Invoiced = rdr.GetBoolean("Invoiced");
info.Remark = rdr.GetString("Remark");
info.MoneyReceipt = rdr.GetDecimal("MoneyReceipt");
info.InputTime = rdr.GetDateTime("InputTime");
info.Status = (OrderStatus)rdr.GetInt32("Status");
info.DeliverStatus = (DeliverStatus)rdr.GetInt32("DeliverStatus");
if (string.IsNullOrEmpty(action))
{
info.EnableDownload = rdr.GetBoolean("EnableDownload");
info.PresentMoney = rdr.GetDecimal("PresentMoney");
info.PresentPoint = rdr.GetInt32("PresentPoint");
info.PresentExp = rdr.GetInt32("PresentExp");
info.DiscountPayment = rdr.GetDouble("Discount_Payment");
info.ChargeDeliver = rdr.GetDecimal("Charge_Deliver");
}
info.AgentName = rdr.GetString("AgentName");
info.Functionary = rdr.GetString("Functionary");
info.InvoiceContent = rdr.GetString("InvoiceContent");
info.BeginDate = rdr.GetDateTime("BeginDate");
info.ContacterName = rdr.GetString("ContacterName");
info.Address = rdr.GetString("Address");
info.ZipCode = rdr.GetString("ZipCode");
info.Mobile = rdr.GetString("Mobile");
info.Phone = rdr.GetString("Phone");
info.Email = rdr.GetString("Email");
info.PaymentType = rdr.GetInt32("PaymentType");
info.DeliverType = rdr.GetInt32("DeliverType");
info.Memo = rdr.GetString("Memo");
info.OutOfStockProject = (OutOfStockProject)rdr.GetInt32("OutOfStockProject");
info.OrderType = rdr.GetInt32("OrderType");
info.CouponId = rdr.GetInt32("CouponID");
info.DeliveryTime = rdr.GetString("DeliveryTime");
return(info);
}
private static void ProductFromrdr <T>(NullableDataReader rdr, T productInfo) where T : ProductInfo
{
productInfo.ProductId = rdr.GetInt32("ProductId");
productInfo.TableName = rdr.GetString("TableName");
productInfo.ProductName = rdr.GetString("ProductName");
productInfo.ProductType = (ProductType)rdr.GetInt32("ProductType");
productInfo.ProductPic = rdr.GetString("ProductPic");
productInfo.ProductThumb = rdr.GetString("ProductThumb");
productInfo.Unit = rdr.GetString("Unit");
productInfo.ProductNum = rdr.GetString("ProductNum");
productInfo.ServiceTermUnit = (ServiceTermUnit)rdr.GetInt32("ServiceTermUnit");
productInfo.ServiceTerm = rdr.GetInt32("ServiceTerm");
productInfo.PriceInfo.Price = rdr.GetDecimal("Price");
productInfo.PriceMarket = rdr.GetDecimal("Price_Market");
productInfo.PriceInfo.PriceMember = rdr.GetDecimal("Price_Member");
productInfo.PriceInfo.PriceAgent = rdr.GetDecimal("Price_Agent");
productInfo.EnableWholesale = rdr.GetBoolean("EnableWholesale");
productInfo.PriceInfo.PriceWholesale1 = rdr.GetDecimal("Price_Wholesale1");
productInfo.PriceInfo.PriceWholesale2 = rdr.GetDecimal("Price_Wholesale2");
productInfo.PriceInfo.PriceWholesale3 = rdr.GetDecimal("Price_Wholesale3");
productInfo.PriceInfo.NumberWholesale1 = rdr.GetInt32("Number_Wholesale1");
productInfo.PriceInfo.NumberWholesale2 = rdr.GetInt32("Number_Wholesale2");
productInfo.PriceInfo.NumberWholesale3 = rdr.GetInt32("Number_Wholesale3");
productInfo.PresentId = rdr.GetInt32("PresentID");
productInfo.PresentNumber = rdr.GetInt32("PresentNumber");
productInfo.PresentPoint = rdr.GetInt32("PresentPoint");
productInfo.PresentExp = rdr.GetInt32("PresentExp");
productInfo.PresentMoney = rdr.GetDecimal("PresentMoney");
productInfo.StocksProject = (StocksProject)rdr.GetInt32("StocksProject");
productInfo.SalePromotionType = rdr.GetInt32("SalePromotionType");
productInfo.MinNumber = rdr.GetInt32("MinNumber");
productInfo.Discount = rdr.GetDouble("Discount");
productInfo.IncludeTax = (TaxRateType)rdr.GetInt32("IncludeTax");
productInfo.TaxRate = rdr.GetDouble("TaxRate");
productInfo.Properties = rdr.GetString("Properties");
productInfo.Weight = rdr.GetDouble("Weight");
productInfo.LimitNum = rdr.GetInt32("LimitNum");
productInfo.EnableSingleSell = rdr.GetBoolean("EnableSingleSell");
productInfo.DependentProducts = rdr.GetString("DependentProducts");
productInfo.ProductKind = (ProductKind)rdr.GetInt32("ProductKind");
productInfo.OrderNum = rdr.GetInt32("OrderNum");
productInfo.Stocks = rdr.GetInt32("Stocks");
productInfo.EnableSale = rdr.GetBoolean("EnableSale");
productInfo.EnableBuyWhenOutofstock = rdr.GetBoolean("EnableBuyWhenOutofstock");
productInfo.BarCode = rdr.GetString("BarCode");
productInfo.ProductExplain = rdr.GetString("ProductExplain");
productInfo.ProducerName = rdr.GetString("ProducerName");
productInfo.TrademarkName = rdr.GetString("TrademarkName");
productInfo.Keyword = rdr.GetString("Keyword");
productInfo.Stars = rdr.GetInt32("Stars");
productInfo.ProductIntro = rdr.GetString("ProductIntro");
productInfo.IsNew = rdr.GetBoolean("IsNew");
productInfo.IsHot = rdr.GetBoolean("IsHot");
productInfo.IsBest = rdr.GetBoolean("IsBest");
productInfo.ProductCharacter = (ProductCharacter)rdr.GetInt32("ProductCharacter");
productInfo.DownloadUrl = rdr.GetString("DownloadUrl");
productInfo.Remark = rdr.GetString("Remark");
productInfo.AlarmNum = rdr.GetInt32("AlarmNum");
productInfo.BuyTimes = rdr.GetInt32("BuyTimes");
productInfo.Minimum = rdr.GetInt32("Minimum");
}
