private bool DoAdd() { bool result = false; Model.wx_travel_scenicDetail model = new Model.wx_travel_scenicDetail { ScenicId = ScenicId, Name = txtName.Text.Trim(), Cover = txtCover.Text.Trim(), BackgroundImage = txtBackgroundImage.Text.Trim(), Digest = txtDigest.Text.Trim(), Content = txtContent.InnerText.Trim(), Audio = txtAudio.Text, AutoAudio = rblAutoAudio.SelectedItem.Value == "1", LoopAudio = rblLoopAudio.SelectedItem.Value == "1" }; if (_bll.Add(model) > 0) { AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "微旅游添加景点详情:" + model.Name); //记录日志 result = true; } return(result); }
public void Add() { wx_travel_scenicDetail bll = new wx_travel_scenicDetail(); Model.wx_travel_scenicDetail model = new Model.wx_travel_scenicDetail { ScenicId = 3, Name = "ghfghfg", Cover = "asdfghfhfghasd", BackgroundImage = "fghfgh", Digest = "fghfgh", Content = "fghfgh", Audio = "fghfgh", AutoAudio = true, LoopAudio = true, Video = "fhfgh", AutoVideo = true, OriginalLink = "asdfghfghasd", //Albumses = new List<Model.wx_travel_albums>() //{ // new wx_travel_albums(){ThumbPath ="asdasdasdasdasdasd" }, // new wx_travel_albums(){ThumbPath ="ffffgfggfg" } //} }; bll.Add(model); }
private void ShowInfo(int id) { Model.wx_travel_scenicDetail model = _bll.GetModel(id); txtName.Text = model.Name; txtCover.Text = model.Cover; txtBackgroundImage.Text = model.BackgroundImage; txtDigest.Text = model.Digest; txtContent.InnerText = model.Content; txtAudio.Text = model.Audio; rblAutoAudio.SelectedValue = model.AutoAudio.HasValue && model.AutoAudio.Value ? "1" : "0"; rblLoopAudio.SelectedValue = model.LoopAudio.HasValue && model.LoopAudio.Value ? "1" : "0"; }
private void ShowInfo() { BLL.wx_travel_scenicDetail dBll = new BLL.wx_travel_scenicDetail(); BLL.wx_travel_picture pBll = new BLL.wx_travel_picture(); Detail = dBll.GetModel(Id); if (Detail != null) { divContent.InnerHtml = Detail.Content; var pictures = pBll.GetModelList("DetailID=" + Detail.Id); rpList.DataSource = pictures; rpList.DataBind(); } }
public int Add(Model.wx_travel_scenicDetail model) { using (IDbConnection db = DbFactory.GetOpenedConnection()) { string query = @"Insert Into dbo.wx_travel_scenicDetail (ScenicId,Name,Cover,BackgroundImage,Digest,Content,Audio,AutoAudio,LoopAudio,Video,AutoVideo,OriginalLink) Values (@ScenicId,@Name,@Cover,@BackgroundImage,@Digest,@Content,@Audio,@AutoAudio,@LoopAudio,@Video,@AutoVideo,@OriginalLink) Select @Id=Scope_Identity() "; DynamicParameters dynamicParameters = new DynamicParameters(); dynamicParameters.AddDynamicParams(model); dynamicParameters.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output); db.Execute(query, dynamicParameters); return(dynamicParameters.Get <int>("@Id")); } }
private bool DoEdit(int id) { bool result = false; Model.wx_travel_scenicDetail model = _bll.GetModel(id); model.Name = txtName.Text.Trim(); model.Cover = txtCover.Text.Trim(); model.BackgroundImage = txtBackgroundImage.Text.Trim(); model.Digest = txtDigest.Text.Trim(); model.Content = txtContent.InnerText.Trim(); model.Audio = txtAudio.Text; model.AutoAudio = rblAutoAudio.SelectedItem.Value == "1"; model.LoopAudio = rblLoopAudio.SelectedItem.Value == "1"; if (_bll.Update(model)) { AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "微旅游编辑景区导览:" + model.Name); //记录日志 result = true; } return(result); }
public bool Update(Model.wx_travel_scenicDetail model) { StringBuilder queryBuilder = new StringBuilder(); queryBuilder.Append("Update [dbo].[wx_travel_scenicDetail]"); queryBuilder.Append(" Set [ScenicId] = @ScenicId"); queryBuilder.Append(",[Name] = @Name"); queryBuilder.Append(",[Cover] = @Cover"); queryBuilder.Append(",[BackgroundImage] = @BackgroundImage"); queryBuilder.Append(",[Digest] = @Digest"); queryBuilder.Append(",[Content] = @Content"); queryBuilder.Append(",[Audio] = @Audio"); queryBuilder.Append(",[AutoAudio] = @AutoAudio"); queryBuilder.Append(",[LoopAudio] = @LoopAudio"); queryBuilder.Append(",[Video] = @Video"); queryBuilder.Append(",[AutoVideo] = @AutoVideo"); queryBuilder.Append(",[OriginalLink] = @OriginalLink"); queryBuilder.Append(" Where Id=@Id"); using (IDbConnection db = DbFactory.GetOpenedConnection()) { return(db.Execute(queryBuilder.ToString(), model) > 0); } }
public bool Update(Model.wx_travel_scenicDetail model) { return(_dal.Update(model)); }
public int Add(Model.wx_travel_scenicDetail model) { return(_dal.Add(model)); }