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); }