protected void btnUpdateGravatar_Click(object sender, EventArgs e) { BLL.Tao.Courses CourseBll = new BLL.Tao.Courses(); int imageWidth = Int32.Parse(txt_width.Text); int imageHeight = Int32.Parse(txt_height.Text); int cutTop = Int32.Parse(txt_top.Text); int cutLeft = Int32.Parse(txt_left.Text); int dropWidth = Int32.Parse(txt_DropWidth.Text); int dropHeight = Int32.Parse(txt_DropHeight.Text); uploadFolder += "/" + CurrentUser.UserID + "/" + CourseId; string filename = Maticsoft.Common.CutPhotoHelp.SaveCutPic(Server.MapPath(ImageIcon.ImageUrl), Server.MapPath("/" + uploadFolder), 0, 0, dropWidth, dropHeight, cutLeft, cutTop, imageWidth, imageHeight); if (CourseId > 0) { Model.Tao.Courses CourseModle = new Model.Tao.Courses(); CourseModle.ImageUrl = "/" + uploadFolder + "/" + filename; CourseModle.CourseID = CourseId; string returnUrl = Request.QueryString["ReturnUrl"]; if (CourseBll.EditCourseThumbnai(CourseModle)) { Response.Redirect(returnUrl); } else { Maticsoft.Common.MessageBox.Show(this, "课程图片上传失败!"); Response.Redirect(returnUrl); return; } } }
public override void DataBind() { courseModel=new Model.Tao.Courses(); courseModel.CreatedUserID = UserID; courseModel.Status = Status; System.Data.DataSet ds = courseBLL.PublishCourseInfo(courseModel); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { this.Repeater_CourseView.DataSource = ds; this.Repeater_CourseView.DataBind(); isMore = "<div class=\"more\"><a href=\"/searchCourse.aspx?key=" + TeacherName + "&uid=" + UserID + "\">更 多课程 >></a></div>"; } } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtExpiryDate.Text)) { strErr += "有效期格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } Model.Tao.Courses CourseModel = new Model.Tao.Courses(); CourseModel.CourseName = this.txtCourseName.Text; CourseModel.ShortDescription = this.txtShortDescription.Text; CourseModel.Description = this.txtContent.Text; CourseModel.CategoryId = Convert.ToInt32(this.listTarget.SelectedValue); CourseModel.ModuleNum = Convert.ToInt32(this.txtModuleCount.Text); CourseModel.TimeDuration = BLL.ConvertTime.TimeToSecond(int.Parse(txtTimeHour.Value), int.Parse(txtMinute.Value), int.Parse(txtSeconds.Value)); CourseModel.ExpiryDate = Convert.ToDateTime(this.txtExpiryDate.Text); CourseModel.Tags = this.txtTags.Text; string imgPath = UploadImage(fileImageUrl, 1); if (string.IsNullOrEmpty(imgPath)) { return; } CourseModel.ImageUrl = imgPath; CourseModel.Status = Convert.ToInt32(this.ddlStatus.SelectedValue); CourseModel.CreatedUserID = CurrentUser.UserID; CourseModel.Recommended = rbRec.Checked ? true : false; CourseModel.SpecialOffer = rbCheap.Checked ? true : false; CourseModel.Hotsale = rbHot.Checked ? true : false; CourseModel.Latest = rbNew.Checked ? true : false; CourseModel.Price = Convert.ToDecimal(this.txtPrince.Text); CourseModel.Sequence = Convert.ToInt32(this.txtOrder.Text); bll.Add(CourseModel); Response.Redirect("list.aspx"); }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsDateTime(txtExpiryDate.Text)) { strErr += "有效期格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } Model.Tao.Courses CourseModel = new Model.Tao.Courses(); CourseModel.CourseID = Convert.ToInt32(hfCourseID.Value); CourseModel.CourseName = this.txtCourseName.Text; CourseModel.ShortDescription = this.txtShortDescription.Text; CourseModel.Description = this.txtContent.Text; CourseModel.ImageUrl = UploadImage(fileImageUrl, 2); if (string.IsNullOrEmpty(CourseModel.ImageUrl)) { CourseModel.ImageUrl = hfImgUrl.Value; } CourseModel.CategoryId = Convert.ToInt32(this.listTarget.SelectedValue); CourseModel.ModuleNum = Convert.ToInt32(this.txtModuleCount.Text); CourseModel.TimeDuration = BLL.ConvertTime.TimeToSecond(int.Parse(txtTimeHour.Value), int.Parse(txtMinute.Value), int.Parse(txtSeconds.Value)); CourseModel.ExpiryDate = Convert.ToDateTime(this.txtExpiryDate.Text); CourseModel.Tags = this.txtTags.Text; CourseModel.Status = Convert.ToInt32(this.ddlStatus.SelectedValue); CourseModel.Recommended = rbRec.Checked ? true : false; CourseModel.SpecialOffer = rbCheap.Checked ? true : false; CourseModel.Hotsale = rbHot.Checked ? true : false; CourseModel.Latest = rbNew.Checked ? true : false; if (!string.IsNullOrEmpty(txtPrince.Text)) { if (PageValidate.IsDecimal(txtPrince.Text) || PageValidate.IsNumber(txtPrince.Text)) { CourseModel.Price = Convert.ToDecimal(this.txtPrince.Text); } else { Maticsoft.Common.MessageBox.Show(this, "输入格式不正确!"); return; } } if (!string.IsNullOrEmpty(txtOrder.Text)) { if (PageValidate.IsNumber(txtOrder.Text)) { CourseModel.Sequence = Convert.ToInt32(this.txtOrder.Text); } } if (!string.IsNullOrEmpty(hfCreatedUserID.Value)) { if (PageValidate.IsNumber(hfCreatedUserID.Value)) { CourseModel.CreatedUserID = Convert.ToInt32(hfCreatedUserID.Value); } } if (!string.IsNullOrEmpty(hfViewCount.Value)) { if (PageValidate.IsNumber(hfViewCount.Value)) { CourseModel.ViewCount = Convert.ToInt32(hfViewCount.Value); } } if (!string.IsNullOrEmpty(hfCourseSpan.Value)) { if (PageValidate.IsNumber(hfCourseSpan.Value)) { CourseModel.CourseSpan = Convert.ToInt32(hfCourseSpan.Value); } } if (!string.IsNullOrEmpty(hfPV.Value)) { if (PageValidate.IsNumber(hfPV.Value)) { CourseModel.PV = Convert.ToInt32(hfPV.Value); } } if (!string.IsNullOrEmpty(hfCourseTypes.Value)) { if (PageValidate.IsNumber(hfCourseTypes.Value)) { CourseModel.CourseTypes = Convert.ToInt32(hfCourseTypes.Value); } } if (!string.IsNullOrEmpty(hfCreatedDate.Value)) { if (PageValidate.IsDateTime(hfCreatedDate.Value)) { CourseModel.CreatedDate = Convert.ToDateTime(hfCreatedDate.Value); } } bll.Update(CourseModel); Response.Redirect("list.aspx"); }
/// <summary> /// 根据CourseID得到CourseName /// </summary> public Model.Tao.Courses GetCourseName(int CourseID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT CourseName "); strSql.Append("FROM Tao_Courses "); strSql.Append("WHERE CourseID=@CourseID "); SqlParameter[] parameters = { new SqlParameter("@CourseID", SqlDbType.Int,4) }; parameters[0].Value = CourseID; Model.Tao.Courses model = new Model.Tao.Courses(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["CourseName"] != null && ds.Tables[0].Rows[0]["CourseName"].ToString() != "") { model.CourseName = ds.Tables[0].Rows[0]["CourseName"].ToString(); } return model; } else { return null; } }
private void CourseExistTime(int cid) { courseModule = courseBll.GetModel(cid); if (courseModule.CourseSpan == 1) { if (courseModule.ViewCount == -1) { this.rbNolimit.Checked = true; } else { this.rbSum.Checked = true; this.limitSum.Value = courseModule.ViewCount.ToString(); } } if (courseModule.ExpiryDate.HasValue) { TimeSpan ts1 = new TimeSpan(courseModule.ExpiryDate.Value.Ticks); TimeSpan ts2 = new TimeSpan(DateTime.Now.Ticks); TimeSpan ts = ts1.Subtract(ts2).Duration(); if (ts.Days > 365) { this.rbForever.Checked = true; } else { this.rbExpTime.Checked = true; this.txtExpTime.Value = courseModule.ExpiryDate.Value.ToString("yyyy-MM-dd"); } } if (courseModule.Price.HasValue) { this.priceName.Value = courseModule.Price.ToString(); } else { this.priceName.Value = "0.00"; } }