public List <Model.CommodityType> GetCommodityType() { List <Model.CommodityType> books = new List <Model.CommodityType>(); CommodityType book = null; if (DBHerpel.OpenConnection()) { SqlDataReader dr = DBHerpel.ExecReader("select * from CommodityType where State=0"); if (dr != null) { while (dr.Read()) { book = new CommodityType(); book.CommodityTypeID = (int)dr["CommodityTypeID"]; book.CommodityTypeName = dr["CommodityTypeName"] as string; book.State = (int)dr["State"]; books.Add(book); } } DBHerpel.CloseConnection(); } return(books); }
/// <summary> /// 查询学生信息 /// </summary> /// <param name="cu">学生信息</param> /// <returns></returns> public List <customer> selcustomer(string where) { List <Model.customer> cus = new List <Model.customer>(); customer sut = null; if (DBHerpel.OpenConnection()) { SqlDataReader dr = DBHerpel.ExecReader("select * from customer where State=0 " + where); if (dr != null) { while (dr.Read()) { sut = new customer(); sut.ID = (int)dr["ID"]; sut.Name = dr["Name"] as string; sut.Account = dr["Account"] as string; sut.Pssword = dr["password"].ToString(); sut.Headportrait = dr["Headportrait"] as string; sut.Phone = dr["Phone"] as string; sut.Email = dr["Email"] as string; sut.Adress = dr["Adress"] as string; sut.State = (int)dr["State"]; cus.Add(sut); } } if (cus.Count == 0) { sut = new customer(); sut.ID = -1; cus.Add(sut); } DBHerpel.CloseConnection(); } return(cus); }
public List <Commodity> selCommodity(int id) { List <Model.Commodity> cus = new List <Model.Commodity>(); Commodity sut = null; SqlParameter[] p = { new SqlParameter("@id", id) }; if (DBHerpel.OpenConnection()) { SqlDataReader dr = DBHerpel.Commodity("proc_Commodity", p); if (dr != null) { while (dr.Read()) { sut = new Commodity(); sut.ID = (int)dr["ID"]; sut.Commodityname = dr["Commodityname"] as string; sut.assignor = (int)dr["assignor"]; sut.CommodityTypeID = (int)dr["CommodityTypeID"]; sut.Imageurl = dr["Imageurl"].ToString(); sut.transferprice = Convert.ToDouble(dr["transferprice"]); sut.originalprice = Convert.ToDouble(dr["originalprice"]); sut.colour = dr["colour"] as string; sut.Adress = dr["Adress"] as string; sut.contact = dr["contact"] as string; sut.commintroduce = dr["commintroduce"] as string; sut.EditTime = dr["EditTime"].ToString(); sut.browsenum = (int)dr["browsenum"]; sut.State = (int)dr["State"]; sut.Name = dr["Name"] as string; cus.Add(sut); } } DBHerpel.CloseConnection(); } return(cus); }