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