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