/// <summary>
/// 得到一个实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ShowShop.Model.Accessories.Outofstock GetModelByID(int id)
{
ShowShop.Model.Accessories.Outofstock model = new ShowShop.Model.Accessories.Outofstock();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 [id],[proid],[proclassandname],[addtime],[addip],[username],[issreguser],[telphone],[mobile],[qq],[email],[msn],[neednum],[content],[state],[isdeal],[dealtime],[dealremark] from yxs_outofstock ");
strSql.Append(" where [id]=@id ");
SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id);
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.Read())
{
model.ID = reader.GetInt32(0);
model.Proid = reader.GetInt32(1);
model.ProClassAndName = reader.GetString(2);
model.AddTime = reader.GetDateTime(3);
model.AddIp = reader.GetString(4);
model.UserName = reader.GetString(5);
model.IssRegUser = reader.GetInt32(6);
model.Telphone = reader.GetString(7);
model.Mobile = reader.GetString(8);
model.QQ = reader.GetString(9);
model.Email = reader.GetString(10);
model.MSN = reader.GetString(11);
model.NeedNum = reader.GetInt32(12);
model.Content = reader.GetString(13);
model.State = reader.GetInt32(14);
model.IsDeal = reader.GetInt32(15);
model.DealTime = reader.GetDateTime(16);
model.DealRemark = reader.GetString(17);
}
}
return model;
}
/// <summary>
/// 所有数据集合
/// </summary>
/// <returns></returns>
public List<ShowShop.Model.Accessories.Outofstock> GetAll()
{
List<ShowShop.Model.Accessories.Outofstock> list = new List<ShowShop.Model.Accessories.Outofstock>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select [id],[proid],[proclassandname],[addtime],[addip],[username],[issreguser],[telphone],[mobile],[qq],[email],[msn],[neednum],[content],[state],[isdeal],[dealtime],[dealremark] from yxs_outofstock ");
strSql.Append(" where 1=1");
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
{
while (reader.Read())
{
ShowShop.Model.Accessories.Outofstock model = new ShowShop.Model.Accessories.Outofstock();
model.ID = reader.GetInt32(0);
model.Proid = reader.GetInt32(1);
model.ProClassAndName = reader.GetString(2);
model.AddTime = reader.GetDateTime(3);
model.AddIp = reader.GetString(4);
model.UserName = reader.GetString(5);
model.IssRegUser = reader.GetInt32(6);
model.Telphone = reader.GetString(7);
model.Mobile = reader.GetString(8);
model.QQ = reader.GetString(9);
model.Email = reader.GetString(10);
model.MSN = reader.GetString(11);
model.NeedNum = reader.GetInt32(12);
model.Content = reader.GetString(13);
model.State = reader.GetInt32(14);
model.IsDeal = reader.GetInt32(15);
model.DealTime = reader.GetDateTime(16);
model.DealRemark = reader.GetString(17);
list.Add(model);
}
}
return list;
}
