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