/// <summary>
/// 查询组织机构
/// </summary>
/// <param name="assistBookCategoryId"></param>
/// <param name="parentId"></param>
/// <param name="idPath"></param>
/// <param name="levelNum"></param>
/// <param name="orderIndex"></param>
/// <param name="assistBookCategoryName"></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 <AssistBookCategory> GetAssistBookCategorys(int assistBookCategoryId, int parentId, string idPath, int levelNum, int orderIndex,
string assistBookCategoryName, string description, string memo, int startRowIndex, int maximumRows, string orderBy)
{
IList <AssistBookCategory> assistBookCategorys = new List <AssistBookCategory>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_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())
{
AssistBookCategory assistBookCategory = CreateModelObject(dataReader);
assistBookCategorys.Add(assistBookCategory);
}
}
_recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count"));
return(assistBookCategorys);
}
/// <summary>
/// 新增辅导教材体系
/// </summary>
/// <param name="assistBookCategory">新增的辅导教材体系信息</param>
/// <returns></returns>
public int AddAssistBookCategory(AssistBookCategory assistBookCategory)
{
int id = dal.AddAssistBookCategory(assistBookCategory);
objLogBll.WriteLog("新增辅导教材体系“" + assistBookCategory.AssistBookCategoryName + "”基本信息");
return(id);
}
public void UpdateAssistBookCategory(AssistBookCategory assistBookCategory)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_CATEGORY_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_category_id", DbType.Int32, assistBookCategory.AssistBookCategoryId);
db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, assistBookCategory.ParentId);
db.AddInParameter(dbCommand, "p_id_path", DbType.String, assistBookCategory.IdPath);
db.AddInParameter(dbCommand, "p_level_num", DbType.Int32, assistBookCategory.LevelNum);
db.AddInParameter(dbCommand, "p_order_index", DbType.Int32, assistBookCategory.OrderIndex);
db.AddInParameter(dbCommand, "p_assist_book_category_name", DbType.String, assistBookCategory.AssistBookCategoryName);
db.AddInParameter(dbCommand, "p_description", DbType.String, assistBookCategory.Description);
db.AddInParameter(dbCommand, "p_memo", DbType.String, assistBookCategory.Memo);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
db.ExecuteNonQuery(dbCommand, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
}
connection.Close();
}
public AssistBookCategory GetAssistBookCategory(int assistBookCategoryId)
{
if (assistBookCategoryId < 1)
{
AssistBookCategory obj = new AssistBookCategory();
return(obj);
}
return(dal.GetAssistBookCategory(assistBookCategoryId));
}
/// <summary>
/// 删除辅导教材体系
/// </summary>
/// <param name="assistBookCategory">要删除的辅导教材体系</param>
public void DeleteAssistBookCategory(AssistBookCategory assistBookCategory)
{
int code = 0;
string strName = GetAssistBookCategory(assistBookCategory.AssistBookCategoryId).AssistBookCategoryName;
dal.DeleteAssistBookCategory(assistBookCategory.AssistBookCategoryId, ref code);
if (code == 0)
{
objLogBll.WriteLog("删除辅导教材体系“" + strName + "”基本信息");
}
}
public AssistBookCategory GetAssistBookCategory(int AssistBookCategoryId)
{
AssistBookCategory assistBookCategory = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_CATEGORY_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_category_id", DbType.Int32, AssistBookCategoryId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
assistBookCategory = CreateModelObject(dataReader);
}
}
return(assistBookCategory);
}
/// <summary>
/// 获取所有知识
/// </summary>
/// <returns>所有知识</returns>
public IList <AssistBookCategory> GetAssistBookCategorys()
{
IList <AssistBookCategory> assistBookCategorys = new List <AssistBookCategory>();
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("USP_GET_ALL");
db.AddInParameter(dbCommand, "p_table_name", DbType.String, "ASSIST_BOOK_CATEGORY");
db.AddInParameter(dbCommand, "p_order_by", DbType.String, "LEVEL_NUM, ORDER_INDEX,ASSIST_BOOK_CATEGORY_ID ASC");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
AssistBookCategory assistBookCategory = CreateModelObject(dataReader);
assistBookCategorys.Add(assistBookCategory);
}
}
_recordCount = assistBookCategorys.Count;
return(assistBookCategorys);
}
public int AddAssistBookCategory(AssistBookCategory assistBookCategory)
{
int id = 0;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_CATEGORY_I";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddOutParameter(dbCommand, "p_assist_book_category_id", DbType.Int32, 4);
db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, assistBookCategory.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_assist_book_category_name", DbType.String, assistBookCategory.AssistBookCategoryName);
db.AddInParameter(dbCommand, "p_description", DbType.String, assistBookCategory.Description);
db.AddInParameter(dbCommand, "p_memo", DbType.String, assistBookCategory.Memo);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
db.ExecuteNonQuery(dbCommand, transaction);
id = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_assist_book_category_id"));
transaction.Commit();
}
catch
{
transaction.Rollback();
}
connection.Close();
return(id);
}
private string GetAssistAssistBookCategoryNames(string strName, int nID)
{
string strAssistAssistBookCategoryName = string.Empty;
if (nID != 0)
{
AssistBookCategoryDAL AssistCategoryDAL = new AssistBookCategoryDAL();
AssistBookCategory AssistCategory = AssistCategoryDAL.GetAssistBookCategory(nID);
if (AssistCategory.ParentId != 0)
{
strAssistAssistBookCategoryName = GetAssistAssistBookCategoryNames("/" + AssistCategory.AssistBookCategoryName, AssistCategory.ParentId) + strName;
}
else
{
strAssistAssistBookCategoryName = AssistCategory.AssistBookCategoryName + strName;
}
}
else
{
strAssistAssistBookCategoryName = strName.Replace("/", "");
}
return(strAssistAssistBookCategoryName);
}
/// <summary>
/// 根据辅导教材ID查询教材
/// </summary>
/// <param name="bookID"></param>
/// <returns></returns>
public AssistBook GetAssistBook(int bookID)
{
AssistBook book = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_id", DbType.Int32, bookID);
db.AddInParameter(dbCommand, "p_org_id", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
book = CreateModelObject(dataReader);
}
}
sqlCommand = "USP_ASSIST_BOOK_RANGE_ORG_S";
DbCommand dbCommand1 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand1, "p_assist_book_id", DbType.Int32, bookID);
sqlCommand = "USP_ASSIST_BOOK_RANGE_POST_S";
DbCommand dbCommand2 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand2, "p_assist_book_id", DbType.Int32, bookID);
sqlCommand = "USP_ASSIST_BOOK_TRAIN_TYPE_S";
DbCommand dbCommand3 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand3, "p_assist_book_id", DbType.Int32, bookID);
IDataReader dataReader1 = db.ExecuteReader(dbCommand1);
IDataReader dataReader2 = db.ExecuteReader(dbCommand2);
IDataReader dataReader3 = db.ExecuteReader(dbCommand3);
ArrayList orgidAL = new ArrayList();
ArrayList postidAL = new ArrayList();
ArrayList trainTypeidAL = new ArrayList();
string strTrainTypeNames = string.Empty;
AssistBookCategoryDAL assistDAL = new AssistBookCategoryDAL();
AssistBookCategory assistcategory = assistDAL.GetAssistBookCategory(book.AssistBookCategoryId);
book.AssistBookCategoryName = GetAssistAssistBookCategoryNames("/" + assistcategory.AssistBookCategoryName, assistcategory.ParentId);
while (dataReader1.Read())
{
if (dataReader1["ORG_ID"].ToString() != "")
{
orgidAL.Add(DataConvert.ToInt(dataReader1["ORG_ID"].ToString()));
}
}
while (dataReader2.Read())
{
if (dataReader2["POST_ID"].ToString() != "")
{
postidAL.Add(DataConvert.ToInt(dataReader2["POST_ID"].ToString()));
}
}
while (dataReader3.Read())
{
if (dataReader3["TRAIN_TYPE_ID"].ToString() != "")
{
trainTypeidAL.Add(DataConvert.ToInt(dataReader3["TRAIN_TYPE_ID"].ToString()));
strTrainTypeNames += GetTrainTypeNames("/" + dataReader3["TYPE_NAME"].ToString(), int.Parse(dataReader3["PARENT_ID"].ToString())) + ",";
}
}
if (strTrainTypeNames.Length > 0)
{
strTrainTypeNames = strTrainTypeNames.Substring(0, strTrainTypeNames.Length - 1);
}
book.orgidAL = orgidAL;
book.postidAL = postidAL;
book.trainTypeidAL = trainTypeidAL;
book.trainTypeNames = strTrainTypeNames;
return(book);
}
/// <summary>
/// 更新辅导教材体系
/// </summary>
/// <param name="assistBookCategory">更新后的辅导教材体系信息</param>
public void UpdateAssistBookCategory(AssistBookCategory assistBookCategory)
{
dal.UpdateAssistBookCategory(assistBookCategory);
objLogBll.WriteLog("修改辅导教材体系“" + assistBookCategory.AssistBookCategoryName + "”基本信息");
}
