protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { string idx = Request["Idx"]; if (!String.IsNullOrEmpty(idx)) { DBEntity.Tab_xw_FlashItem ent = new DBEntity.Tab_xw_FlashItem(); ent = ent.Get(idx); this.aTitle.Text = ent.aTitle; this.Image1.ImageUrl = string.Format("~/upload/Advertisement/{0}", ent.aImg); this.aOrderNumb.Text = ent.aOrderNumb.ToString(); this.aTypeName.Text = ent.aTypeName.ToString(); this.hiddenFileName.Value = ent.aImg; ltlPageTitle.Text = "Flash广告-编辑"; } else { ltlPageTitle.Text = "Flash广告-添加"; } } }
private static Tab_xw_FlashItem ToModel(DataRow row) { Tab_xw_FlashItem model = new Tab_xw_FlashItem(); model.Idx = row.IsNull("Idx") ? null : (System.Int32?)row["Idx"]; model.aTitle = row.IsNull("aTitle") ? null : (System.String)row["aTitle"]; model.aLink = row.IsNull("aLink") ? null : (System.String)row["aLink"]; model.aImg = row.IsNull("aImg") ? null : (System.String)row["aImg"]; model.aTypeName = row.IsNull("aTypeName") ? null : (System.String)row["aTypeName"]; model.aCreatedate = row.IsNull("aCreatedate") ? null : (System.DateTime?)row["aCreatedate"]; model.aOrderNumb = row.IsNull("aOrderNumb") ? null : (System.Int32?)row["aOrderNumb"]; return(model); }
public int AddNew(Tab_xw_FlashItem model) { string sql = "insert into Tab_xw_FlashItem(aTitle,aLink,aImg,aTypeName,aCreatedate,aOrderNumb) values(@aTitle,@aLink,@aImg,@aTypeName,@aCreatedate,@aOrderNumb); select @@identity ;"; int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql , new SqlParameter("@aTitle", model.aTitle) , new SqlParameter("@aLink", model.aLink) , new SqlParameter("@aImg", model.aImg) , new SqlParameter("@aTypeName", model.aTypeName) , new SqlParameter("@aCreatedate", model.aCreatedate) , new SqlParameter("@aOrderNumb", model.aOrderNumb) )); return(Idx); }
public bool Update(Tab_xw_FlashItem model) { string sql = "update Tab_xw_FlashItem set aTitle=@aTitle,aLink=@aLink,aImg=@aImg,aTypeName=@aTypeName,aCreatedate=@aCreatedate,aOrderNumb=@aOrderNumb where Idx=@Idx"; int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql , new SqlParameter("@aTitle", model.aTitle) , new SqlParameter("@aLink", model.aLink) , new SqlParameter("@aImg", model.aImg) , new SqlParameter("@aTypeName", model.aTypeName) , new SqlParameter("@aCreatedate", model.aCreatedate) , new SqlParameter("@aOrderNumb", model.aOrderNumb) , 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/Advertisement/"); fileName = Cmn.Date.ToDateStr2(DateTime.Now) + "_" + Cmn.Rand.GetGuid() + "." + Cmn.Str.GetFileExtends(myFileUpload.FileName); try { upF.Upload(this.myFileUpload, allowExtensions, maxSize, savePath, fileName); } catch (Exception exp) { Cmn.Js.ShowAlert(exp.Message); return; } } string idx = Request["Idx"]; DBEntity.Tab_xw_FlashItem ent = new DBEntity.Tab_xw_FlashItem(); ent.aTitle = this.aTitle.Text; ent.aLink = this.aLink.Text; ent.aImg = fileName; ent.aOrderNumb = Convert.ToInt32(this.aOrderNumb.Text); ent.aTypeName = this.aTypeName.Text; ent.aCreatedate = DateTime.Now; if (string.IsNullOrEmpty(idx)) { ent.AddNew(ent); } else { ent.Idx = Convert.ToInt32(idx); ent.Update(ent); } Cmn.Js.ShowAlert("操作成功!"); Cmn.Js.ExeScript("location.href='xwFlashItemManage.aspx'"); }
public Tab_xw_FlashItem Get(string Idx) { DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_xw_FlashItem 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_xw_FlashItem model = ToModel(row); return(model); }