/// <summary> /// 得到一个实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public ShowShop.Model.Accessories.Hailhellowlink GetModelByID(int id) { ShowShop.Model.Accessories.Hailhellowlink model = new ShowShop.Model.Accessories.Hailhellowlink(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 [id],[sitename],[siteurl],[sitelogo],[sitelevel],[sitecontent],[sitelinktype],[sitestate],[siteclickcount],[createdate],[updatedate],[putoutid],[putouttyid],[aread] from yxs_hailhellowlink "); strSql.Append(" where [id]=@id "); SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.Read()) { model.ID = reader.GetInt32(0); model.SiteName = reader.GetString(1); model.SiteUrl = reader.GetString(2); model.SiteLogo = reader.GetString(3); model.SiteLevel = reader.GetInt32(4); model.SiteContent = reader.GetString(5); model.SiteLinkType = reader.GetInt32(6); model.SiteState = reader.GetInt32(7); model.SiteClickCount = reader.GetInt32(8); model.CreateDate = reader.GetDateTime(9); model.UpdateDate = reader.GetDateTime(10); model.PutoutID = reader.GetInt32(11); model.PutoutTyID = reader.GetInt32(12); model.Aread = reader.GetString(13); //model.SiteImages = reader.GetString(14);// } } return model; }
/// <summary> /// 保存 /// </summary> protected void Save() { ShowShop.BLL.Accessories.Hailhellowlink bll = new ShowShop.BLL.Accessories.Hailhellowlink(); ShowShop.Model.Accessories.Hailhellowlink model = new ShowShop.Model.Accessories.Hailhellowlink(); ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); model.SiteName = this.txtSiteName.Text.Trim(); model.SiteUrl = this.txtSiteUrl.Text.Trim(); if (this.txtSiteLogo.Text.Trim() != null && this.txtSiteLogo.Text.Trim() != "" && !this.fuSmallImages.HasFile) { model.SiteLogo = this.txtSiteLogo.Text.Trim(); } else { //获取图片 ChangeHope.Common.UploadFile uf = new ChangeHope.Common.UploadFile(); uf.ExtensionLim = ".gif,.jpg,.jpeg,.dmp"; uf.FileLengthLim = sp.ImageSize; uf.PostedFile = this.fuSmallImages; uf.SavePath = "/yxuploadfile/brand"; if (uf.Upload()) { if (uf.HaveLoad) { model.SiteLogo = uf.FilePath; } else { if (ViewState["SiteImages"] != null) { model.SiteLogo = ViewState["SiteImages"].ToString(); } else { model.SiteLogo = string.Empty; } } } else { this.ltlMsg.Text = "操作失败," + uf.Message + ""; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } //model.SiteLogo = this.txtSiteLogo.Text.Trim(); model.SiteLevel = Convert.ToInt32(this.txtSiteLevel.Text.Trim()); model.SiteContent = this.txtSiteContent.Text.Trim(); model.SiteLinkType = Convert.ToInt32(this.rablistLinkType.SelectedValue); model.SiteState = Convert.ToInt32(this.rablistSiteState.SelectedValue); model.SiteClickCount = this.txtSiteClickCount.Text == string.Empty ? 0 : Convert.ToInt32(this.txtSiteClickCount.Text.Trim()); model.Aread = this.hfAread.Value != string.Empty ? this.hfAread.Value : "0"; if (ViewState["ID"] != null) { model.ID = Convert.ToInt32(ViewState["ID"].ToString()); model.PutoutID = Convert.ToInt32(ViewState["PutoutID"]); model.PutoutTyID = Convert.ToInt32(ViewState["PutoutTyID"]); model.UpdateDate = DateTime.Now; model.CreateDate = Convert.ToDateTime(ViewState["CreateDate"].ToString()); bll.Amend(model); this.ltlMsg.Text = "操作成功,已保存该信息"; this.BandInfo(model.ID);//刷新 this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; } else { //添加时的类型 model.PutoutTyID = 0; ShowShop.Model.Admin.AdminInfo adminModel = (ShowShop.Model.Admin.AdminInfo)ShowShop.Common.AdministrorManager.Get(); //管理员ID model.PutoutID = adminModel.AdminId; model.CreateDate = DateTime.Now; model.UpdateDate = DateTime.Now; bll.Add(model); this.ltlMsg.Text = "操作成功,已添加该信息"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; } }
/// <summary> /// 所有数据集合 /// </summary> /// <returns></returns> public List<ShowShop.Model.Accessories.Hailhellowlink> GetAll() { List<ShowShop.Model.Accessories.Hailhellowlink> list = new List<ShowShop.Model.Accessories.Hailhellowlink>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select [id],[sitename],[siteurl],[sitelogo],[sitelevel],[sitecontent],[sitelinktype],[sitestate],[siteclickcount],[createdate],[updatedate],[putoutid],[putouttyid],[aread] from yxs_hailhellowlink "); strSql.Append(" where 1=1"); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ShowShop.Model.Accessories.Hailhellowlink model = new ShowShop.Model.Accessories.Hailhellowlink(); model.ID = reader.GetInt32(0); model.SiteName = reader.GetString(1); model.SiteUrl = reader.GetString(2); model.SiteLogo = reader.GetString(3); model.SiteLevel = reader.GetInt32(4); model.SiteContent = reader.GetString(5); model.SiteLinkType = reader.GetInt32(6); model.SiteState = reader.GetInt32(7); model.SiteClickCount = reader.GetInt32(8); model.CreateDate = reader.GetDateTime(9); model.UpdateDate = reader.GetDateTime(10); model.PutoutID = reader.GetInt32(11); model.PutoutTyID = reader.GetInt32(12); model.Aread = reader.GetString(13); list.Add(model); } } return list; }