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);
}
}
}
