protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { DataSet ds = DBEntity.Tab_CourseMain_Type.GetDs(); this.ddlCourseType.DataSource = ds.Tables[0]; this.ddlCourseType.DataTextField = "CourseMainType"; this.ddlCourseType.DataValueField = "Idx"; this.ddlCourseType.DataBind(); //========================== string idx = Request["Idx"]; if (!String.IsNullOrEmpty(idx)) { DBEntity.Tab_CourseMain ent = new DBEntity.Tab_CourseMain(); ent = ent.Get(idx); this.Title.Text = ent.Title; this.CourseContent.Text = ent.CourseContent; this.Image1.ImageUrl = string.Format("~/upload/CourseMain/{0}", ent.PreviewImg); this.SortNo.Text = ent.SortNo.ToString(); this.ReleaseDate.Text = ent.ReleaseDate.ToString(); for (int i = 0; i < this.HomeShowBool.Items.Count; i++) { if (this.HomeShowBool.Items[i].Value == ent.HomeShowBool) { this.HomeShowBool.Items[i].Selected = true; } } for (int i = 0; i < this.ddlCourseType.Items.Count; i++) { if (this.ddlCourseType.Items[i].Value == ent.CourseMainTypeIdx_Fx.ToString()) { this.ddlCourseType.Items[i].Selected = true; } } this.hiddenFileName.Value = ent.PreviewImg; //======== DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_CourseMain where Idx=@Idx" , new SqlParameter("Idx", idx)).Tables[0]; if (dt.Rows.Count == 1) { this.ActivityDescption.Text = dt.Rows[0]["ActivityDescption"].ToString(); this.ActivityUrl.Text = dt.Rows[0]["ActivityUrl"].ToString(); } } } }
public int AddNew(Tab_CourseMain model) { string sql = "insert into Tab_CourseMain(PreviewImg,Title,CourseContent,SortNo,ReleaseDate,HomeShowBool,CourseMainTypeIdx_Fx) values(@PreviewImg,@Title,@CourseContent,@SortNo,@ReleaseDate,@HomeShowBool,@CourseMainTypeIdx_Fx); select @@identity ;"; int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql , new SqlParameter("@PreviewImg", model.PreviewImg) , new SqlParameter("@Title", model.Title) , new SqlParameter("@CourseContent", model.CourseContent) , new SqlParameter("@SortNo", model.SortNo) , new SqlParameter("@ReleaseDate", model.ReleaseDate) , new SqlParameter("@HomeShowBool", model.HomeShowBool) , new SqlParameter("@CourseMainTypeIdx_Fx", model.CourseMainTypeIdx_Fx) )); return(Idx); }
private static Tab_CourseMain ToModel(DataRow row) { Tab_CourseMain model = new Tab_CourseMain(); model.Idx = row.IsNull("Idx")?null:(System.Int32?)row["Idx"]; model.PreviewImg = row.IsNull("PreviewImg")?null:(System.String)row["PreviewImg"]; model.Title = row.IsNull("Title")?null:(System.String)row["Title"]; model.CourseContent = row.IsNull("CourseContent")?null:(System.String)row["CourseContent"]; model.SortNo = row.IsNull("SortNo")?null:(System.Int32?)row["SortNo"]; model.DateCreated = row.IsNull("DateCreated")?null:(System.DateTime?)row["DateCreated"]; model.ReleaseDate = row.IsNull("ReleaseDate")?null:(System.DateTime?)row["ReleaseDate"]; model.HomeShowBool = row.IsNull("HomeShowBool")?null:(System.String)row["HomeShowBool"]; model.CourseMainTypeIdx_Fx = row.IsNull("CourseMainTypeIdx_Fx") ? null : (System.Int32?)row["CourseMainTypeIdx_Fx"]; return(model); }
public bool Update(Tab_CourseMain model) { string sql = "update Tab_CourseMain set PreviewImg=@PreviewImg,Title=@Title,CourseContent=@CourseContent,SortNo=@SortNo,DateCreated=getdate(),ReleaseDate=@ReleaseDate,HomeShowBool=@HomeShowBool,CourseMainTypeIdx_Fx=@CourseMainTypeIdx_Fx where Idx=@Idx"; int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql , new SqlParameter("@PreviewImg", model.PreviewImg) , new SqlParameter("@Title", model.Title) , new SqlParameter("@CourseContent", model.CourseContent) , new SqlParameter("@SortNo", model.SortNo) , new SqlParameter("@ReleaseDate", model.ReleaseDate) , new SqlParameter("@HomeShowBool", model.HomeShowBool) , new SqlParameter("@CourseMainTypeIdx_Fx", model.CourseMainTypeIdx_Fx) , new SqlParameter("Idx", model.Idx) ); return(rows > 0); }
protected void btnSubmit_Click(object sender, EventArgs e) { string fileName = this.hiddenFileName.Value; if (myFileUpload.HasFile) { Cmn.uploadFile upF = new Cmn.uploadFile(); string[] allowExtensions = { ".jpg", ".gif", ".png" }; int maxSize = Convert.ToInt32(Cmn.WebConfig.getApp("app_MaxSizeUpload")); string savePath = Request.MapPath("~/upload/CourseMain/"); fileName = myFileUpload.FileName; try { upF.Upload(this.myFileUpload, allowExtensions, maxSize, savePath, fileName); } catch (Exception exp) { Cmn.Js.ShowAlert(exp.Message); return; } } DBEntity.Tab_CourseMain ent = new DBEntity.Tab_CourseMain(); ent.Idx = int.Parse(Request["Idx"]); ent.Title = this.Title.Text; ent.PreviewImg = fileName; ent.CourseContent = this.CourseContent.Text; ent.HomeShowBool = this.HomeShowBool.SelectedValue; ent.SortNo = Convert.ToInt32(this.SortNo.Text); ent.ReleaseDate = DateTime.Parse(this.ReleaseDate.Text); ent.CourseMainTypeIdx_Fx = Convert.ToInt32(this.ddlCourseType.SelectedValue); ent.Update(ent); string strSql = "update Tab_CourseMain set ActivityDescption='{0}' ,ActivityUrl='{1}' where Idx='{2}'"; strSql = string.Format(strSql, this.ActivityDescption.Text, this.ActivityUrl.Text, Request["Idx"]); SqlHelper.ExecuteNonQuery(CommandType.Text, strSql); Cmn.Js.ShowAlert("操作成功!"); Cmn.Js.ExeScript("location.href='CourseMainManage.aspx'"); }
public Tab_CourseMain Get(string Idx) { DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_CourseMain where Idx=@Idx", new SqlParameter("Idx", Idx)).Tables[0]; if (dt.Rows.Count > 1) { throw new Exception("more than 1 row was found"); } if (dt.Rows.Count <= 0) { return(null); } DataRow row = dt.Rows[0]; Tab_CourseMain model = ToModel(row); return(model); }
//课件列表 private void CourseList() { string strSql = "select top 3 *,DATEDIFF(DAY,ReleaseDate,GETDATE()) from Tab_CourseMain where HomeShowBool='yes' and DATEDIFF(DAY,ReleaseDate,GETDATE())>=0 order by SortNo"; IEnumerable <DBEntity.Tab_CourseMain> ents = new DBEntity.Tab_CourseMain().ListAll(strSql); StringBuilder contentStr = new StringBuilder(); string readCount = "0"; foreach (DBEntity.Tab_CourseMain ent in ents) { strSql = string.Format("select count(1) from Tab_CourseMain_ViewLog where CourseMainIdx={0}", ent.Idx); readCount = SqlHelper.ExecuteScalar(CommandType.Text, strSql).ToString().PadLeft(5, '0'); contentStr.AppendLine("<li>"); contentStr.AppendLine(string.Format("<div class='num1'>{0}</div>", readCount)); contentStr.AppendLine(string.Format("<div class='pic'><a href='{0}/sisley-academy.aspx?cmIdx={1}' onclick='AddViewLog(\"{1}\",\"{3}\")'><img src='upload/CourseMain/{2}' width='133' height='75' /></a></div>", Cmn.WebConfig.getApp("app_WebsiteDomain"), ent.Idx, ent.PreviewImg, ent.Title)); contentStr.AppendLine(string.Format("<div class='text'><span>{0}</span><br />{1}</div>", Cmn.Str.GetStr(ent.Title, 30, false), Cmn.Str.GetStr(ent.CourseContent, 60, true))); contentStr.AppendLine("</li>"); } this.ltlCourseList.Text = contentStr.ToString(); }