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