Esempio n. 1
0
        /// <summary>
        /// 将PagedTable的数据转化为JsonResult.
        /// </summary>
        /// <param name="data">按DataTable的分页数据</param>
        /// <returns>JsonResult对象</returns>
        public static JsonResult ToJsonResult(this PagedTable data)
        {
            JsonResult result = new TextJsonResult();

            StringBuilder sbJson = new StringBuilder();
            StringBuilder sbRows = new StringBuilder();

            sbRows.Append("[");
            JavaScriptSerializer serializer = new JavaScriptSerializer();

            foreach (DataRow row in data.Table.Rows)
            {
                sbRows.Append("{");
                foreach (DataColumn column in data.Table.Columns)
                {
                    sbRows.AppendFormat("\"{0}\":{1},", column.ColumnName, serializer.Serialize(row[column]));
                }
                sbRows.TrimEnd(',');
                sbRows.Append("},");
            }
            sbRows.TrimEnd(',');
            sbRows.Append("]");

            sbJson.AppendFormat("{{\"page\":{0},\"total\":{1},\"records\":{2},\"rows\":{3}}}",
                                data.CurrentPageIndex,
                                data.TotalPageCount,
                                data.TotalItemCount,
                                sbRows);

            result.Data = sbJson;
            result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;

            return(result);
        }
Esempio n. 2
0
        /// <summary>
        /// 将PagedTable的数据转化为JsonResult.
        /// </summary>
        /// <param name="data">按DataTable的分页数据</param>
        /// <returns>JsonResult对象</returns>
        /// <param name="isHhMmDd">是否需要时分秒 </param>
        public static JsonResult ToJsonResultWithDateTime(this PagedTable data, bool isHhMmDd)
        {
            JsonResult result = new TextJsonResult();

            StringBuilder sbJson = new StringBuilder();
            StringBuilder sbRows = new StringBuilder();

            sbRows.Append("[");
            JavaScriptSerializer serializer = new JavaScriptSerializer();

            foreach (DataRow row in data.Table.Rows)
            {
                sbRows.Append("{");
                foreach (DataColumn column in data.Table.Columns)
                {
                    if (column.DataType == typeof(DateTime))
                    {
                        DateTime time    = DateTime.Now;
                        string   strData = string.Empty;
                        if (DateTime.TryParse(row[column] + string.Empty, out time))
                        {
                            //日期是最大值 或最小值 时,设置为空
                            if (time.Year == 9999 || time.Year == default(DateTime).Year || time.Year == DateTime.MinValue.Year)
                            {
                                strData = string.Empty;
                            }
                            else
                            {
                                if (isHhMmDd)
                                {
                                    strData = time.ToString("yyyy-MM-dd HH:mm:ss");
                                }
                                else
                                {
                                    strData = time.ToString("yyyy-MM-dd");
                                }
                            }
                        }
                        else
                        {
                            strData = row[column] + string.Empty;
                        }

                        sbRows.AppendFormat("\"{0}\":{1},", column.ColumnName, serializer.Serialize(strData));
                    }
                    else
                    {
                        sbRows.AppendFormat("\"{0}\":{1},", column.ColumnName, serializer.Serialize(row[column]));
                    }
                }
                sbRows.TrimEnd(',');
                sbRows.Append("},");
            }
            sbRows.TrimEnd(',');
            sbRows.Append("]");

            sbJson.AppendFormat("{{\"page\":{0},\"total\":{1},\"records\":{2},\"rows\":{3}}}",
                                data.CurrentPageIndex,
                                data.TotalPageCount,
                                data.TotalItemCount,
                                sbRows);

            result.Data = sbJson;
            result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;

            return(result);
        }