public ActionResult TeacherList()
{
int pageSize = 30;
StringBuilder strSql = new StringBuilder();
strSql.Append(" and e_LeiB = 1 ");
if (RequestBase.GetString("orgLookup.id").Trim() != "")
{
strSql.AppendFormat(" and d_ID='{0}' ", RequestBase.GetString("orgLookup.id").Trim());
}
if (!string.IsNullOrEmpty(RequestBase.GetString("txtEMingc")))
{
strSql.AppendFormat(" and e_MingC like '" + RequestBase.GetString("txtEMingc").Trim() + "%'");
}
DBUtility.Pagination pagination = new DBUtility.Pagination();
try
{
if (!string.IsNullOrEmpty(RequestBase.GetString("pageNum")))
pagination.Sequence = Convert.ToInt32(RequestBase.GetString("pageNum"));
else
pagination.Sequence = 1;
pagination.ItemUnit = "条记录";
pagination.SortSentence = "";
pagination.Primarykey = "e_ID";
pagination.SearchField = "*";
pagination.TableName = "vw_EmployeeBase";
pagination.PageSize = pageSize;
pagination.UrlStr = "";
pagination.ImagesPath = "../_imgs/grid/";
pagination.SearchSentence = strSql.ToString();
this.ViewData["PageList"] = pagination.GetDataTable();
this.ViewData["TotalCount"] = pagination.RecordCount.ToString();
this.ViewData["NumberPage"] = pageSize.ToString();
this.ViewData["PagenumShown"] = pagination.PageCount.ToString();
this.ViewData["CurrentPage"] = pagination.Sequence.ToString();
this.ViewData["OrderFile"] = RequestBase.GetString("orderField");
this.ViewData["OrderDirection"] = RequestBase.GetString("orderDirection");
return View();
}
catch (Exception err)
{
return View(err.Message);
}
}
public ActionResult SelectEmployeeList()
{
int pageSize = 10;
StringBuilder strSql = new StringBuilder();
strSql.Append(" and el_Code= '00060001' and e_StateCode=0 and e_DeleteStateCode=0");
if (RequestBase.GetString("d_ID").Trim() != "")
{
strSql.AppendFormat(" and d_ID='{0}'", RequestBase.GetString("d_ID").Trim());
}
if (RequestBase.GetString("empName").Trim() != "")
{
strSql.AppendFormat(" and e_MingC like '{0}%' ", RequestBase.GetString("empName").Trim());
}
if (!string.IsNullOrEmpty(RequestBase.GetString("depName")))
{
strSql.AppendFormat(" and d_MingCh like '{0}%'", RequestBase.GetString("depName").Trim());
}
DBUtility.Pagination pagination = new DBUtility.Pagination();
try
{
if (!string.IsNullOrEmpty(RequestBase.GetString("pageNum")))
pagination.Sequence = Convert.ToInt32(RequestBase.GetString("pageNum"));
else
pagination.Sequence = 1;
pagination.ItemUnit = "条记录";
pagination.SortSentence = "";
pagination.Primarykey = "el_ID";
pagination.SearchField = "*";
pagination.TableName = "Vw_SelectEmployee";
pagination.PageSize = pageSize;
pagination.UrlStr = "";
pagination.ImagesPath = "../_imgs/grid/";
pagination.SearchSentence = strSql.ToString();
this.ViewData["PageList"] = pagination.GetDataTable();
this.ViewData["TotalCount"] = pagination.RecordCount.ToString();
this.ViewData["NumberPage"] = pageSize.ToString();
this.ViewData["PagenumShown"] = pagination.PageCount.ToString();
this.ViewData["CurrentPage"] = pagination.Sequence.ToString();
this.ViewData["OrderFile"] = RequestBase.GetString("orderField");
this.ViewData["OrderDirection"] = RequestBase.GetString("orderDirection");
return View();
}
catch (Exception err)
{
return View(err.Message);
}
}