/// <summary> /// 查看科目系列 /// </summary> /// <param name="sid"></param> /// <returns></returns> public static string subjectTree(int sid) { using (DAL.subjectClassDAL dal = new DAL.subjectClassDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToChildren(dal.subjectTree(sid), sid)); } } }
//组卷获得部科室 用于组卷 获得参考对象 public static string get_zj_KS(int companyID, int pid) { using (DAL.departmentDAL dal = new DAL.departmentDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.convert(dal.get_zj_KS(companyID, pid))); } } }
/// <summary> /// 获得部门和科室select /// </summary> /// <param name="companyID"></param> /// <param name="pid"></param> /// <returns></returns> public static string getSelect(int companyID, int pid) { using (DAL.departmentDAL dal = new DAL.departmentDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToJson(dal.getSelect(companyID, pid))); } } }
public static string execAdmHome(int ID) { using (usersDAL dal = new usersDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToJson(dal.execAdmHome(ID), null)); } } }
/// <summary> /// 选择题库数据 /// </summary> /// <param name="eid"></param> /// <returns>childrenJSON</returns> public static string seleSubject(string eid) { using (DAL.subjectClassDAL dal = new DAL.subjectClassDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToChildren(dal.seleSubject(eid), 2)); } } }
/// <summary> /// 顺序练习执行[ln_learnsx]存储过程 /// </summary> /// <param name="m"></param> /// <returns></returns> public static string exeLearnsx(Models.learnsx m) { using (DAL.learn.learnsxDAL dal = new DAL.learn.learnsxDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.convert(dal.exeLearnsx(m))); } } }
/// <summary> /// 获得区域表 select /// </summary> /// <param name="pid"></param> /// <returns></returns> public static string getxzbm(string pxzbm) { using (DAL.publicDAL dal = new DAL.publicDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToJson(dal.getxzbm(pxzbm))); } } }
/// <summary> /// 获得c_bm表里数据 /// </summary> /// <param name="type"></param> /// <returns></returns> public static string getcbm(int type) { using (DAL.publicDAL dal = new DAL.publicDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToJson(dal.getcbm(type))); } } }
/// <summary> /// 通过xzbm获得单位select /// </summary> /// <param name="xzbm"></param> /// <returns></returns> public static string getcompany(string xzbm) { using (DAL.companyDAL dal = new DAL.companyDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToJson(dal.getcompany(xzbm))); } } }
/// <summary> /// 获得级别(包括公共题库) /// </summary> /// <returns></returns> public static string getAllJb() { using (DAL.jbzcDAL dal = new DAL.jbzcDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.convert(dal.getAllJb())); } } }
public static string getExamTest(int sid) { using (DAL.exam.examTestDAL dal = new DAL.exam.examTestDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToJson(dal.getExamTest(sid))); } } }
/// <summary> /// 章节练习获得数据 /// </summary> /// <param name="sid"></param> /// <param name="lid"></param> /// <returns></returns> public static string getChapter(int lid, int sid) { using (DAL.learnSubjectDAl dal = new DAL.learnSubjectDAl()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.convert(dal.getChapter(lid, sid))); } } }
/// <summary> /// 我的题库list,通过eid获得我的题库table /// </summary> /// <param name="eid"></param> /// <returns></returns> public static string getMyLearnTab(string eid) { using (DAL.learnSubjectDAl dal = new DAL.learnSubjectDAl()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.ToJson(dal.getMyLearnTab(eid))); } } }
public static string getData() { using (DAL.root.toolDAL dal = new DAL.root.toolDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.convert(dal.getData())); } } }
/// <summary> /// 获得树数据-维护 /// </summary> /// <param name="pid"></param> /// <returns></returns> public static string getManTree(int pid) { using (DAL.subjectClassDAL dal = new DAL.subjectClassDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { return(jp.convert(dal.getManTree(pid))); } } }
//学习情况统计 public static string learnReport(string TimeStart, string TimeEnd, int companyID, string whereStr) { using (DAL.reportDAL dal = new DAL.reportDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { DataTable dt = dal.learnReport(TimeStart, TimeEnd, companyID, whereStr); return(jp.ToLayuiTable(dt, dt.Rows.Count)); } } }
/// <summary> /// 职称注册情况 /// </summary> /// <param name="companyID"></param> /// <returns></returns> public static string reportJob(int companyID) { using (DAL.reportDAL dal = new DAL.reportDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { DataTable dt = dal.reportJob(companyID); return(jp.ToLayuiTable(dt, dt.Rows.Count)); } } }
/// <summary> /// 考试情况统计 /// </summary> /// <param name="TimeStart"></param> /// <param name="TimeEnd"></param> /// <param name="passScore"></param> /// <param name="whereStr"></param> /// <returns></returns> public static string examReport(string TimeStart, string TimeEnd, decimal passScore, string whereStr) { using (DAL.reportDAL dal = new DAL.reportDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { DataTable dt = dal.examReport(TimeStart, TimeEnd, passScore, whereStr); return(jp.ToLayuiTable(dt, dt.Rows.Count)); } } }
/// <summary> /// 注册统计 /// </summary> /// <param name="companyID"></param> /// <returns></returns> public static string registerReport(string whereStr) { using (DAL.reportDAL dal = new DAL.reportDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { DataTable dt = dal.registerReport(whereStr); return(jp.ToLayuiTable(dt, dt.Rows.Count)); } } }
/// <summary> /// 获得快速背题 /// </summary> /// <param name="m"></param> /// <param name="count"></param> /// <returns></returns> public static string exeLearnks(Models.learnks m) { using (DAL.learn.learnsxDAL dal = new DAL.learn.learnsxDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { int count = 0; DataTable dt = dal.exeLearnks(m, out count); return(jp.ToTablePage(dt, count)); } } }
public static string runpage(Models.paging pag, string format) { using (DAL.pagingDAL dal = new DAL.pagingDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { int count = 0; DataTable dt = dal.execPaging(pag, out count); return(jp.ToTablePage(dt, count, format)); } } }
public static string getSelect(int companyID, int pid) { using (DAL.jbzcDAL dal = new DAL.jbzcDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { if (pid == 0) { return(jp.convert(dal.getjb())); } else { return(jp.convert(dal.getzc(companyID, pid))); } } } }
/// <summary> /// 值获得select /// pid<0:通过leve获得 /// level<0:通过pid获得 /// </summary> /// <param name="level"></param> /// <param name="pid"></param> /// <returns></returns> public static string sele(int level, int pid) { using (DAL.subjectClassDAL dal = new DAL.subjectClassDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { if (level >= 0 && pid < 0) { return(jp.convert(dal.sel_level(level))); } else if (pid >= 0 && level < 0) { return(jp.convert(dal.sel_pid(pid))); } else { return(null); } } } }
public static string profileCore(string eid) { using (employeeDAL dal = new employeeDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { StringBuilder sb = new StringBuilder(); sb.Append("{"); DataSet ds = dal.profileCore(eid); sb.Append("\"info\":" + jp.ToJson(ds.Tables[0], null)); if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { sb.Append(",\"table\":" + jp.ToJson(ds.Tables[1])); } else { sb.Append(",\"table\":null"); } return(sb.ToString() + "}"); } } }