/// <summary> /// Writes the table content to the output. /// </summary> /// <param name="dt">Table to write</param> protected void WriteDataTable(DataTable dt) { pnlContent.Controls.Add(new LiteralControl("<h3>" + dt.TableName + "</h3>")); if (!DataHelper.DataSourceIsEmpty(dt)) { // Add literal for content LiteralControl ltlContent = new LiteralControl(); pnlContent.Controls.Add(ltlContent); // Add control for pager UIPager pagerElem = (UIPager)LoadUserControl("~/CMSAdminControls/UI/Pager/UIPager.ascx"); pagerElem.ID = dt.TableName + "_pager"; pagerElem.PageSizeOptions = "1,2,5,10,25,50,100,##ALL##"; if (dt.Columns.Count > 10) { pagerElem.DefaultPageSize = 1; } else if (dt.Columns.Count > 6) { pagerElem.DefaultPageSize = 2; } pnlContent.Controls.Add(pagerElem); // Add pager connector UniPagerConnector connectorElem = new UniPagerConnector(); connectorElem.PagerForceNumberOfResults = dt.Rows.Count; pagerElem.PagedControl = connectorElem; pnlContent.Controls.Add(connectorElem); tables.Add(new object[] { dt, ltlContent, pagerElem, connectorElem }); } }
/// <summary> /// Writes the table content to the output. /// </summary> /// <param name="dt">Table to write</param> /// <param name="headerLevel">Header level</param> private void WriteDataTable(DataTable dt, int headerLevel) { WriteHeader(dt.TableName, headerLevel); if (!DataHelper.DataSourceIsEmpty(dt)) { // Add literal for content LiteralControl ltlContent = new LiteralControl(); pnlContent.Controls.Add(ltlContent); // Add control for pager UIPager pagerElem = (UIPager)LoadUserControl("~/CMSAdminControls/UI/Pager/UIPager.ascx"); pagerElem.ID = $"{dt.TableName}_{pnlContent.Controls.OfType<UIPager>().Count() + 1}_pager"; pagerElem.PageSizeOptions = "1,2,5,10,25,50,100"; if (dt.Columns.Count > 10) { pagerElem.DefaultPageSize = 1; } else if (dt.Columns.Count > 6) { pagerElem.DefaultPageSize = 2; } pnlContent.Controls.Add(pagerElem); pagerElem.ShowPageSize = false; // Add pager connector UniPagerConnector connectorElem = new UniPagerConnector(); connectorElem.PagerForceNumberOfResults = dt.Rows.Count; pagerElem.PagedControl = connectorElem; pnlContent.Controls.Add(connectorElem); tables.Add(new object[] { dt, ltlContent, pagerElem, connectorElem }); } }
public ActionResult GetDataList(int pageIndex, int pageSize) { UIPager pager = chatServier.GetDataList(pageIndex, pageSize); CommonResult <UIPager> cr = new CommonResult <UIPager>(CommonCode.Success, "请求成功", pager); //throw new Exception("Action出现了问题"); return(Json(cr, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取列表数据 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public UIPager GetDataList(int pageIndex, int pageSize) { UIPager uip = new UIPager(); EFPager <ChatHistories, DateTime> pager = new EFPager <ChatHistories, DateTime>(); pager.PageIndex = pageIndex; pager.PageSize = pageSize; //pager.WhereLambds = x => DbFunctions.DiffDays(x.CreateTime, DateTime.Now) == 0; pager.WhereLambds = x => 1 == 1; pager.IsAsc = false; pager.OrderByLambds = o => o.CreateTime; IQueryable <ChatHistories> items = LoadEntities <ChatHistories, DateTime>(pager); uip.PageSize = pager.PageSize; uip.PageIndex = pager.PageIndex; uip.TotalCount = pager.TotalCount; uip.TotalPages = pager.TotalPages; List <ChatHistoryView> list = new List <ChatHistoryView>(); foreach (var it in items) { ChatHistoryView view = new ChatHistoryView(); view.ChatContent = Utils.ReplaceIllegalWord(it.ChatContent); view.CreateTime = it.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"); view.ClientName = it.ClientName; view.IdentityMd5 = it.IdentityMd5; view.ImgIndex = it.ImgIndex; list.Add(view); } uip.ReponseObj = list.OrderBy(x => x.CreateTime).ToList(); return(uip); }
protected void WriteTablesContent() { foreach (object[] table in tables) { // Prepare the components DataTable dt = (DataTable)table[0]; LiteralControl ltlContent = (LiteralControl)table[1]; UIPager pagerElem = (UIPager)table[2]; UniPagerConnector connectorElem = (UniPagerConnector)table[3]; // Handle the different types of direct page selector int currentPageSize = pagerElem.CurrentPageSize; if (currentPageSize > 0) { if ((float)connectorElem.PagerForceNumberOfResults / (float)currentPageSize > 20.0f) { pagerElem.DirectPageControlID = "txtPage"; } else { pagerElem.DirectPageControlID = "drpPage"; } } // Bind the pager first connectorElem.RaiseOnPageBinding(null, null); // Prepare the string builder StringBuilder sb = new StringBuilder(); // Prepare the indexes for paging int pageSize = pagerElem.CurrentPageSize; int startIndex = (pagerElem.CurrentPage - 1) * pageSize + 1; int endIndex = startIndex + pageSize; // Process all items int index = 0; bool all = (endIndex <= startIndex); if (dt.Columns.Count > 6) { // Write all rows foreach (DataRow dr in dt.Rows) { index++; if (all || (index >= startIndex) && (index < endIndex)) { sb.Append("<table class=\"table table-hover\">"); // Add header sb.AppendFormat("<thead><tr class=\"unigrid-head\"><th>{0}</th><th class=\"main-column-100\">{1}</th></tr></thead><tbody>", GetString("General.FieldName"), GetString("General.Value")); // Add values foreach (DataColumn dc in dt.Columns) { object value = dr[dc.ColumnName]; // Binary columns string content = null; if ((dc.DataType == typeof(byte[])) && (value != DBNull.Value)) { byte[] data = (byte[])value; content = "<" + GetString("General.BinaryData") + ", " + DataHelper.GetSizeString(data.Length) + ">"; } else { content = ValidationHelper.GetString(value, String.Empty); } if (!String.IsNullOrEmpty(content)) { sb.AppendFormat("<tr><td><strong>{0}</strong></td><td class=\"wrap-normal\">", dc.ColumnName); // Possible DataTime columns if ((dc.DataType == typeof(DateTime)) && (value != DBNull.Value)) { DateTime dateTime = Convert.ToDateTime(content); CultureInfo cultureInfo = CultureHelper.GetCultureInfo(MembershipContext.AuthenticatedUser.PreferredUICultureCode); content = dateTime.ToString(cultureInfo); } // Process content ProcessContent(sb, dr, dc.ColumnName, ref content); sb.Append("</td></tr>"); } } sb.Append("</tbody></table>\n"); } } } else { sb.Append("<table class=\"table table-hover\">"); // Add header sb.Append("<thead><tr class=\"unigrid-head\">"); int h = 1; foreach (DataColumn column in dt.Columns) { sb.AppendFormat("<th{0}>{1}</th>", (h == dt.Columns.Count) ? " class=\"main-column-100\"" : String.Empty, column.ColumnName); h++; } sb.Append("</tr></thead><tbody>"); // Write all rows foreach (DataRow dr in dt.Rows) { index++; if (all || (index >= startIndex) && (index < endIndex)) { sb.Append("<tr>"); // Add values foreach (DataColumn dc in dt.Columns) { object value = dr[dc.ColumnName]; // Possible DataTime columns if ((dc.DataType == typeof(DateTime)) && (value != DBNull.Value)) { DateTime dateTime = Convert.ToDateTime(value); CultureInfo cultureInfo = CultureHelper.GetCultureInfo(MembershipContext.AuthenticatedUser.PreferredUICultureCode); value = dateTime.ToString(cultureInfo); } string content = ValidationHelper.GetString(value, String.Empty); content = HTMLHelper.HTMLEncode(content); sb.AppendFormat("<td{0}>{1}</td>", (content.Length >= 100) ? " class=\"wrap-normal\"" : String.Empty, content); } sb.Append("</tr>"); } } sb.Append("</tbody></table>\n"); } ltlContent.Text = sb.ToString(); } }