public JsonResult GetListQgroup(string subjectcontentcode, string subjectcode, int page, int pageSize) { var ret = -10; //mặc định cho phần trang if (pageSize == 0) { pageSize = AppConfig.item4page(); } if (page < 1) { page = 1; } //Khai báo lấy dữ liệu QUESTIONGROUP_BUS bus = new QUESTIONGROUP_BUS(); List <fieldpara> lipa = new List <fieldpara> { new fieldpara("SUBJECTCONTENTCODE", subjectcontentcode, 0) }; //here is subjectcontentcode //here is subbjectcode if (!string.IsNullOrEmpty(subjectcode)) { lipa.Add(new fieldpara("SUBJECTCODE", subjectcode, 0)); } // lipa.Add(new fieldpara("LOCK",0,0)); int countpage; //order by theorder, with pagesize and the page var data = bus.getAllBy2("CODEVIEW", pageSize, page, out countpage, lipa.ToArray()); // tất cả các bản ghi List <QUESTIONGROUP_OBJ> totalData = bus.getAllBy2("CODEVIEW", lipa.ToArray()); int totalItem = totalData.Count; if (totalItem > 0) { ret = 1; } bus.CloseConnection(); //Chỉ số đầu tiên của trang hiện tại (đã trừ -1) int startpage = (page - 1) * pageSize; //Trả về client // var datastring = JsonConvert.SerializeObject(data); var jsonResult = Json(new { lst = data, //Danh sách totalPage = countpage, startindex = startpage, //bắt đầu số trang ret //ok }, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
/// <summary> /// get list QuestionGroup by subjectcontentcode /// </summary> /// <param name="subjectContentCode"></param> /// <param name="questiontypecode"></param> /// <returns></returns> public List <QUESTIONGROUP_OBJ> GetQGroupBySbjContent(string subjectContentCode, string questiontypecode) { QUESTIONGROUP_BUS bus = new QUESTIONGROUP_BUS(); var data = bus.getAllBy2("NAME", new fieldpara("SUBJECTCONTENTCODE", subjectContentCode, 0), new fieldpara("QUESTIONTYPECODE", questiontypecode, 0) ); bus.CloseConnection(); return(data); }
/// <summary> /// lấy chi tiết 1 đề thi /// </summary> /// <param name="examformcode">mã đề thi</param> /// <returns></returns> public JsonResult Preview(string examformcode) { int ret = 0; int numberQuestion = 0; EXAMFORM_BUS busExamform = new EXAMFORM_BUS(); EXAMFORM_OBJ objExamform = busExamform.GetByID((new EXAMFORM_OBJ.BusinessObjectID(examformcode))); busExamform.CloseConnection(); if (objExamform == null) { ret = -2; } //Danh sachs cau truc EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS(); List <EXAMFORMDETAIL_OBJ> liExamformdetail = new List <EXAMFORMDETAIL_OBJ>(); if (ret >= 0) { if (objExamform != null) { liExamformdetail = busExamformdetail.getAllBy2("THEORDER", new fieldpara("EXAMFORMCODE", objExamform.CODE)); } busExamformdetail.CloseConnection(); if (liExamformdetail == null) { ret = -3; } } List <fieldpara> lipa = new List <fieldpara>(); List <jointable> lijoin = new List <jointable>(); //Lay danh sach cac nhom cau hoi QUESTIONGROUP_BUS busQuestiongroup = new QUESTIONGROUP_BUS(); List <QUESTIONGROUP_OBJ> liQuestiongroup = new List <QUESTIONGROUP_OBJ>(); if (ret >= 0) { if (objExamform != null) { lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "CODE", "QUESTIONGROUPCODE", new fieldpara("EXAMFORMCODE", objExamform.CODE))); } liQuestiongroup = busQuestiongroup.getAllBy2("CODE", lipa, lijoin); if (liQuestiongroup == null) { ret = -4; } busQuestiongroup.CloseConnection(); } //Lay danh sach cau hoi QUESTION_BUS busQuestion = new QUESTION_BUS(); List <QUESTION_OBJ> listQuestionreturn = new List <QUESTION_OBJ>(); if (ret >= 0) { lijoin.Clear(); if (objExamform != null) { lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE))); } var liQuestion = busQuestion.getAllBy2("CODE", lipa, lijoin); if (liQuestion == null) { ret = -5; } else { foreach (var objQuestion in liQuestion) { QUESTION_OBJ objTemp = new QUESTION_OBJ(); objTemp.CODE = objQuestion.CODE; objTemp.ANSWERCODE = null; objTemp.CONTENT = objQuestion.CONTENT; objTemp.QUESTIONGROUPCODE = objQuestion.QUESTIONGROUPCODE; objTemp._QUESTIONGROUPCODE = objQuestion._QUESTIONGROUPCODE; objTemp._ID = objQuestion._ID; listQuestionreturn.Add(objTemp); } numberQuestion = liQuestion.Count; } busQuestion.CloseConnection(); } //Lay danh danh cac dap an ANSWER_BUS busAnswer = new ANSWER_BUS(); List <ANSWER_OBJ> liAnswer = new List <ANSWER_OBJ>(); if (ret >= 0) { lijoin.Clear(); if (objExamform != null) { lijoin.Add((new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE)))); } liAnswer = busAnswer.getAllBy2("CODE", lipa, lijoin); if (liAnswer == null) { ret = -6; } busAnswer.CloseConnection(); } var jsonResult = Json(new { numberQuestion, //so luong cau hoi ObjexamForm = objExamform, //examform liExamformDetail = liExamformdetail, //Danh sách examdetail liQuestiongroup, //danh sach nhom cau hoi li_question = listQuestionreturn, //danh sach cac cau hoi li_answer = liAnswer, //danh sach tat ca cac cau tra loi ret //ok }, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
/// <summary> /// Lấy ra chi tiết của một bài thi dựa vào mã sinh viên trong bảng điểm lớp môn học và mã học kì /// </summary> /// <param name="markcode">mã sinh viên trong lớp môn học</param> /// <param name="examtimecode">mã học kì </param> /// <returns></returns> public JsonResult GetDetailExam(string markcode, string examtimecode) { if (string.IsNullOrEmpty(markcode)) { markcode = "1708310001"; } int ret = 0; int numberQuestion = 0; MARK_BUS markbus = new MARK_BUS(); MARK_OBJ objmark = markbus.GetByID(new MARK_OBJ.BusinessObjectID(markcode));//markbus.GetByKey(new fieldpar("STUDENTCODE", _ses.loginCode, 0),new fieldpara("COURSECODE", courseCode, 0)); markbus.CloseConnection(); if (objmark == null) { ret = -7; } EXAMHALLSTUDENT_OBJ obj = new EXAMHALLSTUDENT_OBJ(); if (ret >= 0) { EXAMHALLSTUDENT_BUS bus = new EXAMHALLSTUDENT_BUS(); if (objmark != null) { obj = bus.GetByKey(new fieldpara("MARKCODE", objmark.CODE, 0), new fieldpara("examtimecode", examtimecode)); } bus.CloseConnection(); } //Lấy được một lần thi if (obj == null) { ret = -1; } EXAMFORM_BUS busExamform = new EXAMFORM_BUS(); EXAMFORM_OBJ objExamform = null; //Lấy đề thi if (ret >= 0) { if (obj != null) { objExamform = busExamform.GetByID((new EXAMFORM_OBJ.BusinessObjectID(obj.EXAMFORMCODE))); } busExamform.CloseConnection(); if (objExamform == null) { ret = -2; } } //Danh sachs cau truc EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS(); List <EXAMFORMDETAIL_OBJ> liExamformdetail = new List <EXAMFORMDETAIL_OBJ>(); if (ret >= 0) { if (objExamform != null) { liExamformdetail = busExamformdetail.getAllBy2("THEORDER", new fieldpara("EXAMFORMCODE", objExamform.CODE)); } busExamformdetail.CloseConnection(); if (liExamformdetail == null) { ret = -3; } } List <fieldpara> lipa = new List <fieldpara>(); List <jointable> lijoin = new List <jointable>(); //Lay danh sach cac nhom cau hoi QUESTIONGROUP_BUS busQuestiongroup = new QUESTIONGROUP_BUS(); List <QUESTIONGROUP_OBJ> liQuestiongroup = new List <QUESTIONGROUP_OBJ>(); if (ret >= 0) { if (objExamform != null) { lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "CODE", "QUESTIONGROUPCODE", new fieldpara("EXAMFORMCODE", objExamform.CODE))); } liQuestiongroup = busQuestiongroup.getAllBy2("CODE", lipa, lijoin); if (liQuestiongroup == null) { ret = -4; } busQuestiongroup.CloseConnection(); } //Lay danh sach cau hoi QUESTION_BUS busQuestion = new QUESTION_BUS(); List <QUESTION_OBJ> listQuestionreturn = new List <QUESTION_OBJ>(); if (ret >= 0) { lijoin.Clear(); if (objExamform != null) { lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE))); } var liQuestion = busQuestion.getAllBy2("CODE", lipa, lijoin); if (liQuestion == null) { ret = -5; } else { foreach (var objQuestion in liQuestion) { QUESTION_OBJ objTemp = new QUESTION_OBJ(); objTemp.CODE = objQuestion.CODE; objTemp.ANSWERCODE = null; objTemp.CONTENT = objQuestion.CONTENT; objTemp.QUESTIONGROUPCODE = objQuestion.QUESTIONGROUPCODE; objTemp._QUESTIONGROUPCODE = objQuestion._QUESTIONGROUPCODE; objTemp._ID = objQuestion._ID; listQuestionreturn.Add(objTemp); } numberQuestion = liQuestion.Count; } busQuestion.CloseConnection(); } //Lay danh danh cac dap an ANSWER_BUS busAnswer = new ANSWER_BUS(); List <ANSWER_OBJ> liAnswer = new List <ANSWER_OBJ>(); if (ret >= 0) { lijoin.Clear(); if (objExamform != null) { lijoin.Add((new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE)))); } liAnswer = busAnswer.getAllBy2("CODE", lipa, lijoin); if (liAnswer == null) { ret = -6; } busAnswer.CloseConnection(); } //get list exam result in case student lost the internet EXAMRESULT_BUS busExamresult = new EXAMRESULT_BUS(); List <EXAMRESULT_OBJ> liExamresult = new List <EXAMRESULT_OBJ>(); if (ret >= 0) { if (obj != null) { liExamresult = busExamresult.getAllBy2(new fieldpara("examhallstudentcode", obj.CODE)); } busExamresult.CloseConnection(); } var jsonResult = Json(new { numberQuestion, //so luong cau hoi ObjexamHallstudent = obj, //examhallstudent code ObjexamForm = objExamform, //examform liExamformDetail = liExamformdetail, //Danh sách examdetail liQuestiongroup, //danh sach nhom cau hoi li_question = listQuestionreturn, //danh sach cac cau hoi li_answer = liAnswer, //danh sach tat ca cac cau tra loi liExamresult, //danh sach tat ca cac dap an da tra loi cu sinh vien ret //ok }, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
/// <summary> /// logic: truyền vào coursecode và examtimecode /// từ coursecode và examtimecode -> tìm được examhallstudent tương ứng -> lấy ra được examformcode chính là đề thi mà sinh viên đó làm /// lấy ra danh sách các nhóm câu hỏi của đề thi đấy (dữ liệu trong bảng examformdetail) /// lấy danh sách các câu hỏi /// </summary> /// <param name="coursecode">mã lớp môn học</param> /// <param name="examtimecode"></param> /// <returns></returns> public JsonResult ShowExamResult(string coursecode, string examtimecode) { if (string.IsNullOrEmpty(coursecode)) { coursecode = "1708310001"; } if (string.IsNullOrEmpty(examtimecode)) { examtimecode = "1712250004"; } var ret = 0; string studentcode = ""; List <QUESTION_OBJ> liQuestion = null; List <ANSWER_OBJ> liAnswer = null; List <EXAMRESULT_OBJ> liExamresult = null; EXAMFORM_OBJ objExamform = null; List <EXAMFORMDETAIL_OBJ> liExamformdetail = null; List <QUESTIONGROUP_OBJ> liQuestiongroup = null; int numberQuestion = 0; // số câu hỏi EXAMHALLSTUDENT_OBJ examhallstudentObj = new EXAMHALLSTUDENT_OBJ(); if (_ses.loginType.Equals("STUDENT")) { studentcode = _ses.loginCode; } else { ret = -1; } if (ret >= 0) { List <fieldpara> lipa = new List <fieldpara>(); // get mark MARK_BUS markBus = new MARK_BUS(); lipa.Add(new fieldpara("STUDENTCODE", studentcode, 0)); lipa.Add(new fieldpara("COURSECODE", coursecode, 0)); lipa.Add(new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0)); var mark = markBus.GetByKey(lipa.ToArray()); markBus.CloseConnection(); if (mark != null) { EXAMHALLSTUDENT_BUS bus = new EXAMHALLSTUDENT_BUS(); examhallstudentObj = bus.GetByKey(new fieldpara("MARKCODE", mark.CODE, 0), new fieldpara("EXAMTIMECODE", examtimecode)); bus.CloseConnection(); if (examhallstudentObj != null) { // lấy đề thi EXAMFORM_BUS busExamform = new EXAMFORM_BUS(); objExamform = busExamform.GetByID((new EXAMFORM_OBJ.BusinessObjectID(examhallstudentObj.EXAMFORMCODE))); busExamform.CloseConnection(); if (objExamform != null) { // lấy danh sách chi tiết đề thi EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS(); liExamformdetail = busExamformdetail.getAllBy2("THEORDER", new fieldpara("EXAMFORMCODE", objExamform.CODE)); busExamformdetail.CloseConnection(); if (liExamformdetail != null) { lipa = new List <fieldpara>(); List <jointable> lijoin = new List <jointable>(); //Lay danh sach cac nhom cau hoi QUESTIONGROUP_BUS busQuestiongroup = new QUESTIONGROUP_BUS(); lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "CODE", "QUESTIONGROUPCODE", new fieldpara("EXAMFORMCODE", objExamform.CODE))); liQuestiongroup = busQuestiongroup.getAllBy2("CODE", lipa, lijoin); busQuestiongroup.CloseConnection(); if (liQuestiongroup != null) { //Lay danh sach cau hoi QUESTION_BUS busQuestion = new QUESTION_BUS(); lijoin.Clear(); lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE))); liQuestion = busQuestion.getAllBy2("CODE", lipa, lijoin); numberQuestion = liQuestion.Count; busQuestion.CloseConnection(); // lấy danh sách các câu trả lời lijoin.Clear(); ANSWER_BUS busAnswer = new ANSWER_BUS(); lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE))); liAnswer = busAnswer.getAllBy2("CODE", lipa, lijoin); busAnswer.CloseConnection(); // lấy danh sách kết quả thi của sinh vên đó EXAMRESULT_BUS busExamresult = new EXAMRESULT_BUS(); liExamresult = busExamresult.getAllBy2(new fieldpara("examhallstudentcode", examhallstudentObj.CODE)); busExamresult.CloseConnection(); if (liAnswer == null || liExamresult == null) { ret = -7; } } else { ret = -6; } } else { ret = -5; } } else { ret = -4; } } else { ret = -3; } } else { ret = -2; } } else { ret = -1; } var jsonResult = Json(new { numberQuestion, //so luong cau hoi ObjexamHallstudent = examhallstudentObj, //examhallstudent code ObjexamForm = objExamform, //examform liExamformDetail = liExamformdetail, //Danh sách examdetail liQuestiongroup, li_question = liQuestion, li_answer = liAnswer, li_examresult = liExamresult,//danh sách đáp án ret }, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
/// <summary> /// lấy kết quả bài thi dựa trên mark code /// </summary> /// <param name="markcode"></param> /// <returns></returns> /// show questiongroup /// show question /// show answer /// put data//hide other answer public JsonResult ShowData(string markcode) { var ret = -1; int numberQuestion = 0; //dựa vào mã sinh viên thuộc lớp môn học nào sẽ xác định mã sinh bài thi của phòng nào đó cho môn học đó EXAMHALLSTUDENT_BUS bus = new EXAMHALLSTUDENT_BUS(); EXAMHALLSTUDENT_OBJ obj = bus.GetByKey(new fieldpara("MARKCODE", markcode, 0)); bus.CloseConnection(); //bài kiểm tra EXAMFORM_BUS busExamform = new EXAMFORM_BUS(); EXAMFORM_OBJ objExamform = null; if (ret >= 0) { objExamform = busExamform.GetByID((new EXAMFORM_OBJ.BusinessObjectID(obj.EXAMFORMCODE))); busExamform.CloseConnection(); if (objExamform == null) { ret = -2; } } //Danh sachs cau truc EXAMFORMDETAIL_BUS busExamformdetail = new EXAMFORMDETAIL_BUS(); List <EXAMFORMDETAIL_OBJ> liExamformdetail = new List <EXAMFORMDETAIL_OBJ>(); if (ret >= 0) { if (objExamform != null) { liExamformdetail = busExamformdetail.getAllBy2("THEORDER", new fieldpara("EXAMFORMCODE", objExamform.CODE)); } busExamformdetail.CloseConnection(); if (liExamformdetail == null) { ret = -3; } } List <fieldpara> lipa = new List <fieldpara>(); List <jointable> lijoin = new List <jointable>(); //Lay danh sach cac nhom cau hoi QUESTIONGROUP_BUS busQuestiongroup = new QUESTIONGROUP_BUS(); List <QUESTIONGROUP_OBJ> liQuestiongroup = new List <QUESTIONGROUP_OBJ>(); if (ret >= 0) { if (objExamform != null) { lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "CODE", "QUESTIONGROUPCODE", new fieldpara("EXAMFORMCODE", objExamform.CODE))); } liQuestiongroup = busQuestiongroup.getAllBy2("CODE", lipa, lijoin); if (liQuestiongroup == null) { ret = -4; } busQuestiongroup.CloseConnection(); } //Lay danh sach cau hoi QUESTION_BUS busQuestion = new QUESTION_BUS(); List <QUESTION_OBJ> liQuestion = new List <QUESTION_OBJ>(); if (ret >= 0) { lijoin.Clear(); if (objExamform != null) { lijoin.Add(new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE))); } liQuestion = busQuestion.getAllBy2("CODE", lipa, lijoin); if (liQuestion == null) { ret = -5; } else { numberQuestion = liQuestion.Count; } busQuestion.CloseConnection(); } //Lay danh danh cac dap an ANSWER_BUS busAnswer = new ANSWER_BUS(); List <ANSWER_OBJ> liAnswer = new List <ANSWER_OBJ>(); if (ret >= 0) { lijoin.Clear(); if (objExamform != null) { lijoin.Add((new jointable(typeof(EXAMFORMDETAIL_OBJ), "QUESTIONGROUPCODE", "QUESTIONGROUPCODE", new fieldpara("examformcode", objExamform.CODE)))); } liAnswer = busAnswer.getAllBy2("CODE", lipa, lijoin); if (liAnswer == null) { ret = -6; } busAnswer.CloseConnection(); } var jsonResult = Json(new { numberQuestion, //so luong cau hoi ObjexamHallstudent = obj, //examhallstudent code ObjexamForm = objExamform, //examform liExamformDetail = liExamformdetail, //Danh sách examdetail liQuestiongroup, li_question = liQuestion, li_answer = liAnswer, ret//ok }, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
/// <summary> /// /// </summary> /// <param name="page"></param> /// <param name="pageSize"></param> /// <param name="subjectcode"></param> /// <param name="parentcode"></param> /// <param name="code"></param> /// <param name="codetype"></param> /// <param name="name"></param> /// <param name="nametype"></param> /// <param name="note"></param> /// <param name="notetype"></param> /// <returns></returns> public JsonResult GetAllSearch(int page, int pageSize, string subjectcode, string parentcode, string code, bool codetype, string name, bool nametype, string note, bool notetype) { var ret = 0; //mặc định cho phần trang if (pageSize == 0) { pageSize = AppConfig.item4page(); } if (page < 1) { page = 1; } //Khai báo lấy dữ liệu SUBJECTCONTENT_BUS bus = new SUBJECTCONTENT_BUS(); List <fieldpara> lipa = new List <fieldpara> { new fieldpara("SUBJECTCODE", subjectcode, 0), new fieldpara("PARENTCODE", parentcode, 0) }; if (!string.IsNullOrEmpty(code)) { lipa.Add(codetype ? new fieldpara("CODEVIEW", code, 0) : new fieldpara("CODEVIEW", code, 1)); } if (!string.IsNullOrEmpty(name)) { lipa.Add(nametype ? new fieldpara("NAME", name, 0) : new fieldpara("NAME", name, 1)); } if (!string.IsNullOrEmpty(note)) { lipa.Add(notetype ? new fieldpara("NOTE", note, 0) : new fieldpara("NOTE", note, 1)); } lipa.Add(new fieldpara("UNIVERSITYCODE", _ses.gUNIVERSITYCODE, 0)); // lipa.Add(new fieldpara("LOCK", 0, 0)); int countpage; int totalItem; //order by theorder, with pagesize and the page var data = bus.getAllBy2("THEORDER", pageSize, page, out countpage, out totalItem, lipa); ret = data == null ? -1 : 0; //Trả về cho client var groupquestion = ""; var question = ""; int startpage = 0; // //Chỉ số đầu tiên của trang hiện tại (đã trừ -1) if (ret >= 0) { foreach (var item in data) { item.NOTE = ""; } //Chỉ số đầu tiên của trang hiện tại (đã trừ -1) startpage = (page - 1) * pageSize; //get first questiongroup // string codefistSubcon = data.Count != 0 ? data[0].CODE : ""; //Chỉ số đầu tiên của trang hiện tại (đã trừ -1) if (data.Count != 0) { QUESTIONGROUP_BUS busgroup = new QUESTIONGROUP_BUS(); List <QUESTIONGROUP_OBJ> li = busgroup.getAllBy2("CODEVIEW", new fieldpara("SUBJECTCODE", subjectcode, 0), new fieldpara("SUBJECTCONTENTCODE", data[0].CODE, 0)); if (li.Count > 0) { groupquestion = li.Count != 0 ? JsonConvert.SerializeObject(li[0]) : ""; } if (li.Count != 0) { QUESTION_BUS busquestion = new QUESTION_BUS(); List <QUESTION_OBJ> liquestion = busquestion.getAllBy2("CODEVIEW", new fieldpara("QUESTIONGROUPCODE", li[0].CODE, 0)); if (liquestion.Count > 0) { question = liquestion.Count != 0 ? JsonConvert.SerializeObject(liquestion[0]) : ""; } } } } bus.CloseConnection(); return(Json(new { question, groupquestion, data, //Danh sách lst = data, totalItem, //số lượng bản ghi totalPage = countpage, startindex = startpage, //bắt đầu số trang ret = ret //ok }, JsonRequestBehavior.AllowGet)); }