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);
}
/// <summary>
/// 查询组织机构
/// </summary>
/// <param name="PaperCategoryId"></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 <PaperCategory> GetPaperCategories(int PaperCategoryId, int parentId, string idPath, int levelNum, int orderIndex,
string CategoryName, string description, string memo, int startRowIndex, int maximumRows, string orderBy)
{
IList <PaperCategory> paperCategories = new List <PaperCategory>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Paper_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())
{
PaperCategory paperCategory = CreateModelObject(dataReader);
paperCategories.Add(paperCategory);
}
}
_recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count"));
return(paperCategories);
}
public void UpdatePaperCategory(PaperCategory paperCategory)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Paper_Category_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_paper_category_id", DbType.Int32, paperCategory.PaperCategoryId);
db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, paperCategory.ParentId);
db.AddInParameter(dbCommand, "p_id_path", DbType.String, paperCategory.IdPath);
db.AddInParameter(dbCommand, "p_level_num", DbType.Int32, paperCategory.LevelNum);
db.AddInParameter(dbCommand, "p_order_index", DbType.Int32, paperCategory.OrderIndex);
db.AddInParameter(dbCommand, "p_category_name", DbType.String, paperCategory.CategoryName);
db.AddInParameter(dbCommand, "p_description", DbType.String, paperCategory.Description);
db.AddInParameter(dbCommand, "p_memo", DbType.String, paperCategory.Memo);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
db.ExecuteNonQuery(dbCommand, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
}
connection.Close();
}
/// <summary>
/// 作业类别是否作为查询使用
/// </summary>
/// <param name="bForSearchUse">
/// 是否供查询用，对于：
/// 一、是，则添加一提示项；
/// 二、否，则不添加提示项；
/// </param>
/// <returns>作业类别</returns>
public IList <PaperCategory> GetTaskCategories(bool bForSearchUse)
{
IList <PaperCategory> paperCategories = new List <PaperCategory>(dal.GetTaskCategories());
if (bForSearchUse)
{
PaperCategory paperCategory = new PaperCategory();
paperCategory.CategoryName = "-状态-";
paperCategory.PaperCategoryId = -1;
paperCategories.Insert(0, paperCategory);
}
return(paperCategories);
}
protected void btnSavePaperCategory_Click(object sender, EventArgs e)
{
string categoryName = this.txtPaperCategoryName.Text.Trim();
string categorySummary = this.txtPaperCategorySummary.Text.Trim();
string customerCategoryId = this.ddlCustomerCategoryID.SelectedValue;
using (var context = new PaperContext())
{
if (this.hidePaperCategoryAction.Value == "add")
{
var entity = new PaperCategory
{
CategoryName = categoryName,
CategorySummary = categorySummary,
CustomerCategoryID = int.Parse(customerCategoryId)
};
context.PaperCategories.Add(entity);
context.SaveChanges();
this.hidePaperCategoryAction.Value = "add";
}
else
{
var id = this.hidePaperCategoryID.Value;
int categoryId = int.Parse(id);
var entity = context.PaperCategories.Find(categoryId);
if (entity != null)
{
entity.CategoryName = categoryName;
entity.CategorySummary = categorySummary;
entity.CustomerCategoryID = int.Parse(customerCategoryId);
context.SaveChanges();
this.hidePaperCategoryID.Value = "0";
this.hidePaperCategoryAction.Value = "add";
}
}
InitRepeater2();
this.txtPaperCategoryName.Text = string.Empty;
this.txtPaperCategorySummary.Text = string.Empty;
BindPaperCategory();
}
}
private string GetPaperCategoryNames(string strName, int nID)
{
string strPaperCategoryName = string.Empty;
if (nID != 0)
{
PaperCategoryDAL paperCategoryDAL = new PaperCategoryDAL();
PaperCategory paperCategory = paperCategoryDAL.GetPaperCategory(nID);
if (paperCategory.ParentId != 0)
{
strPaperCategoryName = GetPaperCategoryNames("/" + paperCategory.CategoryName, paperCategory.ParentId) + strName;
}
else
{
strPaperCategoryName = paperCategory.CategoryName + strName;
}
}
return(strPaperCategoryName);
}
public PaperCategory GetPaperCategory(int PaperCategoryId)
{
PaperCategory paperCategory = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USp_Paper_Category_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_Paper_Category_id", DbType.Int32, PaperCategoryId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
paperCategory = CreateModelObject(dataReader);
}
}
return(paperCategory);
}
public int AddPaperCategory(PaperCategory paperCategory)
{
int id = 0;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Paper_Category_I";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddOutParameter(dbCommand, "p_paper_category_id", DbType.Int32, 4);
db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, paperCategory.ParentId);
db.AddOutParameter(dbCommand, "p_id_path", DbType.String, 20);
db.AddOutParameter(dbCommand, "p_level_num", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "p_order_index", DbType.Int32, 4);
db.AddInParameter(dbCommand, "p_category_name", DbType.String, paperCategory.CategoryName);
db.AddInParameter(dbCommand, "p_description", DbType.String, paperCategory.Description);
db.AddInParameter(dbCommand, "p_memo", DbType.String, paperCategory.Memo);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
db.ExecuteNonQuery(dbCommand, transaction);
id = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_paper_category_id"));
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
connection.Close();
return(id);
}
public IList <PaperCategory> GetPaperCategoriesByIDPath(string idPath)
{
IList <PaperCategory> paperCategories = new List <PaperCategory>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Paper_Category_P";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_id_path", DbType.String, idPath);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
PaperCategory paperCategory = CreateModelObject(dataReader);
paperCategories.Add(paperCategory);
}
}
return(paperCategories);
}
public IList <PaperCategory> GetPaperCategories(int PaperCategoryId)
{
IList <PaperCategory> paperCategories = new List <PaperCategory>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Paper_Category_Exam_s";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_Paper_Category_Id", DbType.Int32, PaperCategoryId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
PaperCategory paperCategory = CreateModelObject(dataReader);
paperCategories.Add(paperCategory);
}
}
return(paperCategories);
}
public IList <PaperCategory> GetPaperCategories()
{
IList <PaperCategory> paperCategories = new List <PaperCategory>();
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("USP_GET_ALL");
db.AddInParameter(dbCommand, "p_table_name", DbType.String, "PAPER_CATEGORY");
db.AddInParameter(dbCommand, "p_order_by", DbType.String, "LEVEL_NUM, ORDER_INDEX ASC");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
PaperCategory paperCateogry = CreateModelObject(dataReader);
paperCategories.Add(paperCateogry);
}
}
_recordCount = paperCategories.Count;
return(paperCategories);
}
/// <summary>
/// 新增试卷类别
/// </summary>
/// <param name="paperCategory">新增的试卷类别信息</param>
/// <returns></returns>
public int AddPaperCategory(PaperCategory paperCategory)
{
objLogBll.WriteLog("新增试卷类别“" + paperCategory.CategoryName + "”基本信息");
return(dal.AddPaperCategory(paperCategory));
}
/// <summary>
/// 删除试卷类别
/// </summary>
/// <param name="paperCategory">要删除的试卷类别</param>
public void DeletePaperCategory(PaperCategory paperCategory)
{
DeletePaperCategory(paperCategory.PaperCategoryId);
}
/// <summary>
/// 更新试卷类别
/// </summary>
/// <param name="paperCategory">更新后的试卷类别信息</param>
public void UpdatePaperCategory(PaperCategory paperCategory)
{
objLogBll.WriteLog("修改试卷类别“" + paperCategory.CategoryName + "”基本信息");
dal.UpdatePaperCategory(paperCategory);
}
