/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Tao.Modules GetModel(int ModuleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ModuleID,ModuleName,Description,TimeDuration,Status,Tags,ImageUrl,Type,VideoContent,CreatedDate,CreatedUserID,Price,PV,Sequence,Attachment,UpdatedDate from Tao_Modules "); strSql.Append(" where ModuleID=@ModuleID"); SqlParameter[] parameters = { new SqlParameter("@ModuleID", SqlDbType.Int,4) }; parameters[0].Value = ModuleID; Maticsoft.Model.Tao.Modules model = new Maticsoft.Model.Tao.Modules(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ModuleID"] != null && ds.Tables[0].Rows[0]["ModuleID"].ToString() != "") { model.ModuleID = int.Parse(ds.Tables[0].Rows[0]["ModuleID"].ToString()); } if (ds.Tables[0].Rows[0]["ModuleName"] != null && ds.Tables[0].Rows[0]["ModuleName"].ToString() != "") { model.ModuleName = ds.Tables[0].Rows[0]["ModuleName"].ToString(); } if (ds.Tables[0].Rows[0]["Description"] != null && ds.Tables[0].Rows[0]["Description"].ToString() != "") { model.Description = ds.Tables[0].Rows[0]["Description"].ToString(); } if (ds.Tables[0].Rows[0]["TimeDuration"] != null && ds.Tables[0].Rows[0]["TimeDuration"].ToString() != "") { model.TimeDuration = int.Parse(ds.Tables[0].Rows[0]["TimeDuration"].ToString()); } if (ds.Tables[0].Rows[0]["Status"] != null && ds.Tables[0].Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString()); } if (ds.Tables[0].Rows[0]["Tags"] != null && ds.Tables[0].Rows[0]["Tags"].ToString() != "") { model.Tags = ds.Tables[0].Rows[0]["Tags"].ToString(); } if (ds.Tables[0].Rows[0]["ImageUrl"] != null && ds.Tables[0].Rows[0]["ImageUrl"].ToString() != "") { model.ImageUrl = ds.Tables[0].Rows[0]["ImageUrl"].ToString(); } if (ds.Tables[0].Rows[0]["Type"] != null && ds.Tables[0].Rows[0]["Type"].ToString() != "") { model.Type = int.Parse(ds.Tables[0].Rows[0]["Type"].ToString()); } if (ds.Tables[0].Rows[0]["VideoContent"] != null && ds.Tables[0].Rows[0]["VideoContent"].ToString() != "") { model.VideoContent = ds.Tables[0].Rows[0]["VideoContent"].ToString(); } if (ds.Tables[0].Rows[0]["CreatedDate"] != null && ds.Tables[0].Rows[0]["CreatedDate"].ToString() != "") { model.CreatedDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedDate"].ToString()); } if (ds.Tables[0].Rows[0]["CreatedUserID"] != null && ds.Tables[0].Rows[0]["CreatedUserID"].ToString() != "") { model.CreatedUserID = int.Parse(ds.Tables[0].Rows[0]["CreatedUserID"].ToString()); } if (ds.Tables[0].Rows[0]["Price"] != null && ds.Tables[0].Rows[0]["Price"].ToString() != "") { model.Price = decimal.Parse(ds.Tables[0].Rows[0]["Price"].ToString()); } if (ds.Tables[0].Rows[0]["PV"] != null && ds.Tables[0].Rows[0]["PV"].ToString() != "") { model.PV = int.Parse(ds.Tables[0].Rows[0]["PV"].ToString()); } if (ds.Tables[0].Rows[0]["Sequence"] != null && ds.Tables[0].Rows[0]["Sequence"].ToString() != "") { model.Sequence = int.Parse(ds.Tables[0].Rows[0]["Sequence"].ToString()); } if (ds.Tables[0].Rows[0]["Attachment"] != null && ds.Tables[0].Rows[0]["Attachment"].ToString() != "") { model.Attachment = ds.Tables[0].Rows[0]["Attachment"].ToString(); } if (ds.Tables[0].Rows[0]["UpdatedDate"] != null && ds.Tables[0].Rows[0]["UpdatedDate"].ToString() != "") { model.UpdatedDate = DateTime.Parse(ds.Tables[0].Rows[0]["UpdatedDate"].ToString()); } return model; } else { return null; } }
protected void btnSava_Click(object sender, EventArgs e) { int iCourseId = 0; if (Request.QueryString["CourseId"] != null) { iCourseId = int.Parse(Request.QueryString["CourseId"]); cid = iCourseId; } if (string.IsNullOrEmpty(this.txtModuleName.Text.Trim())) { this.ErrorMsg.Visible = true; this.ErrorMsg.Text = "小节名称不能为空"; return; } if (string.IsNullOrEmpty(this.btnSava.CommandArgument)) { module = new Model.Tao.Modules(); } else { int mId = int.Parse(this.btnSava.CommandArgument); module = modulesBll.GetModel(mId); } //Maticsoft.Model.Tao.Modules module = new Maticsoft.Model.Tao.Modules(); module.ModuleName = this.txtModuleName.Text.Trim(); module.Description = this.txtDescription.Text.Trim(); int iResult = 0; //判断是否为新增小节,当this.btnSava.CommandArgument有值,则为”新增“,否则为”修改“ if (string.IsNullOrEmpty(this.btnSava.CommandArgument)) { //添加课程小节 module.CreatedDate = DateTime.Now; iResult = modulesBll.Add(module); if (iResult > 0) { Maticsoft.Model.Tao.CourseModule courseModule = new Maticsoft.Model.Tao.CourseModule(); courseModule.CourseID = iCourseId; courseModule.ModuleID = iResult; courseModule.ModuleIndex = courseModuleBll.GetMaxModuleIndex(iCourseId); if (courseModuleBll.Add(courseModule) > 0) { this.ErrorMsg.Text = "新增课程成功!"; } } else { modulesBll.Delete(iResult); this.ErrorMsg.Text = "新增课程小节失败,请重试!"; } } else { module.ModuleID = int.Parse(this.btnSava.CommandArgument); this.btnSava.CommandArgument = null; module.UpdatedDate = DateTime.Now; modulesBll.Update(module); } this.txtDescription.Text = string.Empty; this.txtModuleName.Text = string.Empty; this.ErrorMsg.Visible = false; BindData(iCourseId); }