/// <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; } }
private void Bind() { Model.FtSet modelfs = bllfs.GetModel(1); Lwidth.Value = modelfs.Lwidth.ToString(); Lhieght.Value = modelfs.Lhieght.ToString(); Lfontf.Value = modelfs.Lfontf; Fontsize.Value = modelfs.Fontsize.ToString(); Lmargin.Value = modelfs.Lmargin.ToString(); Backcolor.Value = modelfs.Backcolor; Bordercolor.Value = modelfs.Bordercolor; showType.Checked = modelfs.showType; showPrice.Checked = modelfs.showPrice; orderLC.Checked = modelfs.orderLC; ftNum.Value = modelfs.ftNum.ToString(); zzShowType.Checked = modelfs.zzShowType; zzShowPrice.Checked = modelfs.zzShowPrice; showFormTime.Checked = modelfs.showFormTime; showLFico.Checked = modelfs.showLFico; showBmico.Checked = modelfs.showBmico; showyjb.Checked = modelfs.showyjb; showday.Checked = modelfs.showday; daynum.Value = modelfs.daynum.ToString(); showyue.Checked = modelfs.showyue; moneyNum.Value = modelfs.moneyNum.ToString(); showcf.Checked = modelfs.showcf; showThem.Checked = modelfs.showThem; Themtext.Value = modelfs.Themtext; showMember.Checked = modelfs.showMember; modelfs.memberText = memberText.Value; showXy.Checked = modelfs.showXy; showYuli.Checked = modelfs.showYuli; yuliDay.Checked = modelfs.yuliDay; showDayTime.Checked = modelfs.showDayTime; dayNumYl.Value = modelfs.dayNumYl.ToString(); Showxz.Checked = modelfs.showxz; showSf.Checked = modelfs.showSf; showYuee.Checked = modelfs.showYuee; Showzdftime.Checked = modelfs.Showzdftime; Showbooktime.Checked = modelfs.Showbooktime; Showzf.Checked = modelfs.Showzf; Showlc.Checked = modelfs.Showlc; showPeoNum.Checked = modelfs.showPeoNum; showRk.Checked = modelfs.showRk; showWupi.Checked = modelfs.showWupi; Showyz.Checked = modelfs.Showyz; Showmf.Checked = modelfs.Showmf; Showzdf.Checked = modelfs.Showzdf; numSize.Value = modelfs.numSize.ToString(); numColor.Value = modelfs.numColor.ToString(); fxSize.Value = modelfs.fxSize.ToString(); fxColor.Value = modelfs.fxColor.ToString(); yueSize.Value = modelfs.yueSize.ToString(); yueColor.Value = modelfs.yueColor.ToString(); nameSize.Value = modelfs.nameSize.ToString(); nameColor.Value = modelfs.nameColor.ToString(); priceSize.Value = modelfs.priceSize.ToString(); priceColor.Value = modelfs.priceColor.ToString(); TotimeSize.Value = modelfs.TotimeSize.ToString(); TotimeColor.Value = modelfs.TotimeColor.ToString(); zdSize.Value = modelfs.zdSize.ToString(); zdColor.Value = modelfs.zdColor.ToString(); icoColor.Value = modelfs.icoColor.ToString(); }
private void Appe(Model.FtSet modelfs) { List <Model.room_state> list = bllrs.GetModelList("room_state_name!='取消'"); File.WriteAllText(Server.MapPath("~/style/toom.css"), ""); sbtext.Append(".main li{ width:" + modelfs.Lwidth + "px; height:" + modelfs.Lhieght + "px; margin:" + modelfs.Lmargin / 2 + "px; }"); sbtext.Append(".ycan{background:#" + modelfs.Backcolor + ";font-family:" + modelfs.Lfontf + ";font-size:" + modelfs.Fontsize + ";}"); sbtext.Append("body .hidli li:hover{border-color: #" + modelfs.Bordercolor + " !important;box-shadow:1px 1px 1px rgba(0, 0, 0, 0.075) inset, 0px 0px 8px #" + modelfs.Bordercolor + ");}"); /*添加房间颜色的*/ foreach (Model.room_state item in list) { sbtext.Append("." + item.Room_suod + "{background:#" + item.Room_color.Trim() + ";}");//将到房 } /*空房显示房间类型*/ if (!modelfs.showType) { sbtext.Append(".bgblue .fxhrj{display:none;}"); } else { sbtext.Append(".bgblue .fxhrj{display:;margin:0;}"); } /*空房显示价格*/ if (!modelfs.showPrice) { sbtext.Append(".bgblue .youfu{display:none;}"); } else { sbtext.Append(".bgblue .youfu{display:;margin:0;}"); } /*住客房显示房间类型*/ if (!modelfs.zzShowType) { sbtext.Append(".bgorange .fxhrj{display:none;}"); } else { sbtext.Append(".bgorange .fxhrj{display:;}"); } /*在住房间显示价格*/ if (!modelfs.zzShowType) { sbtext.Append(".bgorange .youfu{display:none;}"); } else { sbtext.Append(".bgorange .youfu{display:;margin:0;}"); } /*房号的大小和颜色*/ sbtext.Append(".span01{ font-size:" + modelfs.numSize + "px;color:#" + modelfs.numColor + "}"); /*房行的大小和颜色*/ sbtext.Append(".fxhrj{ font-size:" + modelfs.fxSize + "px;color:#" + modelfs.fxColor + "}"); /*姓名的大小和颜色*/ sbtext.Append(".zuofu{ font-size:" + modelfs.nameSize + "px;color:#" + modelfs.nameColor + "}"); /*价格的大小和颜色*/ sbtext.Append(".youfu{ font-size:" + modelfs.priceSize + "px;color:#" + modelfs.priceColor + "}"); /*余额的大小和颜色*/ sbtext.Append(".dayu{ font-size:" + modelfs.yueSize + "px;color:#" + modelfs.yueColor + "}"); /*图标的大小和颜色*/ sbtext.Append("body .hidli li img{width:" + modelfs.icoColor + "px;}"); /*来店时间的大小和颜色*/ if (!modelfs.showFormTime) { sbtext.Append(".totime{ display:none;}"); } else { sbtext.Append(".totime{ display:block; font-size:" + modelfs.TotimeSize + "px;color:#" + modelfs.TotimeColor + ";}"); } /*是否显示联防图标*/ if (!modelfs.showLFico) { sbtext.Append(".lfico{display:none;}"); } else { sbtext.Append(".lfico{display:inline-block;}"); } /*是否显示欠费图标*/ if (!modelfs.showcf) { sbtext.Append(".qianfei{display:none;}"); } else { sbtext.Append(".qianfei{display:inline-block;}"); } /*是否显示续住图标*/ if (!modelfs.showxz) { sbtext.Append(".xuzhu{display:none;}"); } else { sbtext.Append(".xuzhu{display:inline-block;}"); } /*是否显示锁房图标*/ if (!modelfs.showSf) { sbtext.Append(".suofang{display:none;}"); } else { sbtext.Append(".suofang{display:inline-block;}"); } /*是否显示余额*/ if (!modelfs.showYuee) { sbtext.Append(".yue1{display:none;}"); } else { sbtext.Append(".yue1{display:inline-block;}"); } /*是否显示钟点房时间*/ if (!modelfs.Showzdftime) { sbtext.Append(".stime{display:none;}"); } else { sbtext.Append(".stime{display:inline-block;}"); } /*是否显示预到时间*/ if (!modelfs.Showbooktime) { sbtext.Append(".yudao{display:none;}"); } else { sbtext.Append(".yudao{display:inline-block;}"); } /*lccio*/ if (!modelfs.showLFico) { sbtext.Append(".lccio{display:none;}"); } else { sbtext.Append(".lccio{display:inline-block;}"); } /*lccio*/ if (!modelfs.showLFico) { sbtext.Append(".lccio{display:none;}"); } else { sbtext.Append(".lccio{display:inline-block;}"); } /*是否显示月租房图标*/ if (!modelfs.Showyz) { sbtext.Append(".yuezhu{display:none;}"); } else { sbtext.Append(".yuezhu{display:inline-block;}"); } /*是否显示免费房*/ if (!modelfs.Showmf) { sbtext.Append(".free{display:none;}"); } else { sbtext.Append(".free{display:inline-block;}"); } /*是否显示钟点房*/ if (!modelfs.Showzdf) { sbtext.Append(".zdf{display:none;}"); } else { sbtext.Append(".zdf{display:inline-block;}"); } File.WriteAllText(Server.MapPath("~/style/toom.css"), sbtext.ToString()); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnOk_Click(object sender, EventArgs e) { if (File.Exists(Server.MapPath("~/style/toom.css")))//如果存在文件 { Model.FtSet modelfs = new Model.FtSet(); modelfs.id = 1; modelfs.Lwidth = Convert.ToInt32(Lwidth.Value); modelfs.Lhieght = Convert.ToInt32(Lhieght.Value); modelfs.Lfontf = Lfontf.Value; modelfs.Fontsize = Convert.ToInt32(Fontsize.Value); modelfs.Lmargin = Convert.ToInt32(Lmargin.Value); modelfs.Backcolor = Backcolor.Value; modelfs.Bordercolor = Bordercolor.Value; modelfs.showType = Convert.ToBoolean(showType.Checked); modelfs.showPrice = Convert.ToBoolean(showPrice.Checked); modelfs.orderLC = Convert.ToBoolean(orderLC.Checked); modelfs.ftNum = Convert.ToInt32(ftNum.Value); modelfs.zzShowType = Convert.ToBoolean(zzShowType.Checked); modelfs.zzShowPrice = Convert.ToBoolean(zzShowPrice.Checked); modelfs.showFormTime = Convert.ToBoolean(showFormTime.Checked); modelfs.showLFico = Convert.ToBoolean(showLFico.Checked); modelfs.showBmico = Convert.ToBoolean(showBmico.Checked); modelfs.showyjb = Convert.ToBoolean(showyjb.Checked); modelfs.showday = Convert.ToBoolean(showday.Checked); modelfs.daynum = Convert.ToInt32(daynum.Value); modelfs.showyue = Convert.ToBoolean(showyue.Checked); modelfs.moneyNum = Convert.ToInt32(moneyNum.Value); modelfs.showcf = Convert.ToBoolean(showcf.Checked); modelfs.showThem = Convert.ToBoolean(showThem.Checked); modelfs.Themtext = Themtext.Value; modelfs.showMember = Convert.ToBoolean(showMember.Checked); modelfs.memberText = memberText.Value; modelfs.showXy = Convert.ToBoolean(showXy.Checked); modelfs.showYuli = Convert.ToBoolean(showYuli.Checked); modelfs.yuliDay = Convert.ToBoolean(yuliDay.Checked); modelfs.showDayTime = Convert.ToBoolean(showDayTime.Checked); modelfs.dayNumYl = Convert.ToInt32(dayNumYl.Value); modelfs.showxz = Convert.ToBoolean(Showxz.Checked); modelfs.showSf = Convert.ToBoolean(showSf.Checked); modelfs.showYuee = Convert.ToBoolean(showYuee.Checked); modelfs.Showzdftime = Convert.ToBoolean(Showzdftime.Checked); modelfs.Showbooktime = Convert.ToBoolean(Showbooktime.Checked); modelfs.Showzf = Convert.ToBoolean(Showzf.Checked); modelfs.Showlc = Convert.ToBoolean(Showlc.Checked); modelfs.showPeoNum = Convert.ToBoolean(showPeoNum.Checked); modelfs.showRk = Convert.ToBoolean(showRk.Checked); modelfs.showWupi = Convert.ToBoolean(showWupi.Checked); modelfs.Showyz = Convert.ToBoolean(Showyz.Checked); modelfs.Showmf = Convert.ToBoolean(Showmf.Checked); modelfs.Showzdf = Convert.ToBoolean(Showzdf.Checked); modelfs.numSize = Convert.ToInt32(numSize.Value); modelfs.numColor = numColor.Value; modelfs.fxSize = Convert.ToInt32(fxSize.Value); modelfs.fxColor = fxColor.Value; modelfs.yueSize = Convert.ToInt32(yueSize.Value); modelfs.yueColor = yueColor.Value; modelfs.nameSize = Convert.ToInt32(nameSize.Value); modelfs.nameColor = nameColor.Value; modelfs.priceSize = Convert.ToInt32(priceSize.Value); modelfs.priceColor = priceColor.Value; modelfs.TotimeSize = Convert.ToInt32(TotimeSize.Value); modelfs.TotimeColor = TotimeColor.Value; modelfs.zdSize = Convert.ToInt32(zdSize.Value); modelfs.zdColor = zdColor.Value; modelfs.icoColor = Convert.ToInt32(icoColor.Value); bllfs.Update(modelfs); Appe(modelfs); } else { File.Create(MapPath("~/style/toom.css"));//创建该CSS文件 } }