/// <summary>
/// 护林员周边火点距离
/// </summary>
/// <param name="sw">护林员距离</param>
/// <returns></returns>
public static DataTable getDTByArea(HlyAreaDataSW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" select REALDATAID, USERID, LONGITUDE, LATITUDE, HEIGHT, ELECTRIC, SPEED, DIRECTION, SBTIME, NOTE, ORGNO, SBDATE, SBTIMEBEGIN, PATROLLENGTH, ISOUTRAIL ");
sb.AppendFormat(" from T_IPS_REALDATATEMPORARY t ");
sb.AppendFormat(" where (DATEDIFF(d, SBTIME, '{0}') = 0) AND (dbo.fnGetDistance(LATITUDE,LONGITUDE, {1}, {2}) <= {3}) ", sw.DATETIME, sw.WD, sw.JD, sw.AREA);
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 护林员周边
/// </summary>
/// <param name="sw">周边模型</param>
/// <returns></returns>
public static IEnumerable <T_IPS_REALDATATEMPORARYModel> getModelList(HlyAreaDataSW sw)
{
var result = new List <T_IPS_REALDATATEMPORARYModel>();
DataTable dt = BaseDT.T_IPS_REALDATATEMPORARY.getDTByArea(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_IPS_REALDATATEMPORARYModel m = new T_IPS_REALDATATEMPORARYModel();
//m.REALDATAID = dt.Rows[i]["REALDATAID"].ToString();
m.USERID = dt.Rows[i]["USERID"].ToString();
m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString();
m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString();
m.ORILONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); //原始经度
m.ORILATITUDE = dt.Rows[i]["LATITUDE"].ToString(); //原始纬度
if (sw.MapType != "Skyline")
{
//******************计算坐标偏移量
string[] arr = PublicCls.switJWD(m.LATITUDE, m.LONGITUDE);
m.LATITUDE = arr[0];
m.LONGITUDE = arr[1];
//******************计算坐标偏移量 End
}
m.HEIGHT = dt.Rows[i]["HEIGHT"].ToString();
m.ELECTRIC = dt.Rows[i]["ELECTRIC"].ToString();
m.SPEED = dt.Rows[i]["SPEED"].ToString();
m.DIRECTION = dt.Rows[i]["DIRECTION"].ToString();
m.SBTIME = dt.Rows[i]["SBTIME"].ToString();
if (string.IsNullOrEmpty(m.SBTIME) == false)
{
m.SBTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.SBTIME);
}
m.NOTE = dt.Rows[i]["NOTE"].ToString();
m.ORGNO = dt.Rows[i]["ORGNO"].ToString();
m.SBDATE = dt.Rows[i]["SBDATE"].ToString();
if (string.IsNullOrEmpty(m.SBDATE) == false)
{
m.SBDATE = PublicClassLibrary.ClsSwitch.SwitDate(m.SBDATE);
}
m.SBTIMEBEGIN = dt.Rows[i]["SBTIMEBEGIN"].ToString();
m.PATROLLENGTH = dt.Rows[i]["PATROLLENGTH"].ToString();
result.Add(m);
}
return(result);
}
