/// <summary>
/// 可以获取适用对象等信息
/// </summary>
/// <param name="dbConnString"></param>
/// <param name="codingSortID"></param>
/// <returns></returns>
public List<COMM_CODING_SORT_DETAIL> GetCodingSortList(string dbConnString, string codingSortID)
{
this.ClearErrInfo();
if (string.IsNullOrEmpty(dbConnString) == true)
{
this.errMsg = "目标数据库连接字符串为空，无法连接目标库获取COMM_CODING_SORT_DETAIL表中的信息。";
this.WriteErr();
return null;
}
List<COMM_CODING_SORT_DETAIL> listNode = new List<COMM_CODING_SORT_DETAIL>();
try
{
this.esb.ProviderConnectionString = dbConnString;
Mder.FC.Entities.Mder.MderCenterEntities1 mderEntity = new MderCenterEntities1(esb.ConnectionString);
var records = from tb in mderEntity.COMM_CODING_SORT_DETAIL
where tb.CODING_SORT_ID == codingSortID
select tb;
foreach (var subRec in records)
{
listNode.Add(subRec);
}
}
catch (Exception exp)
{
this.errMsg = "从COMM_RES_CLASS表读取数据失败，" + exp.Message + Environment.NewLine + exp.StackTrace;
this.WriteErr();
return null;
}
return listNode;
}
/// <summary>
/// 获取所有分中心信息
/// </summary>
/// <param name="dbConnString"></param>
/// <returns></returns>
public List<COMM_ORG_NODE_INFO> QueryOrgNodeInfo(string dbConnString)
{
this.ClearErrInfo();
if (string.IsNullOrEmpty(dbConnString) == true)
{
this.errMsg = "目标数据库连接字符串为空，无法连接目标库获取COMM_RES_CLASS表中的信息。";
this.WriteErr();
return null;
}
List<COMM_ORG_NODE_INFO> listNode = new List<COMM_ORG_NODE_INFO>();
try
{
this.esb.ProviderConnectionString = dbConnString;
Mder.FC.Entities.Mder.MderCenterEntities1 mderEntity = new MderCenterEntities1(esb.ConnectionString);
var records = from tb in mderEntity.COMM_ORG_NODE_INFO
select tb;
foreach (var subRec in records)
{
listNode.Add(subRec);
}
}
catch (Exception exp)
{
this.errMsg = "从COMM_RES_CLASS表读取数据失败，" + exp.Message + Environment.NewLine + exp.StackTrace;
this.WriteErr();
return null;
}
return listNode;
}
public List<COMM_RESOURCE_LOMSTANDARD> GetLomNodesFromLomStdTable(string dbConnString)
{
this.ClearErrInfo();
if (string.IsNullOrEmpty(dbConnString) == true)
{
this.errMsg = "目标数据库连接字符串为空，无法连接目标库获取LOM标准信息。";
this.WriteErr();
return null;
}
List<COMM_RESOURCE_LOMSTANDARD> listLomNode = new List<COMM_RESOURCE_LOMSTANDARD>();
try
{
this.esb.ProviderConnectionString = dbConnString;
Mder.FC.Entities.Mder.MderCenterEntities1 mderEntity = new MderCenterEntities1(esb.ConnectionString);
var records = from tb in mderEntity.COMM_RESOURCE_LOMSTANDARD
select tb;
foreach (var subRec in records)
{
listLomNode.Add(subRec);
}
}
catch (Exception exp)
{
this.errMsg = "从LOM标准表读取数据失败，" + exp.Message + ";内部异常信息：" + exp.InnerException.Message;
this.WriteErr();
return null;
}
return listLomNode;
}
public COMM_SYS_USER GetUserByName(string dbConnString, string userName)
{
this.ClearErrInfo();
if (string.IsNullOrEmpty(dbConnString) == true)
{
this.errMsg = "目标数据库连接字符串为空，无法连接目标库获取LOM标准信息。";
this.WriteErr();
return null;
}
try
{
this.esb.ProviderConnectionString = dbConnString;
Mder.FC.Entities.Mder.MderCenterEntities1 mderEntity = new MderCenterEntities1(esb.ConnectionString);
var records = ( from tb in mderEntity.COMM_SYS_USER
where tb.USER_NAME == userName
select tb).Take(1);
if (records.Count() > 0)
{
//return records.ElementAt<COMM_SYS_USER>
foreach (var subVar in records)
{
return subVar;
}
}
}
catch (Exception exp)
{
this.errMsg = "从COMM_SYS_USER表读取数据失败，" + exp.Message + ";内部异常信息：" + exp.StackTrace;
this.WriteErr();
return null;
}
return null;
}
/// <summary>
/// 获取课程类型字典表，
/// key为分类名称，value为guid
/// </summary>
/// <param name="dbConnString"></param>
/// <param name="parentClassID"></param>
/// <returns></returns>
public Dictionary<string, string> GetDicCourseClass(string dbConnString, string parentClassID)
{
this.ClearErrInfo();
if (string.IsNullOrEmpty(dbConnString) == true)
{
this.errMsg = "目标数据库连接字符串为空，无法连接目标库获取COMM_CODING_SORT_DETAIL表中的信息。";
this.WriteErr();
return null;
}
Dictionary<string, string> dicCourseClass = new Dictionary<string, string>();
try
{
this.esb.ProviderConnectionString = dbConnString;
Mder.FC.Entities.Mder.MderCenterEntities1 mderEntity = new MderCenterEntities1(esb.ConnectionString);
var records = from tb in mderEntity.COMM_RES_CLASS
where tb.CLASS_PID == parentClassID
select tb;
foreach (var subRec in records)
{
dicCourseClass.Add(subRec.CLASS_NAME, subRec.CLASS_ID);
}
}
catch (Exception exp)
{
this.errMsg = "从COMM_RES_CLASS表读取数据失败，" + exp.Message + Environment.NewLine + exp.StackTrace;
this.WriteErr();
return null;
}
return dicCourseClass;
}
