public static DataTable GetYD()
{
string sql = "select YDID,KName,KPhone,RTName,TableName,YTime,YJ,Price,bz from YuDing y join RoomType r on y.RTID=r.RTID join Tables t on t.TableID=y.TBID";
return(DBhelper.dd(sql, null));
}
public static DataTable GetBill()
{
string sql = "select sum(CDPrice) CDPrice,CDDate from dbo.ConsumerDetail group by CDDate";
return(DBhelper.dd(sql, null));
}
public static DataTable GetPT()
{
string sql = "select ProductName as '商品名字',SUM(CDAmount) '销量' from ConsumerDetail c join Products p on c.ProdcutID=p.ProductID group by ProductName";
return(DBhelper.dd(sql, null));
}
public static DataTable GetJL()
{
string sql = "select v.VipID,VipName,CBID,CBSale from dbo.ConsumerBill c join Vips v on c.VipID=v.VipID";
return(DBhelper.dd(sql, null));
}