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