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