Ejemplo n.º 1
0
        /// <summary>
        /// 获得分页数据
        /// </summary>
        /// <param Name="pager">分页实体类:KingTop.Model.Pager</param>
        /// <returns></returns>
        public void PageData(KingTop.Model.Pager pager, string strModelId, string strFlowId, string strStateValue)
        {
            ModelManage sqlModelManage = new ModelManage();
            DataTable   dtModelManage  = sqlModelManage.GetList("ONE", Utils.getOneParams(strModelId));
            string      strTableName   = dtModelManage.Rows[0]["tableName"].ToString();

            SqlParameter[] prams = new SqlParameter[] {
                new SqlParameter("@Id", "ID"),
                new SqlParameter("@Table", strTableName),
                new SqlParameter("@Where", GetWhere(pager.DicWhere, strFlowId, strStateValue)),
                new SqlParameter("@Cou", "*,(SELECT Name FROM K_ReviewFlowState WHERE K_ReviewFlowState.StateValue=FlowState) AS StateName"),
                new SqlParameter("@NewPageIndex", pager.PageIndex),
                new SqlParameter("@PageSize", pager.PageSize),
                new SqlParameter("@order", "ID DESC"),
                new  SqlParameter("@isSql", 0),
                new  SqlParameter("@strSql", "")
            };


            DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
                                                  CommandType.StoredProcedure, "proc_Pager", prams);

            pager.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
            pager.PageData(ds.Tables[1]);
        }
Ejemplo n.º 2
0
        // 分页控件数据绑定
        private void SplitDataBind()
        {
            Dictionary <string, string> dicWhere = new Dictionary <string, string>();

            KingTop.Model.Pager p = new KingTop.Model.Pager();
            KingTop.BLL.SysManage.UserGropManage objUserGrop = new KingTop.BLL.SysManage.UserGropManage();

            if (StrKeySearch != "")
            {
                dicWhere.Add("UserGroupName", Utils.UrlDecode(StrKeySearch));
                txtSearch.Text = StrKeySearch;
            }

            //如果不是超级管理员,则只显示自己用户组以下的用户
            string userId = LoginInfoHelper.GetLoginAccountId(Session, Response);

            if (userId != "0")
            {
                DataTable dt = bllUserGrop.GetList("LOGINUSERGROP", Utils.getTwoParams(SiteID.ToString(), userId)).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    dicWhere.Add("NumCode", dt.Rows[0]["NumCode"].ToString());
                }
            }

            dicWhere.Add("SiteID", SiteID.ToString());
            p.Aspnetpage  = Split;
            p.RptControls = rptUserGropeList;
            p.DicWhere    = dicWhere;

            //把表保存到临时内存中
            dsUserGroupRole = bllUserGrop.GetList("GROUPANDROLENAME", Utils.getOneParams(SiteID.ToString()));
            //dsUserGroupName = BllgroupRole.GetUserGroupRole(p);
            objUserGrop.PageData(p, 1);
        }
Ejemplo n.º 3
0
        // 分页控件数据绑定
        private void SplitDataBind()
        {
            Dictionary <string, string> dicWhere = new Dictionary <string, string>();

            KingTop.Model.Pager p = new KingTop.Model.Pager();
            if (StrKeySearch != "")
            {
                dicWhere.Add("UserName", Utils.UrlDecode(StrKeySearch));
                txtSearch.Text = StrKeySearch;
            }

            //如果不是超级管理员,则只显示自己用户组以下的用户
            string userId = LoginInfoHelper.GetLoginAccountId(Session, Response);

            if (userId != "0")
            {
                UserGroup bllUserGrop = new UserGroup();
                DataTable dt          = bllUserGrop.GetList("LOGINUSERGROP", Utils.getTwoParams(SiteID.ToString(), userId)).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    dicWhere.Add("NumCode", dt.Rows[0]["NumCode"].ToString());
                    ourNumCode = dt.Rows[0]["NumCode"].ToString();
                    //strUserGrop = dt.Rows[0]["UserGroupCode"].ToString();
                }
                dicWhere.Add("UserID", userId);
            }

            dicWhere.Add("SiteID", this.SiteID.ToString());
            p.DicWhere    = dicWhere;
            p.Aspnetpage  = Split;
            p.RptControls = RptUser;
            BllAccount.PageData(p, 2);
        }
