public void List(int pageIndex, int stID = 0)
{
PropertyBag["params"] = new
{
STID = stID,
PageIndex = pageIndex
};
int _totalNums = 0, _pageSize = 12;
if (pageIndex < 1)
{
pageIndex = 1;
}
IList <SchoolTerm> _schoolTermList = _schoolTermService.PaginatedSchoolTerm(1, 120, "ID", "1 = 1", ref _totalNums);
PropertyBag["schoolTermList"] = _schoolTermList;
string _conAttr = "1 = 1";
if (stID > 0)
{
_conAttr += " AND STID = " + stID;
}
IList <Video> _videoList = _videoService.PaginatedVideo(pageIndex, _pageSize, "SortNum", _conAttr, ref _totalNums);
PropertyBag["videoList"] = _videoList;
string uri = "List.do?stID=" + stID + "&pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void List(string searchName, int pageIndex)
{
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
PropertyBag["params"] = new
{
PageIndex = pageIndex,
SearchName = searchName
};
int _totalNums = 0, _pageSize = 10;
string _conAttr = "1 = 1";
if (!string.IsNullOrEmpty(searchName))
{
_conAttr += " AND trueName LIKE '%" + searchName + "%'";
}
IList <ScheNotice> _scheNoticeList = _scheNoticeService.PaginatedScheNotice(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
PropertyBag["scheNoticeList"] = _scheNoticeList;
string uri = "List.do?searchName=" + searchName + "&pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void List(int catalogID, int pageIndex)
{
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
PropertyBag["params"] = new
{
CatalogID = catalogID,
PageIndex = pageIndex
};
int _totalNums = 0, _pageSize = 12;
IList <Catalog> _catalogList = _catalogService.PaginatedCatalog(1, 120, "ID", "ModuleCn = 'Article'", ref _totalNums);
PropertyBag["catalogList"] = _catalogList;
string _conAttr = "catalogID = " + catalogID + "";
IList <Article> _artilceList = _articleService.PaginatedArticle(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "List.do?catalogID=" + catalogID + "&pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["articleList"] = _artilceList;
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void List(int pageIndex)
{
PropertyBag["params"] = new
{
PageIndex = pageIndex
};
int _totalNums = 0, _pageSize = 12;
if (pageIndex < 1)
{
pageIndex = 1;
}
string _conAttr = "1 = 1";
IList <BulletinBoard> _bulletinBoardList = _bulletinBoardService.PaginatedBulletinBoard(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
PropertyBag["bulletinBoardList"] = _bulletinBoardList;
string uri = "BulletinBoardList.do?pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void List(int catalogID, int pageIndex)
{
Catalog _catalog = _catalogService.GetCatalogByID(catalogID);
if (_catalog != null)
{
int _totalNums = 0;
int _pageSize = 20;
if (pageIndex < 1)
{
pageIndex = 1;
}
string _conAttr = "catalogID = " + catalogID + "";
IList <Article> _articleList = _articleService.PaginatedArticle(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "List.do?catalogID=" + catalogID + "&pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["catalog"] = _catalog;
PropertyBag["articleList"] = _articleList;
PropertyBag["ltlShowPager"] = ltlShowPager;
}
}
public void List(int pageIndex)
{
PropertyBag["params"] = new
{
PageIndex = pageIndex
};
int _totalNums = 0, _pageSize = 12;
if (pageIndex < 1)
{
pageIndex = 1;
}
string _conAttr = "1 = 1";
IList <PhotoGraph> _photoGraphList = _photoGraphService.PaginatedPhotoGraph(pageIndex, _pageSize, "SortNum", _conAttr, ref _totalNums);
PropertyBag["photoGraphList"] = _photoGraphList;
string uri = "List.do?pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void XHrList(string searchUserName, int stID, int pageIndex)
{
PropertyBag["params"] = new
{
SearchUserName = searchUserName,
STID = stID,
PageIndex = pageIndex
};
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
int _totalNums = 0, _pageSize = 12;
string _conAttr = "1 = 1";
if (!string.IsNullOrEmpty(searchUserName))
{
_conAttr += " AND Employee.Name = '" + searchUserName + "'";
}
if (stID > 0)
{
_conAttr += " AND Registration.STID = " + stID;
}
IList <Registration> _registrationList = _registrationService.PaginatedRegistration(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "javascript:jsPaginated('" + searchUserName + "'," + stID + ",{0});";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["registrationList"] = _registrationList;
PropertyBag["ltlShowPager"] = ltlShowPager;
CancelLayout();
}
public void XHrList(string searchTrueName, int pageIndex)
{
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
PropertyBag["params"] = new
{
SearchTrueName = searchTrueName,
PageIndex = pageIndex
};
int _totalNums = 0, _pageSize = 12;
string _conAttr = "UserType = 0";
if (!string.IsNullOrEmpty(searchTrueName))
{
_conAttr += " AND trueName LIKE '%" + searchTrueName + "%'";
}
IList <Employee> _employeeList = _employeeService.PaginatedEmployee(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "javascript:jsPaginated('" + searchTrueName + "',{0});";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["employeeList"] = _employeeList;
PropertyBag["ltlShowPager"] = ltlShowPager;
CancelLayout();
}
public void XHrList(int employeeID, int stID, string examDate, int pageIndex)
{
int _totalNums = 0, _pageSize = 12;
string _conAttr = "1 = 1";
if (employeeID > 0)
{
_conAttr += " AND EmployeeID =" + employeeID;
}
if (stID > 0)
{
_conAttr += " AND STID =" + stID;
}
DateTime _examDate = DateTime.Today;
if (!string.IsNullOrEmpty(examDate) && DateTime.TryParse(examDate, out _examDate))
{
_conAttr += " AND DATEDIFF(day,ExamDate,'" + _examDate.ToString("yyyy-MM-dd") + "') = 0";
}
IList <ReportCard> _reportCardList = _reportCardService.PaginatedReportCard(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
PropertyBag["reportCardList"] = _reportCardList;
string uri = "javascript:jsPaginated(" + employeeID + "," + stID + ",'" + examDate + "',{0});";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
CancelLayout();
}
public void List(int pageIndex)
{
PropertyBag["params"] = new
{
PageIndex = pageIndex
};
int _totalNums = 0;
int _pageSize = 12;
if (pageIndex < 1)
{
pageIndex = 1;
}
string _conAttr = "1 = 1";
IList <Message> _messageList = _messageService.PaginatedMessage(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
PropertyBag["messageList"] = _messageList;
string uri = "messageList.do?pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void List(int pageIndex)
{
PropertyBag["params"] = new
{
PageIndex = pageIndex
};
int _totalNums = 0, _pageSize = 12;
if (pageIndex < 1)
{
pageIndex = 1;
}
string _conAttr = "1 = 1";
IList <Notification> _notificationList = _notificationService.PaginatedNotification(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
PropertyBag["notificationList"] = _notificationList;
string uri = "List.do?pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void MessageList(int pageIndex)
{
int _totalNums = 0;
int _pageSize = 20;
if (pageIndex < 1)
{
pageIndex = 1;
}
string _conAttr = "1 = 1";
IList <Message> _messageList = _messageService.PaginatedMessage(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "javascript:jsPaginated({0});";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["messageList"] = _messageList;
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void XHrList(int stID, int pageIndex)
{
int _totalNums = 0, _pageSize = 12;
string _conAttr = "1 = 1";
if (stID > 0)
{
_conAttr += " AND STID =" + stID;
}
IList <Syllabus> _syllabusList = _syllabusService.PaginatedSyllabus(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
PropertyBag["syllabusList"] = _syllabusList;
string uri = "javascript:jsPaginated(" + stID + ",{0});";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
CancelLayout();
}
public void Article(int catalogID, int pageIndex)
{
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
PropertyBag["params"] = new
{
CatalogID = catalogID,
PageIndex = pageIndex
};
int _totalNums = 0;
int _pageSize = 12;
string _conAttr = "CatalogID =" + catalogID;
IList <Article> _articleList = _articleService.PaginatedArticle(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "Article.do?catalogID=" + catalogID + "&pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["articleList"] = _articleList;
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void VideoList(int stID = 0, int pageIndex = 1)
{
PropertyBag["catalog"] = -1;
int _totalNums = 0, _pageSize = 12;
if (pageIndex < 1)
{
pageIndex = 1;
}
IList <SchoolTerm> _schoolTermList = _schoolTermService.PaginatedSchoolTerm(1, 120, "SchoolTerm.ID", "SchoolTerm.ID IN(SELECT [STID] FROM [JNyulu_db].[dbo].[Video](NOLOCK) WHERE Permit=0)", ref _totalNums);
PropertyBag["schoolTermList"] = _schoolTermList;
string _conAttr = "permit = 0";
if (stID > 0)
{
_conAttr += " AND STID = " + stID;
}
SchoolTerm _schoolTerm = _schoolTermService.GetBaseSchoolTermByID(stID);
if (_schoolTerm == null)
{
_schoolTerm = new SchoolTerm();
_schoolTerm.Name = "雨露微课堂";
}
PropertyBag["schoolTerm"] = _schoolTerm;
IList <Video> _videoList = _videoService.PaginatedVideo(pageIndex, _pageSize, "SortNum", _conAttr, ref _totalNums);
string uri = "VideoList.do?stID=" + stID + "&pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["videoList"] = _videoList;
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void Message(int pageIndex)
{
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
PropertyBag["params"] = new
{
PageIndex = pageIndex
};
Employee _employee = Session["logonUser"] as Employee;
int _totalNums = 0;
int _pageSize = 12;
string _conAttr = "userName = '******'";
IList <Message> _messageList = _messageService.PaginatedMessage(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "Message.do?pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["messageList"] = _messageList;
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void Notification(int pageIndex)
{
Employee _employee = Session["logonUser"] as Employee;
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
PropertyBag["params"] = new
{
PageIndex = pageIndex
};
int _totalNums = 0;
int _pageSize = 12;
string _conAttr = "Receivers LIKE '%," + _employee.Name + ",%' OR stID IN(SELECT stID FROM [JNyulu_db].[dbo].[Registration] WHERE EmployeeID = " + _employee.ID + ") OR stID = 0";
IList <Notification> _notificationList = _notificationService.PaginatedNotification(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "Notification.do?pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["notificationList"] = _notificationList;
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void BulletinBoard(int pageIndex)
{
Employee _employee = Session["logonUser"] as Employee;
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
PropertyBag["params"] = new
{
PageIndex = pageIndex
};
int _totalNums = 0;
int _pageSize = 12;
string _conAttr = "(Receiver = 0) OR Receiver IN(SELECT stID FROM Registration WHERE EmployeeID=" + _employee.ID + ")";
IList <BulletinBoard> _bulletinBoardList = _bulletinBoardService.PaginatedBulletinBoard(pageIndex, _pageSize, "ID", _conAttr, ref _totalNums);
string uri = "BulletinBoard.do?pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["bulletinBoardList"] = _bulletinBoardList;
PropertyBag["ltlShowPager"] = ltlShowPager;
}
public void Video(int pageIndex, int stID = 0)
{
Employee _employee = Session["logonUser"] as Employee;
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
PropertyBag["params"] = new
{
STID = stID,
PageIndex = pageIndex
};
int _totalNums = 0, _pageSize = 8;
IList <SchoolTerm> _schoolTermList = _schoolTermService.PaginatedSchoolTerm(1, 120, "SchoolTerm.ID", "SchoolTerm.ID IN(SELECT [STID] FROM [JNyulu_db].[dbo].[Registration](NOLOCK) WHERE [EmployeeID] = " + _employee.ID + ")", ref _totalNums);
PropertyBag["schoolTermList"] = _schoolTermList;
if (_schoolTermList != null && _schoolTermList.Count > 0 && stID == 0)
{
stID = _schoolTermList[0].ID;
}
string _conAttr = "STID IN (SELECT STID FROM [Registration] WHERE EmployeeID = " + _employee.ID + ")";
if (stID > 0)
{
_conAttr += " AND STID = " + stID;
}
IList <Video> _videoList = _videoService.PaginatedVideo(pageIndex, _pageSize, "SortNum", _conAttr, ref _totalNums);
PropertyBag["videoList"] = _videoList;
string uri = "Video.do?stID=" + stID + "&pageIndex={0}";
string ltlShowPager = Paginated.BuildPager(uri, _totalNums, pageIndex, _pageSize);
PropertyBag["ltlShowPager"] = ltlShowPager;
}