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