public JsonResult Get(string UserID) { if (!ValidateSession()) { return(SessionError); } if (CurrentUser.ObjectId != UserID || !CurrentUser.UserGroup.IsBusManager) { return(RequestIllegal); } if (DataBaseOperation.QueryMultiple(new DBQuery().WhereEqualTo("TeacherObjectID", UserID), out List <SchoolBusObject> BusList) >= DBQueryStatus.NO_RESULTS) { if (BusList.Count == 0) { BusList.Add(new SchoolBusObject() { ObjectId = "0000000000", BusName = "未找到班车", TeacherID = CurrentUser.ObjectId }); } } else { return(DataBaseError); } int _LSChecked = 0, _CSChecked = 0, _AHChecked = 0, _DirectGoHome = 0; string[] weekType = XConfig.ServerConfig.IsBigWeek() ? new string[] { "0", "1", "2" } : new string[] { "0", "2" }; if (DataBaseOperation.QueryMultiple(new DBQuery().WhereEqualTo("BusID", BusList[0].ObjectId).WhereValueContainedInArray("WeekType", weekType), out List <StudentObject> StudentList) >= DBQueryStatus.NO_RESULTS) { foreach (StudentObject item in StudentList) { _LSChecked = item.LSChecked ? _LSChecked + 1 : _LSChecked; _CSChecked = item.CSChecked ? _CSChecked + 1 : _CSChecked; _AHChecked = item.AHChecked ? _AHChecked + 1 : _AHChecked; _DirectGoHome = item.DirectGoHome == DirectGoHomeMode.DirectlyGoHome ? _DirectGoHome + 1 : _DirectGoHome; } return(Json(new { Bus = BusList[0], AHChecked = _AHChecked, LSChecked = _LSChecked, CSChecked = _CSChecked, DirectGoHome = _DirectGoHome, Total = StudentList.Count })); } else { return(InternalError); } }
public JsonResult Get(string BusID, string TeacherID, string Session, string STAMP) { if (!ValidateSession()) { return(SessionError); } if (!(CurrentUser.ObjectId == TeacherID)) { return(UserGroupError); } //user.UserGroup.BusID == BusID && if (Cryptography.SHA256Encrypt(BusID + ";;" + Session + CurrentUser.ObjectId + ";;" + Session) != STAMP) { return(RequestIllegal); } DBQuery BusQuery = new DBQuery(); BusQuery.WhereEqualTo("objectId", BusID); BusQuery.WhereEqualTo("TeacherObjectID", TeacherID); switch (DataBaseOperation.QueryMultipleData(BusQuery, out List <SchoolBusObject> BusList)) { case DBQueryStatus.INTERNAL_ERROR: return(InternalError); default: { if (BusList.Count == 0) { BusList.Add(new SchoolBusObject() { ObjectId = "0000000000", BusName = "未找到校车", TeacherID = CurrentUser.ObjectId }); } DBQuery StudentQuery = new DBQuery(); StudentQuery.WhereEqualTo("BusID", BusList[0].ObjectId); Dictionary <string, string> dict = new Dictionary <string, string>(); switch (DataBaseOperation.QueryMultipleData(StudentQuery, out List <StudentObject> StudentList)) { case DBQueryStatus.INTERNAL_ERROR: return(DataBaseError); default: dict.Add("count", StudentList.Count.ToString()); for (int i = 0; i < StudentList.Count; i++) { dict.Add("num_" + i.ToString(), StudentList[i].ToString()); } dict.Add("ErrCode", "0"); dict.Add("ErrMessage", "null"); return(Json(dict)); } } } }
public JsonResult Get(string UserID, string Session) { if (ValidateSession()) { if (CurrentUser.ObjectId == UserID && CurrentUser.UserGroup.IsBusManager)//&& SessionUser.UserGroup.BusID == BusID { switch (DataBaseOperation.QueryMultipleData(new DBQuery().WhereEqualTo("TeacherObjectID", UserID), out List <SchoolBusObject> BusList)) { case DBQueryStatus.INTERNAL_ERROR: return(InternalError); default: if (BusList.Count == 0) { BusList.Add(new SchoolBusObject() { ObjectId = "0000000000", BusName = "未找到校车", TeacherID = CurrentUser.ObjectId }); } int LSChecked = 0, CSChecked = 0, AHChecked = 0; switch (DataBaseOperation.QueryMultipleData(new DBQuery().WhereEqualTo("BusID", BusList[0].ObjectId), out List <StudentObject> StudentList)) { case DBQueryStatus.INTERNAL_ERROR: return(InternalError); default: Dictionary <string, string> dict = BusList[0].ToDictionary(); foreach (StudentObject item in StudentList) { LSChecked = item.LSChecked ? LSChecked + 1 : LSChecked; CSChecked = item.CSChecked ? CSChecked + 1 : CSChecked; AHChecked = item.AHChecked ? AHChecked + 1 : AHChecked; } dict.Add("AHChecked", AHChecked.ToString()); dict.Add("LSChecked", LSChecked.ToString()); dict.Add("CSChecked", CSChecked.ToString()); dict.Add("Total", StudentList.Count.ToString()); dict.Add("ErrCode", "0"); dict.Add("ErrMessage", "null"); return(Json(dict)); } } } else { return(RequestIllegal); } } else { return(SessionError); } }
private void LoadList() { // TODO: Fix DataGridView List <tempBusInfo> alist = new List <tempBusInfo>(); var buses = GlobalConfig.Bus_byInfo(startingpoint.Text, endingpoint.Text); foreach (var bus in buses) { var owner = GlobalConfig.Owner_byId(bus.OwnerId)[0]; alist.Add(new tempBusInfo(owner.Name, bus.Start, bus.End, bus.DepartTime, bus.Price)); } if (alist.Count <= 0) { MessageBox.Show("Hiện tại không có chuyến đi này!"); } else { BusList.DataSource = alist; BusList.Update(); BusList.Refresh(); } }