/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(T_SYS_NOTICE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" SELECT INFOID, INFOTITLE, INFOCONTENT, INFOURL, FBTIME, LABLE, NUM, INFOTYPE, INFOUSERID, SYSFLAG");
sb.AppendFormat(" FROM T_SYS_NOTICE");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.INFOID) == false)
{
sb.AppendFormat(" AND INFOID = '{0}'", ClsSql.EncodeSql(sw.INFOID));
}
if (string.IsNullOrEmpty(sw.INFOTITLE) == false)
{
sb.AppendFormat(" AND INFOTITLE like '%{0}%'", ClsSql.EncodeSql(sw.INFOTITLE));
}
if (string.IsNullOrEmpty(sw.INFOTYPE) == false)
{
sb.AppendFormat(" AND INFOTYPE = '{0}'", ClsSql.EncodeSql(sw.INFOTYPE));
}
if (string.IsNullOrEmpty(sw.SYSFLAG) == false)
{
sb.AppendFormat(" AND SYSFLAG = '{0}'", ClsSql.EncodeSql(sw.SYSFLAG));
}
sb.AppendFormat(" order by FBTIME DESC");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在</returns>
public static bool isExists(T_SYS_NOTICE_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from T_SYS_NOTICE where 1=1");
if (string.IsNullOrEmpty(sw.INFOID) == false)
{
sb.AppendFormat(" and HID='{0}'", ClsSql.EncodeSql(sw.INFOID));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取分页信息
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <T_SYS_NOTICE_Model> getListPagerModel(T_SYS_NOTICE_SW sw, out int total)
{
var result = new List <T_SYS_NOTICE_Model>();
DataTable dt = BaseDT.T_SYS_NOTICE.getDT(sw, out total);//列表
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_NOTICE_Model m = new T_SYS_NOTICE_Model();
m.INFOTITLE = dt.Rows[i]["INFOTITLE"].ToString();
m.FBTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["FBTIME"].ToString());
m.LOGINUSERNAME = dt.Rows[i]["LOGINUSERNAME"].ToString();
m.INFOID = dt.Rows[i]["INFOID"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static T_SYS_NOTICE_Model getModel(T_SYS_NOTICE_SW sw)
{
DataTable dt = BaseDT.T_SYS_NOTICE.getDT(sw);
T_SYS_NOTICE_Model m = new T_SYS_NOTICE_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.INFOID = dt.Rows[i]["INFOID"].ToString();
m.INFOTITLE = dt.Rows[i]["INFOTITLE"].ToString();
m.INFOCONTENT = dt.Rows[i]["INFOCONTENT"].ToString();
m.INFOURL = dt.Rows[i]["INFOURL"].ToString();
m.FBTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["FBTIME"].ToString());
m.LABLE = dt.Rows[i]["LABLE"].ToString();
m.NUM = dt.Rows[i]["NUM"].ToString();
m.INFOTYPE = dt.Rows[i]["INFOTYPE"].ToString();
m.INFOUSERID = dt.Rows[i]["INFOUSERID"].ToString();
m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString();
}
return(m);
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(T_SYS_NOTICE_SW sw, out int total)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM T_SYS_NOTICE a left outer join T_SYSSEC_USER b on a.INFOUSERID=b.USERID");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.INFOID) == false)
{
sb.AppendFormat(" AND a.INFOID = '{0}'", ClsSql.EncodeSql(sw.INFOID));
}
if (string.IsNullOrEmpty(sw.INFOTITLE) == false)
{
sb.AppendFormat(" AND a.INFOTITLE like '%{0}%'", ClsSql.EncodeSql(sw.INFOTITLE));
}
if (string.IsNullOrEmpty(sw.INFOTYPE) == false)
{
sb.AppendFormat(" AND a.INFOTYPE = '{0}'", ClsSql.EncodeSql(sw.INFOTYPE));
}
if (string.IsNullOrEmpty(sw.SYSFLAG) == false)
{
sb.AppendFormat(" AND a.SYSFLAG = '{0}'", ClsSql.EncodeSql(sw.SYSFLAG));
}
string sql = "SELECT a.INFOID, a.INFOTITLE, a.INFOCONTENT, a.INFOURL, a.FBTIME, a.LABLE, a.NUM, a.INFOTYPE, a.INFOUSERID, a.SYSFLAG,b.LOGINUSERNAME"
+ sb.ToString()
+ " order by a.FBTIME DESC";
string sqlC = "select count(1) " + sb.ToString();
total = int.Parse(DataBaseClass.ReturnSqlField(sqlC));
sw.curPage = PagerCls.getCurPage(new PagerSW {
curPage = sw.curPage, pageSize = sw.pageSize, rowCount = total
});
DataSet ds = DataBaseClass.FullDataSet(sql, (sw.curPage - 1) * sw.pageSize, sw.pageSize, "a");
return(ds.Tables[0]);
}