public static void UpdateOrderStatus(string _orderNo, string _productNo, byte _orderStatus)
{
if (!OrderInfoBLL.OrderAlreadyExsit(_orderNo))
{
OrderInfoBLL.OrderInfoUpdate(_orderNo, _productNo, _orderStatus);
}
}
public static void RemoveOrder(string _orderNo, string _productNo)
{
if (!OrderInfoBLL.OrderAlreadyExsit(_orderNo))
{
OrderInfoBLL.OrderInfoDelete(_orderNo, _productNo);
}
}
public CDMarzoAutoShopMethods()
{
customerinfobll = new CustomerInfoDAL();
itembll = new ItemDAL();
orderinfobll = new OrderInfoDAL();
salesbll = new SalesDAL();
}
public JsonResult Order_TD(string str)
{
BLL.OrderInfoBLL _BLL = new OrderInfoBLL();
retValue ret = new retValue();
JObject o = null;
PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel;
int userid = userModel._ID;
if (!string.IsNullOrEmpty(str))
{
o = JObject.Parse(str);
string ids = o["ID"]._ToStrTrim();
int Month = o["Month"]._ToInt32();
int OrderNum = o["OrderNum"]._ToInt32();
int Group_Type = o["Group_Type"]._ToInt32();
//1全退,2部分退
if (Group_Type == 1)
{
Month = 0;
OrderNum = 0;
}
ret = _BLL.TD(ids.Remove(ids.Length - 1), userid, Group_Type, Month, OrderNum);
}
var js = JsonConvert.SerializeObject(ret);
return(Json(js, JsonRequestBehavior.AllowGet));
}
public ActionResult OrderInfos(int page, int limit, string test1, string test2,
string Province, string CompanyCity, string CompanyUnderCity,
string CompanyUnderArea, string OrderNo, string UnitName, string BKDH, string OrderState, string CostState)
{
PageModel ret = new PageModel();
BLL.OrderInfoBLL _BLL = new OrderInfoBLL();
PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel;
string OrgID = "";
if (Province._ToInt32() > 0)
{
OrgID = Province;
}
if (CompanyCity._ToInt32() > 0)
{
OrgID = CompanyCity;
}
if (CompanyUnderCity._ToInt32() > 0)
{
OrgID = CompanyUnderCity;
}
if (CompanyUnderArea._ToInt32() > 0)
{
OrgID = CompanyUnderArea;
}
PageModel pg = _BLL.GetOrderInfo(0, BKDH, OrderNo, UnitName, test1, test2,
userModel.OrgID._ToStr(), OrgID, OrderState, CostState, limit, page);
var js = JsonConvert.SerializeObject(pg);
return(Content(js));
}
private void btn_AddOrder_Click(object sender, EventArgs e)
{
if ((this.txtAddOrderNo.Text.Trim().Length > 0) && (this.txtAddProdNo.Text.Trim().Length > 0) && (RegularHelper.isNumericString(this.txtAddOrderCount.Text.Trim())))
{
DialogResult diaresult = SpMessageBox.Show("确定要补充该订单吗？", "订单补充", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (diaresult == DialogResult.OK)
{
if (OrderInfoBLL.OrderAlreadyExsit(this.txtAddOrderNo.Text.Trim()))
{
if (OrderInfo.UpdateOrderCount(this.txtAddOrderNo.Text.Trim(), this.txtAddProdNo.Text.Trim(), int.Parse(this.txtAddOrderCount.Text.Trim())))
{
SpMessageBox.Show("该订单数量补充完成", "订单补充");
}
}
else
{
SpMessageBox.Show("该订单号不存在，请检查该订单号是否生效", "订单补充");
}
SystemLogs.WriteSystemLog(Login.UserName, "add order count:" + this.txtAddOrderCount.Text.Trim() + " for order " + this.txtAddOrderNo.Text.Trim() + " at " + Login.CurrentProductionLine, DateTime.Now);
}
}
else
{
SpMessageBox.Show("请检查订单号，产品号，和订单数量的输入", "订单补充");
}
}
public JsonResult Order_Deletes(string str)
{
BLL.OrderInfoBLL _BLL = new OrderInfoBLL();
retValue ret = new retValue();
string content = string.Empty;
DataTable dt = str.ToTable();
string ids = "";
string costs = "";
foreach (DataRow item in dt.Rows)
{
if (!string.IsNullOrEmpty(item["ID"]._ToStrTrim()))
{
ids += item["ID"]._ToStrTrim() + ",";
costs += item["CostID"]._ToStrTrim() + ",";
}
}
ret = _BLL.DeleteByPK(ids.Remove(ids.Length - 1));
if (ret.result)
{
CostBLL costBLL = new CostBLL();
costBLL.DeleteByPK(costs);
}
content = ret.toJson();
var js = JsonConvert.SerializeObject(ret);
return(Json(js, JsonRequestBehavior.AllowGet));
}
//增加消费
private void button2_Click(object sender, EventArgs e)
{
//
ListView lv = (ListView)tabMain.SelectedTab.Controls[0];
//房间对象
RoomInfo room = (RoomInfo)(tabMain.SelectedTab.Tag);
if (lv.SelectedItems.Count <= 0)
{
msg.MsgDivShow("请选择要增加消费的餐桌", 1);
return;
}
DeskInfo desk = (lv.SelectedItems[0].Tag as DeskInfo);
if (desk.DeskState == 0)//因为只允许单选，所以是tiems[0];
{
msg.MsgDivShow("您选择的开单后的餐桌", 1);
return;
}
//根据餐桌的id查询对应餐桌订单的id
OrderInfoBLL obll = new OrderInfoBLL();
object objOrderId = obll.GetOrderIdByDeskId(desk.DeskId);
FrmAddConsumption fac = FrmAddConsumption.Single(desk.DeskName, Convert.ToInt32(objOrderId));
fac.FormClosed += f_FormClosed;
fac.Show();
}
//顾客结账了
private void button3_Click(object sender, EventArgs e)
{
ListView lv = (ListView)tabMain.SelectedTab.Controls[0];
//房间对象
RoomInfo room = (RoomInfo)(tabMain.SelectedTab.Tag);
if (lv.SelectedItems.Count <= 0)
{
msg.MsgDivShow("请选择要结账的餐桌", 1);
return;
}
DeskInfo desk = (lv.SelectedItems[0].Tag as DeskInfo); //因为只允许单选，所以是tiems[0];
if (desk.DeskState == 0) //0如果是空闲的餐桌
{
msg.MsgDivShow("请选择正在就餐的餐桌", 1);
return;
}
OrderInfoBLL obll = new OrderInfoBLL();
object objOrderId = obll.GetOrderIdByDeskId(desk.DeskId);
FrmGuestPay fgp = FrmGuestPay.Single(Convert.ToInt32(objOrderId), desk.DeskName, desk.DeskId);
fgp.FormClosed += f_FormClosed;
fgp.Show();
}
//确定开单
private void btnOK_Click(object sender, EventArgs e)
{
//开单用了三张表
//先改变餐桌的状态,需要餐桌的id
DeskInfoBLL dkBll = new DeskInfoBLL();
bool dkFlag = dkBll.UpdateDeskStateByDeskId(this.ID, 1);
//添加一个订单
OrderInfo order = new OrderInfo();
order.DelFlag = 0;
order.OrderState = 1;
order.Remark = txtPersonCount.Text + "," + txtDescription.Text;
order.SubBy = 1;
order.SubTime = System.DateTime.Now;
OrderInfoBLL orderBll = new OrderInfoBLL();
//插入一条数据返回该数据的主键id
int orderId = orderBll.AddOrderInfo(order);
//再把订单的id和餐桌的id存到中间表中
ROrderDeskBLL rodBll = new ROrderDeskBLL();
ROrderDesk rod = new ROrderDesk();
rod.DeskId = this.ID; //餐桌的id
rod.OrderId = orderId; //订单的id
bool rodFlag = rodBll.AddROrderDesk(rod);
if (dkFlag && rodFlag)
{
MessageBox.Show("开单成功");
this.Close();
}
else
{
MessageBox.Show("开单失败");
}
}
public static bool UpdateOrderCount(string _orderNo, string _productNo, int _updatedOrderCount)
{
int originalOrderCount = OrderInfoBLL.GetOrderCountByOrderNo(_orderNo);
return(OrderInfoBLL.OrderInfoUpdate(_orderNo, _productNo, _updatedOrderCount + originalOrderCount) &&
ProductionLineInfoBLL.UpdateOrderNoForProductionLine(_orderNo, _productNo, _updatedOrderCount + originalOrderCount));
}
public void SetText(object sender, EventArgs e)
{
//餐桌编号
var mea = e as MyEventArgs;
var dk = mea.Obj as DeskInfo;
labDeskName.Text = dk.DeskName;
_dkId = dk.DeskId;
//订单号 -> 根据DeskId查询OrderId
var orderBLL = new OrderInfoBLL();
var orderId = orderBLL.GetOrderIdByDeskId(dk.DeskId);
labOrderId.Text = orderId.ToString();
//消费总金额 -> 通过OrderId查询
var money = orderBLL.GetMoneyByOrderId(orderId);
if (money != -1)
{
labMoney.Text = money.ToString();
lblMoney.Text = money.ToString();
}
else
{
MessageBox.Show("查询订单消费失败");
}
}
private void FrmAddConsumption_FormClosing(object sender, FormClosingEventArgs e)
{
//更新总价
if (!string.IsNullOrEmpty(labSumMoney.Text))
{
OrderInfoBLL obll = new OrderInfoBLL();
obll.UpdateOrderMoneyAndBeginTimeByOrderId(Convert.ToInt32(labOrderId.Text), Convert.ToDouble(labSumMoney.Text));
//不用提示吧？
}
}
private void btnOK_Click(object sender, EventArgs e)
{
//餐桌的状态
var bllBk = new DeskInfoBLL();
var dkFlag = bllBk.UpdateDeskStateByDeskId(_id, 1);
//添加一个订单
var odrBll = new OrderInfoBLL();
var odr = new OrderInfo();
odr.BeginTime = System.DateTime.Now;
odr.SubTime = System.DateTime.Now;
odr.DelFlag = 0;
odr.OrderMoney = 0;
odr.OrderState = 1;
odr.Remark = txtPersonCount.Text + txtDescription.Text;
odr.SubBy = 1;
int orderId = odrBll.AddOrderInfo(odr);
//添加一个中间表
var rodBll = new R_Order_DeskBLL();
var rod = new R_Order_Desk();
rod.DeskId = _id;
rod.OrderId = orderId;
var rodFlag = rodBll.AddROrderDesk(rod);
if (dkFlag && rodFlag)
{
MessageBox.Show("开单成功");
if (ckbMeal.Checked)
{
var mea = new MyEventArgs();
mea.Name = labDeskName.Text; //餐桌编号
mea.Temp = orderId; //订单Id
//窗体传值
var fam = new FrmAddMoney();
this.evtFrmMoney += new EventHandler(fam.SetText);
if (this.evtFrmMoney != null)
{
this.evtFrmMoney(this, mea);
fam.FormClosed += new FormClosedEventHandler(fam_FormClosed);
fam.ShowDialog();
}
}
else
{
this.Close();
}
}
else
{
MessageBox.Show("开单失败");
}
}
public frmOrderDish(ListView hallView, ListViewItem tableItem)
{
InitializeComponent();
this.hallView = hallView;
this.tableItem = tableItem;
this.Text = "厅包：" + this.hallView.Tag + "餐桌：" + tableItem.Text + "-" + this.Text;
this.diBll = new DishInfoBLL();
this.dtiBll = new DishTypeInfoBLL();
this.odiBll = new OrderDetailInfoBLL();
this.odBll = new OrderInfoBLL();
}
public static void CheckOrderExsit(string _orderNo, string _productNo, int _orderCount)
{
if (!OrderInfoBLL.OrderAlreadyExsit(_orderNo))
{
OrderInfoBLL.OrderInfoInsert(_orderNo, _productNo, _orderCount);
}
else
{
OrderInfoBLL.OrderInfoUpdate(_orderNo, _productNo, _orderCount);
}
}
private FrmGuestPay(int orderId, string deskName, int deskId)
{
InitializeComponent();
labDeskName.Text = deskName;
labOrderId.Text = orderId.ToString();
labdkId.Text = deskId.ToString();
OrderInfoBLL obll = new OrderInfoBLL();
object objMoney = obll.GetMoneyByOrderId(orderId);
labMoney.Text = objMoney.ToString(); //显示消费金额
lblMoney.Text = objMoney.ToString(); //结账金额
}
//增加消费
private void button2_Click(object sender, EventArgs e)
{
TabPage tp = tcin.TabPages[tcin.SelectedIndex];
//获取当前选中房间的名字
RoomInfo room = tp.Tag as RoomInfo;
FrmEventArgs fea = new FrmEventArgs();
fea.Money = Convert.ToDecimal(room.RoomMinimunConsume);
fea.Name = room.RoomName;
//string roomName = room.RoomName;
//最低消费
//获取当前选项卡中的listview控件
ListView lv = tp.Controls[0] as ListView;
//判断是否有选中的餐桌
if (lv.SelectedItems.Count > 0)
{
//获取当前选中的餐桌
DeskInfo dk = lv.SelectedItems[0].Tag as DeskInfo;
if (dk.DeskState == 1)
{
//fea.obj = dk;
fea.Name = dk.DeskName;//餐桌的编号
//订单的id，根据餐桌的id查找订单的id
OrderInfoBLL obll = new OrderInfoBLL();
int orderId = obll.GetOrderIdByDeskId(dk.DeskId);
fea.Temp = orderId;
FrmAddMoney fam = new FrmAddMoney();
this.evtAddMoney += new EventHandler(fam.SetText);//注册事件
if (this.evtAddMoney != null)
{
this.evtAddMoney(this, fea);
}
fam.FormClosed += new FormClosedEventHandler(fbi_FormClosed);
fam.ShowDialog();
}
else
{
MessageBox.Show("请选择开单的餐桌");
}
}
else
{
MessageBox.Show("没选中");
}
}
/// <summary>
/// 获取订单列表
/// </summary>
/// <param name="pageindex"></param>
/// <param name="pagesize"></param>
/// <param name="starttime"></param>
/// <param name="endtime"></param>
/// <param name="status"></param>
/// <param name="appname"></param>
/// <param name="username"></param>
/// <returns></returns>
public dynamic GetList(int pageindex, int pagesize, string starttime, string endtime, int status, string appname, string username)
{
try
{
OrderInfoBLL orderInfoBLL = new OrderInfoBLL();
//throw new Exception("错误");
return(orderInfoBLL.GetPageList(pageindex, pagesize, starttime, endtime, status, appname, username));
}
catch (ErrorMsgException ex)
{
return(new { status = 1, message = ex.Message });
}
}
public ActionResult Order_getCounts(string str)
{
retValue ret = new retValue();
PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel;
int userid = userModel._ID;
BLL.OrderInfoBLL _BLL = new OrderInfoBLL();
JObject o = null;
if (!string.IsNullOrEmpty(str))
{
o = JObject.Parse(str);
string test1 = o["test1"]._ToStrTrim();
string test2 = o["test2"]._ToStrTrim();
string Province = o["Province"]._ToStrTrim();
string CompanyCity = o["CompanyCity"]._ToStrTrim();
string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim();
string CompanyUnderArea = o["CompanyUnderArea"]._ToStrTrim();
string OrderNo = o["OrderNo"]._ToStrTrim();
string UnitName = o["UnitName"]._ToStrTrim();
string BKDH = o["BKDH"]._ToStrTrim();
string OrderState = o["OrderState"]._ToStrTrim();
string CostState = o["CostState"]._ToStrTrim();
string OrgID = "";
if (Province._ToInt32() > 0)
{
OrgID = Province;
}
if (CompanyCity._ToInt32() > 0)
{
OrgID = CompanyCity;
}
if (CompanyUnderCity._ToInt32() > 0)
{
OrgID = CompanyUnderCity;
}
if (CompanyUnderArea._ToInt32() > 0)
{
OrgID = CompanyUnderArea;
}
PageModel pg = _BLL.GetCount(0, BKDH, OrderNo, UnitName, test1, test2,
userModel.OrgID._ToStr(), OrgID, OrderState, CostState);
ret.result = true;
ret.data = pg.msg;
}
var js = JsonConvert.SerializeObject(ret);
return(Json(js, JsonRequestBehavior.AllowGet));
}
private void FrmAddMoney_FormClosing(object sender, FormClosingEventArgs e)
{
if (labSumMoney.Text != "" && !string.IsNullOrEmpty(labSumMoney.Text))
{
var bll = new OrderInfoBLL();
var id = Convert.ToInt32(labOrderId.Text);
var money = Convert.ToInt32(labSumMoney.Text);
if (bll.UpdateMoneyByOrderId(id, money) == false)
{
MessageBox.Show("保存订单总消费失败");
}
}
}
private int Id;//存餐桌的id
public void SetTxt(object sender, EventArgs e)
{
FrmEventArgs fea = e as FrmEventArgs;
this.Id = fea.DkIdZ; //获取餐桌的id
labDeskName.Text = fea.Name; //餐桌的编号
labOrderId.Text = fea.Temp.ToString(); //订单的id
//根据订单的id查询这个订单消费了多少钱
OrderInfoBLL bll = new OrderInfoBLL();
labMoney.Text = bll.GetOrderMoney(fea.Temp).ToString();
lblMoney.Text = labMoney.Text;//结账金额和消费金额一样------坑
}
//确定开单
private void btnOK_Click(object sender, EventArgs e)
{
//餐桌的id,改变餐桌的状态
DeskInfoBLL dkBll = new DeskInfoBLL();
bool dkResult = dkBll.UpdateDeskStateByDeskId(this.Id, 1);//餐桌开单了
//添加一个订单,需要备注,订单的状态,提交人,提交时间,删除标识
OrderInfo order = new OrderInfo();
order.Remark = txtPersonCount.Text + txtDescription.Text;//人数和描述(备注)直接存到备注信息里
order.SubBy = 1;
order.SubTime = DateTime.Now;
order.DelFlag = 0;
order.OrderState = 1; //标识的是这个订单正在使用
OrderInfoBLL odBll = new OrderInfoBLL();
int orderId = odBll.GetOrderIdInsertOrderInfo(order); //插入一个订单的同时获取该订单的id
//向中间表(订单和餐桌)插入 订单的id还有餐桌的id
ROrderDeskBLL roddkBll = new ROrderDeskBLL();
ROrderDesk rod = new ROrderDesk();
rod.DeskId = this.Id; //餐桌id
rod.OrderId = orderId; //订单id
bool RoDResult = roddkBll.AddROrderDesk(rod);
if (dkResult && RoDResult)
{
MessageBox.Show("开单成功");
this.Close();
}
else
{
MessageBox.Show("开单失败");
}
if (ckbMeal.Checked)
{
FrmAddMoney fam = new FrmAddMoney();
this.evt += new EventHandler(fam.SetTxt);
FrmEventArgs fea = new FrmEventArgs();
fea.Name = labDeskName.Text; //餐桌的编号
fea.Temp = orderId; //订单的id
if (this.evt != null)
{
this.evt(this, fea);
}
//增加消费的窗体关闭后,当前的开单窗体关闭
fam.FormClosed += new FormClosedEventHandler(fam_FormClosed);
fam.ShowDialog();
}
}
private void btnAccounts_Click(object sender, EventArgs e)
{
OrderInfo order = new OrderInfo();
order.OrderId = Convert.ToInt32(labOrderId.Text); //订单的id
order.EndTime = DateTime.Now; //订单中的结束时间
//如果选择会员
if (cmbMemmber.SelectedIndex == 0)
{
//不是会员
// order.DisCount = 10;
}
else
{
//是会员
//会员的余额更新
//如果是会员,那么要获取该会员的余额-当前消费的金额,更新到会员的表中
decimal memYuMoney = Convert.ToDecimal(labyeMoney.Text) - Convert.ToDecimal(lblMoney.Text);
int memId = Convert.ToInt32(cmbMemmber.SelectedValue);
MemmberInfoBLL bll = new MemmberInfoBLL();
bool memresult = bll.UpdateMoney(memId, memYuMoney); //更新会员的余额
order.OrderMemId = memId; //订单中的会员id
order.DisCount = Convert.ToDecimal(lblDis.Text); //这个是订单中的会员折扣
}
//更新餐桌的状态=0
//获取餐桌的id,更改餐桌的状态
DeskInfoBLL dkBll = new DeskInfoBLL();
bool result = dkBll.UpdateDeskStateByDeskId(this.Id, 0);
//订单的状态=2
//获取订单的id更改订单的状态.更新这个订单最后花费多少钱,结束时间
order.OrderMoney = Convert.ToDecimal(lblMoney.Text);//这个订单花了多少钱
//窗体关闭
OrderInfoBLL obll = new OrderInfoBLL();
bool oresult = obll.UpdateOrderInfoMoney(order);
if (result && oresult)
{
MessageBox.Show("结账成功");
this.Close();
}
else
{
MessageBox.Show("结账失败");
}
}
private bool TryUpdateOrderInfo()
{
OrderInfoBLL orderBll = new OrderInfoBLL();
OrderInfo order = orderBll.get(this.orderId);
order.EndTime = DateTime.Now;
order.OrderMoney = Convert.ToDouble(lblCheckMoney.Text);
order.OrderState = (int)OrderStatus.Checked;
if (cmbMember.SelectedIndex != 0)
{
MemberInfo member = (MemberInfo)cmbMember.SelectedItem;
order.OrderMemberId = member.MemberId;
order.DisCount = member.MemDiscount;
}
return(orderBll.update(order));
}
/// <summary>
/// 构造函数
/// </summary>
public DiagnosisPayController()
{
orderInfoBLL = new OrderInfoBLL();
orderfeedetailBLL = new OrderfeedetailBLL();
reginfoBLL = new ReginfoBLL();
feeinfoBLL = new FeeinfoBLL();
feeInfodetailBLL = new FeeInfodetailBLL();
ptInfoBLL = new PtInfoBLL();
sysDeptBLL = new SysDeptBLL();
sysUserinfoBLL = new SysUserinfoBLL();
feeTrialBLL = new FeeTrialBLL();
commKeyBLL = new CommKeyBLL();
commFeeBLL = new CommFeeBLL();
commMedBLL = new CommMedBLL();
commYbCodeBLL = new CommYbCodeBLL();
}
private void FrmAddMoney_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult.OK == MessageBox.Show("确定关闭吗?", "提示订单提交", MessageBoxButtons.OKCancel))
{
if (!string.IsNullOrEmpty(labSumMoney.Text))
{
OrderInfoBLL bll = new OrderInfoBLL();
if (bll.UpdateOrderMoney(this.ordId, Convert.ToDecimal(labSumMoney.Text)))
{
MessageBox.Show("订单提交成功");
}
else
{
MessageBox.Show("订单提交失败");
}
}
}
}
public void ExportOrder(string starttime, string endtime, int status, string appname, string username)
{
OrderInfoBLL orderInfoBLL = new OrderInfoBLL();
List <OrderInfo> exportList = orderInfoBLL.ExportList(starttime, endtime, status, appname, username);
StringBuilder sb = new StringBuilder();
sb.AppendLine("AppId\t" + "应用名称\t" + "任务类型\t" + "用户名\t" + "IDFA\t" + "IP地址\t" + "任务开始时间\t" + "任务完成时间\t" + "状态\t" + "订单创建时间\t");
foreach (OrderInfo item in exportList)
{
sb.AppendLine(item.TaskInfo.AppId + "\t" + item.TaskInfo.App.Name + "\t" + item.TaskInfo.Type.ToString() + "\t" + item.Account.UserName + "\t" + item.IDFA + "\t" + item.IPAddress + "\t" + (item.StartTime == null ? "" : item.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss")) + "\t" + (item.EndTime == null ? "" : item.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss")) + "\t" + item.Status.ToString() + "\t" + item.CreateTime.ToString("yyyy-MM-dd HH:mm:ss") + "\t");
}
System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
System.Web.HttpContext.Current.Response.AddHeader
("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("订单记录明细" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"));
System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";
System.Web.HttpContext.Current.Response.Write(sb.ToString());
System.Web.HttpContext.Current.Response.Flush();
System.Web.HttpContext.Current.Response.End();
}
//结账按钮
private void button3_Click(object sender, EventArgs e)
{
TabPage tp = tcInFo.SelectedTab; //获取当前餐桌所在的房间的选项卡
RoomInfo r = tp.Tag as RoomInfo; //从tag中获取房间的对象==坑---名字,最低消费
ListView lv = tp.Controls[0] as ListView; //获取listview
if (lv.SelectedItems.Count > 0)
{
ListViewItem lvt = lv.SelectedItems[0]; //获取当前listview中选中的项
DeskInfo dk = lvt.Tag as DeskInfo; //可以获取该选中的餐桌的编号还有id
if (dk.DeskState == 1)
{
FrmBalance fb = new FrmBalance();
this.evtBalance += new EventHandler(fb.SetTxt);//传值
//获取要传递的参数后 显示开单的窗体
FrmEventArgs fea = new FrmEventArgs();
fea.Name = dk.DeskName; //餐桌的编号
fea.DkIdZ = dk.DeskId; //餐桌的id
//这里必须要获取该餐桌的订单id===============坑
OrderInfoBLL obll = new OrderInfoBLL();
int orderId = obll.GetOrderIdByDeskId(dk.DeskId); //获取订单的id(当前餐桌)
fea.Temp = orderId; //订单id传到消费窗体中
if (this.evtBalance != null)
{
this.evtBalance(this, fea);
}
//此窗体关闭后 一定要进行刷新.
fb.FormClosed += new FormClosedEventHandler(fbl_FormClosed);//调用上面的方法
fb.ShowDialog();
}
else
{
MessageBox.Show("请选择已经开单的餐桌");
}
}
else
{
MessageBox.Show("请看好目标后再下手");
}
}
private void btnOk_Click(object sender, EventArgs e)
{
//顾客开单
//更新餐桌状态
DeskInfoBLL dbll = new DeskInfoBLL();
int deksId = Convert.ToInt32(labId.Text);
bool isDesk = dbll.UpdateDeskInfoStateByDeskId(deksId, 1);//1标识正在使用
//生成订单
OrderInfoBLL obll = new OrderInfoBLL();
OrderInfo order = new OrderInfo();
order.BeginTime = DateTime.Now;
order.DelFlag = 0;
order.DisCount = 0;
order.OrderMoney = 0;
order.OrderState = 1;//表示已经开单
order.Remark = txtPersonCount.Text + "个人" + txtDescription.Text;
order.SubBy = 1;
order.SubTime = System.DateTime.Now;
object obj = obll.AddOrderInfo(order);//返回的是刚刚插入的订单的主键id;
//向中间表插入一条数据
R_Order_DeskBLL rodbll = new R_Order_DeskBLL();
R_Order_Desk rod = new R_Order_Desk();
rod.DeskId = deksId;
rod.OrderId = Convert.ToInt32(obj);
ordId = Convert.ToInt32(obj);
bool isRod = rodbll.AddR_Order_Desk(rod);
if (!isDesk || !isRod)
{
md.MsgDivShow("开单失败，请联系管理员", 1);
return;
}
md.MsgDivShow("开单成功", 1, Bind);
// md.MsgDivShow("开单成功",1,Bind);
}
