/// <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; }