/// <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>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(YJ_WEATHER_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO YJ_WEATHER(WEATHERDATE, BYORGNO, TOWNNAME, JD, WD, P, T, W, F)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.WEATHERDATE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.TOWNNAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.JD));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.WD));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.P));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.T));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.W));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.F));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确！", ""));
}
}
/// <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);
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(YJ_WEATHER_Model m)
{
if (m.opMethod == "Add")
{
SystemCls.LogSave("3", "气象信息:" + m.WEATHERID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.YJ_WEATHER.Add(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
//if (m.opMethod == "Mdy")
//{
// SystemCls.LogSave("4", "气象信息:" + m.EMNAME, ClsStr.getModelContent(m));
// Message msgUser = BaseDT.YJ_WEATHER.Mdy(m);
// return new Message(msgUser.Success, msgUser.Msg, m.returnUrl);
//}
//if (m.opMethod == "Del")
//{
// SystemCls.LogSave("5", "气象信息:" + m.EMNAME, ClsStr.getModelContent(m));
// Message msgUser = BaseDT.YJ_WEATHER.Del(m);
// return new Message(msgUser.Success, msgUser.Msg, m.returnUrl);
//}
return(new Message(false, "无效操作", ""));
}
