/// <summary>
/// 生成营业报表
/// </summary>
private void Bind(string day, string end)
{
//List<Model.occu_infor> listoi = blloi.GetDaySheet("CONVERT(varchar(100), oi.occ_time,23)>='"+day+"' and CONVERT(varchar(100), oi.occ_time,23)<='"+dayend+"'");
//if (listoi != null)
//{
// foreach (Model.occu_infor model in listoi)
// {
// sbtext.Append("<tr class=\"sj\"><td><a href='DailySheet.aspx?day=" + model.occ_time.ToString("yyyy-MM-dd") + "'>" + model.occ_time.ToString("yyyy-MM-dd") + "</a></td><td>" + model.room_number + "</td><td>" + model.occ_name + "</td><td>" + model.Real_mode_mode.real_mode_name + "</td><td>" + GetRoomStatu(model.state_id) + "</td><td>" + model.real_price + "</td><td>" + GetRoomStatu(model) + "</td><td>" + model.occ_time + "</td><td>" + model.depar_time + "</td><td class=\"ff\">" + GetRoomStatu(model) + "</td><td class=\"fy\">" + GetGoodsFh(model) + "</td><td><span class=\"hj\"></span></td></tr>");
// }
//}
DataSet ds = blloi.GetDaySheetbymouth("CONVERT(varchar(100), oi.occ_time,23)>='" + day + "' and CONVERT(varchar(100), oi.occ_time,23)<='" + dayend + "' group by CONVERT(varchar(100), oi.occ_time,23)");
if (ds != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
sbtext.Append("<tr class=\"sj\"><td><a onclick=\"ShowTab('" + dr[0].ToString() + "日报表','/Admin/ShiftExc/DailySheet.aspx?day=" + dr[0].ToString() + "')\" >" + dr[0].ToString() + "</a></td><td class=\"rz1\">" + dr[1].ToString() + "</td><td class=\"zf1\">" + sumroomnum + "</td><td class=\"rzn1\">" + Gn(sumroomnum.ToString(), dr[1].ToString()) + "</td><td class=\"pj1\">" + Convert.ToDecimal(dr[2].ToString()).ToString("0.##") + "</td><td class=\"fz\">" + Convert.ToDecimal(dr[3].ToString()).ToString("0.##") + "</td><td class=\"xf\">" + GetFy(dr[0].ToString()) + "</td><td class=\"xj\"></td></tr>");
}
}
}