protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { RentInfoHelper helper = new RentInfoHelper(); DataTable dt = helper.GetRentsByStreet("9"); foreach (DataRow row in dt.Rows) { dataInfo += "[" + row["Longitude"].ToString() + ", " + row["Latitude"].ToString() + ", '" + row["Available"].ToString() + "', \"地址:" + row["RAddress"].ToString() + "<br/>" + "房主:" + row["ROwner"].ToString() + " " + helper.OverString(row["RIDCard"].ToString()) + "<br/>" + "状态:" + (row["Available"].ToString().ToUpper() == "已租" ? "<span style='color:red;'>出租中</span>" : "空闲") + "\"],"; } if (!string.IsNullOrEmpty(dataInfo)) { dataInfo = dataInfo.Substring(0, dataInfo.Length - 1); } string sql = "select * from Motor_BerthesInfo"; DataTable mDt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0]; foreach (DataRow row in mDt.Rows) { motordataInfo += "[" + row["Lon"].ToString() + ", " + row["Lat"].ToString() + ", '" + row["Status"].ToString() + "','" + row["BertheNumber"].ToString() + "'],"; } if (!string.IsNullOrEmpty(motordataInfo)) { motordataInfo = motordataInfo.Substring(0, motordataInfo.Length - 1); } } }
//Scattergram.aspx?category=0&sDate=&eDate=&corpId=®DeptId= protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { defaultLon = ConfigurationManager.AppSettings["defaultLon"]; defaultLat = ConfigurationManager.AppSettings["defaultLat"]; category = Request["category"]; year = Request["year"]; month = Request["month"]; day = Request["day"]; psname = Request["psname"]; RentInfoHelper helper = new RentInfoHelper(); string startDate = string.Empty; string endDate = string.Empty; if (!string.IsNullOrEmpty(day)) { startDate = day; endDate = Convert.ToDateTime(startDate).AddDays(1).ToString("yyyy-MM-dd"); } else if (!string.IsNullOrEmpty(month) && string.IsNullOrEmpty(day) == true) { startDate = year + "-" + month + "-01"; endDate = Convert.ToDateTime(startDate).AddMonths(1).ToString("yyyy-MM-dd"); } else if (string.IsNullOrEmpty(month) && string.IsNullOrEmpty(day)) { startDate = year + "-01-01"; endDate = Convert.ToDateTime(startDate).AddYears(1).ToString("yyyy-MM-dd"); } DataTable dt = helper.GetScattergramData(startDate, endDate, psname == "全部" ? "" : psname, LigerRM.Common.SysContext.CurrentUserID.ToString()); foreach (DataRow row in dt.Rows) { dataInfo += "[" + row["Longitude"].ToString() + ", " + row["Latitude"].ToString() + //", \"警局:" + row["RPSName"].ToString() + "<br/>" + //"租赁人:" + row["RRAContactName"].ToString() + " " + helper.OverString(row["RRAContactTel"].ToString()) + "<br/>" + ", \"地址:" + row["RAddress"].ToString() + "<br/>" + "房主:" + row["ROwner"].ToString() + " " + helper.OverString(row["RIDCard"].ToString()) + "<br/>" + "状态:" + (row["IsAvailable"].ToString().ToUpper() == "已租" ? "<span style='color:red;'>出租中</span>" : "空闲") + //"时间:" + DateTime.Parse(row["RRAStartDate"].ToString()).ToString("yyyy-MM-dd") + " " + DateTime.Parse(row["RRAEndDate"].ToString()).ToString("yyyy-MM-dd") + "\"],"; } if (!string.IsNullOrEmpty(dataInfo)) { dataInfo = dataInfo.Substring(0, dataInfo.Length - 1); } } }