/// <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>
/// 获得区域表 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>
/// 获得部门和科室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));
}
}
}
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>
/// 我的题库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 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() + "}");
}
}
}