/// <summary> /// 获取实体分页(可设定返回值) /// </summary> public DataTable GetDownloadCenterListByFileds(DownloadCenterTO TO, int pageIndex, int pageSize, string orderBy, string fileds, out int rowCount) { string table = " [DownloadCenter] "; string pk = " ID "; string fields = fileds; string filter = "";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal); #region 组织查询条件 //if (!string.IsNullOrEmpty(TO.MC)) //{ // filter += string.Format(" and MC like '%{0}%' ", StringHelper.SQLFilter(TO.MC)); //} filter += " isdel=1 "; if (!string.IsNullOrEmpty(TO.Title)) { filter += string.Format(" and Title like '%{0}%' ", StringHelper.SQLFilter(TO.Title)); } #endregion string sort = " ID DESC ";//排序 if (!string.IsNullOrEmpty(orderBy)) { sort = orderBy; } SqlParameter[] parameters = { new SqlParameter("@Tables", SqlDbType.VarChar, 1000), new SqlParameter("@PK", SqlDbType.VarChar, 100), new SqlParameter("@Fields", SqlDbType.VarChar, 1000), new SqlParameter("@Pageindex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@Filter", SqlDbType.VarChar, 1000), new SqlParameter("@Sort", SqlDbType.VarChar, 200), new SqlParameter("@RowCount", SqlDbType.Int) }; parameters[0].Value = table; parameters[1].Value = pk; parameters[2].Value = fields; parameters[3].Value = pageIndex; parameters[4].Value = pageSize; parameters[5].Value = filter; parameters[6].Value = sort; parameters[7].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.RunProcedure("SP_DividePage", parameters, "DownloadCenterList"); rowCount = (int)parameters[7].Value; return(ds.Tables[0]); }
/// <summary> /// 获取参数 /// </summary> private DownloadCenterTO GetCriteria() { DownloadCenterTO criteria = new DownloadCenterTO(); if (this.txtStartDate.Text.Trim() != "") { criteria.StartDt = Convert.ToDateTime(this.txtStartDate.Text.Trim()); } if (this.txtEndDate.Text.Trim() != "") { criteria.EndDt = Convert.ToDateTime(this.txtEndDate.Text.Trim()); } criteria.Title = this.txtTitle.Text.Trim(); criteria.PubDepId = Check.GetInt32(ddlDep.SelectedValue); return(criteria); }
/// <summary> /// 获取实体分页 /// 后台使用 /// </summary> public DataTable GetDownloadCenterListByBack(DownloadCenterTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount) { return(service.GetDownloadCenterListByBack(TO, pageIndex, pageSize, orderBy, out rowCount)); }
/// <summary> /// 获取实体分页 /// 后台使用 /// </summary> public DataTable GetDownloadCenterListByBack(DownloadCenterTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount) { string table = " DownloadCenter b left join UserInfo u on b.PublishUserCode=u.UserCode left join Department d on u.DepartmentId=d.Id "; string pk = " b.ID "; string fields = " b.Id,b.PublishUserCode,b.Title,b.AffixOldName,b.PublishTime,u.UserName as PubName,d.RoleName as PubDep "; string filter = "";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal); #region 组织查询条件 //if (!string.IsNullOrEmpty(TO.MC)) //{ // filter += string.Format(" and MC like '%{0}%' ", StringHelper.SQLFilter(TO.MC)); //} filter += " b.isdel=1 "; if (!string.IsNullOrEmpty(TO.Title)) { filter += string.Format(" and b.Title like '%{0}%' ", StringHelper.SQLFilter(TO.Title)); } if (!string.IsNullOrEmpty(TO.PubName)) { filter += string.Format(" and u.PubName like '%{0}%' ", StringHelper.SQLFilter(TO.PubName)); } if (TO.PubDepId > 0) { filter += string.Format(" and d.id={0} ", TO.PubDepId); } //根据开始日期进行选择 if (TO.StartDt.HasValue) { DateTime beginDt = DateTime.Parse(TO.StartDt.Value.ToShortDateString()); filter += string.Format(" and b.PublishTime>='{0}' ", beginDt); } //根据结束日期进行选择 if (TO.EndDt.HasValue) { var endDate = DateTime.Parse(TO.EndDt.Value.ToShortDateString() + " 23:59:59"); filter += string.Format(" and b.PublishTime<='{0}' ", endDate); } #endregion string sort = " b.ID DESC ";//排序 if (!string.IsNullOrEmpty(orderBy)) { sort = orderBy; } SqlParameter[] parameters = { new SqlParameter("@Tables", SqlDbType.VarChar, 1000), new SqlParameter("@PK", SqlDbType.VarChar, 100), new SqlParameter("@Fields", SqlDbType.VarChar, 1000), new SqlParameter("@Pageindex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@Filter", SqlDbType.VarChar, 1000), new SqlParameter("@Sort", SqlDbType.VarChar, 200), new SqlParameter("@RowCount", SqlDbType.Int) }; parameters[0].Value = table; parameters[1].Value = pk; parameters[2].Value = fields; parameters[3].Value = pageIndex; parameters[4].Value = pageSize; parameters[5].Value = filter; parameters[6].Value = sort; parameters[7].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.RunProcedure("SP_DividePage", parameters, "BulletinList"); rowCount = (int)parameters[7].Value; return(ds.Tables[0]); }