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