Ejemplo n.º 4
0
        public string SplitSQLPacking(KingTop.Model.Pager pager, string tableName, string sqlField, string sqlWhere, string sqlOrder, string sqlFieldForignData)
        {
            StringBuilder   splitSQL; // 分页SQL语句
            string          outOrder;
            Regex           reg;
            MatchCollection matchCollection;

            // 匹配表名
            reg      = new Regex(@"\s+(?<1>[0-9a-zA-Z_]+)\.[0-9a-zA-Z_]+\s+");
            splitSQL = new StringBuilder();

            matchCollection = reg.Matches(sqlOrder);
            outOrder        = sqlOrder;
            // 格式化外表引用字段

            sqlField = FormatField(sqlField, sqlFieldForignData);

            // 由排序创建表联合后的外排序

            foreach (Match match in matchCollection)
            {
                outOrder = sqlOrder.Replace(match.Groups[1].Value, "A");
            }

            // 记录总数
            splitSQL.Append("select count(1) from ");
            splitSQL.Append(tableName);
            if (!string.IsNullOrEmpty(sqlWhere.Trim()))
            {
                splitSQL.Append(" where ");
                splitSQL.Append(sqlWhere);
            }
            splitSQL.Append(";");

            // 分页SQL
            splitSQL.Append("select * from (");
            splitSQL.Append("select row_number() over(order by ");
            splitSQL.Append(sqlOrder);
            splitSQL.Append(") as RowNum,");
            splitSQL.Append(sqlField);
            splitSQL.Append(" from ");
            splitSQL.Append(tableName);
            if (!string.IsNullOrEmpty(sqlWhere.Trim()))
            {
                splitSQL.Append(" where ");
                splitSQL.Append(sqlWhere);
            }
            splitSQL.Append(")A where ");
            splitSQL.Append(" A.RowNum between ");
            splitSQL.Append(pager.PageSize * (pager.PageIndex - 1) + 1);
            splitSQL.Append(" and ");
            splitSQL.Append(pager.PageSize * pager.PageIndex);
            splitSQL.Append(" order by ");
            splitSQL.Append(outOrder);

            return(splitSQL.ToString());
        }
Ejemplo n.º 5
0
        public void PageData(KingTop.Model.Pager pager, Hashtable hsWhereEqual, Hashtable hsWhereLike, string sort)
        {
            StringBuilder       selSQL;         // 查询SQL
            string              selTotalSQL;    // 查询所有记录条数SQL
            List <SqlParameter> selParam;       // 查询参数
            DataSet             ds;

            selSQL   = new StringBuilder();
            selParam = new List <SqlParameter>();

            selSQL.Append("ModelFieldType=@ModelFieldType");            // 一般模型字段

            selParam.Add(new SqlParameter("@ModelFieldType", 1));

            foreach (string key in hsWhereEqual.Keys)   // 添加查询条件
            {
                if (hsWhereEqual[key] != null && !string.IsNullOrEmpty(hsWhereEqual[key].ToString().Trim()))
                {
                    selSQL.Append(" and " + key + "=@" + key);
                }
                selParam.Add(new SqlParameter("@" + key, hsWhereEqual[key]));
            }

            foreach (string key in hsWhereLike.Keys)    // 添加搜索条件
            {
                selSQL.Append(" and " + key + "  like '%" + hsWhereLike[key] + "%' ");
            }

            selTotalSQL = "select count(*) from  K_ModelField where " + selSQL.ToString() + ";";

            if (!string.IsNullOrEmpty(sort))    // 加入自定义排序

            {
                selSQL.Insert(0, "select T.* from (select ROW_NUMBER() over(order by " + sort + ") as IndexNum,ID,Name,ModelFieldGroupId,IsRequired,FieldAlias,BasicField,IsSystemFiierd,IsDel,IsEnable,Orders,IsListEnable,IsSearch,IsInputValue from K_ModelField where ");
            }
            else // 默认排序
            {
                selSQL.Insert(0, "select T.* from (select ROW_NUMBER() over(order by orders asc) as IndexNum,ID,Name,ModelFieldGroupId,IsRequired,FieldAlias,BasicField,IsSystemFiierd,IsDel,IsEnable,Orders,IsListEnable,IsSearch,IsInputValue from K_ModelField where ");
            }

            if (!string.IsNullOrEmpty(sort))    // 加入自定义排序

            {
                selSQL.Append(")T where T.IndexNum Between " + (pager.PageIndex - 1) * pager.PageSize + " and " + pager.PageSize * pager.PageIndex + " order by T." + sort.Trim() + ";");
            }
            else // 默认排序
            {
                selSQL.Append(")T where T.IndexNum Between " + (pager.PageIndex - 1) * pager.PageSize + " and " + pager.PageSize * pager.PageIndex + " order by T.orders asc;");
            }

            selSQL.Insert(0, selTotalSQL);

            ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, selSQL.ToString(), selParam.ToArray());
            pager.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
            pager.PageData(ds.Tables[1]);
        }
        // 分页控件数据绑定
        private void SplitDataBind(Dictionary <string, string> dicWhere)
        {
            KingTop.Model.Pager             p         = new KingTop.Model.Pager();
            KingTop.BLL.Content.ModelManage objsource = new KingTop.BLL.Content.ModelManage();

            p.Aspnetpage  = Split;
            p.RptControls = rptModelManage;
            p.DicWhere    = dicWhere;
            objsource.PageData(p);
        }
