public string getJson(int role_id)
{
Lythen.BLL.sys_role roleBll = new sys_role();
string roles = roleBll.GetOwnRole(role_id);
if (roles == "")
{
return("");
}
DataTable dtTeacher = dal.GetTeacherByRoles(roles).Tables[0];
if (!Directory.Exists(CachePath))
{
Directory.CreateDirectory(CachePath);
}
string file_path = string.Format("{0}teacher_{1}.txt", CachePath, role_id);
StringBuilder sb = new StringBuilder();
if (!File.Exists(file_path))
{
sb.Append("[{\"Teacher_id\":0,\"Teacher_realname\":\"请选择老师\"}");
DataTable dtSub = new Lythen.BLL.subject().GetList("").Tables[0];
if (dtTeacher.Rows.Count == 0)
{
sb.Append("]");
return(sb.ToString());
}
else
{
foreach (DataRow dr in dtTeacher.Rows)
{
sb.Append(",{\"Teacher_id\":").Append(dr["Teacher_id"]).Append(",\"Teacher_realname\":\"").Append(dr["Teacher_realname"]).Append("\"}");
}
}
sb.Append("]");
StreamWriter sw = new StreamWriter(file_path);
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
return(sb.ToString());
}
else
{
StreamReader sr = new StreamReader(file_path);
string str = sr.ReadToEnd();
sr.Close();
return(str);
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 返回下拉列表所需要的JSON
/// </summary>
/// <param name="IdIsTxt">ID的参数是否为科目的title，即ID，与txt一样，都是名称</param>
/// <returns></returns>
public string GetListJson()
{
DataTable dtGrade = dal.GetAllLiteList().Tables[0];
if (!Directory.Exists(CachePath))
{
Directory.CreateDirectory(CachePath);
}
string file_path = CachePath + "Grade.txt";
StringBuilder sb = new StringBuilder();
if (!File.Exists(file_path))
{
sb.Append("[{\"id\":0,\"text\":\"请选择年级\"}");
DataTable dtSub = new Lythen.BLL.subject().GetList("").Tables[0];
if (dtGrade.Rows.Count == 0)
{
sb.Append("]");
return(sb.ToString());
}
else
{
foreach (DataRow dr in dtGrade.Rows)
{
sb.Append(",{\"id\":\"").Append(dr["g_id"]).Append("\",\"text\":\"").Append(dr["g_title"]).Append("\"}");
}
}
sb.Append("]");
StreamWriter sw = new StreamWriter(file_path);
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
return(sb.ToString());
}
else
{
StreamReader sr = new StreamReader(file_path);
string str = sr.ReadToEnd();
sr.Close();
return(str);
}
}
public string GetJsonList(int sub_id)
{
DataTable dtCourse = dal.GetLiteList(sub_id).Tables[0];
if (!Directory.Exists(CachePath))
{
Directory.CreateDirectory(CachePath);
}
string file_path = string.Format("{0}course_{1}.txt", CachePath, sub_id);
StringBuilder sb = new StringBuilder();
if (!File.Exists(file_path))
{
sb.Append("[{\"Course_id\":0,\"Course_title\":\"请选择课程\"}");
DataTable dtSub = new Lythen.BLL.subject().GetList("").Tables[0];
if (dtCourse.Rows.Count == 0)
{
sb.Append("]");
return(sb.ToString());
}
else
{
foreach (DataRow dr in dtCourse.Rows)
{
sb.Append(",{\"id\":").Append(dr["Course_id"]).Append(",\"Course_title\":\"").Append(dr["Course_title"]).Append("\"}");
}
}
sb.Append("]");
StreamWriter sw = new StreamWriter(file_path);
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
return(sb.ToString());
}
else
{
StreamReader sr = new StreamReader(file_path);
string str = sr.ReadToEnd();
sr.Close();
return(str);
}
}
/// <summary>
/// 返回下拉列表所需要的JSON
/// </summary>
/// <param name="IdIsTxt">ID的参数是否为科目的title，即ID，与txt一样，都是名称</param>
/// <returns></returns>
public string GetListJson()
{
if (!Directory.Exists(CachePath)) Directory.CreateDirectory(CachePath);
string file_path = CachePath + "subject.txt";
StringBuilder sb = new StringBuilder();
if (!File.Exists(file_path))
{
sb.Append("[{\"id\":0,\"text\":\"请选择科目\",\"children\":[");
DataTable dtSub = new Lythen.BLL.subject().GetList("").Tables[0];
if (dtSub.Rows.Count == 0)
{
sb.Append(" ]}]");
return sb.ToString();
}
else
{
DataRow[] drs = dtSub.Select("Subject_parent=0");
int len = drs.Length;
foreach (DataRow dr in drs)
{
len--;
WriteNode(dr, dtSub, sb, len);
}
}
sb.Append("]}]");
StreamWriter sw = new StreamWriter(file_path);
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
return sb.ToString();
}
else
{
StreamReader sr = new StreamReader(file_path);
string str = sr.ReadToEnd();
sr.Close();
return str;
}
}
