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