/// <summary>
/// 查询
/// </summary>
/// <param name="PaperCategoryId"></param>
/// <param name="PaperStrategyId"></param>
/// <param name="IsRandomOrder"></param>
/// <param name="SingleAsMultiple"></param>
/// <param name="CategoryName"></param>
/// <param name="description"></param>
/// <param name="PaperStrategyName"></param>
/// <param name="startRowIndex">起始记录行</param>
/// <param name="maximumRows">每页记录条数</param>
/// <param name="orderBy">排序字符串，如"FieldName ASC"</param>
/// <returns></returns>
public IList <PaperStrategy> GetPaperStrategy(int PaperStrategyId, int PaperCategoryId, bool IsRandomOrder, bool SingleAsMultiple,
string PaperStrategyName, int StrategyMode, string description, int startRowIndex, int maximumRows, string orderBy)
{
IList <PaperStrategy> paperCategories = new List <PaperStrategy>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_PAPER_STRATEGY_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())
{
PaperStrategy paperCategory = CreateModelObject(dataReader);
paperCategories.Add(paperCategory);
}
}
_recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count"));
return(paperCategories);
}
public void UpdatePaperStrategy(PaperStrategy paperStrategy)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_PAPER_STRATEGY_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_paper_strategy_id", DbType.Int32, paperStrategy.PaperStrategyId);
db.AddInParameter(dbCommand, "p_paper_category_id", DbType.Int32, paperStrategy.PaperCategoryId);
db.AddInParameter(dbCommand, "p_is_random_order", DbType.Int32, paperStrategy.IsRandomOrder ? 1 : 0);
db.AddInParameter(dbCommand, "p_single_as_multiple", DbType.Int32, paperStrategy.SingleAsMultiple ? 1 : 0);
db.AddInParameter(dbCommand, "p_description", DbType.String, paperStrategy.Description);
db.AddInParameter(dbCommand, "p_memo", DbType.String, paperStrategy.Memo);
db.AddInParameter(dbCommand, "p_paper_strategy_name", DbType.String, paperStrategy.PaperStrategyName);
db.AddInParameter(dbCommand, "p_strategy_mode", DbType.Int32, paperStrategy.StrategyMode);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
db.ExecuteNonQuery(dbCommand, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
}
connection.Close();
}
public PaperStrategy GetPaperStrategy(int PaperStrategyId)
{
PaperStrategy paperStrategy = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_PAPER_STRATEGY_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_Paper_Strategy_id", DbType.Int32, PaperStrategyId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
paperStrategy = CreateModelObject(dataReader);
}
}
PaperCategoryDAL paperCategoryDAL = new PaperCategoryDAL();
PaperCategory paperCategory = paperCategoryDAL.GetPaperCategory(paperStrategy.PaperCategoryId);
paperStrategy.CategoryNames = GetPaperCategoryNames("/" + paperCategory.CategoryName, paperCategory.ParentId);
return(paperStrategy);
}
public IList <PaperStrategy> GetPaperStrategyByPaperCategoryIDPath(string PaperCategoryIDPath)
{
IList <PaperStrategy> paperCategories = new List <PaperStrategy>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_PAPER_STRATEGY_Q1";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_id_path", DbType.String, PaperCategoryIDPath);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
PaperStrategy paperStrategy = CreateModelObject(dataReader);
paperCategories.Add(paperStrategy);
}
}
return(paperCategories);
}
public IList <PaperStrategy> GetPaperStrategyByPaperCategoryId(int PaperCategoryId, int StrategyMode)
{
IList <PaperStrategy> paperCategories = new List <PaperStrategy>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_PAPER_STRATEGY_F";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_Paper_Category_id", DbType.Int32, PaperCategoryId);
db.AddInParameter(dbCommand, "p_STRATEGY_MODE", DbType.Int32, StrategyMode);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
PaperStrategy paperStrategy = CreateModelObject(dataReader);
paperCategories.Add(paperStrategy);
}
}
return(paperCategories);
}
public void DeletePaperStrategy(PaperStrategy paperStrategy)
{
DeletePaperStrategy(paperStrategy.PaperCategoryId);
}
public void UpdatePaperStrategy(PaperStrategy paperStrategy)
{
objLogBll.WriteLog("修改组卷策略：" + paperStrategy.PaperStrategyName);
dal.UpdatePaperStrategy(paperStrategy);
}
public int AddPaperStrategy(PaperStrategy paperStrategy)
{
objLogBll.WriteLog("新增组卷策略：" + paperStrategy.PaperStrategyName);
return(dal.AddPaperStrategy(paperStrategy));
}
