private string GetAssistAssistBookCategoryNames(string strName, int nID)
{
string strAssistAssistBookCategoryName = string.Empty;
if (nID != 0)
{
AssistBookCategoryDAL AssistCategoryDAL = new AssistBookCategoryDAL();
AssistBookCategory AssistCategory = AssistCategoryDAL.GetAssistBookCategory(nID);
if (AssistCategory.ParentId != 0)
{
strAssistAssistBookCategoryName = GetAssistAssistBookCategoryNames("/" + AssistCategory.AssistBookCategoryName, AssistCategory.ParentId) + strName;
}
else
{
strAssistAssistBookCategoryName = AssistCategory.AssistBookCategoryName + strName;
}
}
else
{
strAssistAssistBookCategoryName = strName.Replace("/", "");
}
return(strAssistAssistBookCategoryName);
}
/// <summary>
/// 根据辅导教材ID查询教材
/// </summary>
/// <param name="bookID"></param>
/// <returns></returns>
public AssistBook GetAssistBook(int bookID)
{
AssistBook book = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_id", DbType.Int32, bookID);
db.AddInParameter(dbCommand, "p_org_id", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
book = CreateModelObject(dataReader);
}
}
sqlCommand = "USP_ASSIST_BOOK_RANGE_ORG_S";
DbCommand dbCommand1 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand1, "p_assist_book_id", DbType.Int32, bookID);
sqlCommand = "USP_ASSIST_BOOK_RANGE_POST_S";
DbCommand dbCommand2 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand2, "p_assist_book_id", DbType.Int32, bookID);
sqlCommand = "USP_ASSIST_BOOK_TRAIN_TYPE_S";
DbCommand dbCommand3 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand3, "p_assist_book_id", DbType.Int32, bookID);
IDataReader dataReader1 = db.ExecuteReader(dbCommand1);
IDataReader dataReader2 = db.ExecuteReader(dbCommand2);
IDataReader dataReader3 = db.ExecuteReader(dbCommand3);
ArrayList orgidAL = new ArrayList();
ArrayList postidAL = new ArrayList();
ArrayList trainTypeidAL = new ArrayList();
string strTrainTypeNames = string.Empty;
AssistBookCategoryDAL assistDAL = new AssistBookCategoryDAL();
AssistBookCategory assistcategory = assistDAL.GetAssistBookCategory(book.AssistBookCategoryId);
book.AssistBookCategoryName = GetAssistAssistBookCategoryNames("/" + assistcategory.AssistBookCategoryName, assistcategory.ParentId);
while (dataReader1.Read())
{
if (dataReader1["ORG_ID"].ToString() != "")
{
orgidAL.Add(DataConvert.ToInt(dataReader1["ORG_ID"].ToString()));
}
}
while (dataReader2.Read())
{
if (dataReader2["POST_ID"].ToString() != "")
{
postidAL.Add(DataConvert.ToInt(dataReader2["POST_ID"].ToString()));
}
}
while (dataReader3.Read())
{
if (dataReader3["TRAIN_TYPE_ID"].ToString() != "")
{
trainTypeidAL.Add(DataConvert.ToInt(dataReader3["TRAIN_TYPE_ID"].ToString()));
strTrainTypeNames += GetTrainTypeNames("/" + dataReader3["TYPE_NAME"].ToString(), int.Parse(dataReader3["PARENT_ID"].ToString())) + ",";
}
}
if (strTrainTypeNames.Length > 0)
{
strTrainTypeNames = strTrainTypeNames.Substring(0, strTrainTypeNames.Length - 1);
}
book.orgidAL = orgidAL;
book.postidAL = postidAL;
book.trainTypeidAL = trainTypeidAL;
book.trainTypeNames = strTrainTypeNames;
return(book);
}
