/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(YJ_SATELLITECLOUD_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM YJ_SATELLITECLOUD a");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.CLOUDID) == false)
{
sb.AppendFormat(" AND CLOUDID = '{0}'", ClsSql.EncodeSql(sw.CLOUDID));
}
if (!string.IsNullOrEmpty(sw.DateBegin))
{
sb.AppendFormat(" AND CLOUDTIME>='{0} 00:00:00'", sw.DateBegin);
}
if (!string.IsNullOrEmpty(sw.DateEnd))
{
sb.AppendFormat(" AND CLOUDTIME<='{0} 23:59:59'", sw.DateEnd);
}
string sql = "SELECT CLOUDID, CLOUDTIME, CLOUDNAME, CLOUDFILENAME"
+ sb.ToString()
+ " order by CLOUDTIME DESC";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getTopDT(YJ_SATELLITECLOUD_SW sw)
{
StringBuilder sb = new StringBuilder();
if (string.IsNullOrEmpty(sw.TopCount)) //获取最新记录个数
{
sw.TopCount = "10"; //默认10条
}
sb.AppendFormat(" SELECT top {0} CLOUDID, CLOUDTIME, CLOUDNAME, CLOUDFILENAME,CLOUDORIGIONNAME", sw.TopCount);
sb.AppendFormat(" FROM YJ_SATELLITECLOUD");
string sql = sb.ToString()
+ " order by CLOUDTIME desc,CLOUDID DESC";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static YJ_SATELLITECLOUD_Model getModel(YJ_SATELLITECLOUD_SW sw)
{
DataTable dt = BaseDT.YJ_SATELLITECLOUD.getDT(sw);
YJ_SATELLITECLOUD_Model m = new YJ_SATELLITECLOUD_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.CLOUDID = dt.Rows[i]["CLOUDID"].ToString();
m.CLOUDTIME = ClsSwitch.SwitTM(dt.Rows[i]["CLOUDTIME"].ToString());
m.CLOUDNAME = dt.Rows[i]["CLOUDNAME"].ToString();
m.CLOUDFILENAME = dt.Rows[i]["CLOUDFILENAME"].ToString();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <YJ_SATELLITECLOUD_Model> getListModel(YJ_SATELLITECLOUD_SW sw)
{
DataTable dt = BaseDT.YJ_SATELLITECLOUD.getDT(sw);//列表
var result = new List <YJ_SATELLITECLOUD_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
YJ_SATELLITECLOUD_Model m = new YJ_SATELLITECLOUD_Model();
m.CLOUDID = dt.Rows[i]["CLOUDID"].ToString();
m.CLOUDTIME = ClsSwitch.SwitTM(dt.Rows[i]["CLOUDTIME"].ToString());
m.CLOUDNAME = dt.Rows[i]["CLOUDNAME"].ToString();
m.CLOUDFILENAME = dt.Rows[i]["CLOUDFILENAME"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型 sw.TopCount 默认为10 sw.MANSTATE 默认取所有</param>
/// <returns>参见模型</returns>
public static IEnumerable <YJ_SATELLITECLOUD_Model> getListModelTop(YJ_SATELLITECLOUD_SW sw)
{
DataTable dt = BaseDT.YJ_SATELLITECLOUD.getTopDT(sw); //列表
var result = new List <YJ_SATELLITECLOUD_Model>();
string path = ConfigCls.getConfigValue("WxImagesPath"); //压缩卫星云图
string orginalpath = ConfigCls.getConfigValue("WxImagesOriginalPath"); //原始卫星云图
for (int i = 0; i < dt.Rows.Count; i++)
{
YJ_SATELLITECLOUD_Model m = new YJ_SATELLITECLOUD_Model();
m.CLOUDID = dt.Rows[i]["CLOUDID"].ToString();
m.CLOUDTIME = ClsSwitch.SwitTM(dt.Rows[i]["CLOUDTIME"].ToString());
m.CLOUDNAME = dt.Rows[i]["CLOUDNAME"].ToString();
m.CLOUDFILENAME = path + dt.Rows[i]["CLOUDFILENAME"].ToString();
m.CLOUDORIGIONNAME = orginalpath + dt.Rows[i]["CLOUDORIGIONNAME"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
