/// <summary> /// 获得实际费用 /// </summary> /// <param name="statuid"></param> /// <returns></returns> public string GetRoomStatu(Model.occu_infor model) { double price = Convert.ToDouble(model.real_price); double zk = Convert.ToDouble(model.Hourse_scheme_model.hs_Discount) * Convert.ToDouble(0.1); return((price * zk).ToString()); }
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> private void GetInfoBySuo() { string SuoMa = context.Request.QueryString["SuoMa"]; BLL.SysParameter bllsys = new BLL.SysParameter(); Model.SysParamter modelsyts = bllsys.GetModel(1); string suo = modelsyts.MarkSuo; BLL.SuoRoom bllss = new BLL.SuoRoom(); List <Model.SuoRoom> listss = bllss.GetModelList("SuoType='" + suo + "' and SuoMa='" + SuoMa + "'"); string roomNumber = ""; string res = string.Empty; if (listss.Count > 0) { Model.SuoRoom modelss = listss[0]; roomNumber = modelss.RoomNumber; BLL.occu_infor blloc = new BLL.occu_infor(); List <Model.occu_infor> listocc = blloc.GetModelList("state_id=0 and room_number='" + roomNumber + "'"); if (listocc.Count > 0) { Model.occu_infor modelocc = listocc[0]; var obj = new { state = "0", occ_name = modelocc.occ_name.ToString(), occ_time = modelocc.occ_time.ToString(), depar_time = modelocc.depar_time.ToString(), fxxs = RealModel(modelocc.real_mode_id) }; res = js.Serialize(obj); } else { var obj = new { state = "1" }; } } context.Response.Write(res); }
/// <summary> /// 获得实际费用 /// </summary> /// <param name="statuid"></param> /// <returns></returns> public string GetRoomStatu(Model.occu_infor model) { //double price = Convert.ToDouble(model.real_price); //double zk = Convert.ToDouble(model.Hourse_scheme_model.hs_Discount) * Convert.ToDouble(0.1); //return (price * zk).ToString(); string txt = GetRealName(model.real_mode_id); if (txt == "天房" || txt == "自用房" || txt == "免费房") { return(bllty.GetModel(model.real_type_id).room_listedmoney.ToString()); } if (txt == "钟点房") { return(bllhr.GetModel(Convert.ToInt32(model.sort)).hs_start_price.ToString()); } if (txt == "凌晨房") { return(bllty.GetModel(model.real_type_id).Room_ealry_price.ToString()); } if (txt == "月租房") { return(bllty.GetModel(model.real_type_id).Room_Moth_price.ToString()); } return(""); }
public void BindInfo() { Model.occu_infor mod = new Model.occu_infor(); txt_roomNum.Value = fmOc.GetModel(ids).room_number; txtrzDate.InnerText = (fmOc.GetModel(ids).occ_time).ToString(); txt_name.InnerText = (fmOc.GetModel(ids).occ_name).ToString(); // txt_rzdate.Value = System.DateTime.Now.ToString(); }
public void Bind() { Model.occu_infor mod = new Model.occu_infor(); labfh.Text = fmrzInfo.GetModel(ids).room_number; labfx.Text = (fmrzInfo.GetModel(ids).real_type_id).ToString(); labkffs.Text = (fmrzInfo.GetModel(ids).meth_pay_id).ToString(); lably.Text = fmrzInfo.GetModel(ids).real_scheme_id.ToString(); labname.Text = fmrzInfo.GetModel(ids).occ_name.ToString(); labrzDate.Text = fmrzInfo.GetModel(ids).occ_time.ToString(); labfjMoney.Text = fmrzInfo.GetModel(ids).real_scheme_id.ToString(); labSymoney.Text = fmrzInfo.GetModel(ids).real_price.ToString(); }
public void Bind() { Model.occu_infor mod = new Model.occu_infor(); labfh.Text = fmrzInfo.GetModel(ids).room_number; labfx.Text = GetRealTypeName(fmrzInfo.GetModel(ids).real_type_id); labkffs.Text = GetKffsName(fmrzInfo.GetModel(ids).real_mode_id); lably.Text = GetLYName(fmrzInfo.GetModel(ids).source_id); labname.Text = fmrzInfo.GetModel(ids).occ_name.ToString(); labrzDate.Text = fmrzInfo.GetModel(ids).occ_time.ToString(); labfjMoney.Text = fmrzInfo.GetModel(ids).real_scheme_id.ToString(); labSymoney.Text = fmrzInfo.GetModel(ids).real_price.ToString(); }
public void Bind() { Model.occu_infor mod = new Model.occu_infor(); labfh.Text = fmrzInfo.GetModel(ids).room_number; labfx.Text = GetRealTypeName(fmrzInfo.GetModel(ids).real_type_id); labkffs.Text = GetKffsName(fmrzInfo.GetModel(ids).real_mode_id); lably.Text = GetLYName(fmrzInfo.GetModel(ids).source_id); labname.Text = fmrzInfo.GetModel(ids).occ_name.ToString(); labrzDate.Text = fmrzInfo.GetModel(ids).occ_time.ToString(); labfjMoney.Text = fmrzInfo.GetModel(ids).real_scheme_id.ToString(); labSymoney.Text = fmrzInfo.GetModel(ids).deposit.ToString(); txt_ydDate.Value = fmrzInfo.GetModel(ids).depar_time.ToString(); txt_xdDate.Value = Convert.ToDateTime(fmrzInfo.GetModel(ids).depar_time).AddDays(Convert.ToInt32(txt_liveDay.Value)).ToString(); }
public override void SonLoad() { if (Request["hfID"] != null) { hfID = Convert.ToInt32(Request["hfID"]); } modelafter = blloi.GetModel(hfID); List <Model.occu_infor> list = blloi.GetModelList("continuelive=" + hfID + " and occ_with='否' and state_id=0"); if (list != null) { modelh = list[0]; } }
/// <summary> /// 绑定入住人的信息 /// </summary> private void BindOcc() { List <Model.occu_infor> list = blloc.GetModelList("order_id='" + roomnum + "'"); if (list.Count > 0) { modelocc = list[0]; //string s1 = modelocc.depar_time; DateTime dtone = Convert.ToDateTime(Convert.ToDateTime(modelocc.depar_time).ToString("yyyy-MM-dd")); DateTime dtwo = Convert.ToDateTime(Convert.ToDateTime(modelocc.occ_time).ToString("yyyy-MM-dd")); TimeSpan span = dtone.Subtract(dtwo); //TimeSpan ts = Convert.ToDateTime(modelocc.depar_time) - Convert.ToDateTime(modeloi.occ_time); shijian = span.Days.ToString(); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAdds_Click(object sender, EventArgs e) { try { CdHotelManage.Model.goods_account model = new CdHotelManage.Model.goods_account(); CdHotelManage.BLL.goods_account bll = new CdHotelManage.BLL.goods_account(); Model.occu_infor Ocmodels = new Model.occu_infor(); Ocmodels.state_id = 1; Ocmodels.continuelive = ids; Ocmodels.brithday = Convert.ToDateTime(fmrzInfo.GetModel(ids).brithday).ToString(); Ocmodels.occ_time = System.DateTime.Now; Ocmodels.depar_time = Convert.ToDateTime(txt_ydDate.Value); Ocmodels.pha_sched = Convert.ToDateTime(txt_xdDate.Value); Ocmodels.deposit = Convert.ToDecimal(txt_yjMoney.Value); Ocmodels.stay_day = Convert.ToInt32(txt_liveDay.Value); Ocmodels.meth_pay_id = Convert.ToInt32(DDlZffs.SelectedValue); model.ga_number = ids.ToString(); model.ga_Type = 3; model.ga_name = "续住收款"; model.ga_number = ids.ToString(); model.ga_price = Convert.ToDecimal(txt_yjMoney.Value); model.ga_sum_price = 0; model.ga_date = Convert.ToDateTime(System.DateTime.Now); model.ga_occuid = fmrzInfo.GetModel(ids).order_id; model.ga_people = UserNow.UserID; model.ga_sfacount = "否"; model.ga_remker = txt_Remaker.Value; model.Ga_goodNo = fmrzInfo.GetModel(ids).occ_no; model.ga_zffs_id = Convert.ToInt32(DDlZffs.SelectedValue); model.ga_roomNumber = fmrzInfo.GetModel(ids).room_number; int Result = bll.Add(model); int day = Convert.ToInt32(fmrzInfo.GetModel(ids).stay_day) + Convert.ToInt32(txt_liveDay.Value); string sql = "update occu_infor set stay_day='" + day + "',depar_time='" + txt_xdDate.Value + "' where occ_id=" + fmrzInfo.GetModel(ids).occ_id + " "; fmrzInfo.Updates(sql); if (Result > 0 && fmrzInfo.Add(Ocmodels) > 0) { Helper.AddRoom(model.ga_roomNumber); // Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", ""); ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript'>if(confirm('续住成功,是否打印收款单?')){XZintRZ(this," + fmrzInfo.GetModel(ids).order_id + ") }else{Close('房态图'); }; parent.Window_Close();</script>"); } else { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "续住失败!", ""); } } catch { } }
/// <summary> /// 获得一个房间的商品费用 /// </summary> /// <param name="statuid"></param> /// <returns></returns> public string GetGoodsFh(Model.occu_infor model) { DataTable dt = bllga.GetGoodsFh(model.room_number, "and CONVERT(varchar(100), ga.ga_date,23)='" + day + "'"); if (dt != null) { string s = dt.Rows[0][0].ToString(); if (s != "") { return(dt.Rows[0][0].ToString()); } else { return("0"); } } return("0"); }
/// <summary> /// 获得一个房间的房费用 /// </summary> /// <param name="statuid"></param> /// <returns></returns> public string GetGoodsFF(Model.occu_infor model) { DataTable dt = bllga.GetGoodsFh1(model.room_number, "and DATEDIFF(second ,'" + day + "',ga_date)>0 and DATEDIFF(second ,'" + day + "',ga_date)<86400"); if (dt != null) { string s = dt.Rows[0][0].ToString(); if (s != "") { return(Convert.ToDouble(dt.Rows[0][0]).ToString("0.##")); } else { return("0"); } } return("0"); }
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> private void Bind() { try { Model.FtSet modelfs = bllfs.GetModel(1); DataSet dts = brbll.GetList("Rn_state in(2,7)"); foreach (DataRow drs in dts.Tables[0].Rows) { string a = drs["Rn_roomNum"].ToString(); Model.occu_infor modelocc = fmmx.GetModels(" where occ_with='否' and state_id=0 and room_number='" + a + "'"); if (modelocc != null) { str1 = "state_id=0 and u.sa < " + modelocc.real_price + " and"; if (modelfs.showday) { str1 = "state_id=0 and 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, 5, 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 (!dicCz.ContainsKey(a)) { dicCz.Add(a, "1"); } } } } Session["iscz"] = dicCz; } catch (Exception ex) { throw; } }
protected void BtnOk_Click(object a, EventArgs e) { for (int i = 0; i < this.rep.Items.Count; i++) { CheckBox check = (CheckBox)this.rep.Items[i].FindControl("cbk"); if (check != null) { if (check.Checked) { HiddenField hidNewsId = this.rep.Items[i].FindControl("hidId") as HiddenField; Model.occu_infor model = blloc.GetModel(Convert.ToInt32(hidNewsId.Value)); List <Model.occu_infor> listiccs = blloc.GetModelList(" order_id='" + model.order_id + "'"); if (listiccs.Count > 0) { foreach (Model.occu_infor item in listiccs) { item.order_id = orderid.Value; item.lordRoomid = loadRoom.Value; blloc.Update(item); } } List <Model.goods_account> listga = bllga.GetModelList1(" ga_occuid=" + model.order_id + ""); foreach (Model.goods_account modelga in listga) { modelga.ga_occuid = orderid.Value; bllga.Update(modelga); } model.lordRoomid = loadRoom.Value; model.order_id = orderid.Value; blloc.Update(model); } } } List <Model.occu_infor> listicc = blloc.GetModelList("order_id='" + orderid.Value + "'"); foreach (Model.occu_infor item in listicc) { sbroom.Append(item.room_number + ","); } Helper.AddRoom(loadRoom.Value, sbroom.ToString() + loadRoom.Value + ","); Response.Write("<script>alert('合并成功!');parent.Window_Close();</script>"); }
private void Chafeng() { try { System.Text.StringBuilder sbtext = new System.Text.StringBuilder(); string occno = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Replace("-", "").Replace(":", "").Replace(" ", "").Replace("/", ""); int id = Convert.ToInt32(context.Request.QueryString["id"]); Model.occu_infor modelocc = blloc.GetModel(id); if (modelocc.room_number == modelocc.lordRoomid) { context.Response.Write("err"); context.Response.End(); } else { List <Model.occu_infor> listicc = blloc.GetModelList("order_id='" + modelocc.order_id + "'"); foreach (Model.occu_infor item in listicc) { sbtext.Append(item.room_number + ","); } List <Model.goods_account> listga = bllga.GetModelList1("ga_occuid='" + modelocc.order_id + "' and ga_roomNumber='" + modelocc.room_number + "'"); if (listga.Count > 0) { foreach (Model.goods_account item in listga) { item.ga_occuid = occno; bllga.Update(item); } } Helper.AddRoom(modelocc.room_number, sbtext.ToString()); modelocc.order_id = occno; modelocc.GzRoom = ""; modelocc.lordRoomid = modelocc.room_number; blloc.Update(modelocc); context.Response.Write("ok"); context.Response.End(); } } catch (Exception ex) { throw; } }
public void Bind() { Model.occu_infor mod = new Model.occu_infor(); labfh.Text = fmrzInfo.GetModel(ids).room_number; labfx.Text = GetRealTypeName((fmrzInfo.GetModel(ids).real_type_id)); labkffs.Text = GetKffsName(fmrzInfo.GetModel(ids).real_mode_id); lably.Text = GetLYName(fmrzInfo.GetModel(ids).source_id); labname.Text = fmrzInfo.GetModel(ids).occ_name.ToString(); labrzDate.Text = fmrzInfo.GetModel(ids).occ_time.ToString(); labfjMoney.Text = fmrzInfo.GetModel(ids).real_price.ToString(); labSymoney.Text = fmrzInfo.GetModel(ids).amount_money.ToString(); double ysMoney = 0; DataSet dt = fmgoodvount.GetList(" ga_occuid in ('" + fmrzInfo.GetModel(ids).order_id + "')"); foreach (DataRow dr in dt.Tables[0].Rows) { try { ysMoney += double.Parse(dr["ga_sum_price"].ToString()); } catch { } } labSymoney.Text = ysMoney.ToString(); }
/// <summary> /// 协议入住费用转 /// </summary> private void XieYi() { if (accounts.Value != "") //如果是协议单位入住,更新入住天数 并要把设置计算佣金 { Model.occu_infor modelocc = fmOc.GetModel(ids); TimeSpan ts = Convert.ToDateTime(modelocc.depar_time) - Convert.ToDateTime(modelocc.occ_time); int mydays = ts.Days; if (mydays <= 0) { mydays = 1; } Model.customer modelcus = bllcus.GetAccounts(accounts.Value); modelcus.occNum += mydays; bllcus.Update(modelcus); /*计算佣金*/ string accou = account.Value; if (modelocc.CpID != null) { Model.cprotocol modelcp = bllcp.GetModel(Convert.ToInt32(modelocc.CpID)); if (modelcp != null) { bool dayhire = modelcp.Dayhire; //是否每日计佣 int Commission = Convert.ToInt32(modelcp.Commission); //佣金 bool ishire = modelcp.ishire; //是否按房类计佣 int day = ts.Days; int sum = 0; //总佣金 if (ishire) //如果 是按房类记算佣金 { BLL.cprotocolPrice bllcpp = new BLL.cprotocolPrice(); List <Model.cprotocolPrice> listcpp = bllcpp.GetModelList("cpID=" + modelcp.ID + " and RoomType=" + modelocc.real_type_id); if (listcpp.Count > 0) { Commission = Convert.ToInt32(listcpp[0].commission); } } if (dayhire) { sum = Commission * day; } else { sum = Commission; } BLL.Commission bllcomm = new BLL.Commission(); Model.Commission modelcomm = new Model.Commission(); modelcomm.Accounts = accounts.Value; modelcomm.CommDesp = ""; modelcomm.CommDate = DateTime.Now; modelcomm.CommSum = sum; modelcomm.IsBack = false; modelcomm.GoodNumber = modelocc.occ_no; modelcomm.IsEveryDay = modelcp.Dayhire; modelcomm.DayComm = modelcp.Commission; modelcomm.CommRemark = ""; bllcomm.Add(modelcomm); } } } if (idids.Value != "") //如果是协议单位 { List <Model.goods_account> listga = bllga.GetModelList1("ID in (" + idids.Value + ")"); if (listga.Count > 0) { foreach (Model.goods_account item in listga) { item.Ga_Account = account.Value; item.ga_Type = 204; bllga.Update(item); } } } }
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(); }
protected string GetMenu(int state, int id, string Roomid) { string FtName = ""; if (state != 0) { FtName = fmft.GetModel(state).room_state_name; } string html = ""; try { if (id.ToString() != "") { switch (FtName) { case "在住房": string cf = string.Empty; Model.occu_infor modelocc = blloc.GetModel(id); List <Model.occu_infor> listicc = blloc.GetModelList("order_id='" + modelocc.order_id + "'"); if (listicc.Count > 1) { cf = GetHtmlDiv("拆分", "onclick=\"ChaFeng(" + id + ")\""); } else { cf = ""; } html += GetHtmlDiv("结账", "onclick=\"ShowTabs('结账'," + id + ")\"") + GetHtmlDiv("加开房间", "onclick=\"ShowAddRoom('加开房间'," + id + ")\"") + GetHtmlDiv("合并房间", "onclick=\"AddRoom('合并房间'," + id + ")\"") + cf + GetHtmlDiv("商品入账", "onclick=\"GoodsAdds(this," + id + ")\"") + GetHtmlDiv("费用入账", "onclick=\"CostAdds(this," + id + ")\"") + GetHtmlDiv("续住", "onclick=\"ShowTabs1('续住'," + id + ")\"") + GetHtmlDiv("换房", "onclick=\"replaceAdds(this," + id + ")\"") + GetHtmlDiv("修改在住房信息", "onclick=\"ShowTab('修改在住房信息'," + id + ",1)\"") + GetHtmlDiv("撤销在住房", "onclick=\"CheXiao(" + id + ")\"") + GetHtmlDiv("修改房态", "", true); break; case "脏住房": string cf1 = string.Empty; Model.occu_infor modelocc1 = blloc.GetModel(id); List <Model.occu_infor> listicc1 = blloc.GetModelList("order_id='" + modelocc1.order_id + "'"); if (listicc1.Count > 1) { cf1 = GetHtmlDiv("拆分", "onclick=\"ChaFeng(" + id + ")\""); } else { cf1 = ""; } html += GetHtmlDiv("结账", "onclick=\"ShowTabs('结账'," + id + ")\"") + GetHtmlDiv("加开房间", "onclick=\"ShowAddRoom('加开房间'," + id + ")\"") + GetHtmlDiv("合并房间", "onclick=\"AddRoom('合并房间'," + id + ")\"") + cf1 + GetHtmlDiv("商品入账", "onclick=\"GoodsAdds(this," + id + ")\"") + GetHtmlDiv("费用入账", "onclick=\"CostAdds(this," + id + ")\"") + GetHtmlDiv("续住", "onclick=\"ShowTabs1('续住'," + id + ")\"") + GetHtmlDiv("换房", "onclick=\"replaceAdds(this," + id + ")\"") + GetHtmlDiv("修改在住房信息", "onclick=\"ShowTab('修改在住房信息'," + id + ",1)\"") + GetHtmlDiv("撤销在住房", "onclick=\"CheXiao(" + id + ")\"") + GetHtmlDiv("修改房态", "", true); break; case "干净房": if (fhBll.GetModelList(" Rn_roomNum='" + Roomid + "'")[0].Room_suod.ToString().Trim() == "是") { html += GetHtmlDiv("修改房态", "", true); } else { html += GetHtmlDiv("开房", "onclick=\"ShowTab('在住房信息'," + id + ",0)\"") + GetHtmlDiv("修改房态", "", true); } break; case "将到房": html += GetHtmlDiv("开房", "onclick=\"ShowTab('在住房信息'," + id + ",0)\"") + GetHtmlDiv("修改房态", "", true); break; case "脏房": if (fhBll.GetModelList(" Rn_roomNum='" + Roomid + "'")[0].Room_suod.ToString().Trim() == "是") { html += GetHtmlDiv("修改房态", "", true); } else { html += GetHtmlDiv("开房", "onclick=\"ShowTab('在住房信息'," + id + ",0)\"") + GetHtmlDiv("修改房态", "", true); } break; case "维修房": html += GetHtmlDiv("查看维修房", "onclick=\"ShowweixiuTabs('查看维修房'," + id + ",2);\"") + GetHtmlDiv("结束维修房", "onclick=\"cds(2," + id + ")\""); break; case "自用房": html += GetHtmlDiv("查看自用房", "onclick=\"ShowweixiuTabs('查看自用房'," + id + ",3)\"") + GetHtmlDiv("结束自用房", "onclick=\"cds(2," + id + ");\""); break; default: html += GetHtmlDiv("修改房态", "", true); break; } } } catch { } return(html); }
/// <summary> /// 获得实际费用 /// </summary> /// <param name="statuid"></param> /// <returns></returns> public string GetRoomStatu(Model.occu_infor model) { return(Convert.ToDecimal(bllrn.GetModelList("Rn_roomNum='" + model.room_number + "'")[0].Rn_price).ToString("0.##")); }
/// <summary> /// 通过ID日查询出来开的所有房间 /// </summary> /// <param name="orrderID"></param> private void Bind(string orrderID) { List <Model.occu_infor> lisiico = blloi.GetDaySheetByOrderID(" order_id='" + orrderID + "'"); if (lisiico != null) { nowmodel = lisiico[0]; if (nowmodel.meth_pay_id == null) { nowmodel.Meth_pay_model = new Model.meth_pay(); nowmodel.Meth_pay_model.meth_pay_name = "信用卡预授权"; } foreach (Model.occu_infor model in lisiico) { sbtext.Append("<tr><td>" + model.room_number + "</td><td>" + model.Real_mode_mode.real_mode_name + "</td><td>" + GetRoomStatu(model) + "</td><td>" + model.real_price + "</td></tr>"); } } if (Request.QueryString["desp"] != null) { if (Convert.ToInt32(Request.QueryString["desp"]) < 0) { fangshi = "退款"; } nowmodel.deposit = Convert.ToDecimal(Request.QueryString["desp"]); } Model.SysParamter modelsys = bllsys.GetModel(1); if (nowmodel.real_mode_id == 2) //如果是钟点房 { } else if (nowmodel.real_mode_id != 5)//如果是天房 { if (modelsys.DayFee == 1) { strstrs = "住宿时间超过次日" + modelsys.DayTime + "-" + modelsys.DayFeeTwo + "时按分钟收费,超过" + modelsys.DayFeeTwo + "时按一天结账。"; } else { strstrs = "住宿时间超过次日" + modelsys.DayTime + "-" + modelsys.DayFeeTwo + "时加收半费,超过" + modelsys.DayFeeTwo + "时按一天结账。"; } } else if (nowmodel.real_mode_id == 5)//如果是凌晨房 { string fee = string.Empty; string fangan = string.Empty; string sel = string.Empty; string EarlyOutTime = modelsys.EarlyOutTime.ToString();//凌晨房计费开始时间 if (modelsys.EarlyFee == 1) { fee = "加收半天房费"; } else if (modelsys.EarlyFee == 2) { fee = "按分钟收费"; } else if (modelsys.EarlyFee == 3) { fee = "不加收房费"; } if (modelsys.EarlyFeeSel == 1) { sel = "次日"; } else if (modelsys.EarlyFeeSel == 2) { sel = "当日"; } string EarlyOutTimes = modelsys.EarlyOutTimes.ToString();//凌晨房结束时间 if (modelsys.EarlyFeeTwo == 0) { fangan = "加收全天房价"; } else if (modelsys.EarlyFeeTwo == 1) { fangan = "转为全天房价"; } strstrs = "住宿时间超过" + sel + "" + EarlyOutTime + "-" + EarlyOutTimes + "时" + fee + ",超过" + EarlyOutTimes + "时" + fangan + "。"; } }
/// <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, "保存失败!", ""); } }