protected void btnAccept_Click(object sender, EventArgs e)
{
tm_Settlement entity = new tm_Settlement();
entity.SettlementDate = DateTime.Now.ToString("yyyy-MM-dd");
entity.PrintTime = DateTime.Now;
entity.CustomerCount = Int32.Parse(labCustomerCount.Text);
entity.OrderCount = Int32.Parse(labOrderCount.Text);
entity.AmountReceivable = decimal.Parse(labAmountReceivable.Text);
entity.SingleAmount = decimal.Parse(labSingleAmount.Text);
entity.ChargeAmount = decimal.Parse(labCharge.Text);
entity.DonationAmount = decimal.Parse(labDonationAmount.Text);
entity.DiscountAmount = decimal.Parse(labDiscountAmount.Text);
entity.AmountCollected = decimal.Parse(labAmountCollected.Text);
entity.CashAmount = decimal.Parse(labCashAmount.Text);
entity.WXAmount = decimal.Parse(labWXAmount.Text);
entity.ZFBAmount = decimal.Parse(labZFBAmount.Text);
entity.CardAmount = decimal.Parse(labCreditAmount.Text);
entity.MemberAmount = decimal.Parse(labVipAmount.Text);
entity.GroupAmount = decimal.Parse(labGroupAmount.Text);
entity.BackAmount = decimal.Parse(labBackAmount.Text);
entity.ACCashAmount = decimal.Parse(tbxCashFact.Text.Trim());
entity.ACWXAmount = decimal.Parse(tbxWXFact.Text.Trim());
entity.ACZFBAmount = decimal.Parse(tbxZFBFact.Text.Trim());
entity.ACCardAmount = decimal.Parse(tbxCreditFact.Text.Trim());
entity.ACMemberAmount = decimal.Parse(tbxVipFact.Text.Trim());
entity.ACGroupAmount = decimal.Parse(tbxGroupFact.Text.Trim());
entity.DZAmount = decimal.Parse(labDisCount.Text.Trim());
Core.Container.Instance.Resolve <IServiceSettlement>().Create(entity);
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
LocalPrint(entity);
}
/// <summary>
/// 交班跳转
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCalc_Click(object sender, EventArgs e)
{
IList <ICriterion> qryList = new List <ICriterion>();
qryList.Add(Expression.Gt("TabieState", 1));
IList <tm_Tabie> listTabie = Core.Container.Instance.Resolve <IServiceTabie>().Query(qryList);
//检查是否有没有结清的台座
if (listTabie != null && listTabie.Count > 0)
{
Alert.ShowInTop("存在已开餐台！");
}
else
{
//查询是否存在今日交班实体
List <ICriterion> qrylist = new List <ICriterion>();
qrylist.Add(Expression.Eq("SettlementDate", DateTime.Now.ToString("yyyy-MM-dd")));
tm_Settlement entity = Core.Container.Instance.Resolve <IServiceSettlement>().GetEntityByFields(qrylist);
if (entity == null)
{
//交班
PageContext.RegisterStartupScript(WindowJiaoBan.GetShowReference("~/Dinner/Settlement.aspx", "交班"));
}
else
{
Alert.ShowInTop("今日已交班，如需更改数据，请前往交班表进行反结！！！", "提示窗口", MessageBoxIcon.Information);
}
}
}
/// <summary>
/// 点菜单前台打印
/// </summary>
/// <param name="listDish"></param>
/// <param name="entity"></param>
protected void LocalPrint(tm_Settlement entity)
{
if (entity != null)
{
StringBuilder one = new StringBuilder();
StringBuilder two = new StringBuilder();
StringBuilder three = new StringBuilder();
one.Append("农投良品生活馆\n");
one.Append("交班单\n");
one.Append("\n");
two.Append("\n");
two.Append("\n");
two.Append("\n");
three.Append("\n");
three.Append("\n");
three.Append("\n");
one.Append("营业员\n");
two.Append("\n");
three.AppendFormat("{0}\n", User.Identity.Name);
one.AppendFormat("营业日期：{0}\n", DateTime.Now.ToShortDateString());
two.Append("\n");
three.Append("\n");
one.AppendFormat("打印时间：{0}\n", DateTime.Now.ToString());
two.Append("\n");
three.Append("\n");
one.Append("---------------------------------------------------------------------------\n");
two.Append("\n");
three.Append("\n");
one.Append("客数：\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.CustomerCount);
one.Append("单数：\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.OrderCount);
one.Append("-----------------------------------------------------------------------------\n");
two.Append("\n");
three.Append("\n");
one.Append("应收金额\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.AmountReceivable);
one.Append("赠送金额\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.DonationAmount);
one.Append("折扣金额\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.DZAmount);
one.Append("抹零金额\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.DiscountAmount);
one.Append("退菜金额\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.BackAmount);
one.Append("免单金额\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.SingleAmount);
one.Append("挂账金额\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.ChargeAmount);
one.Append("实付金额\n");
two.Append("\n");
three.AppendFormat("{0}\n", entity.AmountCollected);
one.Append("-----------------------------------------------------------------------------\n");
two.Append("\n");
three.Append("\n");
one.Append("票面金额\n");
two.Append("实盘金额\n");
three.Append("溢缺\n");
one.AppendFormat("(现金){0}\n", entity.CashAmount);
two.AppendFormat("{0}\n", entity.ACCashAmount);
three.AppendFormat("{0}\n", entity.CashAmount - entity.ACCashAmount);
one.AppendFormat("(美团){0}\n", entity.GroupAmount);
two.AppendFormat("{0}\n", entity.ACGroupAmount);
three.AppendFormat("{0}\n", entity.GroupAmount - entity.ACGroupAmount);
one.AppendFormat("(微信){0}\n", entity.WXAmount);
two.AppendFormat("{0}\n", entity.ACWXAmount);
three.AppendFormat("{0}\n", entity.WXAmount - entity.ACWXAmount);
one.AppendFormat("(支付宝){0}\n", entity.ZFBAmount);
two.AppendFormat("{0}\n", entity.ACZFBAmount);
three.AppendFormat("{0}\n", entity.ZFBAmount - entity.ACZFBAmount);
one.AppendFormat("(刷卡){0}\n", entity.CardAmount);
two.AppendFormat("{0}\n", entity.ACCardAmount);
three.AppendFormat("{0}\n", entity.CardAmount - entity.ACCardAmount);
one.AppendFormat("(会员卡){0}\n", entity.MemberAmount);
two.AppendFormat("{0}\n", entity.ACMemberAmount);
three.AppendFormat("{0}\n", entity.MemberAmount - entity.ACMemberAmount);
one.Append("-----------------------------------------------------------------------------\n");
two.Append("\n");
three.Append("\n");
one.Append("地址：渝北区冉家坝龙山路301号\n");
two.Append(" \n");
three.Append("\n");
one.Append("电话：02367364577\n");
two.Append(" \n");
three.Append("\n");
one.Append("欢迎光临\n");
two.Append("\n");
three.Append("\n");
LocalPrint(one.ToString(), two.ToString(), three.ToString());
}
}
protected void Databind()
{
//查询交班实体
tm_Settlement entity = Core.Container.Instance.Resolve <IServiceSettlement>().GetEntity(_id);
labDate.Text = entity.SettlementDate;
labSettlementDate.Text = entity.SettlementDate.ToString();
//查询数据保存至缓存
string start = entity.SettlementDate;
string end = DateTime.Parse(entity.SettlementDate).AddDays(1).ToString("yyyy-MM-dd");
string sqlwhere = "SELECT sum(Population) AS personCount," +
"COUNT(1) AS tabieCount," +
"sum(usingInfo.Moneys) AS Moneys," +
"sum(PrePrice) AS PrePrice," +
"sum(DisCount) AS DisCount," +
"sum(FactPrice) AS FactPrice," +
"sum(Erasing) AS Erasing," +
"(SELECT sum(FactPrice) FROM tm_tabieusinginfo WHERE OpenTime > '" + start + "' AND OpenTime < '" + end + "' AND OrderState = '3' ) AS freeMoney," +
"(SELECT sum(FactPrice) FROM tm_tabieusinginfo WHERE OpenTime > '" + start + "' AND OpenTime < '" + end + "' AND OrderState = '4') AS ChargeMoney," +
"sum(dishinfo.Moneys) AS BackMoneys," +
"sum(usingInfo.GroupMoneys) AS GroupMoneys," +
"sum(tablePay.CashMoneys) AS CashMoneys," +
"sum(tablePay.CreditMoneys) AS CreditMoneys," +
"sum(tablePay.VipcardMoneys) AS VipcardMoneys," +
"sum(wx.OnlineMoneys) AS WxMoneys," +
"sum(zfb.OnlineMoneys) AS ZfbMoneys " +
"FROM tm_tabieusinginfo usingInfo " +
"LEFT JOIN (SELECT Moneys,TabieUsingID FROM tm_tabiedishesinfo WHERE DishesType = '2') AS dishinfo ON dishinfo.TabieUsingID = usingInfo.ID " +
"LEFT JOIN tm_tabiepayinfo tablePay ON tablePay.TabieUsingID = usingInfo.ID " +
"LEFT JOIN (SELECT TabieUsingID,OnlineMoneys FROM tm_tabiepayinfo WHERE PayWayOnline = '1') AS wx ON wx.TabieUsingID = usingInfo.ID " +
"LEFT JOIN (SELECT TabieUsingID,OnlineMoneys FROM tm_tabiepayinfo WHERE PayWayOnline = '2') AS zfb ON zfb.TabieUsingID = usingInfo.ID " +
"WHERE OpenTime > '" + start + "' AND OpenTime < '" + end + "'";
DataSet ds = DbHelperSQL.Query(sqlwhere);
DataRow row = ds.Tables[0].Rows[0];
labCustomerCount.Text = row["personCount"].ToString() == "" ? "0" : row["personCount"].ToString(); //人数
labOrderCount.Text = row["tabieCount"].ToString() == "" ? "0" : row["tabieCount"].ToString(); //订单数
labAmountReceivable.Text = row["Moneys"].ToString() == "" ? "0.00" : row["Moneys"].ToString(); //应付金额
labAmountCollected.Text = row["FactPrice"].ToString() == "" ? "0.00" : row["FactPrice"].ToString(); //实付金额
labDonationAmount.Text = row["PrePrice"].ToString() == "" ? "0.00" : row["PrePrice"].ToString(); //赠送金额
labDiscountAmount.Text = row["Erasing"].ToString() == "" ? "0.00" : row["Erasing"].ToString(); //抹零金额
labBackAmount.Text = row["BackMoneys"].ToString() == "" ? "0.00" : row["BackMoneys"].ToString(); //退菜金额
labSingleAmount.Text = row["freeMoney"].ToString() == "" ? "0.00" : row["freeMoney"].ToString(); //免单金额
labCharge.Text = row["ChargeMoney"].ToString() == "" ? "0.00" : row["ChargeMoney"].ToString(); //挂账金额
labCashAmount.Text = row["CashMoneys"].ToString() == "" ? "0.00" : row["CashMoneys"].ToString(); //现金金额
tbxCashFact.Text = row["CashMoneys"].ToString() == "" ? "0.00" : row["CashMoneys"].ToString(); //现金实盘
labWXAmount.Text = row["WxMoneys"].ToString() == "" ? "0.00" : row["WxMoneys"].ToString(); //微信金额
tbxWXFact.Text = row["WxMoneys"].ToString() == "" ? "0.00" : row["WxMoneys"].ToString(); //微信实盘
labZFBAmount.Text = row["ZfbMoneys"].ToString() == "" ? "0.00" : row["ZfbMoneys"].ToString(); //支付宝金额
tbxZFBFact.Text = row["ZfbMoneys"].ToString() == "" ? "0.00" : row["ZfbMoneys"].ToString(); //支付宝实盘
labCreditAmount.Text = row["CreditMoneys"].ToString() == "" ? "0.00" : row["CreditMoneys"].ToString(); //刷卡金额
tbxCreditFact.Text = row["CreditMoneys"].ToString() == "" ? "0.00" : row["CreditMoneys"].ToString(); //刷卡实盘
labVipAmount.Text = row["VipcardMoneys"].ToString() == "" ? "0.00" : row["VipcardMoneys"].ToString(); //会员卡金额
tbxVipFact.Text = row["VipcardMoneys"].ToString() == "" ? "0.00" : row["VipcardMoneys"].ToString(); //会员卡实盘
labGroupAmount.Text = row["GroupMoneys"].ToString() == "" ? "0.00" : row["GroupMoneys"].ToString(); //团购金额
tbxGroupFact.Text = row["GroupMoneys"].ToString() == "" ? "0.00" : row["GroupMoneys"].ToString(); //团购实盘
labDisCount.Text = row["DisCount"].ToString() == "" ? "0" : row["DisCount"].ToString(); //折扣金额
}
