/// <summary> /// 查询组织机构 /// </summary> /// <param name="regulationCategoryID"></param> /// <param name="parentID"></param> /// <param name="idPath"></param> /// <param name="levelNum"></param> /// <param name="orderIndex"></param> /// <param name="categoryName"></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 <RegulationCategory> GetRegulationCategories(int regulationCategoryID, int parentID, string idPath, int levelNum, int orderIndex, string categoryName, string description, string memo, int startRowIndex, int maximumRows, string orderBy) { IList <RegulationCategory> regulationCategories = new List <RegulationCategory>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_REGULATION_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()) { RegulationCategory regulationCategory = CreateModelObject(dataReader); regulationCategories.Add(regulationCategory); } } _recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count")); return(regulationCategories); }
public void UpdateRegulationCategory(RegulationCategory regulationCategory) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_REGULATION_CATEGORY_U"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_regulation_category_id", DbType.Int32, regulationCategory.RegulationCategoryID); db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, regulationCategory.ParentID); db.AddInParameter(dbCommand, "p_id_path", DbType.String, regulationCategory.IdPath); db.AddInParameter(dbCommand, "p_level_num", DbType.Int32, regulationCategory.LevelNum); db.AddInParameter(dbCommand, "p_order_index", DbType.Int32, regulationCategory.OrderIndex); db.AddInParameter(dbCommand, "p_category_name", DbType.String, regulationCategory.CategoryName); db.AddInParameter(dbCommand, "p_description", DbType.String, regulationCategory.Description); db.AddInParameter(dbCommand, "p_memo", DbType.String, regulationCategory.Memo); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, transaction); transaction.Commit(); } catch { transaction.Rollback(); } connection.Close(); }
public RegulationCategory GetRegulationCategory(int regulationCategoryID) { RegulationCategory regulationCategory = null; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_REGULATION_CATEGORY_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_regulation_category_id", DbType.Int32, regulationCategoryID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { regulationCategory = CreateModelObject(dataReader); } } return(regulationCategory); }
public int AddRegulationCategory(RegulationCategory regulationCategory) { int id = 0; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_REGULATION_CATEGORY_I"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddOutParameter(dbCommand, "p_regulation_category_id", DbType.Int32, 4); db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, regulationCategory.ParentID); db.AddOutParameter(dbCommand, "p_id_path", DbType.String, 20); db.AddOutParameter(dbCommand, "p_level_num", DbType.Int32, 4); db.AddInParameter(dbCommand, "p_order_index", DbType.Int32, regulationCategory.OrderIndex); db.AddInParameter(dbCommand, "p_category_name", DbType.String, regulationCategory.CategoryName); db.AddInParameter(dbCommand, "p_description", DbType.String, regulationCategory.Description); db.AddInParameter(dbCommand, "p_memo", DbType.String, regulationCategory.Memo); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, transaction); id = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_regulation_category_id")); transaction.Commit(); } catch { transaction.Rollback(); } connection.Close(); return(id); }
public IList <RegulationCategory> GetRegulationCategories() { IList <RegulationCategory> regulationCategories = new List <RegulationCategory>(); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("USP_GET_ALL"); db.AddInParameter(dbCommand, "p_table_name", DbType.String, "REGULATION_CATEGORY"); db.AddInParameter(dbCommand, "p_order_by", DbType.String, "LEVEL_NUM, ORDER_INDEX ASC"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { RegulationCategory regulationCategory = CreateModelObject(dataReader); regulationCategories.Add(regulationCategory); } } _recordCount = regulationCategories.Count; return(regulationCategories); }
/// <summary> /// 删除知识类别 /// </summary> /// <param name="regulationCategory">要删除的知识类别</param> public void DeleteRegulationCategory(RegulationCategory regulationCategory) { DeleteRegulationCategory(regulationCategory.RegulationCategoryID); }
/// <summary> /// 更新知识类别 /// </summary> /// <param name="regulationCategory">更新后的知识类别信息</param> public void UpdateRegulationCategory(RegulationCategory regulationCategory) { objLogBll.WriteLog("修改法规类别“" + regulationCategory.CategoryName + "”基本信息"); dal.UpdateRegulationCategory(regulationCategory); }
/// <summary> /// 新增知识类别 /// </summary> /// <param name="regulationCategory">新增的知识类别信息</param> /// <returns></returns> public int AddRegulationCategory(RegulationCategory regulationCategory) { objLogBll.WriteLog("新增法规类别“" + regulationCategory.CategoryName + "”基本信息"); return(dal.AddRegulationCategory(regulationCategory)); }