/// <summary> /// 获取列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static YJ_WEATHER_Model getModel(YJ_WEATHER_SW sw) { DataTable dt = BaseDT.YJ_WEATHER.getDT(sw);//列表 DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { }); YJ_WEATHER_Model m = new YJ_WEATHER_Model(); if (dt.Rows.Count > 0) { int i = 0; m.WEATHERID = dt.Rows[i]["WEATHERID"].ToString(); m.WEATHERDATE = ClsSwitch.SwitTM(dt.Rows[i]["WEATHERDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.TOWNNAME = dt.Rows[i]["TOWNNAME"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.P = dt.Rows[i]["P"].ToString(); m.T = dt.Rows[i]["T"].ToString(); m.W = dt.Rows[i]["W"].ToString(); m.F = dt.Rows[i]["F"].ToString(); m.TCUR = dt.Rows[i]["TCUR"].ToString(); m.THIGH = dt.Rows[i]["THIGH"].ToString(); m.TLOWER = dt.Rows[i]["TLOWER"].ToString(); m.orgName = BaseDT.T_SYS_ORG.getName(dtOrg, m.BYORGNO); } dt.Clear(); dt.Dispose(); dtOrg.Clear(); dtOrg.Dispose(); return(m); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <YJ_WEATHER_Model> getNewListModel(YJ_WEATHER_SW sw) { DataTable dt = BaseDT.YJ_WEATHER.getNewDT(sw);//列表 var result = new List <YJ_WEATHER_Model>(); for (int i = 0; i < dt.Rows.Count; i++) { YJ_WEATHER_Model m = new YJ_WEATHER_Model(); m.WEATHERID = dt.Rows[i]["WEATHERID"].ToString(); m.WEATHERDATE = ClsSwitch.SwitTM(dt.Rows[i]["WEATHERDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.TOWNNAME = dt.Rows[i]["TOWNNAME"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.P = dt.Rows[i]["P"].ToString(); m.T = dt.Rows[i]["T"].ToString(); m.W = dt.Rows[i]["W"].ToString(); m.F = dt.Rows[i]["F"].ToString(); m.TCUR = dt.Rows[i]["TCUR"].ToString(); m.THIGH = dt.Rows[i]["THIGH"].ToString(); m.TLOWER = dt.Rows[i]["TLOWER"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getNewDT(YJ_WEATHER_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" SELECT WEATHERID, WEATHERDATE, BYORGNO, TOWNNAME, JD, WD, P, T, W, F,TCUR,THIGH,TLOWER"); sb.AppendFormat(" FROM YJ_WEATHER"); sb.AppendFormat(" where CONVERT(varchar(10),WEATHERDATE,120)= CONVERT(varchar(10), (select max(WEATHERDATE) from YJ_WEATHER), 120)"); if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO)); } if (string.IsNullOrEmpty(sw.TopORGNO) == false) { if (sw.TopORGNO.Substring(4, 5) == "00000")//获取所有市的 { sb.AppendFormat(" AND SUBSTRING(BYORGNO,1,4) = '{0}'", ClsSql.EncodeSql(sw.TopORGNO.Substring(0, 4))); } else if (sw.TopORGNO.Substring(6, 3) == "000")//获取所有县的 { sb.AppendFormat(" AND SUBSTRING(BYORGNO,1,6) = '{0}'", ClsSql.EncodeSql(sw.TopORGNO.Substring(0, 6))); } else { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.TopORGNO)); } } string sql = sb.ToString() + " order by BYORGNO DESC"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
public JsonResult GetWeatherList() { MessageListObject msg = null; var sw = new YJ_WEATHER_SW(); var list = YJ_WEATHERCls.getNewListModel(sw); msg = new MessageListObject(true, list); return(Json(msg)); }
/// <summary> /// 获取天气情况 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <Weather_Model> getWeatherData(YJ_WEATHER_SW sw) { DataTable dt = BaseDT.YJ_WEATHER.getNewDT(sw); var result = new List <Weather_Model>(); for (int i = 0, len = dt.Rows.Count; i < len; i++) { Weather_Model m = new Weather_Model(); m.TOWNNAME = dt.Rows[i]["TOWNNAME"].ToString(); m.WEATHERDATE = dt.Rows[i]["WEATHERDATE"].ToString(); m.P = dt.Rows[i]["P"].ToString(); m.TCUR = dt.Rows[i]["TCUR"].ToString(); m.THIGH = dt.Rows[i]["THIGH"].ToString(); m.TLOWER = dt.Rows[i]["TLOWER"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 根据当前单位获取气象信息 /// </summary> /// <param name="sw">参见模型</param> /// <returns>返回气象信息</returns> public static string getWeather(YJ_WEATHER_SW sw) { if (string.IsNullOrEmpty(sw.BYORGNO)) { sw.BYORGNO = SystemCls.getCurUserOrgNo(); } YJ_WEATHER_Model wm = YJ_WEATHERCls.getModel(new YJ_WEATHER_SW { BYORGNO = sw.BYORGNO }); string str; if (string.IsNullOrEmpty(wm.WEATHERDATE) == false)// (!string.IsNullOrEmpty(wm.THIGH) && !string.IsNullOrEmpty(wm.THIGH) && !string.IsNullOrEmpty(wm.THIGH)) { str = "[" + PublicClassLibrary.ClsSwitch.SwitDate(wm.WEATHERDATE) + " " + wm.orgName + "] 最高气温" + wm.THIGH + "℃,最低气温" + wm.TLOWER + "℃,雨量" + wm.P + "mm"; } else { str = "暂无气象信息"; } return(str); }