protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlDataAdapter da = new SqlDataAdapter(@"select distinct(TableNumbers),SUM(Prices) as Prices,People,Uname from Order_Temp
where Visibles=0 group by TableNumbers,People,Uname", sConnString);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
RtList.DataSource = dt;
RtList.DataBind();
}
else
{
Label1.Text = "目前無可加點的桌子";
Label1.Visible = true;
}
}
}
private void GetOrderTemp(string StrTableNumbers)
{
using (SqlDataAdapter da = new SqlDataAdapter("select * from Order_Temp where TableNumbers=@TableNumbers and Visibles=0", sConnString))
{
da.SelectCommand.Parameters.Add("TableNumbers", SqlDbType.NVarChar).Value = StrTableNumbers;
using (DataTable dt = new DataTable())
{
da.Fill(dt);
if (dt.Rows.Count > 0)
{
RtList.Visible = true;
RtList.DataSource = dt;
RtList.DataBind();
}
else
{
RtList.Visible = false;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlDataAdapter da = new SqlDataAdapter(@"select distinct(TableNumbers),SUM(Prices) as Prices,People,Uname from Order_Temp
where Visibles=0 group by TableNumbers,People,Uname", sConnString);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
RtList.DataSource = dt;
RtList.DataBind();
}
da.SelectCommand.CommandText = @"select SUM(Turnovers) as Prices from TodayMoney where
CONVERT(varchar(100), Cdate, 111)= CONVERT(varchar(100), GETDATE(), 111)";
DataTable dt2 = new DataTable();
da.Fill(dt2);
if (dt2.Rows.Count > 0)
{
LbMoney.Text = "<br /><br />今日營業額:" + dt2.Rows[0][0].ToString() + "元";
DataTable dt3 = new DataTable();
da.SelectCommand.CommandText = @"select distinct(Foods),SUM(Counts) as Counts
from Order_Temp where CONVERT(varchar(100), Cdate, 111)= CONVERT(varchar(100), GETDATE(), 111)
and Visibles=1 group by Foods";
da.Fill(dt3);
if (dt3.Rows.Count > 0)
{
Rtlist3.DataSource = dt3;
Rtlist3.DataBind();
}
}
else
{
LbMoney.Text = "<br /><br />今日營業額:0元";
}
}
}
