/// <summary> /// 撤销结账 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btncxSava_Click(object sender, EventArgs e) { if (ddlState.SelectedValue == "4") { string SQls = "update room_number set Rn_state=2 where Rn_roomNum='" + brBll.GetModel(Convert.ToInt32(txt_room.Value)).room_number + "'"; string strs = "update occu_infor set state_id='0', tuifaId='0',occ_TfTime=null where occ_id=" + txt_room.Value + ""; if (fmroom.Updates(SQls) && brBll.Updates(strs)) { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "撤销挂单成功!", ""); } } else { List <Model.goods_account> listga = bllga.GetModelList1("ga_occuid='" + brBll.GetModel(Convert.ToInt32(txt_room.Value)).order_id + "' and ga_isjz=1"); if (listga != null && listga.Count > 0) { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "已交班不能撤销结账!", ""); } else { string strsql = "update goods_account set ga_sfacount='否' where ga_occuid='" + brBll.GetModel(Convert.ToInt32(txt_room.Value)).order_id + "'"; string SQl = string.Empty; if (rooms.Value != "") { SQl = "update room_number set Rn_state=2 where Rn_roomNum in(" + rooms.Value + ")"; } string strs = "update occu_infor set state_id='0', tuifaId='0' where order_id=" + brBll.GetModel(Convert.ToInt32(txt_room.Value)).order_id + ""; string SQls = "delete from goods_account where ga_Type in(4,6) and ga_occuid='" + brBll.GetModel(Convert.ToInt32(txt_room.Value)).order_id + "'"; if (fmroom.Updates(SQl) && brBll.Updates(strs)) { fmgoods.Updates(strsql); fmgoods.Deletes(SQls); string up = rooms.Value.Replace("'", ""); Helper.AddRoom(brBll.GetModel(Convert.ToInt32(txt_room.Value)).room_number, up + ","); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "撤销结账成功!", ""); } else { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "撤销结账失败!", ""); } } } }