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"; } } }
/// <summary> /// 添加房号 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdd_Click(object sender, EventArgs e) { string id = Request.QueryString["id"].ToString(); Model.room_number frmfh = new Model.room_number(); frmfh.Rn_roomNum = txt_roomid.Value; frmfh.Rn_floor = DDlouc.SelectedValue; frmfh.Rn_room = ddroomtype.SelectedValue; frmfh.Rn_remaker = txt_Reamker.Value; frmfh.Rn_Type = 1; frmfh.Rn_price = Convert.ToDecimal(txt_money.Value); if (id == "") { int Result = fhBll.Add(frmfh); if (Result > 0) { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", ""); } } else { frmfh.id = Convert.ToInt32(id); if (fhBll.Update(frmfh)) { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "更新成功!", ""); } } }
protected void btnAdd_Click(object sender, EventArgs e) { Model.room_number model = new Model.room_number(); //string stayroomNum = txt_stay.Value.Substring(txt_stay.Value.Length - 1, 1); //string endnum = txt_end.Value.Substring(txt_end.Value.Length - 1, 1); int count = 0; int number = Convert.ToInt32(txt_stay.Value); int Addlength = Convert.ToInt32(txt_end.Value) - Convert.ToInt32(txt_stay.Value); for (int i = 0; i <= Addlength; i++) { model.Rn_price = Convert.ToDecimal(txt_money.Value); model.Rn_flloeld = DDlLD.SelectedValue; model.Rn_floor = DDlouc.SelectedValue; model.Rn_room = ddroomtype.SelectedValue; model.Rn_Type = 1; model.Rn_state = 3; model.Rn_remaker = ""; model.Rn_Tobe = 0; if (i == 0) { model.Rn_roomNum = txt_A.Value + txt_stay.Value; } else { number++; if (number < 10) { model.Rn_roomNum = txt_A.Value + "0" + (number).ToString(); } else { model.Rn_roomNum = txt_A.Value + (number).ToString(); } } string endnum = model.Rn_roomNum.Substring(model.Rn_roomNum.Length - 1, 1); if (txt_roomws.Value.Trim().Contains(endnum)) { } else { if (!IsCuzai(model.Rn_roomNum)) { fhBll.Add(model); } } count++; } if (count > 0) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('保存成功');parent.Window_Close();</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('保存失败');</script>"); } }
/// <summary> /// 多人开房绑定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnBind_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txt_id.Value); Model.room_number mod = new Model.room_number(); txt_roomid.Value = fhBll.GetModel(id).Rn_roomNum; ddroomtype.SelectedValue = (fhBll.GetModel(id).Rn_room).ToString(); txt_money.Value = (fhBll.GetModel(id).Rn_price).ToString(); txt_rzdate.Value = System.DateTime.Now.ToString(); }
public static void UpdateRoom(string room) { List <Model.room_number> listrn = bllrn.GetModelList("Rn_roomNum='" + room + "'"); if (listrn.Count > 0) { Model.room_number modelrn = listrn[0]; modelrn.Rn_Tobe = 0; bllrn.Update(modelrn); } }
/// <summary> /// 删除房间 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btndelete2_Click(object sender, EventArgs e) { Model.room_number fm = new Model.room_number(); int id = Convert.ToInt32(txt_fj.Value); if (fhBll.Delete(id)) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('删除成功');</script>"); BindFH(); } }
/// <summary> /// 根据房号来判断是否预定 /// </summary> /// <returns></returns> private bool IsBook(string roomNumber) { List <Model.room_number> list = bllrn.GetModelList("Rn_roomNum='" + roomNumber + "'"); if (list.Count > 0) { Model.room_number modelrn = list[0]; if (modelrn.Rn_Tobe == 1) { return(true); } } return(false); }
private void Isroom() { string id = context.Request.QueryString["id"]; Model.room_number modelrn = bllrn.GetModel(Convert.ToInt32(id)); List <Model.occu_infor> listoc = blloi.GetModelList("state_id=0 and room_number='" + modelrn.Rn_roomNum + "'"); if (listoc.Count > 0) { context.Response.Write("ok"); } else { context.Response.Write("err"); } }
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> /// <param name="sender"></param> /// <param name="e"></param> protected void btnBind_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txt_id.Value); Model.room_number mod = new Model.room_number(); txt_roomid.Value = fhBll.GetModel(id).Rn_roomNum; ddroomtype.SelectedValue = (fhBll.GetModel(id).Rn_room).ToString(); txt_money.Value = (fhBll.GetModel(id).Rn_price).ToString(); txt_rzdate.Value = System.DateTime.Now.ToString(); string a = hidSchool.Value; if (txt_type.Value == "0") { string[] Content = contents.Split('|'); for (int i = 0; i < Content.Length - 1; i++) { if (Content[i].Split('#')[0] == txt_roomid.Value) { string b = Content[i].Split('#')[3].ToString(); txt_name.Value = Content[i].Split('#')[10]; txt_Sex.Value = Content[i].Split('#')[11]; txt_CardId.Value = Content[i].Split('#')[15]; txt_ylDate.Value = Content[i].Split('#')[7]; txt_zfzhanghao.Value = Content[i].Split('#')[20]; txt_Day.Value = Content[i].Split('#')[8]; txt_Date2.Value = Content[i].Split('#')[12]; txt_CardId.Value = Content[i].Split('#')[15]; DDlSFz.SelectedValue = Content[i].Split('#')[14]; // txt_address.Value = Content[i].Split('#')[20]; txt_mingzhu.Value = Content[i].Split('#')[13]; txt_address.Value = Content[i].Split('#')[19]; } } } btn_rooms.Value = "终止开房"; DivDisHidroom.Style.Add("display", "block"); }
/// <summary> /// 添加房号 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdd_Click(object sender, EventArgs e) { string id = Request.QueryString["id"].ToString(); Model.room_number frmfh = new Model.room_number(); frmfh.Rn_roomNum = txt_roomid.Value; frmfh.Rn_floor = DDlouc.SelectedValue; frmfh.Rn_room = ddroomtype.SelectedValue; frmfh.Rn_remaker = txt_Reamker.Value; frmfh.Rn_Type = 1; frmfh.Rn_flloeld = DDlLD.SelectedValue; frmfh.Rn_state = 3; frmfh.Rn_price = Convert.ToDecimal(txt_money.Value); if (id == "") { if (!IsCuzai(frmfh.Rn_roomNum)) { int Result = fhBll.Add(frmfh); if (Result > 0) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('保存成功');parent.Window_Close();</script>"); } } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('该房号已经存在!');</script>"); } } else { frmfh.id = Convert.ToInt32(id); if (fhBll.Update(frmfh)) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('更新成功');parent.Window_Close();</script>"); } } }
public void bindInfo() { Model.room_number mod = new Model.room_number(); BindYXGV(); if (Request.QueryString["type"].ToString() == "yding") { IList <Model.book_room> list = brBll.GetBookRoomPager("book_id", "Desc", 1, 1, " WHERE book_no='" + Request.QueryString["ydbookno"].ToString() + "' "); if (list.Count > 0) { foreach (Model.book_room item in list) { item.ListBr = fmrdet.GetListModel("Book_no='" + item.book_no + "' and Room_number in (" + Request.QueryString["xqid"].ToString() + ") and Room_typeid=1"); foreach (Model.Book_Rdetail br in item.ListBr) { contents += br.Room_number + "#" + (br.Real_type_Id.ToString()) + "#" + (item.source_id.ToString()) + "#" + (br.Real_Scheme_Id.ToString()) + "#" + br.Real_Price.ToString() + "#" + "否" + "#" + (item.real_time.ToString()) + "#" + 1 + "#" + (item.time_from.ToString()) + "#" + item.book_Name + "#" + this.txt_Sex.Value + "#" + this.txt_Date2.Value + "#" + this.txt_mingzhu.Value + "#" + (this.DDlSFz.SelectedValue) + "#" + (this.txt_CardId.Value) + "#" + item.remark + "#" + (item.meth_pay_id.ToString()) + "#" + txt_address.Value + "#" + item.ListBr[0].Room_number + "#" + item.tele_no + "|"; } } } } if (Request.QueryString["type"].ToString() == "0") { txt_roomid.Value = fhBll.GetModel(Convert.ToInt32(ids)).Rn_roomNum; ddroomtype.SelectedValue = fhBll.GetModel(Convert.ToInt32(ids)).Rn_room.ToString(); txt_money.Value = fhBll.GetModel(Convert.ToInt32(ids)).Rn_price.ToString(); txt_rzdate.Value = System.DateTime.Now.ToString(); txt_roomnumber.Value = ids.ToString(); txt_zfzhanghao.Value = txt_roomid.Value; contents += this.txt_roomid.Value + "#" + (this.ddroomtype.SelectedValue) + "#" + "否" + "#" + (this.txt_rzdate.Value) + "#" + (this.txt_Day.Value) + "#" + (this.txt_ylDate.Value) + "#" + this.txt_name.Value + "#" + this.txt_Sex.Value + "#" + this.txt_Date2.Value + "#" + this.txt_mingzhu.Value + "#" + (this.DDlSFz.SelectedValue) + "#" + (this.txt_CardId.Value) + "#" + this.txt_Remaker.Value + "#" + (DDlZffs.SelectedValue) + "#" + txt_address.Value + "#" + txt_zfzhanghao.Value + "#" + txt_lxphone.Value + "|"; } }
/// <summary> /// 新增与修改 /// </summary> private void AddBook() { try { bool isb = true; System.Text.StringBuilder sbText = new System.Text.StringBuilder(); string book_no = string.Empty; string isUpdate = context.Request.Form["isUpdate"].ToString(); if (isUpdate == "true") { book_no = context.Request.Form["book_no"].ToString(); List <Model.Book_Rdetail> listbr = bllrd.GetListModel("Book_no='" + book_no + "'"); if (listbr.Count > 0) { Model.room_number modelrt = new Model.room_number(); foreach (Model.Book_Rdetail item in listbr) { if (item.Room_number != null) { if (item.Room_number.Trim() != "") { modelrt = bllrn.GetModelList("Rn_roomNum='" + item.Room_number + "'")[0]; modelrt.Rn_Tobe = 0; Helper.AddRoom(item.Room_number); bllrn.Update(modelrt); } } } } bool rels = bllrd.DeletebyWhere("Book_no='" + book_no + "'"); if (rels) { bllbr.DeletebyWhere("Book_no='" + book_no + "'"); } } else { book_no = "Y" + System.DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", ""); } string txtname = context.Request.Form["txtname"].ToString(); string txtPhone = context.Request.Form["txtPhone"].ToString(); string txtDh = context.Request.Form["txtDh"].ToString(); string txtrz = context.Request.Form["txtrz"].ToString(); string txttf = context.Request.Form["txttf"].ToString(); string txtyd = context.Request.Form["txtyd"].ToString(); string txtmCard = context.Request.Form["txtmCard"].ToString(); string guarWayDll = context.Request.Form["guarWayDll"].ToString(); string guestSourceDdl = context.Request.Form["guestSourceDdl"].ToString(); string methPayDdl = context.Request.Form["methPayDdl"].ToString(); string txtdj = context.Request.Form["txtdj"].ToString(); string textRemaker = context.Request.Form["textRemaker"].ToString(); string accounts = context.Request.Form["accounts"].ToString(); string CpId = context.Request.Form["CpId"].ToString(); string strs = context.Request.Form["sjs"].ToString(); int? cid = null; if (CpId != "") { cid = Convert.ToInt32(CpId); } strs = strs.Remove(strs.Length - 1, 1); Model.book_room model = new Model.book_room() { book_no = book_no, book_Name = txtname, tele_no = txtPhone, onli_no = txtDh, guar_way = guarWayDll, mem_cardno = txtmCard, time_to = Convert.ToDateTime(txtrz), time_from = Convert.ToDateTime(txttf), real_time = Convert.ToDateTime(txtyd), source_id = Convert.ToInt32(guestSourceDdl), meth_pay_id = Convert.ToInt32(methPayDdl), deposit = Convert.ToDecimal(txtdj), remark = textRemaker, Userid = UserNow.UserID, Accounts = accounts, CpID = cid }; if (Math.Floor(Convert.ToDouble(txtdj)) == 0) { model.state_id = 6; } else { model.state_id = 1; } int rel = bllbr.Add(model); if (rel > 0) { string[] strlist = strs.Split(new char[1] { '*' }, StringSplitOptions.RemoveEmptyEntries); Dictionary <string, string> dic = new Dictionary <string, string>(); foreach (string str in strlist) { dic.Clear(); string[] strdelt = str.Split(new char[1] { ',' }); foreach (string s in strdelt) { string[] strval = s.Split(new char[1] { ':' }); dic.Add(strval[0], strval[1]); } Model.Book_Rdetail modelbr = new Model.Book_Rdetail() { Book_no = model.book_no, Real_type_Id = Convert.ToInt32(dic["typeid"]), Room_number = dic["roomnumber"], Real_num = Convert.ToInt32(dic["number"]), Ok_num = 0, Real_Price = Convert.ToDecimal(dic["price"]), Real_Scheme_Id = Convert.ToInt32(dic["fangan"]), RoomTypeID = Convert.ToInt32(model.state_id) }; if (!IsBook(modelbr.Room_number)) { isb = false; List <Model.room_number> list = bllrn.GetModelList("Rn_roomNum='" + modelbr.Room_number + "'"); if (list.Count > 0) { Model.room_number modelrn = list[0]; modelrn.Rn_Tobe = 1; bllrn.Update(modelrn); } if (modelbr.Room_number.Trim() != "") { Helper.AddRoom(modelbr.Room_number); } bllrd.Add(modelbr); } else { sbText.Append(modelbr.Room_number + ","); } } } if (isUpdate == "true") { context.Response.Write("更新成功!,' '"); } else { if (isb) { bllbr.Delete(rel); context.Response.Write("房间已被预定!," + book_no + ""); } else { string finalStr = "{book_no:" + book_no + "}"; Model.goods_account modelga = new Model.goods_account() { ga_name = "预定收款", ga_number = model.book_no, ga_price = Convert.ToDecimal(model.deposit), ga_zffs_id = Convert.ToInt32(methPayDdl), ga_date = DateTime.Now, ga_people = UserNow.UserID, ga_Type = 8, ga_occuid = "", ga_remker = "", ga_sum_price = Convert.ToDecimal("0.0000"), ga_sfacount = "是", ga_isjz = 0, ga_roomNumber = "0", ga_num = 0, ga_unit = "" }; bllga.Add(modelga); if (sbText.ToString() != "") { context.Response.Write("新增成功" + sbText.ToString() + "已被预定!," + book_no + ""); } else { context.Response.Write("新增成功!," + book_no + ""); } } } context.Response.End(); } catch (Exception ex) { context.Response.End(); } }
public void Bind() { sbhtml.Clear(); Dictionary <string, string> dicstr = new Dictionary <string, string>(); Dictionary <string, string> dicCz = new Dictionary <string, string>(); /*计算边房对应的图标*/ List <Model.occu_infor> listocc = fmmx.GetModelList("occ_with='否' and state_id=0"); dicstr = Session["dic"] as Dictionary <string, string>; dicCz = Session["iscz"] as Dictionary <string, string>; StrWheres(); DivContent.InnerHtml = ""; string sjsj = ""; string img = ""; string GoodNo = ""; Model.room_number frmfh = new Model.room_number(); Model.floor_manage frmlc = new Model.floor_manage(); DataTable dt = fmlc.GetListYou(); List <Model.room_number> listrn = bllrn.GetModelList(""); if (listrn.Count > 0) { allroom = listrn.Count; } DataSet dts = null; foreach (DataRow dr in dt.Rows) { dts = brBll.GetList(stwhere + " and Rn_floor=" + dr["floor_id"].ToString() + ""); //if (txt_Namesp.Value == "") //{ // dts = brBll.GetList(stwhere + " and Rn_floor=" + dr["floor_id"].ToString() + ""); //} //else if (txt_Namesp.Value == "欠费") //{ // string SQL = "select (SUM(ga_price)-SUM(ga_sum_price)) as c,ga_occuid from dbo.goods_account where ga_occuid in (select order_id from dbo.occu_infor where state_id=0) group by ga_occuid"; // spanqianf.Attributes.Add("class", "bor"); // dtQX = fmgood.GoodsQX(SQL); // foreach (DataRow drqf in dtQX.Tables[0].Rows) // { // if (Convert.ToDouble(drqf["c"]) < 0) // { // if (GoodNo == "") // { // drqfsb.Append("'" + drqf["ga_occuid"].ToString() + "'"); // } // else { drqfsb.Append("," + "'" + drqf["ga_occuid"].ToString() + "'"); } // } // } // if (drqfsb.ToString() == "") //如果没有欠费 // { // dts = brBll.GetList("1!=1"); // } // else//查询出来所有的欠费房间 // { // dts = brBll.GetListed(stwhere + " and Rn_floor=" + dr["floor_id"].ToString() + " and b.order_id in(" + drqfsb.ToString() + ")", " left join occu_infor as b on a.Rn_roomNum=b.room_number left join real_mode as c on b.real_mode_id=c.real_mode_id "); // } //} //else if (txt_Namesp.Value == "催帐") { // dts = brBll.GetListed("", "inner join( select * from occu_infor as oi inner join (select SUM(ga_price)-SUM(ga_sum_price) as sa,ga_occuid as t from goods_account where ga_isys=1 group by ga_occuid) as u on u.t =oi.order_id where u.sa<oi.real_price and datediff(D,[depar_time],'"+DateTime.Now.ToString()+"')=0) as uio on uio.room_number=a.Rn_roomNum and Rn_floor=" + dr["floor_id"].ToString() + ""); //} //else if (txt_Namesp.Value == "将走房") { // dts = brBll.GetList("Rn_floor=" + dr["floor_id"].ToString() + ""); //} //else //{ // dts = brBll.GetListed(stwhere + " and Rn_floor=" + dr["floor_id"].ToString() + "", " left join occu_infor as b on a.Rn_roomNum=b.room_number left join real_mode as c on b.real_mode_id=c.real_mode_id "); //} if (dts.Tables[0].Rows.Count > 0) { sbhtml.Append("<ul class='main'>"); foreach (DataRow drs in dts.Tables[0].Rows) { price = ""; Names = ""; xuzhu = ""; jzfimg = ""; LFimg = ""; totime = ""; numDay = ""; if ((drs["Rn_state"]) == null || drs["Rn_state"].ToString() == "") { drs["Rn_state"] = "0"; } FtNames = fmft.GetModel(Convert.ToInt32(drs["Rn_state"])).room_state_name; GetClass(Convert.ToInt32(drs["Rn_state"])); if (FtNames == "干净房") { sjsj = "ondblclick=\"ShowTabt('在住房信息'," + drs["id"].ToString() + ",0,this)\""; } else { sjsj = ""; } if (txt_Namesp.Value == "催帐") { czico = "<img src='/admin/images/iconcuizhang.png' />"; czCount++; } if (FtNames == "在住房" || FtNames == "脏住房") { try { a = drs["Rn_roomNum"].ToString(); lfcounts = 0; modelocc = fmmx.GetModels(" where occ_with='否' and state_id=0 and room_number='" + a + "'"); Names = modelocc.occ_name; totime = modelocc.occ_time.ToString("g"); real_mode_id = modelocc.real_mode_id; drs["id"] = modelocc.occ_id; switch (real_mode_id) { case 2: price = "<img src='../../images/sicon04.png' class=\"zdf\"/>"; zdfang++; break; case 19: price = "<img src='../../images/sicon01.png' class=\"yuezhu\"/>"; yzf++; break; case 5: price = "<img src='../../images/sicon03.png' class=\"lccio\" />"; lingcfang++; break; case 20: price = "<img src='/admin/images/iconfree.png' class=\"free\"/>"; mfcount++; break; default: break; } //str1 = "u.sa < " + modelocc.real_price + " and"; //if (modelfs.showday) //{ // str1 = "u.sa < " + Convert.ToInt32(modelfs.daynum) * modelocc.real_price + " and"; //} //else //{ // str1 = ""; //} //if (modelfs.showyue) //{ // str1 += " u.sa<" + modelfs.moneyNum + " and"; //} //dstable = brBll.GetProc(str1, Convert.ToInt32(dr["floor_id"]), a, DateTime.Now.ToString()); //dstable = brBll.GetListed("", "inner join( select * from occu_infor as oi inner join (select SUM(ga_price)-SUM(ga_sum_price) as sa,ga_occuid as t from goods_account where ga_isys=1 group by ga_occuid) as u on u.t =oi.order_id where " + str1 + " datediff(D,[depar_time],'" + DateTime.Now.ToString() + "')=0) as uio on uio.room_number=a.Rn_roomNum and Rn_floor=" + dr["floor_id"].ToString() + " and room_number='" + a + "'"); //if (dstable.Tables[0].Rows.Count > 0) //{ // if (modelfs.showyjb) // { // czico = "<img src='/admin/images/iconcuizhang.png'/>"; // } // czCount++; //} if (dicCz.ContainsKey(a.ToString())) { if (dicCz[a.ToString()].ToString() == "1") { if (modelfs.showyjb) { czico = "<img src='/admin/images/iconcuizhang.png'/>"; } czCount++; bs = true; } } date1 = Convert.ToDateTime(fmmx.GetModels(" where occ_with='否' and state_id=0 and real_mode_Id!=2 and real_mode_Id!=19 and room_number='" + a.ToString() + "'").depar_time.ToString()); date2 = System.DateTime.Now; cc = date1.Day - date2.Day; if (cc < 0) { cc = (Convert.ToDateTime(date1.ToString("yyyy-MM-dd")) - Convert.ToDateTime(date2.ToString("yyyy-MM-dd"))).Days; } if (modelfs.yuliDay) {//只是当日预离 if (cc == 0) { if (modelfs.showYuli) { //jzfimg = "<img src=\"/admin/images/iconjiangzou.png\">"; } jzhouf++; } } else if (modelfs.showDayTime) { //多少天内预离显示 if (Convert.ToInt32(cc) <= Convert.ToInt32(modelfs.dayNumYl)) { if (Convert.ToInt32(cc) == 0 || cc < 0) { numDay = "<span class=\"numday\"> </span>"; } else { numDay = "<span class=\"numday\">" + cc + "</span>"; } if (modelfs.showYuli) { //jzfimg = "<img src=\"/admin/images/iconjiangzou.png\">"; } jzhouf++; } } countxuzhu = fmmx.GetRecordCount(" where continuelive=" + modelocc.occ_id + ""); if (countxuzhu > 0) { xuzhu = "<img src=\"/admin/images/iconxz.png\">"; xuzhufang++; } countLF = fmmx.GetRecordCount(" where order_id='" + modelocc.order_id + "'"); if (listocc.Count > 1) { LFimg = dicstr[a.ToString()]; LFcount++; } //SQLlf = "select order_id from occu_infor where order_id in (select order_id from occu_infor group by order_id having count(order_id) > 1) group by order_id"; //DtLF = fmgood.GoodsQX(SQLlf); //LFcount = DtLF.Tables[0].Rows.Count; } catch { } } b = drs["Rn_roomNum"].ToString(); if (drs["Room_suod"].ToString().Trim() == "是")//是否为锁房间 { img = "<img src='/admin/images/iconsuofang.png' class=\"suofang\">"; sjsj = ""; suofang++; } else { img = ""; } yudao = string.Empty; string yustr = string.Empty; string yudaoDay = string.Empty; if (drs["Rn_Tobe"] != null)//是否为预定房间 { if (Convert.ToInt32(drs["Rn_Tobe"]) == 1) { yudao = GetYuDao(b); yustr = "yuding"; DateTime datestr = Convert.ToDateTime(yudao); DateTime dataend = Convert.ToDateTime(DateTime.Now); int days = datestr.Day - dataend.Day; if (days < 0) { TimeSpan tss = (Convert.ToDateTime(datestr.ToString("yyyy-MM-dd")) - Convert.ToDateTime(dataend.ToString("yyyy-MM-dd"))); days = tss.Days; } if (days <= 0) { yudaoDay = "<div class=\"yuding hrj\"> </div>"; yudao = Convert.ToDateTime(yudao).ToString("hh:mm"); } else { yudao = ""; yudaoDay = "<div class=\"yuding hrj\">" + days + "</div>"; } } } sbhtml.Append("<li class=\"hidli\" rooms=" + b + "><ul><li rooms=" + b + " id=" + Convert.ToInt32(drs["id"].ToString()) + " state=" + Convert.ToInt32(drs["Rn_state"]) + " " + sjsj + " class='" + yustr + " " + Style + "'><a href='#'><span class='span01'>" + b + "</span>" + numDay + "<span style='color:yellow'>" + ZC(drs["Rn_roomNum"].ToString()) + "</span><br /><span class=\"fxhrj\">" + fxdic[Convert.ToInt32(drs["Rn_room"])] + "</span> <p>" + img + "<span class=\"icospan\">" + price + "</span><span class=\"lfico\">" + LFimg + "</span><span class=\"qianfei\"></span> <span class=\"xuzhu\">" + xuzhu + "</span><span class=\"czimg\">" + czico + "</span><span class=\"jzfimg\">" + jzfimg + "</span><span class='totime'>" + totime + "</span></p><br /><span class='zuofu'>" + Names + "</span><span class='youfu'>" + Convert.ToDecimal(drs["Rn_price"].ToString()).ToString("0.##") + "</span><span class=\"yue1\"></span><span class=\"stime\"></span><span class=\"shengyu\"></span></a><span class=\"yudao\">" + yudao + "</span></span>" + yudaoDay + "</li></ul></li>"); czico = ""; bs = false; } sbhtml.Append("</ul>"); } } DivContent.InnerHtml = sbhtml.ToString(); }