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, "保存失败！", "");
}
}
