/// <summary>
/// 获得数据列表
/// </summary>
///'ProductId','SupplierId','CategoryId','CatalogId','Number','Name','Letter','MarketPrice','Price','Unit','Size','Origin','Packing','Material','Style','Certificate','OpenLight','ConsumerStrata','VIP','TaxInvoice','TaxRate','Content','DiscountIs','DiscountRate','DiscountTimeStart','DiscountTimeEnd','ChineseZodiac','Astro','Views','Sales','Amount','PostagePayer','PostageTemptId','Postage','Overpay','Visible','IsNew','State','Time','UpdateTim'
public IList<ProductMD> GetListArray(string fields, string where)
{
IList<ProductMD> list = new List<ProductMD>();
DbCommand dbCommand = DB.GetSqlStringCommand("select " + fields + " from db_Product where " + where);
using (IDataReader dr = DB.ExecuteReader(dbCommand))
{
while (dr.Read())
{
ProductMD md = new ProductMD();
#region 赋值给model
for (int i = 0; i < dr.FieldCount; i++)
{
if (dr.GetName(i).Equals("ProductId") && dr["ProductId"] != DBNull.Value)
{
md.ProductId = dr.GetInt32(i);
}
else if (dr.GetName(i).Equals("SupplierId") && dr["SupplierId"] != DBNull.Value)
{
md.SupplierId = dr.GetInt32(i);
}
else if (dr.GetName(i).Equals("CategoryId") && dr["CategoryId"] != DBNull.Value)
{
md.CategoryId = dr.GetString(i);
}
else if (dr.GetName(i).Equals("CatalogId") && dr["CatalogId"] != DBNull.Value)
{
md.CatalogId = dr.GetInt32(i);
}
else if (dr.GetName(i).Equals("Number") && dr["Number"] != DBNull.Value)
{
md.Number = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Name") && dr["Name"] != DBNull.Value)
{
md.Name = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Letter") && dr["Letter"] != DBNull.Value)
{
md.Letter = dr.GetString(i);
}
else if (dr.GetName(i).Equals("MarketPrice") && dr["MarketPrice"] != DBNull.Value)
{
md.MarketPrice = dr.GetDecimal(i);
}
else if (dr.GetName(i).Equals("Price") && dr["Price"] != DBNull.Value)
{
md.Price = dr.GetDecimal(i);
}
else if (dr.GetName(i).Equals("Unit") && dr["Unit"] != DBNull.Value)
{
md.Unit = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Size") && dr["Size"] != DBNull.Value)
{
md.Size = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Origin") && dr["Origin"] != DBNull.Value)
{
md.Origin = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Tag") && dr["Tag"] != DBNull.Value)
{
md.Tag = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Packing") && dr["Packing"] != DBNull.Value)
{
md.Packing = dr.GetByte(i);
}
else if (dr.GetName(i).Equals("Material") && dr["Material"] != DBNull.Value)
{
md.Material = dr.GetInt16(i);
}
else if (dr.GetName(i).Equals("Style") && dr["Style"] != DBNull.Value)
{
md.Style = dr.GetInt16(i);
}
else if (dr.GetName(i).Equals("Certificate") && dr["Certificate"] != DBNull.Value)
{
md.Certificate = dr.GetBoolean(i);
}
else if (dr.GetName(i).Equals("OpenLight") && dr["OpenLight"] != DBNull.Value)
{
md.OpenLight = dr.GetBoolean(i);
}
else if (dr.GetName(i).Equals("ConsumerStrata") && dr["ConsumerStrata"] != DBNull.Value)
{
md.ConsumerStrata = dr.GetString(i);
}
else if (dr.GetName(i).Equals("VIP") && dr["VIP"] != DBNull.Value)
{
md.VIP = dr.GetBoolean(i);
}
else if (dr.GetName(i).Equals("TaxInvoice") && dr["TaxInvoice"] != DBNull.Value)
{
md.TaxInvoice = dr.GetBoolean(i);
}
else if (dr.GetName(i).Equals("TaxRate") && dr["TaxRate"] != DBNull.Value)
{
md.TaxRate = dr.GetDecimal(i);
}
else if (dr.GetName(i).Equals("Content") && dr["Content"] != DBNull.Value)
{
md.Content = dr.GetString(i);
}
else if (dr.GetName(i).Equals("DiscountIs") && dr["DiscountIs"] != DBNull.Value)
{
md.DiscountIs = dr.GetBoolean(i);
}
else if (dr.GetName(i).Equals("DiscountRate") && dr["DiscountRate"] != DBNull.Value)
{
md.DiscountRate = dr.GetDecimal(i);
}
else if (dr.GetName(i).Equals("DiscountTimeStart") && dr["DiscountTimeStart"] != DBNull.Value)
{
md.DiscountTimeStart = dr.GetDateTime(i);
}
else if (dr.GetName(i).Equals("DiscountTimeEnd") && dr["DiscountTimeEnd"] != DBNull.Value)
{
md.DiscountTimeEnd = dr.GetDateTime(i);
}
else if (dr.GetName(i).Equals("ChineseZodiac") && dr["ChineseZodiac"] != DBNull.Value)
{
md.ChineseZodiac = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Astro") && dr["Astro"] != DBNull.Value)
{
md.Astro = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Views") && dr["Views"] != DBNull.Value)
{
md.Views = dr.GetInt32(i);
}
else if (dr.GetName(i).Equals("Sales") && dr["Sales"] != DBNull.Value)
{
md.Sales = dr.GetInt32(i);
}
else if (dr.GetName(i).Equals("Amount") && dr["Amount"] != DBNull.Value)
{
md.Amount = dr.GetInt32(i);
}
else if (dr.GetName(i).Equals("PostagePayer") && dr["PostagePayer"] != DBNull.Value)
{
md.PostagePayer = dr.GetByte(i);
}
else if (dr.GetName(i).Equals("Postage") && dr["Postage"] != DBNull.Value)
{
md.Postage = dr.GetString(i);
}
else if (dr.GetName(i).Equals("Overpay") && dr["Overpay"] != DBNull.Value)
{
md.Overpay = dr.GetDecimal(i);
}
else if (dr.GetName(i).Equals("Visible") && dr["Visible"] != DBNull.Value)
{
md.Visible = dr.GetBoolean(i);
}
else if (dr.GetName(i).Equals("IsNew") && dr["IsNew"] != DBNull.Value)
{
md.IsNew = dr.GetBoolean(i);
}
else if (dr.GetName(i).Equals("State") && dr["State"] != DBNull.Value)
{
md.State = dr.GetByte(i);
}
else if (dr.GetName(i).Equals("Time") && dr["Time"] != DBNull.Value)
{
md.Time = dr.GetDateTime(i);
}
else if (dr.GetName(i).Equals("UpdateTime") && dr["UpdateTime"] != DBNull.Value)
{
md.UpdateTime = dr.GetDateTime(i);
}
}
#endregion
list.Add(md);
}
}
return list;
}