public static List <Model.Kseouser> GetKseouser() //查询用户 { string sql = "select LoginName,[Password] from Kseouser where LoginName = 'htt' and [Password] = '123456'"; SqlDataReader dr = DBHpelp.ExecuteReader(sql); List <Kseouser> kseouser = new List <Kseouser>(); Kseouser model = null; while (dr.Read()) { model = new Kseouser(); model.LoginName = dr["LoginName"].ToString(); model.Password = dr["Password"].ToString(); kseouser.Add(model); } dr.Close(); return(kseouser); }
public static List <Model.Lipstick> GetLipstick() //查询商品 { string sql = "select * from Lipstick"; SqlDataReader dr = DBHpelp.ExecuteReader(sql); List <Model.Lipstick> Lipstick = new List <Model.Lipstick>(); Model.Lipstick kso = null; while (dr.Read()) { kso = new Lipstick(); kso.LipID = (int)dr["LipID"]; kso.Lphoto = dr["Lphoto"].ToString(); kso.LTitle = dr["LTitle"].ToString(); kso.LPrice = (decimal)dr["LPrice"]; kso.LColor = dr["LColor"].ToString(); Lipstick.Add(kso); } dr.Close(); return(Lipstick); }
public int DeleteLipstick(int id) //删除商品 { return(DBHpelp.ExecQuery("delete from Lipstick where LipID = " + id + "")); }
public int InsertLipstick(Model.Lipstick lipstick) //添加商品 { return(DBHpelp.ExecQuery("INSERT INTO Lipstick ('Lphoto','[LTitle]',[LPrice],'LColor')VALUES('" + lipstick.Lphoto + "','" + lipstick.LPrice + "','" + lipstick.LColor + "')")); }