private void GetDepartList()
{
DepartmentTO to = new DepartmentTO();
if (!string.IsNullOrEmpty(Request.Form["DepartName"]))
{
to.RoleName = DepartName = Request.Form["DepartName"];
}
string orderBy = "";
if (!string.IsNullOrEmpty(Request.Form["hidDepartName"]))
{
pageIndex = Convert.ToInt32(Request.Form["hidPosit"]);
}
else
{
if (!string.IsNullOrEmpty(Request.QueryString["pageIndex"]))
{
pageIndex = Convert.ToInt32(Request.QueryString["pageIndex"]);
}
}
DataTable dt = new DepartmentBLL().GetDepartmentList(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["RoleName"]);
sb.AppendFormat("<td><span class=\"bottom cl_block\"><a style=\"color:#3B96D3;\" href=\"javascript:void(0)\" onclick=\"UpdatePosit({0})\">修改</a>   <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>   <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>");
}
DepartList = sb.ToString();
string url = "PositionList.aspx?pageIndex={0}";
if (!string.IsNullOrEmpty(DepartName))
{
url += "&DepartName=" + DepartName;
}
DepartPage = DivPage.Pager(pageSize, rowCount, pageIndex, url);
}
/// <summary>
/// 获取实体分页
/// </summary>
public DataTable GetDepartmentList(DepartmentTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
string table = " [Department] ";
string pk = " ID ";
string fields = " * ";
string filter = " 1=1 ";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal);
#region 组织查询条件
if (!string.IsNullOrEmpty(TO.RoleName))
{
filter += string.Format(" and RoleName like '%{0}%' ", StringHelper.SQLFilter(TO.RoleName));
}
#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, "DepartmentList");
rowCount = (int)parameters[7].Value;
return(ds.Tables[0]);
}
protected string GetDep()
{
int totalCount = 0;
int pageIndex = 1;
if (pageIndex == 0)
{
pageIndex = 1;
}
int pageSize = 15;
string orderBy = " ";
StringBuilder sbHtml = new StringBuilder();
sbHtml.Append(" <a onclick=\"SearchUser(0,0)\">全部</a> |");
BLL.DepartmentBLL bllDep = new DepartmentBLL();
DepartmentTO depTo = new DepartmentTO();
DataTable dtDep = bllDep.GetDepartmentList(depTo, pageIndex, pageSize, "", out totalCount);
if (dtDep.Rows.Count > 0)
{
int flag = 0;
foreach (DataRow drDep in dtDep.Rows)
{
string depName = drDep["roleName"].ToString();
string depId = drDep["id"].ToString();
if (flag == dtDep.Rows.Count - 1)
{
sbHtml.Append(" <a onclick=\"SearchUser(0," + depId + ")\">" + depName + "</a> ");
}
else
{
sbHtml.Append(" <a onclick=\"SearchUser(0," + depId + ")\">" + depName + "</a> |");
}
flag++;
}
}
return(sbHtml.ToString());
}
/// <summary>
/// 获得数据列表分页
/// </summary>
/// <returns></returns>
public DataTable GetDepartmentList(DepartmentTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
return(service.GetDepartmentList(TO, pageIndex, pageSize, orderBy, out rowCount));
}
