/// <summary>
/// 查询桌子
/// </summary>
/// <param name="RTID"></param>
/// <returns></returns>
public static List <TablesMDL> selectTable(int RTID)
{
string sql = "select * from dbo.Tables where 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (RTID != 0)
{
sql += " and RTID=@RTID";
sp.Add(new SqlParameter("@RTID", RTID));
}
else
{
sql += "and TableState=0";
}
SqlDataReader dr = DBhelper.MySqlDataReader(sql, sp.ToArray());
List <TablesMDL> list = new List <TablesMDL>();
while (dr.Read())
{
TablesMDL tm = new TablesMDL();
tm.TableID = Convert.ToInt32(dr[0]);
tm.TableName = dr[1].ToString();
tm.RTID = Convert.ToInt32(dr[2]);
tm.TableArea = dr[3].ToString();
tm.TableState = Convert.ToInt32(dr[4]);
list.Add(tm);
}
dr.Close();
return(list);
}
public static List <VipGradeMDL> getlist(VipGradeMDL vg)
{
string sql = "select * from vipgrade where 1=1";
List <SqlParameter> list = new List <SqlParameter>();
List <VipGradeMDL> list1 = new List <VipGradeMDL>();
if (vg != null)
{
if (vg.vgid > 0)
{
sql += " and vgid=@vgid";
list.Add(new SqlParameter("@vgid", vg.vgid));
}
}
using (SqlDataReader sda = DBhelper.MySqlDataReader(sql, list.ToArray()))
{
while (sda.Read())
{
VipGradeMDL v = new VipGradeMDL();
v.vgid = Convert.ToInt32(sda[0]);
v.vgname = sda[1].ToString();
v.vgdiscount = Convert.ToDouble(sda[2]);
list1.Add(v);
}
return(list1);
}
}
/// <summary>
/// 查询所有商品
/// </summary>
/// <param name="PTID"></param>
/// <param name="JP"></param>
/// <returns></returns>
public static List <ProductsMDL> selectProduct(string ProductJP)
{
string sql = "select * from dbo.Products where 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (ProductJP != "")
{
sql += " and ProductJP like @ProductJP";
sp.Add(new SqlParameter("@ProductJP", "%" + ProductJP + "%"));
}
SqlDataReader dr = DBhelper.MySqlDataReader(sql, sp.ToArray());
List <ProductsMDL> list = new List <ProductsMDL>();
while (dr.Read())
{
ProductsMDL pd = new ProductsMDL();
pd.ProductID = Convert.ToInt32(dr[0]);
pd.ProductName = dr[1].ToString();
pd.PTID = Convert.ToInt32(dr[2]);
pd.ProductJP = dr[3].ToString();
pd.ProductPrice = Convert.ToDouble(dr[4]);
pd.ProductPic = dr[6].ToString();
pd.ProductIntroduction = dr[5].ToString();
list.Add(pd);
}
dr.Close();
return(list);
}
//lcy
public static List <AdminsMDL> Getlist(AdminsMDL a)
{
string sql = "select * from admins where 1=1";
List <SqlParameter> list = new List <SqlParameter>();
List <AdminsMDL> list1 = new List <AdminsMDL>();
if (a != null)
{
if (a.userid > 0)
{
sql += " and userid=@userid";
list.Add(new SqlParameter("@username", a.UserName));
}
}
using (SqlDataReader sda = DBhelper.MySqlDataReader(sql, list.ToArray()))
{
while (sda.Read())
{
AdminsMDL ad = new AdminsMDL();
ad.userid = Convert.ToInt32(sda[0]);
ad.UserName = sda[1].ToString();
ad.UserCompellation = sda[3].ToString();
list1.Add(ad);
}
return(list1);
}
}
public static List <VipsMDL> GetVips(int VipID)
{
string sql = "select * from Vips v left join dbo.VIPGrade g on v.GradeID=g.VGID where 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (VipID != 0)
{
sql += " and VipID=@VipID";
sp.Add(new SqlParameter("@VipID", VipID));
}
SqlDataReader dr = DBhelper.MySqlDataReader(sql, sp.ToArray());
List <VipsMDL> list = new List <VipsMDL>();
while (dr.Read())
{
VipsMDL v = new VipsMDL();
v.VipID = Convert.ToInt32(dr[0]);
v.VipName = dr[1].ToString();
v.VipSex = dr[2].ToString();
v.GradeID = Convert.ToInt32(dr[3]);
v.VipTel = dr[4].ToString();
v.VipStartDate = dr[5].ToString();
v.VipEndDate = dr[6].ToString();
//v.VipType = Convert.ToInt32(dr[7]);
if (dr[8].ToString() == "")
{
v.VGName = "其他会员";
}
else
{
v.VGName = dr[8].ToString();
}
if (dr[9].ToString() == "")
{
v.VGDiscount = 1.0;
}
else
{
v.VGDiscount = Convert.ToDouble(dr[9]);
}
list.Add(v);
}
dr.Close();
return(list);
}
public static List <TablesMDL> getlist(RoomTypeMDL rt)
{
string sql = "select * from tables a join roomtype b on a.rtid=b.rtid where 1=1";
List <SqlParameter> list1 = new List <SqlParameter>();
if (rt != null)
{
if (rt.rtname != "")
{
sql += " and b.rtname=@rtname";
list1.Add(new SqlParameter("@rtname", rt.rtname));
}
}
List <TablesMDL> list = new List <TablesMDL>();
using (SqlDataReader sda = DBhelper.MySqlDataReader(sql, list1.ToArray()))
{
while (sda.Read())
{
TablesMDL tb = new TablesMDL();
tb.tablename = sda[1].ToString();
tb.tablearea = sda[3].ToString();
if (Convert.ToInt32(sda["tablestate"]) == 0)
{
tb.tablestate = "可用";
}
else if (Convert.ToInt32(sda["tablestate"]) == 1)
{
tb.tablestate = "占用";
}
else if (Convert.ToInt32(sda["tablestate"]) == 2)
{
tb.tablestate = "预订";
}
else if (Convert.ToInt32(sda["tablestate"]) == 3)
{
tb.tablestate = "停用";
}
tb.rtid = sda[6].ToString();
tb.tableid = Convert.ToInt32(sda[0]);
list.Add(tb);
}
}
return(list);
}
//梁晨煜
public static List <RoomTypeMDL> getlist()
{
string sql = "select * from roomtype ";
List <RoomTypeMDL> list = new List <RoomTypeMDL>();
using (SqlDataReader sda = DBhelper.MySqlDataReader(sql, null))
{
while (sda.Read())
{
RoomTypeMDL rt = new RoomTypeMDL();
rt.rtid = Convert.ToInt32(sda["rtid"]);
rt.rtname = sda[1].ToString();
rt.rtmount = Convert.ToInt32(sda[4]);
list.Add(rt);
}
return(list);
}
}
/// <summary>
/// 查询房间
/// </summary>
/// <returns>l房间对象集合</returns>
public static List <RoomTypeMDL> selectRoom()
{
string sql = "select * from RoomType";
SqlDataReader dr = DBhelper.MySqlDataReader(sql, null);
List <RoomTypeMDL> list = new List <RoomTypeMDL>();
while (dr.Read())
{
RoomTypeMDL rt = new RoomTypeMDL();
rt.RTID = Convert.ToInt32(dr[0]);
rt.RTName = dr[1].ToString();
rt.RTConsume = Convert.ToDouble(dr[2]);
//rt.RTIsDisCount = Convert.ToInt32(dr[3]);
rt.RTMount = Convert.ToInt32(dr[4]);
list.Add(rt);
}
dr.Close();
return(list);
}
public static List <AdminsMDL> GetLogin(string user)
{
string sql = "select * from admins where Username=@username";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@username", user));
SqlDataReader dr = DBhelper.MySqlDataReader(sql, list.ToArray());
List <AdminsMDL> ad = new List <AdminsMDL>();
while (dr.Read())
{
AdminsMDL adm = new AdminsMDL();
adm.userid = Convert.ToInt32(dr[0]);
adm.UserName = dr[1].ToString();
adm.UserPWD = dr[2].ToString();
adm.UserCompellation = dr[3].ToString();
adm.LoginType = Convert.ToInt32(dr[6]);
adm.headID = Convert.ToInt32(dr[7]);
ad.Add(adm);
}
dr.Close();
return(ad);
}
