/// <summary>
/// kiểm tra 1 đối tượng
/// nếu là teststructcode hoặc là cha-> load teststructcontent
/// nếu là lá thì load teststructdetail
/// </summary>
/// <param name="code">mã cần kiểm tra</param>
/// <returns>
/// ret = -1: LỖI;
/// data.count > 0: có con
/// </returns>
public JsonResult CheckParent(string code, string teststructcode)
{
var ret = -1;
List <TESTSTRUCTCONTENT_OBJ> liTestStructContent = new List <TESTSTRUCTCONTENT_OBJ>();
List <TESTSTRUCTDETAIL_OBJ> liTestStructDetail = null;
TESTSTRUCTCONTENT_BUS bus = new TESTSTRUCTCONTENT_BUS();
var res = bus.getAllBy2("THEORDER", new fieldpara("PARENTCODE", code, 0));
if (res != null && res.Count > 0)
{
ret = 1;
}
if (ret >= 0)
{
liTestStructContent = res;
}
else // là nút lá-> get teststructdetail
{
TESTSTRUCTDETAIL_BUS bus2 = new TESTSTRUCTDETAIL_BUS();
List <fieldpara> lipa = new List <fieldpara>();
lipa.Add(new fieldpara("TESTSTRUCTCODE", teststructcode, 0));
lipa.Add(new fieldpara("TESTSTRUCTCONTENTCODE", code, 0));
var res2 = bus2.getAllBy2("CODE", lipa.ToArray());
if (res2 != null)
{
ret = 2;
liTestStructDetail = res2;
}
bus2.CloseConnection();
}
bus.CloseConnection();
return(Json(new { ret = ret, liTestStructContent = liTestStructContent, liTestStructDetail = liTestStructDetail }, JsonRequestBehavior.AllowGet));
}
// lấy danh sách các đề thi
public JsonResult GetAll(string subjectCode)
{
var ret = 0;
//Lây dữ iệu
TESTSTRUCT_BUS bus = new TESTSTRUCT_BUS();
List <fieldpara> lipa = new List <fieldpara> {
new fieldpara("UNIVERSITYCODE", ses.gUNIVERSITYCODE, 0)
};
//Lọc đơn vị cấp trên; '' sẽ là không co đơn vị cấp trên
if (!string.IsNullOrEmpty(subjectCode))
{
lipa.Add(new fieldpara("SUBJECTCODE", subjectCode, 0));
}
//order by theorder, with pagesize and the page
var liTestStruct = bus.getAllBy2("CODE ", lipa.ToArray());
TESTSTRUCTCONTENT_BUS busTestStructContent = new TESTSTRUCTCONTENT_BUS();
var liTestStructContent = busTestStructContent.getAllBy2("CODE", lipa.ToArray());
// dữ liệu trả về là join giữa liTestStruct và liTestStructContent
if (liTestStruct == null || liTestStructContent == null)
{
ret = -1;
}
if (ret >= 0)
{
if (liTestStruct != null)
{
foreach (var item in liTestStruct)
{
TESTSTRUCTCONTENT_OBJ objTemp = new TESTSTRUCTCONTENT_OBJ();
objTemp.CODE = item.CODE;
objTemp.SUBJECTCODE = item.SUBJECTCODE;
objTemp.NAME = item.NAME;
objTemp.PARENTCODE = "";
objTemp.TESTSTRUCTCODE = item.CODE;
objTemp.UNIVERSITYCODE = ses.gUNIVERSITYCODE;
if (liTestStructContent != null) //ko null thì add vào
{
liTestStructContent.Add(objTemp);
}
}
}
}
bus.CloseConnection();
//Chỉ số đầu tiên của trang hiện tại (đã trừ -1)
//Trả về cho client
return(Json(new { data = liTestStructContent, liTestStruct, ret }, JsonRequestBehavior.AllowGet));
}
