public JObject PageLoad(long start, long limit, string field, string direction, string searchInfo)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
CourseStu mybase = new CourseStu(dbserver);
string logincode = searchInfo;
string term = getTerm();
string filterf = null;
JObject jobj = null;
DataTable table = null;
if (logincode.Length == 9)
{
filterf = string.Format("select distinct VBC.nvcElectiveNum,nvcCourseName,nvcCourseNature,nvcName,(select count(*) from V_Evaluate_Vote AS VEV where VEV.nvcStuNo+VEV.nvcElectiveNum =VBC.nvcStuNo+VBC.nvcElectiveNum) as isVote,nvcTeaPhoto,nvcTeacher from V_BaseInfo_CourseStu as VBC where nvcStuNo='{0}' AND VBC.nvcElectiveNum like '%{1}%'", logincode, term);
table = dbserver.ExecuteTable(filterf);
jobj = CreateJsonInstance_S(table);
}
else
{
filterf = string.Format("select nvcElectiveNum,nvcCourseName,nvcCourseNature,COUNT(*) as nvcCount from V_Evaluate_Vote where nvcLoginCode='{0}' and nvcElectiveNum like '%{1}%' group by nvcElectiveNum,nvcLoginCode,nvcCourseName,nvcCourseNature", logincode, term);
table = dbserver.ExecuteTable(filterf);
jobj = CreateJsonInstance_T(table);
}
return(jobj);
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject PageLoad(long start, long limit, string field, string direction, string searchInfo, string logincode)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
Detail mybase = new Detail(dbserver);
DBSearchInfo sinfo = new DBSearchInfo(searchInfo);
string term = getTerm();
if (sinfo.Count <= 0)
{
string filterf = string.Format("nvcStuNo='{0}' and nvcElectiveNum like '%{1}%'", logincode, term);
return(mybase.Load(dbsort, filterf));
}
else
{
string filterf = sinfo.GetSiftQueryString();
return(mybase.Load(dbsort, filterf));
}
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject DetailLoad(long start, long limit, string field, string direction, string searchInfo)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
string[] data = searchInfo.Split(';');
DBServer dbserver = new SqlServer();
JObject jobj = null;
DataTable table = null;
string searchText = string.Empty;
if (data[1] == "总览")
{
searchText = string.Format("select distinct VAD.nvcStuNo,nvcStuName,Temp.IntCount from (select nvcStuNo,COUNT(nvcStuNo) from V_Attendance_Detail where nvcElectiveNum='{0}' group by nvcStuNo) As Temp(nvcStuNo,IntCount), V_Attendance_Detail AS VAD where Temp.nvcStuNo=VAD.nvcStuNo and nvcElectiveNum='{0}' order by IntCount desc", data[0]);
table = dbserver.ExecuteTable(searchText);
jobj = CreateJsonInstance_All(table);
}
else
{
searchText = string.Format("select V_Attendance_MajorXQ.dtmRollTime,nvcRollWay,nvcCoutPeo,cast((nvcCoutPeo*100.0/totalPeo*1) as dec(18,2)) as Percentage,nvcStuNo,nvcStuName,nvcReason,V_Attendance_Detail.ID from V_Attendance_MajorXQ,V_Attendance_Detail where V_Attendance_MajorXQ.nvcElectiveNum='{0}' and V_Attendance_MajorXQ.intRollCount={1} and V_Attendance_MajorXQ.ID=V_Attendance_Detail.nvcAttendanceID order by V_Attendance_MajorXQ.intRollCount asc", data[0], data[1]);
table = dbserver.ExecuteTable(searchText);
jobj = CreateJsonInstance_Detail(table);
}
return(jobj);
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject PageLoad_T(long start, long limit, string field, string direction, string searchInfo, string logincode)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
CourseStu mybase = new CourseStu(dbserver);
string term = String.Empty;
if (searchInfo == null)
{
term = getTerm();
}
else
{
string[] data = searchInfo.Split(';');
term = data[0] + "-" + data[1];
}
//对同一个同一学年教授多门课
string cmdText = string.Format("select nvcElectiveNum from V_BaseInfo_EduTask where nvcLoginCode='{0}' and nvcElectiveNum like '%{1}%'", logincode, term);
DataTable table = dbserver.ExecuteTable(cmdText);
JArray array = new JArray();
JObject jobj = null;
DataTable dt = new DataTable();
dt.Columns.Add("nvcElectiveNum");
dt.Columns.Add("nvcCourseName");
dt.Columns.Add("nvcCourseNature");
dt.Columns.Add("nvcEvaGrade");
dt.Columns.Add("avgScore");
dt.Columns.Add("intEvaPeo");
dt.Columns.Add("intNotEvaPeo");
dt.Columns.Add("nvcConPeo");
foreach (DataRow row in table.Rows)
{
string nums = (row["nvcElectiveNum"] != null) ? row["nvcElectiveNum"].ToString() : null;
string filterf = string.Format("select nvcElectiveNum,nvcCourseName,nvcCourseNature,(select nvcEvaGrade from V_Evaluate_Level where (select avg(intScore) from V_BaseInfo_CourseStu where nvcElectiveNum ='{0}' )between intLowMark and intHighMark)as nvcEvaGrade,avg(intScore) AS avgScore,(select count(nvcStuNo) from V_BaseInfo_CourseStu where intIsEvaluate=1 and nvcElectiveNum ='{0}') AS intEvaPeo,(select count(nvcStuNo) from V_BaseInfo_CourseStu where intIsEvaluate=0 and nvcElectiveNum ='{0}') AS intNotEvaPeo,(select count(nvcStuNo) from V_BaseInfo_CourseStu where nvcElectiveNum ='{0}' and (intIsEvaluate=1 and (nvcContents!='' or nvcContents!=NULL))) As nvcConPeo from V_BaseInfo_CourseStu where nvcElectiveNum ='{0}' group by nvcElectiveNum,nvcLoginCode,nvcCourseName,nvcCourseNature", nums);
DataRow dr = dbserver.ExecuteRow(filterf);
if (dr != null)
{
dt.Rows.Add(dr["nvcElectiveNum"], dr["nvcCourseName"], dr["nvcCourseNature"], dr["nvcEvaGrade"], dr["avgScore"], dr["intEvaPeo"], dr["intNotEvaPeo"], dr["nvcConPeo"]);
}
}
jobj = CreateJsonInstance_T(dt);
return(jobj);
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject MessageLoad(long start, long limit, string field, string direction, string searchInfo)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
string searchText = string.Format("select dtmLeaveTime,nvcContents from V_BaseInfo_CourseStu where nvcElectiveNum='{0}' and (nvcContents!='NULL' or nvcContents!='') and intIsEvaluate=1", searchInfo);
DataTable table = dbserver.ExecuteTable(searchText);
return(CreateJsonInstance_M(table));
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject PageLoad(long start, long limit, string field, string direction, string searchInfo)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
ApplyApproval mybase = new ApplyApproval(dbserver);
string filterf = string.Format("nvcLoginCode='{0}' and nvcCheckResult is null or nvcCheckResult='待议' ", searchInfo);
return(mybase.Load(dbsort, filterf));
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject PageLoad(long start, long limit, string field, string direction, string searchInfo)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
CourseStu mybase = new CourseStu(dbserver);
string term = getTerm();
string filterf = string.Format("nvcStuNo='{0}' and nvcElectiveNum like '%{1}%'", searchInfo, term);
return(mybase.Load(dbsort, filterf));
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject PageLoad(long start, long limit, string field, string direction, string searchInfo)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
string filterf = string.Format("select nvcElectiveNum,nvcCourseName,timeAndPlace,attendanceCount from V_Attendance_TeaCourse where nvcLoginCode='{0}'", searchInfo);
JObject jobj = null;
DataTable table = null;
table = dbserver.ExecuteTable(filterf);
jobj = CreateJsonInstance_Major(table);
return(jobj);
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject TimeLoad(long start, long limit, string field, string direction, string searchInfo)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
string filterf = string.Format("select distinct intRollCount from V_Attendance_Detail where nvcElectiveNum='{0}'", searchInfo);
JObject jobj = null;
DataTable table = null;
table = dbserver.ExecuteTable(filterf);
jobj = CreateJsonInstance_Time(table);
return(jobj);
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
public JObject PageLoad(long start, long limit, string field, string direction, string searchInfo)
{
try
{
DBSortPage dbsort = new DBSortPage(start, limit, field, direction);
DBServer dbserver = new SqlServer();
Class mybase = new Class(dbserver);
DBSearchInfo sinfo = new DBSearchInfo(searchInfo);
if (sinfo.Count <= 0)
{
return(mybase.Load(dbsort));
}
else
{
string filterf = sinfo.GetSiftQueryString();
return(mybase.Load(dbsort, filterf));
}
}
catch (Exception ex)
{
return(ShowDataLoadError(ex.Message));
}
}
