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