public void UpdateCoursewareTrainType(CoursewareTrainType obj) { Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_COURSEWARE_TRAIN_TYPE_U"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_courseware_id", DbType.Int32, obj.CoursewareID); db.AddInParameter(dbCommand, "p_train_type_id", DbType.Int32, obj.TrainTypeID); db.AddInParameter(dbCommand, "p_order_index", DbType.Int32, obj.OrderIndex); db.ExecuteNonQuery(dbCommand); }
protected void btnOK_Click(object sender, EventArgs e) { if (Request.QueryString.Get("TrainTypeID") != null) { int bookID = Convert.ToInt32(Request.QueryString.Get("CoursewareID")); int trainTypeID = Convert.ToInt32(Request.QueryString.Get("TrainTypeID")); CoursewareTrainTypeBLL objBll = new CoursewareTrainTypeBLL(); CoursewareTrainType obj = objBll.GetCoursewareTrainType(bookID, trainTypeID); int order = Convert.ToInt32(txtOrderIndex.Text); int max = Convert.ToInt32(Request.QueryString.Get("MaxOrder")); if (order > max) { obj.OrderIndex = max; } else { obj.OrderIndex = order; } objBll.UpdateCoursewareTrainType(obj); } else { CoursewareBLL objBll = new CoursewareBLL(); RailExam.Model.Courseware obj = objBll.GetCourseware(Convert.ToInt32(Request.QueryString.Get("CoursewareID"))); int order = Convert.ToInt32(txtOrderIndex.Text); int max = Convert.ToInt32(Request.QueryString.Get("MaxOrder")); if (order > max) { obj.OrderIndex = max; } else { obj.OrderIndex = order; } objBll.UpdateCourseware(obj); } Response.Write("<script>top.returnValue='true';window.close();</script>"); }
public CoursewareTrainType GetCoursewareTrainType(int coursewareID, int trainTypeID) { CoursewareTrainType obj = new CoursewareTrainType(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_COURSEWARE_TRAIN_TYPE_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_courseware_id", DbType.Int32, coursewareID); db.AddInParameter(dbCommand, "p_train_type_id", DbType.Int32, trainTypeID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { obj = CreateModelObject(dataReader); } } return(obj); }
public IList <CoursewareTrainType> GetCoursewareTrainTypeByCoursewareID(int coursewareID) { IList <CoursewareTrainType> objList = new List <CoursewareTrainType>(); Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_COURSEWARE_TRAIN_TYPE_S"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_courseware_id", DbType.Int32, coursewareID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { CoursewareTrainType obj = CreateModelObject(dataReader); objList.Add(obj); } } return(objList); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PrjPub.CurrentLoginUser == null) { Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } if (PrjPub.HasEditRight("课件管理") && PrjPub.IsServerCenter) //&& PrjPub.CurrentLoginUser.SuitRange == 1 { HfUpdateRight.Value = "True"; } else { HfUpdateRight.Value = "False"; } if (PrjPub.HasDeleteRight("课件管理") && PrjPub.IsServerCenter) //&& PrjPub.CurrentLoginUser.SuitRange == 1 { HfDeleteRight.Value = "True"; } else { HfDeleteRight.Value = "False"; } OrganizationBLL orgBll = new OrganizationBLL(); int orgID = orgBll.GetStationOrgID(PrjPub.CurrentLoginUser.OrgID); HfOrgId.Value = orgID.ToString(); BindGrid(); } else { string strDeleteID = Request.Form.Get("DeleteID"); if (!string.IsNullOrEmpty(strDeleteID)) { DeleteData(int.Parse(strDeleteID)); BindGrid(); } if (Request.Form.Get("Refresh") == "true") { BindGrid(); } } string strUpID = Request.Form.Get("UpID"); if (strUpID != null && strUpID != "") { if (Request.QueryString.Get("type") == "Courseware") { CoursewareBLL objBll = new CoursewareBLL(); RailExam.Model.Courseware obj = objBll.GetCourseware(Convert.ToInt32(strUpID)); obj.OrderIndex = obj.OrderIndex - 1; objBll.UpdateCourseware(obj); } if (Request.QueryString.Get("type") == "TrainType") { int trainTypeID = Convert.ToInt32(Request.QueryString.Get("id")); CoursewareTrainTypeBLL objTrainTypeBll = new CoursewareTrainTypeBLL(); CoursewareTrainType objTrainType = objTrainTypeBll.GetCoursewareTrainType(Convert.ToInt32(strUpID), trainTypeID); objTrainType.OrderIndex = objTrainType.OrderIndex - 1; objTrainTypeBll.UpdateCoursewareTrainType(objTrainType); } BindGrid(); } string strDownID = Request.Form.Get("DownID"); if (strDownID != null && strDownID != "") { if (Request.QueryString.Get("type") == "Courseware") { CoursewareBLL objBll = new CoursewareBLL(); RailExam.Model.Courseware obj = objBll.GetCourseware(Convert.ToInt32(strDownID)); obj.OrderIndex = obj.OrderIndex + 1; objBll.UpdateCourseware(obj); } if (Request.QueryString.Get("type") == "TrainType") { int trainTypeID = Convert.ToInt32(Request.QueryString.Get("id")); CoursewareTrainTypeBLL objTrainTypeBll = new CoursewareTrainTypeBLL(); CoursewareTrainType objTrainType = objTrainTypeBll.GetCoursewareTrainType(Convert.ToInt32(strDownID), trainTypeID); objTrainType.OrderIndex = objTrainType.OrderIndex + 1; objTrainTypeBll.UpdateCoursewareTrainType(objTrainType); } BindGrid(); } }
public void UpdateCoursewareTrainType(CoursewareTrainType coursewareTrainType) { dal.UpdateCoursewareTrainType(coursewareTrainType); }
public void AddCoursewareTrainType(CoursewareTrainType coursewareTrainType) { dal.AddCoursewareTrainType(coursewareTrainType); }