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();
}
