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); } }