/// <summary> /// 清台并返回餐台列表 /// </summary> protected void CloseTabie() { tm_Tabie tabieEntity = Core.Container.Instance.Resolve <IServiceTabie>().GetEntity(TabieID); tabieEntity.TabieState = 1; tabieEntity.CurrentUsingID = 0; Core.Container.Instance.Resolve <IServiceTabie>().Update(tabieEntity); //更新就餐信息菜品信息打印状态 string sql = string.Format("UPDATE tm_tabiedishesinfo SET IsPrint=1 WHERE TabieUsingID={0} and IsPrint=0 ", TabieUsingID); DbHelperMySQL.ExecuteSql(sql); //更新会员信息 bool IsVip = bool.Parse(ConfigurationManager.AppSettings["IsVip"]); if (IsVip) { IList <ICriterion> qryList = new List <ICriterion>(); qryList.Add(Expression.Eq("VIPPhone", txtVip.Text.Trim())); tm_vipinfo vipInfo = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntityByFields(qryList); if (vipInfo != null) { vipInfo.VIPCount -= decimal.Parse(nbxVip.Text); Core.Container.Instance.Resolve <IServiceVipInfo>().Update(vipInfo); } } //返回 PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); }
/// <summary> /// 会员号变化处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void txtVip_Blur(object sender, EventArgs e) { lblVipMoney.Text = "0"; if (!string.IsNullOrEmpty(MergeNO)) { //获取合并餐台信息 List <ICriterion> qrylist = new List <ICriterion>(); qrylist.Add(Expression.Eq("MergeNO", MergeNO)); IList <tm_TabieUsingInfo> list = Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().Query(qrylist); //获取会员信息 IList <ICriterion> qryList = new List <ICriterion>(); qryList.Add(Expression.Eq("VIPPhone", txtVip.Text.Trim())); tm_vipinfo vipInfo = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntityByFields(qryList); if (vipInfo != null) { //获取整单交易和应付金额 foreach (tm_TabieUsingInfo usingInfo in list) { lblVipMoney.Text = vipInfo.VIPCount.ToString(); //更新会员信息 usingInfo.VipID = txtVip.Text.Trim(); Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().Update(usingInfo); } } else { Alert.Show("会员号不存在!"); } } }
private void Bind() { tm_vipinfo entity = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntity(_id); txtRemark.Text = entity.Remark; lblDate.Text = entity.RegisterDate.ToString("yyyy-MM-dd HH:mm:ss"); txbVipPhone.Text = entity.VIPPhone; txbVipPhone.Readonly = true; txtVipName.Text = entity.VIPName; }
protected void btnSaveClose_Click(object sender, EventArgs e) { if (action == "add") { IList <ICriterion> qryList = new List <ICriterion>(); qryList.Add(Expression.Eq("VIPPhone", txbVipPhone.Text.Trim())); tm_vipinfo vipObj = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntityByFields(qryList); //判断重复 if (vipObj != null) { Alert.Show("注册电话号码已存在!"); return; } } SaveItem(); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); }
/// <summary> /// 会员号变化处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void txtVip_Blur(object sender, EventArgs e) { lblVipMoney.Text = "0"; tm_TabieUsingInfo entity = Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().GetEntity(TabieUsingID); //获取会员信息 IList <ICriterion> qryList = new List <ICriterion>(); qryList.Add(Expression.Eq("VIPPhone", txtVip.Text.Trim())); tm_vipinfo vipInfo = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntityByFields(qryList); if (vipInfo != null) { lblVipMoney.Text = vipInfo.VIPCount.ToString(); //更新会员信息 entity.VipID = txtVip.Text.Trim(); Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().Update(entity); } else { Alert.Show("会员号不存在!"); } }
protected void Page_Load(object sender, EventArgs e) { GPPayWay.Hidden = false; GPvip.Hidden = false; GPFreeReason.Hidden = true; GPChargeReason.Hidden = true; tm_TabieUsingInfo entity = Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().GetEntity(TabieUsingID); if (!IsPostBack) { if (entity.ClearTime == null) { //设置结算时间 dltCloseTabie.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //更新结算时间 entity.ClearTime = DateTime.Parse(DateTime.Parse(dltCloseTabie.Text.Trim()).ToString("yyyy-MM-dd HH:mm:ss")); Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().Update(entity); } else { dltCloseTabie.Text = ((DateTime)entity.ClearTime).ToString("yyyy-MM-dd HH:mm:ss"); } txtVip.Text = entity.VipID; //获取会员余额信息 if (!string.IsNullOrEmpty(entity.VipID)) { IList <ICriterion> qryList = new List <ICriterion>(); qryList.Add(Expression.Eq("VIPPhone", entity.VipID)); tm_vipinfo vipInfo = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntityByFields(qryList); lblVipMoney.Text = vipInfo != null?vipInfo.VIPCount.ToString() : "0"; } } labMoneys.Text = entity.Moneys.ToString(); labPrePrice.Text = entity.PrePrice.ToString(); labFactPrice.Text = entity.FactPrice.ToString(); }
private void SaveItem() { tm_vipinfo vipInfo = new tm_vipinfo(); if (action == "edit") { vipInfo = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntity(_id);; } if (action == "add") { vipInfo.VIPPhone = txbVipPhone.Text.Trim(); vipInfo.RegisterDate = DateTime.Now; } vipInfo.VIPName = txtVipName.Text.Trim(); vipInfo.Remark = txtRemark.Text.Trim(); if (action == "edit") { Core.Container.Instance.Resolve <IServiceVipInfo>().Update(vipInfo); } else { Core.Container.Instance.Resolve <IServiceVipInfo>().Create(vipInfo); } }
protected string GetVipName(string VipID) { tm_vipinfo entity = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntity(Int32.Parse(VipID)); return(entity.VIPName); }
/// <summary> /// 结算留存单打印 /// </summary> protected void LocalPrint() { tm_TabieUsingInfo tabieUsingInfo = Core.Container.Instance.Resolve <IServiceTabieUsingInfo>().GetEntity(TabieUsingID); tm_Tabie tabieEntity = Core.Container.Instance.Resolve <IServiceTabie>().GetEntity(tabieUsingInfo.TabieID); IList <ICriterion> qrylist = new List <ICriterion>(); qrylist.Add(Expression.Eq("TabieUsingID", tabieUsingInfo.ID)); tm_TabiePayInfo PayEntity = Core.Container.Instance.Resolve <IServiceTabiePayInfo>().GetEntityByFields(qrylist); StringBuilder sb = new StringBuilder(); StringBuilder count = new StringBuilder(); StringBuilder price = new StringBuilder(); sb.Append("农投良品生活馆\n"); sb.Append("结算单\n"); sb.AppendFormat("桌 位:{0}\n", tabieEntity.TabieName); sb.AppendFormat("账单编号:{0}\n", tabieUsingInfo.OrderNO); sb.AppendFormat("营业日期:{0}\n", DateTime.Now.ToShortDateString()); sb.AppendFormat("开台时间:{0}\n", tabieUsingInfo.OpenTime.ToString("yyyy-MM-dd HH:mm:ss")); sb.AppendFormat("结账时间:{0}\n", DateTime.Parse(dltCloseTabie.Text).ToString("yyyy-MM-dd HH:mm:ss")); sb.AppendFormat("客 数:{0}\n", tabieUsingInfo.Population); sb.AppendFormat("收款机号 \n"); count.Append("\n"); count.Append("\n"); count.Append("\n"); count.Append("\n"); count.Append("\n"); count.Append("\n"); count.Append("\n"); count.Append("\n"); count.AppendFormat("收银员:{0} \n", User.Identity.Name); price.Append("\n"); price.Append("\n"); price.Append("\n"); price.Append("\n"); price.Append("\n"); price.Append("\n"); price.Append("\n"); price.Append("\n"); price.Append("\n"); sb.Append("---------------------------------------------------------------------------\n"); count.Append("\n"); price.Append("\n"); sb.Append("菜品名称\n"); count.Append("数量 \n"); price.Append("金额 \n"); sb.Append("---------------------------------------------------------------------------\n"); count.Append("\n"); price.Append("\n"); //获取点菜信息 string sql = string.Format("SELECT DishesName,sum(DishesCount) as DishesCount,SUM(Moneys) as Moneys,UnitName,IsFree,DishesType FROM tm_tabiedishesinfo WHERE TabieUsingID={0} GROUP BY DishesName,UnitName,IsFree,DishesType ORDER BY DishesName " , tabieUsingInfo.ID); DataSet ds = DbHelperMySQL.Query(sql); if (ds.Tables[0] != null) { foreach (DataRow row in ds.Tables[0].Rows) { //判断赠送 if (!row["IsFree"].ToString().Equals("1")) { //判断退菜 if (row["DishesType"].ToString().Equals("1")) { sb.AppendFormat("{0}\n", row["DishesName"].ToString()); } if (row["DishesType"].ToString().Equals("2")) { sb.AppendFormat("{0}[退菜]\n", row["DishesName"].ToString()); } //团购菜品 if (row["DishesType"].ToString().Equals("3")) { sb.AppendFormat("{0}[套餐]\n", row["DishesName"].ToString()); } } else { sb.AppendFormat("{0}[赠送]\n", row["DishesName"].ToString()); } count.AppendFormat("{0}{1}\n", row["DishesCount"].ToString(), row["UnitName"].ToString()); price.AppendFormat("{0}\n", row["Moneys"].ToString()); } } sb.Append("-----------------------------------------------------------------------------\n"); count.Append("\n"); price.Append("\n"); sb.Append("消费合计:\n"); count.Append("\n"); price.AppendFormat("{0}\n", tabieUsingInfo.Moneys); sb.Append("赠送金额:\n"); count.Append("\n"); price.AppendFormat("{0}\n", tabieUsingInfo.PrePrice); sb.Append("抹零金额:\n"); count.Append("\n"); price.AppendFormat("{0}\n", tabieUsingInfo.Erasing); sb.Append("应付金额:\n"); count.Append("\n"); price.AppendFormat("{0}\n", tabieUsingInfo.FactPrice); sb.AppendFormat("折扣[{0}折]\n", tabieUsingInfo.DisPoint); count.Append("\n"); price.AppendFormat("{0}\n", tabieUsingInfo.Discount); sb.Append("-----------------------------------------------------------------------------\n"); count.Append("\n"); price.Append("\n"); //买单支付 if (rblPayType.SelectedValue == "1") { if (!string.IsNullOrEmpty(PayEntity.PayWayCash)) { sb.Append("现金支付:\n"); count.Append("\n"); price.AppendFormat("{0}\n", PayEntity.CashMoneys); } if (!string.IsNullOrEmpty(PayEntity.PayWayCredit)) { sb.Append("刷卡支付:\n"); count.Append("\n"); price.AppendFormat("{0}\n", PayEntity.CreditMoneys); } if (!string.IsNullOrEmpty(PayEntity.PayWayVipcard)) { sb.Append("会员卡支付:\n"); count.Append("\n"); price.AppendFormat("{0}\n", PayEntity.VipcardMoneys); //获取会员卡信息和余额 IList <ICriterion> qryList = new List <ICriterion>(); qryList.Add(Expression.Eq("VIPPhone", tabieUsingInfo.VipID)); tm_vipinfo vipInfo = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntityByFields(qryList); if (vipInfo != null) { sb.AppendFormat("会员卡:{0}\n", tabieUsingInfo.VipID); count.AppendFormat("余额:{0}\n", vipInfo.VIPCount); price.AppendFormat("\n"); } } if (!string.IsNullOrEmpty(PayEntity.PayWayOnline)) { sb.Append("微信支付:\n"); count.Append("\n"); price.AppendFormat("{0}\n", PayEntity.OnlineMoneys); } if (!string.IsNullOrEmpty(PayEntity.PayWayZFB)) { sb.Append("支付宝支付:\n"); count.Append("\n"); price.AppendFormat("{0}\n", PayEntity.ZFBMoneys); } sb.Append("-----------------------------------------------------------------------------\n"); count.Append("\n"); price.Append("\n"); } //美团 if (!string.IsNullOrEmpty(tabieUsingInfo.GroupCardNO)) { sb.AppendFormat("美团【{0}】:\n", tabieUsingInfo.GroupName); count.AppendFormat("{0}\n", tabieUsingInfo.GroupCardNO); price.Append("\n"); sb.Append("-----------------------------------------------------------------------------\n"); count.Append("\n"); price.Append("\n"); } //免单 if (rblPayType.SelectedValue == "2") { sb.Append("免单:\n"); price.AppendFormat("{0}\n", tabieUsingInfo.FreeReason); count.Append("\n"); sb.Append("-----------------------------------------------------------------------------\n"); count.Append("\n"); price.Append("\n"); } //挂账 if (rblPayType.SelectedValue == "3") { sb.Append("挂账:\n"); count.AppendFormat("{0}\n", tabieUsingInfo.Charge); price.Append("\n"); sb.Append("-----------------------------------------------------------------------------\n"); count.Append("\n"); price.Append("\n"); } sb.Append("地址:渝北区冉家坝龙山路301号\n"); count.Append(" \n"); price.Append("\n"); sb.Append("电话:02367364577\n"); count.Append(" \n"); price.Append("\n"); sb.Append("欢迎光临\n"); count.Append("\n"); price.Append("\n"); LocalPrint(sb.ToString(), count.ToString(), price.ToString()); }
protected void btnSure_Click(object sender, EventArgs e) { string Moneys = tbxMoneys.Text.Trim(); //充值金额 if ((!string.IsNullOrEmpty(Moneys) && !Moneys.Equals("0"))) { //判断是否为在线支付 if (cblPayWay.SelectedValue.Equals("3") || cblPayWay.SelectedValue.Equals("4")) { //判断是否已完成在线支付(前者),如果支付失败再次支付(后者) if (string.IsNullOrEmpty(hfdPayType.Text) || hfdPayType.Text.Equals("1")) { //判断在线支付方式 if (cblPayWay.SelectedValue.Equals("3"))//微信 { //指定子页面传回的值的去处并挑战至子页面 PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdPayTime.ClientID, hfdPayType.ClientID) + Window1.GetShowReference("~/Dinner/DOnlinePay.aspx?money=" + tbxMoneys.Text.Trim() + "&pay_type=010&terminal_trace=" + _OrderNO)); return; } else//支付宝 { //指定子页面传回的值的去处并挑战至子页面 PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdPayTime.ClientID, hfdPayType.ClientID) + Window1.GetShowReference("~/Dinner/DOnlinePay.aspx?money=" + tbxMoneys.Text.Trim() + "&pay_type=020&terminal_trace=" + _OrderNO)); return; } } } } string Presentation = tbxFree.Text.Trim(); //赠送金额 if ((!string.IsNullOrEmpty(Moneys) && !Moneys.Equals("0")) || (!string.IsNullOrEmpty(Presentation) && !Presentation.Equals("0"))) { //新增会员卡充值记录 tm_VIPPrepaid entity = new tm_VIPPrepaid(); entity.VipID = _id; entity.VIPPhone = Int32.Parse(Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntity(_id).VIPPhone); entity.PrepaidDate = DateTime.Now; entity.PrepaidAmount = decimal.Parse(Moneys == "" ? "0" : Moneys); entity.PresentationAmount = decimal.Parse(Presentation == "" ? "0" : Presentation); entity.PrepaidWay = cblPayWay.SelectedValue; entity.Operator = User.Identity.Name; entity.OrderNO = _OrderNO; Core.Container.Instance.Resolve <IServiceVIPPrepaid>().Create(entity); //更新会员卡金额 tm_vipinfo _Vipinfo = Core.Container.Instance.Resolve <IServiceVipInfo>().GetEntity(_id); _Vipinfo.VIPCount += (entity.PrepaidAmount + entity.PresentationAmount); if (_Vipinfo.VIPCount > decimal.Parse((99999999.99).ToString()) || _Vipinfo.VIPCount < 0) { Alert.ShowInTop("充值金额不能为0!"); return; } Core.Container.Instance.Resolve <IServiceVipInfo>().Update(_Vipinfo); //清空金额输入框 tbxMoneys.Text = String.Empty; tbxFree.Text = String.Empty; labPayState.Text = String.Empty; imgPayState.ImageUrl = String.Empty; Alert.ShowInTop("充值成功!"); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } }