public static string GetCoursewareTypeInfo(CoursewareType ct)
{
string strTypeInfo = string.Empty;
switch (ct)
{
case CoursewareType.PPT:
strTypeInfo = "数据文件";
break;
case CoursewareType.PDF:
strTypeInfo = "URL地址";
break;
case CoursewareType.Media:
strTypeInfo = "Media文件(wmv,wma,mp3)";
break;
case CoursewareType.MediaAddText:
strTypeInfo = "Media文件需添加文本";
break;
case CoursewareType.Flash:
strTypeInfo = "Flash文件(swf)";
break;
case CoursewareType.Resource:
strTypeInfo = "下载资源";
break;
}
return(strTypeInfo);
}
/// <summary>
/// 查询组织机构
/// </summary>
/// <param name="coursewareTypeId"></param>
/// <param name="parentId"></param>
/// <param name="idPath"></param>
/// <param name="levelNum"></param>
/// <param name="orderIndex"></param>
/// <param name="coursewareTypeName"></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 <CoursewareType> GetCoursewareTypes(int coursewareTypeId, int parentId, string idPath, int levelNum, int orderIndex,
string coursewareTypeName, string description, string memo, int startRowIndex, int maximumRows, string orderBy)
{
IList <CoursewareType> coursewareTypes = new List <CoursewareType>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_COURSEWARE_TYPE_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())
{
CoursewareType coursewareType = CreateModelObject(dataReader);
coursewareTypes.Add(coursewareType);
}
}
_recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count"));
return(coursewareTypes);
}
/// <summary>
/// 新增课件类别
/// </summary>
/// <param name="coursewareType">新增的课件类别信息</param>
/// <returns></returns>
public int AddCoursewareType(CoursewareType coursewareType)
{
int id = dal.AddCoursewareType(coursewareType);
objLogBill.WriteLog("新增课件类别“" + coursewareType.CoursewareTypeName + "”");
return(id);
}
public void UpdateCoursewareType(CoursewareType coursewareType)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_COURSEWARE_TYPE_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_courseware_type_id", DbType.Int32, coursewareType.CoursewareTypeId);
db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, coursewareType.ParentId);
db.AddInParameter(dbCommand, "p_id_path", DbType.String, coursewareType.IdPath);
db.AddInParameter(dbCommand, "p_level_num", DbType.Int32, coursewareType.LevelNum);
db.AddInParameter(dbCommand, "p_order_index", DbType.Int32, coursewareType.OrderIndex);
db.AddInParameter(dbCommand, "p_courseware_type_name", DbType.String, coursewareType.CoursewareTypeName);
db.AddInParameter(dbCommand, "p_description", DbType.String, coursewareType.Description);
db.AddInParameter(dbCommand, "p_memo", DbType.String, coursewareType.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="coursewareType">要删除的课件类别</param>
public void DeleteCoursewareType(CoursewareType coursewareType)
{
int code = 0;
string strName = GetCoursewareType(coursewareType.CoursewareTypeId).CoursewareTypeName;
dal.DeleteCoursewareType(coursewareType.CoursewareTypeId, ref code);
if (code == 0)
{
objLogBill.WriteLog("删除课件类别“" + strName + "”");
}
}
private string GetCoursewareTypeNames(string strName, int nID)
{
string strCoursewareTypeName = string.Empty;
if (nID != 0)
{
CoursewareTypeDAL coursewareTypeDAL = new CoursewareTypeDAL();
CoursewareType coursewareType = coursewareTypeDAL.GetCoursewareType(nID);
if (coursewareType.ParentId != 0)
{
strCoursewareTypeName = GetCoursewareTypeNames("/" + coursewareType.CoursewareTypeName, coursewareType.ParentId) + strName;
}
else
{
strCoursewareTypeName = coursewareType.CoursewareTypeName + strName;
}
}
return(strCoursewareTypeName);
}
public CoursewareType GetCoursewareType(int coursewareTypeId)
{
CoursewareType coursewareType = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_COURSEWARE_TYPE_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_courseware_type_id", DbType.Int32, coursewareTypeId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
coursewareType = CreateModelObject(dataReader);
}
}
return(coursewareType);
}
/// <summary>
/// 取得某课程相关的课程类别信息
/// </summary>
/// <param name="courseID"></param>
/// <returns></returns>
public IList <CoursewareType> GetCoursewareTypesByCourseID(int courseID)
{
IList <CoursewareType> coursewareTypes = new List <CoursewareType>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_COURSE_WARE_TYPE";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_course_id", DbType.Int32, courseID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
CoursewareType coursewareType = CreateModelObject(dataReader);
coursewareTypes.Add(coursewareType);
}
}
return(coursewareTypes);
}
public int AddCoursewareType(CoursewareType coursewareType)
{
int id = 0;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_COURSEWARE_TYPE_I";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddOutParameter(dbCommand, "p_Courseware_Type_id", DbType.Int32, 4);
db.AddInParameter(dbCommand, "p_parent_id", DbType.Int32, coursewareType.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_Courseware_Type_name", DbType.String, coursewareType.CoursewareTypeName);
db.AddInParameter(dbCommand, "p_description", DbType.String, coursewareType.Description);
db.AddInParameter(dbCommand, "p_memo", DbType.String, coursewareType.Memo);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
db.ExecuteNonQuery(dbCommand, transaction);
id = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_Courseware_Type_id"));
transaction.Commit();
}
catch
{
transaction.Rollback();
}
connection.Close();
return(id);
}
public IList <CoursewareType> GetCoursewareTypes()
{
IList <CoursewareType> coursewareTypes = new List <CoursewareType>();
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("USP_GET_ALL");
db.AddInParameter(dbCommand, "p_table_name", DbType.String, "COURSEWARE_TYPE");
db.AddInParameter(dbCommand, "p_order_by", DbType.String, "LEVEL_NUM, ORDER_INDEX ASC");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
CoursewareType coursewareType = CreateModelObject(dataReader);
coursewareTypes.Add(coursewareType);
}
}
_recordCount = coursewareTypes.Count;
return(coursewareTypes);
}
/// <summary>
/// 更新课件类别
/// </summary>
/// <param name="coursewareType">更新后的课件类别信息</param>
public void UpdateCoursewareType(CoursewareType coursewareType)
{
dal.UpdateCoursewareType(coursewareType);
objLogBill.WriteLog("修改课件类别“" + coursewareType.CoursewareTypeName + "”");
}
public Courseware GetCourseware(int coursewareID)
{
Courseware courseware = null;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_COURSEWARE_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_courseware_id", DbType.Int32, coursewareID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
courseware = CreateModelObject(dataReader);
}
}
sqlCommand = "USP_COURSEWARE_TRAIN_TYPE_S";
DbCommand dbCommand1 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand1, "p_courseware_id", DbType.Int32, coursewareID);
sqlCommand = "USP_COURSEWARE_RANGE_ORG_S";
DbCommand dbCommand2 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand2, "p_courseware_id", DbType.Int32, coursewareID);
sqlCommand = "USP_COURSEWARE_RANGE_POST_S";
DbCommand dbCommand3 = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand3, "p_courseware_id", DbType.Int32, coursewareID);
IDataReader dataReader1 = db.ExecuteReader(dbCommand1);
IDataReader dataReader2 = db.ExecuteReader(dbCommand2);
IDataReader dataReader3 = db.ExecuteReader(dbCommand3);
ArrayList trainTypeIDAL = new ArrayList();
ArrayList orgIDAL = new ArrayList();
ArrayList postIDAL = new ArrayList();
string strTrainTypeNames = string.Empty;
CoursewareTypeDAL coursewareTypeDAL = new CoursewareTypeDAL();
CoursewareType coursewareType = coursewareTypeDAL.GetCoursewareType(courseware.CoursewareTypeID);
courseware.CoursewareTypeNames = GetCoursewareTypeNames("/" + coursewareType.CoursewareTypeName, coursewareType.ParentId);
while (dataReader1.Read())
{
if (dataReader1["TRAIN_TYPE_ID"].ToString() != "")
{
trainTypeIDAL.Add(DataConvert.ToInt(dataReader1["TRAIN_TYPE_ID"].ToString()));
strTrainTypeNames += GetTrainTypeNames("/" + dataReader1["TRAIN_TYPE_NAME"].ToString(), int.Parse(dataReader1["PARENT_ID"].ToString())) + ",";
}
}
while (dataReader2.Read())
{
if (dataReader2["ORG_ID"].ToString() != "")
{
orgIDAL.Add(DataConvert.ToInt(dataReader2["ORG_ID"].ToString()));
}
}
while (dataReader3.Read())
{
if (dataReader3["POST_ID"].ToString() != "")
{
postIDAL.Add(DataConvert.ToInt(dataReader3["POST_ID"].ToString()));
}
}
if (strTrainTypeNames.Length > 0)
{
strTrainTypeNames = strTrainTypeNames.Substring(0, strTrainTypeNames.Length - 1);
}
courseware.TrainTypeIDAL = trainTypeIDAL;
courseware.OrgIDAL = orgIDAL;
courseware.PostIDAL = postIDAL;
courseware.TrainTypeNames = strTrainTypeNames;
return(courseware);
}
