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); } } }
private void GetHouseInfo() { RentInfoHelper helper = new RentInfoHelper(); DataTable dt = helper.GetRentsByStreet("9"); HOUSE_TOTALCOUNT = dt.Rows.Count.ToString(); int leftCount = 0; int usedCount = 0; foreach (DataRow row in dt.Rows) { if (row["Available"].ToString() == "True") { leftCount++; } else { usedCount++; } } HOUSE_LEFTCOUNT = leftCount.ToString(); HOUSE_USEDCOUNT = usedCount.ToString(); }