Ejemplo n.º 7
0
 public DataSet GetUserGroupRole(KingTop.Model.Pager pager, int SiteID)
 {
     SqlParameter[] prams = new SqlParameter[] {
         new SqlParameter("@NewPageIndex", pager.PageIndex),
         new SqlParameter("@PageSize", pager.PageSize),
         new SqlParameter("@SiteID", SiteID)
     };
     return(SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
                                     CommandType.StoredProcedure, "PROC_GetUserGroupName", prams));
 }
Ejemplo n.º 8
0
        public void PageData(KingTop.Model.Pager pager, string tbName)
        {
            AddSpecialSqlWhere();                                       // 添加特殊条件

            if (!string.IsNullOrEmpty(this._deliverAndSearchUrlParam))  // 添加传递的URL参数条件
            {
                dal.GetKeepUrlParam(ref this._sqlWhere, this.tableName, this._deliverAndSearchUrlParam, filterUrlParam, HttpContext.Current.Request.QueryString);
            }

            dal.PageData(pager, tbName, this._sqlField, this._sqlWhere, this._sqlOrder, this._sqlFieldForignData);
        }
Ejemplo n.º 9
0
        /// <summary>
        /// 获得分页数据
        /// </summary>
        public void PageData(KingTop.Model.Pager pager, string tableName, string sqlField, string sqlWhere, string sqlOrder, string sqlFieldForignData)
        {
            string sql;

            sql = SplitSQLPacking(pager, tableName, sqlField, sqlWhere, sqlOrder, sqlFieldForignData);
            sql = Regex.Replace(sql, @"(?<3>(?<1>[0-9a-zA-Z_]+)\.(?<2>[0-9a-zA-Z_]+))", "${1}.[${2}]");                // 格式化SQL中的字段名成[字段名]格式
            DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
                                                  CommandType.Text, sql);

            pager.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
            pager.PageData(ds.Tables[1]);
        }
Ejemplo n.º 10
0
        /// <summary>
        /// 获得分页数据
        /// </summary>
        /// <param Name="pager">分页实体类:KingTop.Model.Pager</param>
        /// <returns></returns>
        public void PageData(KingTop.Model.Pager pager)
        {
            SqlParameter[] prams = new SqlParameter[] {
                new SqlParameter("@NewPageIndex", pager.PageIndex),
                new SqlParameter("@PageSize", pager.PageSize)
            };
            DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
                                                  CommandType.StoredProcedure, "proc_GetDataTableInfo", prams);

            pager.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
            pager.PageData(ds.Tables[1]);
        }
        private void PageData()
        {
            Dictionary <string, string> dcWhere = new Dictionary <string, string>();

            dcWhere.Add("RecyclingManageID", strPid);
            KingTop.Model.Pager p = new KingTop.Model.Pager();
            p.Aspnetpage  = AspNetPager1;
            p.SearField   = "*,(select tablename from K_RecyclingManage where ID=AssociatedID) as tableName";
            p.RptControls = rptModelFileGroup;
            p.DicWhere    = dcWhere;
            bllRecyclingAssociated.PageData(p);
        }
        // 分页控件数据绑定
        private void SplitDataBind()
        {
            KingTop.Model.Pager p;         // 分页控件
            Hashtable           hsWhereEqual;

            hsWhereEqual = new Hashtable();
            p            = new KingTop.Model.Pager();

            hsWhereEqual.Add("IsDel", IsDel);
            p.Aspnetpage  = Split;
            p.RptControls = rptModelField;
            commonField.PageData(p, hsWhereEqual, GetSearch(), Sort);
        }
Ejemplo n.º 13
0
        // 分页控件数据绑定
        private void SplitDataBind()
        {
            Dictionary <string, string> dicWhere = new Dictionary <string, string>();

            KingTop.Model.Pager p = new KingTop.Model.Pager();
            if (StrKeySearch != "")
            {
                dicWhere.Add(Utils.UrlDecode(Request.QueryString["searchType"]), Utils.UrlDecode(StrKeySearch));
                txtSearch.Text = StrKeySearch;
            }
            p.Aspnetpage  = Split;
            p.RptControls = rptActionList;
            p.DicWhere    = dicWhere;
            objActionPermit.PageData(p, 1, SiteID);
        }
Ejemplo n.º 14
0
        private void PageData()
        {
            Dictionary <string, string> dcWhere = new Dictionary <string, string>();

            if (StrKeySearch != "")
            {
                dcWhere.Add("tableName", Utils.UrlDecode(StrKeySearch));
                txtGroupName.Text = StrKeySearch;
            }
            KingTop.Model.Pager p = new KingTop.Model.Pager();
            p.Aspnetpage  = AspNetPager1;
            p.RptControls = rptModelFileGroup;
            p.DicWhere    = dcWhere;
            bllRecyclingManage.PageData(p);
        }
        // 分页控件数据绑定
        private void SplitDataBind()
        {
            Dictionary <string, string> dicWhere = new Dictionary <string, string>();

            KingTop.Model.Pager p = new KingTop.Model.Pager();

            if (StrKeySearch != "")
            {
                dicWhere.Add("TemplateName", Utils.UrlDecode(StrKeySearch));
                txtSearch.Text = StrKeySearch;
            }

            p.Aspnetpage  = Split;
            p.RptControls = rptTemplateList;
            p.DicWhere    = dicWhere;
            bllTemplate.PageData(p);
        }
Ejemplo n.º 16
0
        /// <summary>
        /// 获得分页数据
        /// </summary>
        /// <param name="pager">分页实体类:KingTop.Model.Pager</param>
        /// <returns></returns>
        public void PageData(KingTop.Model.Pager pager)
        {
            SqlParameter[] prams = new SqlParameter[]{
                new SqlParameter("@Id","ID"),
                new SqlParameter("@Table","K_TemplateProject"),
                new SqlParameter("@Where",GetWhere(pager.DicWhere)),
                new SqlParameter("@Cou","*"),
                new SqlParameter("@NewPageIndex",pager.PageIndex),
                new SqlParameter("@PageSize",pager.PageSize),
                new SqlParameter("@order","ID DESC"),
                new  SqlParameter("@isSql",0),
                new  SqlParameter("@strSql","")
            };

            DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
                      CommandType.StoredProcedure, "proc_Pager", prams);
            pager.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
            pager.PageData(ds.Tables[1]);
        }
Ejemplo n.º 17
0
        private void PageData()
        {
            Dictionary <string, string> dcWhere = new Dictionary <string, string>();

            if (StrKeySearch != "")
            {
                dcWhere.Add("title", Utils.UrlDecode(StrKeySearch));
                txtGroupName.Text = StrKeySearch;
            }
            if (strPid != "" && strPid != "0")
            {
                dcWhere.Add("tableName2", strPid);
                ddlTable.SelectedValue = strPid;
            }
            KingTop.Model.Pager p = new KingTop.Model.Pager();
            p.Aspnetpage  = AspNetPager1;
            p.RptControls = rptModelFileGroup;
            p.DicWhere    = dcWhere;
            bllRecyclingManage.PageNewsData(p);
        }
Ejemplo n.º 18
0
        /// <summary>
        /// 使用SQL语句获得分页数据
        /// </summary>
        /// <param Name="pager">分页实体类:KingTop.Model.Pager</param>
        /// <returns></returns>
        public void PageData(KingTop.Model.Pager pager, int StrNumber)
        {
            SqlParameter[] prams = new SqlParameter[] {
                new SqlParameter("@Id", ""),
                new SqlParameter("@Table", ""),
                new SqlParameter("@Where", ""),
                new SqlParameter("@Cou", ""),
                new SqlParameter("@NewPageIndex", pager.PageIndex),
                new SqlParameter("@PageSize", pager.PageSize),
                new SqlParameter("@order", "UserID asc"),
                new  SqlParameter("@isSql", 1),
                new  SqlParameter("@strSql", GetStrSqlByNumber(StrNumber))
            };

            DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
                                                  CommandType.StoredProcedure, "proc_Pager", prams);

            pager.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
            pager.PageData(ds.Tables[1]);
        }
Ejemplo n.º 19
0
        private void PageData()
        {
            Dictionary <string, string> dcWhere = new Dictionary <string, string>();

            if (StrKeySearch != "")
            {
                dcWhere.Add("Name", StrKeySearch);
                txtGroupName.Text = strKeySearch;
            }
            if (StrModelId != "" && StrModelId != "-1")
            {
                dcWhere.Add("ModelId", StrModelId);
                ddlModelList.SelectedValue = StrModelId;
            }
            KingTop.Model.Pager p = new  KingTop.Model.Pager();
            p.Aspnetpage  = AspNetPager1;
            p.RptControls = rptModelFileGroup;
            p.DicWhere    = dcWhere;
            bllModelFieldGroup.PageData(p);
        }
Ejemplo n.º 20
0
        /// <summary>
        /// 使用SQL语句获得分页数据
        /// </summary>
        /// <param Name="pager">分页实体类:KingTop.Model.Pager</param>
        /// <returns></returns>
        public void PageData(KingTop.Model.Pager pager, int StrNumber)
        {
            SqlParameter[] prams = new SqlParameter[] {
                new SqlParameter("@Id", ""),
                new SqlParameter("@Table", ""),
                new SqlParameter("@Where", ""),
                new SqlParameter("@Cou", ""),
                //new SqlParameter("@NewPageIndex",pager.PageIndex),
                new SqlParameter("@NewPageIndex", Utils.ParseInt(System.Web.HttpContext.Current.Request.QueryString["page"], 1)),
                new SqlParameter("@PageSize", pager.PageSize),
                new SqlParameter("@order", "Orders DESC,UserID DESC"),
                new  SqlParameter("@isSql", 1),
                new  SqlParameter("@strSql", GetStrSqlByNumber(StrNumber, pager.DicWhere))
            };

            DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
                                                  CommandType.StoredProcedure, "proc_Pager", prams);

            pager.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
            pager.PageData(ds.Tables[1]);
        }
Ejemplo n.º 21
0
        /// <summary>
        /// 获得分页数据
        /// </summary>
        /// <param Name="pager">分页实体类:KingTop.Model.Pager</param>
        /// <returns></returns>
        public void PageData(KingTop.Model.Pager pager)
        {
            SqlParameter[] prams = new SqlParameter[] {
                new SqlParameter("@Id", "ID"),
                new SqlParameter("@Table", "K_ModelFieldGroup"),
                new SqlParameter("@Where", GetWhere(pager.DicWhere)),
                new SqlParameter("@Cou", "*,(SELECT Title FROM K_ModelManage WHERE ID = ModelId) AS ModelName"),
                new SqlParameter("@NewPageIndex", pager.PageIndex),
                new SqlParameter("@PageSize", pager.PageSize),
                new SqlParameter("@order", "Orders asc"),
                new  SqlParameter("@isSql", 0),
                new  SqlParameter("@strSql", "")
            };


            DataSet ds = SQLHelper.ExecuteDataSet(SQLHelper.ConnectionStringLocalTransaction,
                                                  CommandType.StoredProcedure, "proc_Pager", prams);

            pager.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
            pager.PageData(ds.Tables[1]);
        }
