/// <summary> /// 获取记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(PEST_CONSULREPLY_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM PEST_CONSULREPLY WHERE 1=1"); if (string.IsNullOrEmpty(sw.PEST_CONSULREPLYID) == false) { sb.AppendFormat(" AND PEST_CONSULTATIONID = '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULTATIONID)); } if (string.IsNullOrEmpty(sw.PEST_CONSULTATIONID) == false) { sb.AppendFormat(" AND PEST_CONSULTATIONID = '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULTATIONID)); } if (string.IsNullOrEmpty(sw.REPLYUID) == false) { sb.AppendFormat(" AND REPLYUID = '{0}'", ClsSql.EncodeSql(sw.REPLYUID)); } if (string.IsNullOrEmpty(sw.REPLYTIME) == false) { sb.AppendFormat(" AND REPLYTIME = '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.REPLYTIME).ToString())); sb.AppendFormat(" AND REPLYTIME = '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.REPLYTIME).AddDays(1).AddSeconds(-1).ToString())); } string sql = "SELECT PEST_CONSULREPLYID, PEST_CONSULTATIONID, REPLYUID, REPLYTIME, REPLYCONTENT" + sb.ToString() + " ORDER BY REPLYTIME "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static DataTable getDT(PEST_CONSULREPLY_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM PEST_CONSULREPLY WHERE 1=1"); if (string.IsNullOrEmpty(sw.PEST_CONSULREPLYID) == false) { sb.AppendFormat(" AND PEST_CONSULTATIONID = '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULTATIONID)); } if (string.IsNullOrEmpty(sw.PEST_CONSULTATIONID) == false) { sb.AppendFormat(" AND PEST_CONSULTATIONID = '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULTATIONID)); } if (string.IsNullOrEmpty(sw.REPLYUID) == false) { sb.AppendFormat(" AND REPLYUID = '{0}'", ClsSql.EncodeSql(sw.REPLYUID)); } if (string.IsNullOrEmpty(sw.REPLYTIME) == false) { sb.AppendFormat(" AND REPLYTIME = '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.REPLYTIME).ToString())); sb.AppendFormat(" AND REPLYTIME = '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.REPLYTIME).AddDays(1).AddSeconds(-1).ToString())); } string sql = "SELECT PEST_CONSULREPLYID, PEST_CONSULTATIONID, REPLYUID, REPLYTIME, REPLYCONTENT" + sb.ToString() + " ORDER BY REPLYTIME "; 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]); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在</returns> public static bool isExists(PEST_CONSULREPLY_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from PEST_CONSULREPLY where 1=1"); if (string.IsNullOrEmpty(sw.PEST_CONSULREPLYID) == false) { sb.AppendFormat(" where PEST_CONSULREPLYID= '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULREPLYID)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }