protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string psName = Request["psname"]; startDate = Request["sDate"]; endDate = Request["eDate"]; statisticType = Request["category"]; RentInfoHelper helper = new RentInfoHelper(); chartData = "["; switch (statisticType) { case "AllPoliceStation": case "AllPoliceHouse": if (policeStationName != "全部") { policeStationName = psName; } mtitle = "<b>房源全量统计</b>"; stitle = "所属警局:" + policeStationName + " <br />统计日期:" + startDate + " 至 " + endDate; yTitle = "入住数量"; serieTitle = "入住量"; DataTable dt = helper.GetStatisticData(statisticType, startDate, endDate, psName == "全部" ? "" : psName, LigerRM.Common.SysContext.CurrentUserID.ToString()); decimal totalCount = 0; foreach (DataRow row in dt.Rows) { totalCount += decimal.Parse(row["RentRecordCount"].ToString()); } Random ran = new Random(1); int rowIndex = ran.Next(0, dt.Rows.Count - 1); int index = 0; foreach (DataRow row in dt.Rows) { //{ // name: 'Chrome', // y: 12.8, // sliced: true, // selected: true //}, if (rowIndex == index) { chartData += "{name:'" + row["PSName"].ToString() + "',y:" + ((decimal.Parse(row["RentRecordCount"].ToString()) / totalCount) * 100).ToString("f2") + ",sliced: true,selected: true},"; } else { chartData += "['" + row["PSName"].ToString() + "'," + ((decimal.Parse(row["RentRecordCount"].ToString()) / totalCount) * 100).ToString("f2") + "],"; } index++; } break; case "AllDistrict": if (policeStationName != "全部") { DataTable dt1 = helper.GetDataTable("select * from Rent_PoliceStation where PSName='" + psName + "'"); if (dt1.Rows.Count > 0) { policeStationName = dt1.Rows[0]["co_corp_name"].ToString(); } } mtitle = "<b>所属区域全量统计</b>"; stitle = "所属区域:" + policeStationName + " <br />统计日期:" + startDate + " 至 " + endDate; yTitle = "入住数量"; serieTitle = "入住量"; DataTable dt2 = helper.GetStatisticData(statisticType, startDate, endDate, psName == "全部" ? "" : psName, LigerRM.Common.SysContext.CurrentUserID.ToString()); foreach (DataRow row in dt2.Rows) { chartData += "['" + row["rd_reg_dept_name"].ToString() + "'," + row["PackageCount"].ToString() + "],"; } break; //case "AllPoliceHouse": // if (policeStationName != "全部") // { // policeStationName = psName; // } // mtitle = "<b>所属警局全量统计</b>"; // stitle = "所属警局:" + policeStationName + " <br />统计日期:" + startDate + " 至 " + endDate; // yTitle = "入住数量"; // serieTitle = "入住量"; // DataTable dt3 = helper.GetStatisticData(statisticType, startDate, endDate, psName == "全部" ? "" : psName); // foreach (DataRow row in dt3.Rows) // { // chartData += "['" + row["PSName"].ToString() + "'," + row["RentRecordCount"].ToString() + "],"; // } // break; } if (!string.IsNullOrEmpty(chartData)) { chartData = chartData.Substring(0, chartData.Length - 1); } chartData = chartData + "]"; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string psName = Request["psname"]; startDate = Request["sDate"]; endDate = Request["eDate"]; statisticType = Request["category"]; RentInfoHelper helper = new RentInfoHelper(); chartData = "["; switch (statisticType) { case "AllPoliceStation": if (policeStationName != "全部") { policeStationName = psName; } mtitle = "<b>房源全量统计</b>"; stitle = "所属警局:" + policeStationName + " <br />统计日期:" + startDate + " 至 " + endDate; yTitle = "入住数量"; serieTitle = "入住量"; DataTable dt = helper.GetStatisticData(statisticType, startDate, endDate, psName == "全部" ? "" : psName, LigerRM.Common.SysContext.CurrentUserID.ToString()); foreach (DataRow row in dt.Rows) { chartData += "['" + row["PSName"].ToString() + "'," + row["RentRecordCount"].ToString() + "],"; } break; case "AllDistrict": if (policeStationName != "全部") { DataTable dt1 = helper.GetDataTable("select * from Rent_PoliceStation where PSName='" + psName + "'"); if (dt1.Rows.Count > 0) { policeStationName = dt1.Rows[0]["co_corp_name"].ToString(); } } mtitle = "<b>所属区域全量统计</b>"; stitle = "所属区域:" + policeStationName + " <br />统计日期:" + startDate + " 至 " + endDate; yTitle = "入住数量"; serieTitle = "入住量"; DataTable dt2 = helper.GetStatisticData(statisticType, startDate, endDate, psName == "全部" ? "" : psName, LigerRM.Common.SysContext.CurrentUserID.ToString()); foreach (DataRow row in dt2.Rows) { chartData += "['" + row["rd_reg_dept_name"].ToString() + "'," + row["PackageCount"].ToString() + "],"; } break; case "AllPoliceHouse": if (policeStationName != "全部") { policeStationName = psName; } mtitle = "<b>所属警局全量统计</b>"; stitle = "所属警局:" + policeStationName + " <br />统计日期:" + startDate + " 至 " + endDate; yTitle = "入住数量"; serieTitle = "入住量"; DataTable dt3 = helper.GetStatisticData(statisticType, startDate, endDate, psName == "全部" ? "" : psName, LigerRM.Common.SysContext.CurrentUserID.ToString()); foreach (DataRow row in dt3.Rows) { chartData += "['" + row["PSName"].ToString() + "'," + row["RentRecordCount"].ToString() + "],"; } break; } if (!string.IsNullOrEmpty(chartData)) { chartData = chartData.Substring(0, chartData.Length - 1); } chartData = chartData + "]"; } }