/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw">参见条件模型CollectDataSW</param> /// <returns>参见模型CollectDataListModel</returns> public static IEnumerable <CollectDataListModel> get_CollectDataModelList(CollectDataSW sw) { var result = new List <CollectDataListModel>(); DataTable dt = T_IPSCOL_COLLECTDATA.getUnionDT(sw); for (int i = 0; i < dt.Rows.Count; i++) { CollectDataListModel m = new CollectDataListModel(); m.COLLECTID = long.Parse(dt.Rows[i]["COLLECTID"].ToString()); m.HID = int.Parse(dt.Rows[i]["HID"].ToString()); m.LONGITUDE = (dt.Rows[i]["LONGITUDE"] == null) ? 0 : decimal.Parse(dt.Rows[i]["LONGITUDE"].ToString()); m.LATITUDE = (dt.Rows[i]["LATITUDE"] == null) ? 0 : decimal.Parse(dt.Rows[i]["LATITUDE"].ToString()); //******************计算坐标偏移量 string[] arr = PublicCls.switJWD(m.LATITUDE.ToString(), m.LONGITUDE.ToString()); m.LATITUDE = Convert.ToDecimal(arr[0]); m.LONGITUDE = Convert.ToDecimal(arr[1]); //******************计算坐标偏移量 End m.SYSTYPEVALUE = dt.Rows[i]["SYSTYPEVALUE"].ToString(); m.COLLECTNAME = dt.Rows[i]["COLLECTNAME"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); //if (string.IsNullOrEmpty(Convert.ToString(dt.Rows[i]["HEIGHT"])))//判断是否是空值 //{ // dt.Rows[i]["HEIGHT"] = 0; //} m.COLLECTTIME = Convert.ToDateTime(dt.Rows[i]["COLLECTTIME"].ToString()); result.Add(m); } return(result); }
public JsonResult GetCollectAjax(string Hid) { //获取参数 var sw = new CollectDataSW(); sw.HID = Convert.ToInt32(Hid); var model = T_IPSCOL_COLLECTDATACls.get_CollectDataModelList(sw); return(Json(model)); }
/// <summary> /// 获取采集数据 /// </summary> /// <param name="sw">参见模型</param> /// <returns>返回DataTable</returns> public static DataTable getUnionDT(CollectDataSW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT * FROM T_IPSCOL_COLLECTDATA a Left join T_IPSCOL_DATADETAIL b On a.COLLECTID=b.COLLECTID" + " Left join T_IPSCOL_DATAUPLOAD c On c.COLLECTID=b.COLLECTID"); sb.AppendFormat(" WHERE 1=1"); sb.AppendFormat(" AND a.HID = {0}", sw.HID); sb.AppendFormat(" ORDER BY a.COLLECTTIME desc"); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }