Exemple #1
0
    /// <summary>
    /// 职位列表
    /// </summary>
    private void GetPositionList()
    {
        PositionTO to = new PositionTO();

        if (!string.IsNullOrEmpty(Request.Form["PositName"]))
        {
            to.Name = pName = Request.Form["PositName"];
        }
        string orderBy = "";

        if (!string.IsNullOrEmpty(Request.Form["hidPosit"]))
        {
            pageIndex = Convert.ToInt32(Request.Form["hidPosit"]);
        }
        else
        {
            if (!string.IsNullOrEmpty(Request.QueryString["pageIndex"]))
            {
                pageIndex = Convert.ToInt32(Request.QueryString["pageIndex"]);
            }
        }
        DataTable     dt = new PositionBLL().GetPositionList(to, pageIndex, pageSize, orderBy, out rowCount);
        StringBuilder sb = new StringBuilder();

        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr = dt.Rows[i];
                if (i % 2 == 0)
                {
                    sb.Append("<tr bgcolor=\"#f8f8f8\">");
                }
                else
                {
                    sb.Append("<tr>");
                }
                sb.AppendFormat("<td height=\"40\" align=\"center\"><span class=\"line\" style=\"COLOR: #666;\">{0}</span></td>", i + 1);
                sb.AppendFormat("<td><span class=\"line cl_sp\" style=\"COLOR: #666;\">{0}</span><span class=\"line cl_inp\" style=\"COLOR: #666;display:none;\"><input type=\"text\" value=\"{0}\" style=\"width:120px;\"/></span></td>", dr["Name"]);
                sb.AppendFormat("<td><span class=\"bottom cl_block\"><a style=\"color:#3B96D3;\"  href=\"javascript:void(0)\" onclick=\"UpdatePosit({0})\">修改</a> &nbsp <a style=\"color:#3B96D3;\" onclick=\"delPosition('{1}')\"  href=\"javascript:void(0)\">删除</a></span> <span class=\"bottom cl_none\" style=\"display:none;\"><a style=\"color:#3B96D3;\"  href=\"javascript:void(0)\" onclick=\"SavePosit({0},'{1}')\">保存</a> &nbsp <a style=\"color:#3B96D3;\"  href=\"javascript:void(0)\" onclick=\"CanclePosit({0})\">取消</a></span> </td></tr>", i, dr["ID"]);
            }
        }
        else
        {
            sb.Append("<tr bgcolor=\"#f8f8f8\"><td colspan=\"10\"><span class=\"line\">没有相关信息!</span></td></tr>");
        }
        positList = sb.ToString();
        string url = "PositionList.aspx?pageIndex={0}";

        if (!string.IsNullOrEmpty(pName))
        {
            url += "&PositName=" + pName;
        }
        PageList = DivPage.Pager(pageSize, rowCount, pageIndex, url);
    }
Exemple #2
0
        /// <summary>
        /// 获取实体分页
        /// </summary>
        public DataTable GetPositionList(PositionTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
        {
            string table  = " [Position] ";
            string pk     = " ID ";
            string fields = " * ";
            string filter = " 1=1 ";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal);

            #region 组织查询条件


            if (!string.IsNullOrEmpty(TO.Name))
            {
                filter += string.Format(" and Name like '%{0}%' ", StringHelper.SQLFilter(TO.Name));
            }

            #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, "PositionList");
            rowCount = (int)parameters[7].Value;
            return(ds.Tables[0]);
        }
Exemple #3
0
 /// <summary>
 /// 获得数据列表分页
 /// </summary>
 /// <returns></returns>
 public DataTable GetPositionList(PositionTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
 {
     return(service.GetPositionList(TO, pageIndex, pageSize, orderBy, out rowCount));
 }