Ejemplo n.º 22
0
 /// <summary>
 /// 获得分页数据
 /// </summary>
 /// <param name="pager">分页实体类:KingTop.Model.Pager</param>
 /// <returns></returns>
 public void PageData(KingTop.Model.Pager pager)
 {
     dal.PageData(pager);
 }
        // 分页控件数据绑定
        private void SplitDataBind()
        {
            KingTop.Model.Pager split;
            string[]            splitParam;
            string tempVar;    // 临时变量

            // 初始加载时的SQL各参数

            splitParam = ctrManageList.GetSQLParam(hdnCustomCol.Value, hdnShowCol.Value);

            ctrManageList.SqlWhere = splitParam[1];                   // 初始时的where

            tempVar = ctrManageList.Search();                         // 搜索栏条件
            //查询条件保存到cookies中
            if (!string.IsNullOrEmpty(tempVar))
            {
                SetModelCookies("search", Server.UrlEncode(tempVar));
            }
            else if (!string.IsNullOrEmpty(SearchWhere))
            {
                tempVar = SearchWhere;
            }

            if (!string.IsNullOrEmpty(ctrManageList.SqlWhere.Trim()) && !string.IsNullOrEmpty(tempVar))
            {
                ctrManageList.SqlWhere = ctrManageList.SqlWhere + " and " + tempVar;
            }
            else
            {
                ctrManageList.SqlWhere += tempVar;
            }

            tempVar = ctrManageList.LinkSearch();                     // 链接按钮中的搜索条件
            //查询条件保存到cookies中
            if (!string.IsNullOrEmpty(tempVar))
            {
                SetModelCookies("searchlink", Server.UrlEncode(tempVar));
            }
            else if (!string.IsNullOrEmpty(SearchlinkWhere))
            {
                tempVar = SearchlinkWhere;
            }
            if (!string.IsNullOrEmpty(ctrManageList.SqlWhere.Trim()) && !string.IsNullOrEmpty(tempVar))
            {
                ctrManageList.SqlWhere = ctrManageList.SqlWhere + " and " + tempVar;
            }
            else
            {
                ctrManageList.SqlWhere += tempVar;
            }


            ctrManageList.SqlOrder = splitParam[3];                  // 初始时的order by
            tempVar = BLL.Content.ControlManageList.GetClientSort(); // 列表标题排序

            if (tempVar.Contains(".Orders"))                         // 排序字段排序列
            {
                if (!string.IsNullOrEmpty(ctrManageList.SqlOrder.Trim()) && !string.IsNullOrEmpty(tempVar.Trim()) && tempVar.Contains(".Orders asc"))
                {
                    ctrManageList.SqlOrder = ctrManageList.SqlOrder.Replace(".Orders desc", ".Orders asc");
                }

                if (!string.IsNullOrEmpty(ctrManageList.SqlOrder.Trim()) && !string.IsNullOrEmpty(tempVar.Trim()) && tempVar.Contains(".Orders desc"))
                {
                    ctrManageList.SqlOrder = ctrManageList.SqlOrder.Replace(".Orders asc", ".Orders desc");
                }
            }
            else // 其它字段排序
            {
                if (!string.IsNullOrEmpty(ctrManageList.SqlOrder.Trim()) && !string.IsNullOrEmpty(tempVar.Trim()))
                {
                    ctrManageList.SqlOrder = tempVar + "," + ctrManageList.SqlOrder;
                }
                else
                {
                    ctrManageList.SqlOrder = tempVar + ctrManageList.SqlOrder;
                }
            }


            // 初始加载时选取的字段
            int page = 1;

            if (pageindex > 0)
            {
                page = pageindex;
            }
            else if (!string.IsNullOrEmpty(Request.QueryString["page"]))
            {
                page = Utils.ParseInt(Request.QueryString["page"], 1);
            }
            else if (!string.IsNullOrEmpty(ModelPageNum))
            {
                page = Utils.ParseInt(ModelPageNum, 1);
            }
            ctrManageList.SqlField = splitParam[2];
            // 基本字段中引用外表数据的字段参数
            ctrManageList.SqlFieldForignData = hdnForignTableCol.Value;
            split             = new KingTop.Model.Pager();
            split.PageIndex   = page;
            split.Aspnetpage  = Split;
            split.RptControls = rptListInfo;
            ctrManageList.PageData(split, splitParam[0]);
        }
Ejemplo n.º 24
0
 public DataSet GetUserGroupRole(KingTop.Model.Pager pager, int SiteID)
 {
     return(dal.GetUserGroupRole(pager, SiteID));
 }
Ejemplo n.º 25
0
 public void PageData(KingTop.Model.Pager pager, string strModelId, string strFlowId, string strStateValue)
 {
     dal.PageData(pager, strModelId, strFlowId, strStateValue);
 }
Ejemplo n.º 26
0
 /// <summary>
 /// 用SQL语句获得分页数据
 /// </summary>
 /// <param name="pager">分页实体类:KingTop.Model.Pager</param>
 /// <returns></returns>
 public void PageData(KingTop.Model.Pager pager, int StrNumber, int SiteID)
 {
     dal.PageData(pager, StrNumber, SiteID);
 }
Ejemplo n.º 27
0
 public void PageData(KingTop.Model.Pager pager, int strNumber)
 {
     dal.PageData(pager, strNumber);
 }