/// <summary> /// 添加餐桌订单中间表信息 /// </summary> /// <param name="rod"></param> /// <returns></returns> public int AddR_Order_Desk(R_Order_Desk rod) { string sql = "insert into R_Order_Desk(OrderId,DeskId)values(@OrderId,@DeskId)"; SqlParameter[] ps = { new SqlParameter("@OrderId", rod.OrderId), new SqlParameter("@DeskId", rod.DeskId) }; return(SqlHelper.ExecuteNonQuery(sql, ps)); }
/// <summary> /// 开单的三件事情 /// </summary> /// <param name="insertOrder">插入的order,注意该order对象没有id</param> /// <param name="desk">state:0--->空闲;1--->就餐</param> /// <returns>返回orderId</returns> public int AddOrderAddOrder_DeskUpdateDesk(OrderInfo insertOrder, DeskInfo desk) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString)) { con.Open(); SqlTransaction tx = con.BeginTransaction(); try { //修改deskinfo的state为1 new DeskInfoDAL().UpdateDeskInfoStateByDeskIdAndState(con, tx, (int)desk.DeskId, 1); //插入新的order,并将得到的id传给下面的R_Order_Desk int orderId = add(con, tx, insertOrder); //插入order_desk R_Order_Desk od = new R_Order_Desk(); od.OrderId = orderId; od.DeskId = desk.DeskId; new R_Order_DeskDAL().add(con, tx, od); tx.Commit(); return(orderId); } catch { tx.Rollback(); return(0); } } }
public R_Order_Desk toModel(DataRow dr) { R_Order_Desk model = new R_Order_Desk(); model.RID = dr.IsNull("RID") ? null : (Int32?)dr["RID"]; model.OrderId = dr.IsNull("OrderId") ? null : (Int32?)dr["OrderId"]; model.DeskId = dr.IsNull("DeskId") ? null : (Int32?)dr["DeskId"]; return(model); }
public int add(SqlConnection con, SqlTransaction tran, R_Order_Desk model) { object o = DBNull.Value; return(Convert.ToInt32(sqlHelper.executeScalar(con, tran, "insert into R_Order_Desk (OrderId,DeskId) output inserted.RID values(@OrderId,@DeskId)" , new SqlParameter("OrderId", (model.OrderId == null) ? o : model.OrderId) , new SqlParameter("DeskId", (model.DeskId == null) ? o : model.DeskId) ))); }
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 int update(R_Order_Desk model) { object o = DBNull.Value; string sqlText = @"update R_Order_Desk set OrderId=@OrderId,DeskId=@DeskId where RID =@RID "; return(sqlHelper.executeNonQuery(sqlText , new SqlParameter("RID", (model.RID == null) ? o : model.RID) , new SqlParameter("OrderId", (model.OrderId == null) ? o : model.OrderId) , new SqlParameter("DeskId", (model.DeskId == null) ? o : model.DeskId) )); }
/// <summary> /// 确定开单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { //做三件事情 //1更改餐桌状态 DeskInfoBll dkbll = new DeskInfoBll(); bool dkFlag = dkbll.UpdateDeskStateByDeskId(this.ID, 1); //2添加一个订单 OrderInfoBll orbll = new OrderInfoBll(); OrderInfo o = new OrderInfo(); o.SubTime = System.DateTime.Now; o.DelFlag = 0; o.OrderMoney = 0; o.OrderState = 1; o.Remark = txtPersonCount.Text + txtDescription.Text; o.SubBy = 1; int orderId = orbll.AddOrderInfo(o); //3添加一个中间表 R_Order_DeskBll rodbll = new R_Order_DeskBll(); R_Order_Desk rod = new R_Order_Desk(); rod.DeskId = this.ID; rod.OrderId = orderId; bool rodFlag = rodbll.AddOrderDesk(rod); if (dkFlag && rodFlag) { MessageBox.Show("开单成功"); } else { MessageBox.Show("开单失败"); } if (ckbMeal.Checked) { FrmAddMoney frm_money = new FrmAddMoney(); mea_money.Name = labDeskName.Text; //餐桌的编号 mea_money.Temp = orderId; //订单id this.evtFrmmoney += new EventHandler(frm_money.SetText); if (this.evtFrmmoney != null) { this.evtFrmmoney(this, mea_money); frm_money.FormClosed += new FormClosedEventHandler(frm_money_formclosed); frm_money.ShowDialog(); } } else { } }
public IEnumerable <R_Order_Desk> getAll() { string sqlText = @"select * from R_Order_Desk"; DataTable dt = sqlHelper.executeDataTable(sqlText); List <R_Order_Desk> models = new List <R_Order_Desk>(); foreach (DataRow dr in dt.Rows) { R_Order_Desk model = new R_Order_Desk(); model.RID = dr.IsNull("RID") ? null : (Int32?)dr["RID"]; model.OrderId = dr.IsNull("OrderId") ? null : (Int32?)dr["OrderId"]; model.DeskId = dr.IsNull("DeskId") ? null : (Int32?)dr["DeskId"]; models.Add(model); } return(models); }
public R_Order_Desk get(int id) { string sqlText = @"select * from R_Order_Desk where RID = @id"; DataTable dt = sqlHelper.executeDataTable(sqlText, new SqlParameter("id", id)); if (dt.Rows.Count <= 0) { return(null); } else { R_Order_Desk model = new R_Order_Desk(); DataRow dr = dt.Rows[0]; model.RID = dr.IsNull("RID") ? null : (Int32?)dr["RID"]; model.OrderId = dr.IsNull("OrderId") ? null : (Int32?)dr["OrderId"]; model.DeskId = dr.IsNull("DeskId") ? null : (Int32?)dr["DeskId"]; return(model); } }
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); }
private void btnOk_Click(object sender, EventArgs e) { //首先改变餐桌状态 DeskInfoBLL dkBll = new DeskInfoBLL(); bool dkFlag = dkBll.UpdateDeskInfoStateByDeskId(Convert.ToInt32(labId.Text), 1); //添加一个订单 返回该订单ID OrderInfo order = new OrderInfo(); order.BeginTime = System.DateTime.Now; //订单的开始时间 order.DelFlag = 0; //删除标识 order.DisCount = 0; //折扣==针对会员 order.OrderMoney = 0; //订单消费的金额默认值为0 order.OrderState = 1; //订单状态1===使用 order.Remark = txtPersonCount.Text + "个" + txtDescription.Text; //备注 order.SubBy = 1; //提交人默认1 order.SubTime = System.DateTime.Now; OrderInfoBll oBll = new OrderInfoBll(); //获得订单的id object orderIdObj = oBll.AddOrderInfo(order); //为餐桌和订单的中间表添加一条记录 R_Order_Desk rod = new R_Order_Desk(); rod.DeskId = Convert.ToInt32(labId.Text); //餐桌的id rod.OrderId = Convert.ToInt32(orderIdObj); //订单的id ordId = rod.OrderId; //存储订单的id R_Order_DeskBll rodBll = new R_Order_DeskBll(); bool rodFlag = rodBll.AddR_Order_Desk(rod); if (dkFlag && rodFlag) { md.MsgDivShow("开单成功", 1, Bind); } else { md.MsgDivShow("开单失败,请联系程序员", 1); return; } }
/// <summary> /// 添加一个中间表 /// </summary> /// <param name="rod"></param> /// <returns></returns> public int AddOrderDesk(R_Order_Desk rod) { string sql = "insert into R_Order_Desk(OrderId,DeskId)values(@OrderId,@DeskId)"; return(Sqlitehelper.ExecuteNonQuery(sql, new SQLiteParameter("@OrderId", rod.OrderId), new SQLiteParameter("@DeskId", rod.DeskId))); }
public int add(R_Order_Desk model) { return(new R_Order_DeskDAL().add(model)); }
/// <summary> /// 添加一个中间表 /// </summary> /// <param name="rod"></param> /// <returns></returns> public bool AddOrderDesk(R_Order_Desk rod) { return(rdo_dal.AddOrderDesk(rod) > 0); }
/// <summary> /// 添加一个中间表的数据 /// </summary> public bool AddROrderDesk(R_Order_Desk rod) { return(dal.AddROrderDesk(rod) > 0); }
/// <summary> /// 添加一个餐桌和订单的中间表的一条数据 /// </summary> /// <param name="rod">中间表的对象</param> /// <returns>受影响的行数</returns> public bool AddR_Order_Desk(R_Order_Desk rod) { return(rodDal.AddR_Order_Desk(rod) > 0); }
public int update(R_Order_Desk model) { return(new R_Order_DeskDAL().update(model)); }