protected void Page_Load(object sender, EventArgs e) { Page.UnobtrusiveValidationMode = UnobtrusiveValidationMode.None; if (!IsPostBack) { if (HttpContext.Current.Session["JMPrincipal"] != null) { var principal = HttpContext.Current.Session["JMPrincipal"] as JMReports.Business.MyPrincipal; if (principal != null) { int userId = (principal.Identity as JMReports.Business.MyIdentity).Id; Business.UserHotelComponent rc = new Business.UserHotelComponent(); var userHotelList = rc.getUserHotel(userId); selDept.DataSource = userHotelList; selDept.DataTextField = "ChineseName"; selDept.DataValueField = "HotelId"; selDept.DataBind(); selDept.Items.Insert(0, ""); var defaultHotel = userHotelList.FirstOrDefault(); if (defaultHotel != null) selDept.Items.FindByValue(defaultHotel.HotelId.ToString()).Selected = true; try { var search = HttpContext.Current.Session["CurrentCondition"] as JMReports.Business.SearchCondition; selDept.SelectedValue = search.Hotel; } catch { } } } } }
protected void btnSave_Click(object sender, EventArgs e) { if (lbUserList.SelectedIndex >= 0) { int userId = 0; userId = int.Parse(lbUserList.SelectedValue.ToString()); var hotelList = new List<Hotel>(); for (int i = 0; i <= gvHotel.Rows.Count - 1; i++) { CheckBox cb1 = (CheckBox)gvHotel.Rows[i].FindControl("cb1"); if (cb1.Checked) { //Page.Response.Write(gvReport.DataKeys[i].Value); hotelList.Add(new Hotel { HotelId = int.Parse(gvHotel.DataKeys[i].Value.ToString()) }); } } Business.UserHotelComponent rc = new Business.UserHotelComponent(); int retVal = rc.setUserHotel(userId, hotelList); this.alertClient(retVal >= 0 ? "用户酒店关联成功!" : "关联失败,请联系系统管理员"); } }
public void setPage() { for (int i = 0; i <= gvHotel.Rows.Count - 1; i++) { CheckBox cb1 = (CheckBox)gvHotel.Rows[i].FindControl("cb1"); cb1.Checked = false; } if (lbUserList.SelectedIndex >= 0) { int userId = 0; userId = int.Parse(lbUserList.SelectedValue.ToString()); Business.UserHotelComponent rc = new Business.UserHotelComponent(); var userHotelList = rc.getUserHotel(userId); if (userHotelList != null && userHotelList.Count > 0) { foreach(var item in userHotelList) { for (int i = 0; i <= gvHotel.Rows.Count - 1; i++) { if (gvHotel.DataKeys[i].Value.ToString() == item.HotelId.ToString()) { CheckBox cb1 = (CheckBox)gvHotel.Rows[i].FindControl("cb1"); cb1.Checked = true; } } } } } }
private void SetDailyRevenueBI() { ObjectDataSource ods = this.ObjectDataSource1; { ods.TypeName = "JMReports.WebApp.ReportBussiness.DailyReport"; ods.SelectMethod = "GetDailyRevenueBIReport"; ods.SelectParameters.Clear(); ods.SelectParameters.Add("dt1", this.txtDatetime.Text); } ObjectDataSource ods2 = this.ObjectDataSource2; { ods2.TypeName = "JMReports.WebApp.ReportBussiness.DailyReport"; ods2.SelectMethod = "GetDailyRoomRevenueBIReport"; ods2.SelectParameters.Clear(); ods2.SelectParameters.Add("dt1", this.txtDatetime.Text); } ObjectDataSource ods3 = this.ObjectDataSource3; { ods3.TypeName = "JMReports.WebApp.ReportBussiness.DailyReport"; ods3.SelectMethod = "GetDailyRestaurantRevenueBIReport"; ods3.SelectParameters.Clear(); ods3.SelectParameters.Add("dt1", this.txtDatetime.Text); } ObjectDataSource ods4 = this.ObjectDataSource4; { ods4.TypeName = "JMReports.WebApp.ReportBussiness.DailyReport"; ods4.SelectMethod = "GetDailyOccupancyRateBIReport"; ods4.SelectParameters.Clear(); ods4.SelectParameters.Add("dt1", this.txtDatetime.Text); } //添加参数 ReportViewer rv = this.ReportViewer1; { ReportParameter p1 = new ReportParameter("title", " 经营日报表(" + this.txtDatetime.Text + ")"); ReportParameter p2 = new ReportParameter("date1", this.txtDatetime.Text); ReportParameter p3 = new ReportParameter("HotelIds"); if (HttpContext.Current.Session["JMPrincipal"] != null) { var principal = HttpContext.Current.Session["JMPrincipal"] as JMReports.Business.MyPrincipal; if (principal != null) { int userId = (principal.Identity as JMReports.Business.MyIdentity).Id; Business.UserHotelComponent rc = new Business.UserHotelComponent(); var userHotelList = rc.getUserHotel(userId); var abc = from a in userHotelList select a.HotelId.ToString(); p3.Values.AddRange(abc.ToArray()); } } rv.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3 }); rv.LocalReport.EnableHyperlinks = true; rv.PageCountMode = PageCountMode.Actual; rv.ShowBackButton = false; rv.ShowToolBar = false; rv.ShowRefreshButton = false; rv.LocalReport.Refresh(); } }