/// <summary> /// 获取实体分页 /// </summary> public DataTable GetCall_FAQList(Call_FAQListTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount) { string table = " [Call_FAQList] "; string pk = " CF_ID "; string fields = " * "; string filter = "1=1";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal); #region 组织查询条件 if (TO.CF_SoftTypeID > 0) { filter += string.Format(" and CF_SoftTypeID = {0} ", TO.CF_SoftTypeID); } if (!string.IsNullOrEmpty(TO.CF_ErrorList)) { filter += string.Format(" and CF_ErrorList like '%{0}%' ", StringHelper.SQLFilter(TO.CF_ErrorList)); } if (TO.CF_AddDate > Convert.ToDateTime("1980-01-01")) { filter += string.Format(" and CF_AddDate >= '{0}' ", TO.CF_AddDate.ToString("yyyy-MM-dd")); } if (TO.CF_EndDate > Convert.ToDateTime("1980-01-01")) { filter += string.Format(" and CF_AddDate < '{0}' ", TO.CF_EndDate.AddDays(1).ToString("yyyy-MM-dd")); } #endregion string sort = " CF_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, "Call_FAQList"); rowCount = (int)parameters[7].Value; return(ds.Tables[0]); }
/// <summary> /// 获得数据列表分页 /// </summary> /// <returns></returns> public DataTable GetCall_FAQListList(Call_FAQListTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount) { return(service.GetCall_FAQList(TO, pageIndex, pageSize, orderBy, out rowCount)); }
private void DataBind() { Call_FAQListTO sto = new Call_FAQListTO(); #region 条件 if (!string.IsNullOrEmpty(Request["sltType"])) { sto.CF_SoftTypeID = Convert.ToInt32(Request["sltType"].ToString().Trim());//类型 } if (!string.IsNullOrEmpty(Request["pErrorList"])) { sto.CF_ErrorList = Request["pErrorList"].ToString().Trim();//标题 } //else // sto.CF_SoftTypeID = Convert.ToInt32(Request["uname"].ToString().Trim());//存 用户名称 if (!string.IsNullOrEmpty(Request["stime"])) { DateTime dtStime = Convert.ToDateTime("1980-01-01"); DateTime.TryParse(Request["stime"].ToString().Trim(), out dtStime); sto.CF_AddDate = dtStime;//保存操作开始时间 } if (!string.IsNullOrEmpty(Request["etime"])) { DateTime dtEtime = Convert.ToDateTime("2250-01-01"); DateTime.TryParse(Request["etime"].ToString().Trim(), out dtEtime); sto.CF_EndDate = dtEtime;//保存操作结束时间 } #endregion if (!string.IsNullOrEmpty(Request.QueryString["pageIndex"])) { int.TryParse(Request.QueryString["pageIndex"], out pageIndex); } HYTD.BLL.Call_FAQListBLL bll = new HYTD.BLL.Call_FAQListBLL(); DataTable dt = bll.GetCall_FAQListList(sto, pageIndex, pageSize, "", out rowCount); //分页 string getUrl = ""; if (Request.Url.Query.Length > 0 && Request.Url.Query.IndexOf("pageIndex") > -1 && Request.Url.Query.IndexOf("&") > -1) { getUrl = Request.Url.Query.Substring(Request.Url.Query.IndexOf("&")); } else if (Request.Url.Query.Length > 0) { getUrl = Request.Url.Query.Substring(1); } string url = "FAQList.aspx?pageIndex={0}&" + getUrl.Trim('&'); strtt = DividePage.Pager(pageSize, rowCount, pageIndex, url); if (dt.Rows.Count > 0) { int num = 0; StringBuilder sbContent = new StringBuilder(); //string strNew = string.Empty; string strEdit = string.Empty; string strDelete = string.Empty; foreach (DataRow dr in dt.Rows) { num++; //strNew = string.Format("<a href=\"javascript:;\" name=\"NewFAQ\" onclick=\"NewFAQ({0})\" >新建</a> ", dr["CF_ID"]); strEdit = string.Format("<a href=\"javascript:;\" name=\"EditFAQ\" onclick=\"EditFAQ({0})\">修改</a>", dr["CF_ID"].ToString()); strDelete = string.Format("<a href=\"javascript:;\" name=\"DeleteFAQ\" onclick=\"DeleteFAQ({0})\">删除</a>", dr["CF_ID"].ToString()); sbContent.AppendFormat("<tbody>"); sbContent.AppendFormat("<tr>"); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", num); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\"><a href=\"javascript:;\" onclick=\"ShowFAQ({1})\">{0}</a></td>", dr["CF_ErrorList"].ToString(), dr["CF_ID"].ToString()); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CF_Describe"]); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", dr["CF_AddDate"]); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", getSoftTypename(dr["CF_SoftTypeID"].ToString())); sbContent.AppendFormat("<td class=\"num\" title=\"{0}\">{0} </td>", getUsername(dr["CF_UserID"].ToString())); sbContent.AppendFormat("<td class=\"num\">{0} {1}</td>", strEdit, strDelete); sbContent.AppendFormat("</tr>"); sbContent.AppendFormat("</tbody>"); } script = sbContent.ToString(); } else { script = "没有搜索到相关内容!"; } //获取当前页 //if (rowCount % pageSize == 0) //{ // pageNum = rowCount / pageSize; //} //else //{ // pageNum = (rowCount / pageSize) + 1; //} }