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 + "')"));
}
