//首页杂志浏览,下载Url private void MagazineHomeAd() { DBEntity.Tab_magazineHomeAd ent = new DBEntity.Tab_magazineHomeAd(); ent = ent.Get("1"); this.MagazineAd_BrowserUrl.HRef = ent.BrowserUrl; this.MagazineAd_DownlowdRarPath.HRef = ent.DownlowdRarPath; }
private static Tab_magazineHomeAd ToModel(DataRow row) { Tab_magazineHomeAd model = new Tab_magazineHomeAd(); model.Idx = row.IsNull("Idx")?null:(System.Int32?)row["Idx"]; model.DownlowdRarPath = row.IsNull("DownlowdRarPath")?null:(System.String)row["DownlowdRarPath"]; model.BrowserUrl = row.IsNull("BrowserUrl")?null:(System.String)row["BrowserUrl"]; return(model); }
public int AddNew(Tab_magazineHomeAd model) { string sql = "insert into Tab_magazineHomeAd(DownlowdRarPath,BrowserUrl) values(@DownlowdRarPath,@BrowserUrl); select @@identity ;"; int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql , new SqlParameter("@DownlowdRarPath", model.DownlowdRarPath) , new SqlParameter("@BrowserUrl", model.BrowserUrl) )); return(Idx); }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { DBEntity.Tab_magazineHomeAd ent = new DBEntity.Tab_magazineHomeAd(); ent = ent.Get("1"); this.BrowserUrl.Text = ent.BrowserUrl; this.DownlowdRarPath.Text = ent.DownlowdRarPath; } }
public bool Update(Tab_magazineHomeAd model) { string sql = "update Tab_magazineHomeAd set DownlowdRarPath=@DownlowdRarPath,BrowserUrl=@BrowserUrl where Idx=@Idx"; int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql , new SqlParameter("@DownlowdRarPath", model.DownlowdRarPath) , new SqlParameter("@BrowserUrl", model.BrowserUrl) , new SqlParameter("Idx", model.Idx) ); return(rows > 0); }
protected void btnSubmit_Click(object sender, EventArgs e) { DBEntity.Tab_magazineHomeAd ent = new DBEntity.Tab_magazineHomeAd(); ent.Idx = 1; ent.BrowserUrl = this.BrowserUrl.Text; ent.DownlowdRarPath = this.DownlowdRarPath.Text; ent.Update(ent); Cmn.Js.ShowAlert("操作成功!"); Cmn.Js.ExeScript("location.href='AdvertisementEditMagazine.aspx'"); }
public Tab_magazineHomeAd Get(string Idx) { DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_magazineHomeAd 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_magazineHomeAd model = ToModel(row); return(model); }