/// <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));
}
