/// <summary> /// 根据字典类型查询 /// </summary> /// <param name="dictType">字典类型</param> /// <param name="dictStatus">字典状态</param> /// <param name="dictTypeStatus">字典类型状态</param> /// <returns>包含字典类型名称的字典信息</returns> public static DataTable SelectByDictType(string dictType, DictStatusEnum dictStatus, DictTypeStatusEnum dictTypeStatus) { //创建Database对象 Database db = DatabaseFactory.CreateDatabase(); //创建DbCommand对象 DbCommand dbCommand = db.GetStoredProcCommand("UP_SYDict_SelectByDictType"); //添加输入输出参数 db.AddInParameter(dbCommand, "@DictStatus", DbType.Int32, dictStatus); db.AddInParameter(dbCommand, "@DictType", DbType.String, dictType); db.AddInParameter(dbCommand, "@DictTypeStatus", DbType.Int32, dictTypeStatus); return db.ExecuteDataSet(dbCommand).Tables[0]; }
/// <summary> /// 根据字典类型查询 /// </summary> /// <param name="dictType">字典类型</param> /// <param name="dictStatus">字典状态</param> /// <param name="dictTypeStatus">字典类型状态</param> /// <returns>包含字典类型名称的字典信息</returns> public static DataTable SelectByDictType(string dictType, DictStatusEnum dictStatus, DictTypeStatusEnum dictTypeStatus) { return DictDAL.SelectByDictType(dictType, dictStatus, dictTypeStatus); }