/// <summary> /// 查询组织机构 /// </summary> /// <param name="assistBookCategoryId"></param> /// <param name="parentId"></param> /// <param name="idPath"></param> /// <param name="levelNum"></param> /// <param name="orderIndex"></param> /// <param name="assistBookCategoryName"></param> /// <param name="description"></param> /// <param name="memo"></param> /// <param name="startRowIndex">起始记录行</param> /// <param name="maximumRows">每页记录条数</param> /// <param name="orderBy">排序字符串,如"FieldName ASC"</param> /// <returns></returns> public IList <AssistBookCategory> GetAssistBookCategorys(int assistBookCategoryId, int parentId, string idPath, int levelNum, int orderIndex, string assistBookCategoryName, string description, string memo, int startRowIndex, int maximumRows, string orderBy) { IList <AssistBookCategory> assistBookCategorys = new List <AssistBookCategory>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_ASSIST_BOOK_CATEGORY_S"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_start_row_index", DbType.Int32, startRowIndex); db.AddInParameter(dbCommand, "p_page_size", DbType.Int32, maximumRows); db.AddInParameter(dbCommand, "p_order_by", DbType.AnsiString, GetMappingOrderBy(orderBy)); db.AddOutParameter(dbCommand, "p_count", DbType.Int32, 4); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { AssistBookCategory assistBookCategory = CreateModelObject(dataReader); assistBookCategorys.Add(assistBookCategory); } } _recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count")); return(assistBookCategorys); }
/// <summary> /// 新增辅导教材体系 /// </summary> /// <param name="assistBookCategory">新增的辅导教材体系信息</param> /// <returns></returns> public int AddAssistBookCategory(AssistBookCategory assistBookCategory) { int id = dal.AddAssistBookCategory(assistBookCategory); objLogBll.WriteLog("新增辅导教材体系“" + assistBookCategory.AssistBookCategoryName + "”基本信息"); return(id); }
public void UpdateAssistBookCategory(AssistBookCategory assistBookCategory) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_ASSIST_BOOK_CATEGORY_U"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_assist_book_category_id", DbType.Int32, assistBookCategory.AssistBookCategoryId); db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, assistBookCategory.ParentId); db.AddInParameter(dbCommand, "p_id_path", DbType.String, assistBookCategory.IdPath); db.AddInParameter(dbCommand, "p_level_num", DbType.Int32, assistBookCategory.LevelNum); db.AddInParameter(dbCommand, "p_order_index", DbType.Int32, assistBookCategory.OrderIndex); db.AddInParameter(dbCommand, "p_assist_book_category_name", DbType.String, assistBookCategory.AssistBookCategoryName); db.AddInParameter(dbCommand, "p_description", DbType.String, assistBookCategory.Description); db.AddInParameter(dbCommand, "p_memo", DbType.String, assistBookCategory.Memo); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, transaction); transaction.Commit(); } catch { transaction.Rollback(); } connection.Close(); }
public AssistBookCategory GetAssistBookCategory(int assistBookCategoryId) { if (assistBookCategoryId < 1) { AssistBookCategory obj = new AssistBookCategory(); return(obj); } return(dal.GetAssistBookCategory(assistBookCategoryId)); }
/// <summary> /// 删除辅导教材体系 /// </summary> /// <param name="assistBookCategory">要删除的辅导教材体系</param> public void DeleteAssistBookCategory(AssistBookCategory assistBookCategory) { int code = 0; string strName = GetAssistBookCategory(assistBookCategory.AssistBookCategoryId).AssistBookCategoryName; dal.DeleteAssistBookCategory(assistBookCategory.AssistBookCategoryId, ref code); if (code == 0) { objLogBll.WriteLog("删除辅导教材体系“" + strName + "”基本信息"); } }
public AssistBookCategory GetAssistBookCategory(int AssistBookCategoryId) { AssistBookCategory assistBookCategory = null; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_ASSIST_BOOK_CATEGORY_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_assist_book_category_id", DbType.Int32, AssistBookCategoryId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { assistBookCategory = CreateModelObject(dataReader); } } return(assistBookCategory); }
/// <summary> /// 获取所有知识 /// </summary> /// <returns>所有知识</returns> public IList <AssistBookCategory> GetAssistBookCategorys() { IList <AssistBookCategory> assistBookCategorys = new List <AssistBookCategory>(); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("USP_GET_ALL"); db.AddInParameter(dbCommand, "p_table_name", DbType.String, "ASSIST_BOOK_CATEGORY"); db.AddInParameter(dbCommand, "p_order_by", DbType.String, "LEVEL_NUM, ORDER_INDEX,ASSIST_BOOK_CATEGORY_ID ASC"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { AssistBookCategory assistBookCategory = CreateModelObject(dataReader); assistBookCategorys.Add(assistBookCategory); } } _recordCount = assistBookCategorys.Count; return(assistBookCategorys); }
public int AddAssistBookCategory(AssistBookCategory assistBookCategory) { int id = 0; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_ASSIST_BOOK_CATEGORY_I"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddOutParameter(dbCommand, "p_assist_book_category_id", DbType.Int32, 4); db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, assistBookCategory.ParentId); db.AddOutParameter(dbCommand, "p_id_path", DbType.String, 20); db.AddOutParameter(dbCommand, "p_level_num", DbType.Int32, 4); db.AddOutParameter(dbCommand, "p_order_index", DbType.Int32, 4); db.AddInParameter(dbCommand, "p_assist_book_category_name", DbType.String, assistBookCategory.AssistBookCategoryName); db.AddInParameter(dbCommand, "p_description", DbType.String, assistBookCategory.Description); db.AddInParameter(dbCommand, "p_memo", DbType.String, assistBookCategory.Memo); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, transaction); id = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_assist_book_category_id")); transaction.Commit(); } catch { transaction.Rollback(); } connection.Close(); return(id); }
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); }
/// <summary> /// 更新辅导教材体系 /// </summary> /// <param name="assistBookCategory">更新后的辅导教材体系信息</param> public void UpdateAssistBookCategory(AssistBookCategory assistBookCategory) { dal.UpdateAssistBookCategory(assistBookCategory); objLogBll.WriteLog("修改辅导教材体系“" + assistBookCategory.AssistBookCategoryName + "”基本信息"); }