public override void SonLoad() { if (!IsPostBack) { //ids = Convert.ToInt32(Request.QueryString["id"]); string id = Request.QueryString["id"]; ids = blloc.GetModelList("order_id='" + id + "'")[0].occ_id; txt_hidid.Value = ids.ToString(); Model.occu_infor modelocc = fmOc.GetModel(ids); if (modelocc == null) { Model.room_number modelrn = bllrn.GetModel(ids); modelocc = blloc.GetModelList("room_number='" + modelrn.Rn_roomNum + "' and state_id=0")[0]; } prooccmodle = modelocc; occno = modelocc.occ_no.ToString(); orderid = modelocc.order_id.ToString(); orderids.Value = orderid; btnserch_Click(null, null); BindZFFS(); BindInfo(); occid = ""; hidids = ""; txt_id.Value = ids.ToString(); try { txt_ysqje.Value = fmrz.GetModels(" where ga_occuid='" + occno + "'").ga_price.ToString(); } catch { txt_ysqje.Value = "0.00"; } } }
public override void SonLoad() { if (!IsPostBack) { ids = Convert.ToInt32(Request.QueryString["id"]); txt_hidid.Value = ids.ToString(); Model.occu_infor modelocc = fmOc.GetModel(Convert.ToInt32(Request.QueryString["id"])); if (modelocc == null) { Model.room_number modelrn = bllrn.GetModel(ids); modelocc = blloc.GetModelList("room_number='" + modelrn.Rn_roomNum + "' and state_id=0")[0]; } prooccmodle = modelocc; if (modelocc.mem_cardno != "" && modelocc.mem_cardno != null) { btn_duihaun.Style.Add("display", "inline-block"); hycard.Value = modelocc.mem_cardno; } else { btn_duihaun.Style.Add("display", "none"); hycard.Value = ""; } zffs_id.Value = modelocc.meth_pay_id.ToString(); occno = modelocc.occ_no.ToString(); orderid = modelocc.order_id.ToString(); orderids.Value = orderid; accounts.Value = modelocc.Accounts; btnserch_Click(null, null); BindZFFS(); BindInfo(); occid = ""; hidids = ""; txt_id.Value = ids.ToString(); try { txt_ysqje.Value = fmrz.GetModels(" where ga_occuid='" + occno + "'").ga_price.ToString(); } catch { txt_ysqje.Value = "0.00"; } } }
/// <summary> /// 获取在住客人详细详细 /// </summary> public void BindGvInfo() { string RoomNum = ""; double xiaofei = 0; //消费 double shoukuan = 0; //收款 double yue = 0; //余额 string sukeName = ""; double ysk = 0; int id = fmoc.GetModels(" where room_number='" + roomNum + "' and state_id=0 and occ_with='否'").occ_id; string orderid = fmoc.GetModels(" where room_number='" + roomNum + "' and state_id=0 and occ_with='否'").order_id; string Ocnono = fmoc.GetModels(" where room_number='" + roomNum + "' and state_id=0 and occ_with='否'").occ_no; IList <Model.goods_account> list = gmGood.GetModelList1(" ga_occuid='" + orderid + "'"); for (int i = 0; i < list.Count; i++) { xiaofei += Convert.ToDouble((list[i].ga_price)); shoukuan += Convert.ToDouble((list[i].ga_sum_price)); } IList <Model.occu_infor> lists = fmoc.GetModelList(" order_id='" + orderid + "' and occ_with='是'"); for (int i = 0; i < lists.Count; i++) { if (sukeName == "") { sukeName += (lists[i].occ_name); } else { sukeName += ";" + (lists[i].occ_name).ToString(); } } yue = xiaofei - shoukuan; try { ysk = Convert.ToDouble(gmGood.GetModels(" where ga_occuid='" + Ocnono + "'").ga_price.ToString()); } catch { ysk = 0; } DataSet dts = fmoc.GetList(" order_id='" + orderid + "' and occ_with='否'"); foreach (DataRow dr1 in dts.Tables[0].Rows) { if (RoomNum == "") { RoomNum += dr1["room_number"].ToString(); } else { RoomNum += ";" + dr1["room_number"].ToString(); } } string a = RoomNum; DataSet dt = fmoc.GetList(" room_number='" + roomNum + "' and state_id=0 and occ_with='否'"); foreach (DataRow dr in dt.Tables[0].Rows) { content = dr["occ_name"].ToString() + "," + dr["room_number"].ToString() + "," + dr["sex"].ToString() + "," + GetRealTypeName(Convert.ToInt32(dr["real_type_id"].ToString())) + "," + dr["occ_time"].ToString() + "," + dr["depar_time"].ToString() + "," + GetzjName(Convert.ToInt32(dr["card_id"].ToString())) + "," + dr["card_no"].ToString() + "," + dr["state_id"].ToString() + "," + dr["address"].ToString() + "," + dr["remark"].ToString() + "," + GetKffsName(Convert.ToInt32(dr["real_mode_id"].ToString())) + "," + RoomNum + "," + shoukuan + "," + xiaofei + "," + yue + "," + sukeName + "," + ysk + "," + Convert.ToDecimal(dr["real_price"]).ToString("0.##") + "," + GetRealTypeNamePrice(Convert.ToInt32(dr["real_type_id"])) + "," + dr["mem_cardno"].ToString() + "," + GetXieYi(dr["accounts"].ToString()); } }
/// <summary> /// 换房 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdds_Click(object sender, EventArgs e) { Model.occu_infor mode = new Model.occu_infor(); string SQl = "update room_number set Rn_state=4 where Rn_roomNum='" + labfh.Text + "';update room_number set Rn_state=2 where Rn_roomNum='" + txt_RoomNum.Value + "'";; Model.occu_infor Ocmodels = new Model.occu_infor(); Ocmodels.state_id = 2; Ocmodels.continuelive = ids; Ocmodels.occ_time = System.DateTime.Now; Ocmodels.room_number = (txt_RoomNum.Value).ToString(); Ocmodels.real_price = Convert.ToDecimal(txt_Money.Value); Ocmodels.remark = txt_Remaker.Value; Ocmodels.state_id = 0; Ocmodels.occ_no = fmrzInfo.GetModel(ids).occ_no; Ocmodels.occ_name = fmrzInfo.GetModel(ids).occ_name; Ocmodels.occ_with = "否"; Ocmodels.stay_day = fmrzInfo.GetModel(ids).stay_day; Ocmodels.depar_time = fmrzInfo.GetModel(ids).depar_time; Ocmodels.sex = fmrzInfo.GetModel(ids).sex; Ocmodels.card_id = fmrzInfo.GetModel(ids).card_id; Ocmodels.brithday = fmrzInfo.GetModel(ids).brithday; Ocmodels.family_name = fmrzInfo.GetModel(ids).family_name; Ocmodels.address = fmrzInfo.GetModel(ids).address; Ocmodels.meth_pay_id = fmrzInfo.GetModel(ids).meth_pay_id; Ocmodels.deposit = fmrzInfo.GetModel(ids).deposit; Ocmodels.remark = fmrzInfo.GetModel(ids).remark; Ocmodels.lordRoomid = (txt_RoomNum.Value).ToString(); Ocmodels.phonenum = fmrzInfo.GetModel(ids).phonenum; Ocmodels.Room_type_model = fmrzInfo.GetModel(ids).Room_type_model; Ocmodels.source_id = fmrzInfo.GetModel(ids).source_id; Ocmodels.real_mode_id = fmrzInfo.GetModel(ids).real_mode_id; Ocmodels.real_scheme_id = fmrzInfo.GetModel(ids).real_scheme_id; Ocmodels.real_type_id = fmrzInfo.GetModel(ids).real_type_id; Ocmodels.order_id = fmrzInfo.GetModel(ids).order_id; Ocmodels.tuifaId = "0"; string noces = System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", ""); string strsql = ""; if (fmrzInfo.GetRecordCount("where order_id='" + Ocmodels.order_id + "'") == 1) { strsql = "update occu_infor set state_id=2,tuifaId=2,continuelive=1 ,order_id='" + noces + "' where occ_id='" + ids + "'"; } else { // strsql = "update occu_infor set state_id=3,tuifaId=2,continuelive=1 where order_id=" + Ocmodels.order_id + ""; strsql = "update occu_infor set state_id=2,tuifaId=2,continuelive=1 where occ_id=" + ids + ""; } fmrzInfo.Updates(strsql); CdHotelManage.Model.goods_account model = new CdHotelManage.Model.goods_account(); CdHotelManage.BLL.goods_account bll = new CdHotelManage.BLL.goods_account(); double money = double.Parse(txt_Money.Value) - double.Parse(labSymoney.Text); if (money > 0) { money = double.Parse(labSymoney.Text) - double.Parse(txt_Money.Value); } else { money = double.Parse(labSymoney.Text); } string Remaker = labname.Text + "从" + labfh.Text + "换到" + txt_RoomNum.Value + " 从" + labkffs.Text + "(" + labSymoney.Text + ")调整为天房(" + txt_Money.Value + ") 操作时间:" + System.DateTime.Now; string beizhu = fmGoods.GetModels(" where ga_Type=8 order by ga_date ").ga_remker + Remaker + ","; string Date = fmGoods.GetModels(" where ga_Type=8 order by ga_date ").ga_date.ToString(); string upsql = "update goods_account set ga_sum_price='" + money + "',ga_remker='" + beizhu + "' where ga_Type=8 and datediff(SS,ga_date,'" + Date + "')=0 and ga_occuid='" + Ocmodels.order_id + "'"; fmGoods.Updates(upsql); if (fhBll.Updates(SQl) && fmrzInfo.Add(Ocmodels) > 0) { Helper.AddRoom(Ocmodels.room_number); Helper.AddRoom(Ocmodels.lordRoomid); //Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", ""); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript'>if(confirm('换房成功,是否打换房单')){Show(" + ids + ");}else{ parent.location.reload(); };</script>"); } else { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存失败!", ""); } }