private bool DoAdd() { bool result = false; Model.wx_userweixin weixin = GetWeiXinCode(); Model.wx_travel_scenic model = new Model.wx_travel_scenic { wid = weixin.id, Name = txtName.Text.Trim(), Description = txtDescription.InnerText.Trim(), TemplateId = 1, FirstBgImg = txtFirstBgImg.Text, IdentifyImg = txtIdentifyImg.Text, DisplayAction = rblDiaplayAction.SelectedItem.Value, SecondBgImg = txtSecondBgImg.Text.Trim(), AutoDisplayNextPage = rblAutoDisplayNextPage.SelectedItem.Value == "1", Delay = Convert.ToInt32(txtDelay.Text) }; if (_bll.Add(model) > 0) { AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "微旅游添加景区导览:" + model.Name); //记录日志 result = true; } return(result); }
public void Add() { BLL.wx_travel_scenic bll = new BLL.wx_travel_scenic(); Model.wx_travel_scenic model = new Model.wx_travel_scenic(); model.Name = "qweqwe"; model.Description = "qweqwe"; model.TemplateId = 1; model.FirstBgImg = "qweqwe"; model.IdentifyImg = "qweqwe"; model.DisplayAction = "qweqwe"; model.SecondBgImg = "qweqwe"; model.AutoDisplayNextPage = true; model.Delay = 1000; model.AudioPath = "qweqwe"; model.AutoPlayAudio = true; model.AudioLoop = true; model.VideoPath = "123123123123"; model.AutoPlayVideo = true; model.extInt1 = 1; model.extInt2 = 1; model.extStr1 = "qweqwe"; model.extStr2 = "qweqwe"; int result = bll.Add(model); Assert.AreNotEqual(result, 0); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.wx_travel_scenic model) { using (IDbConnection db = DbFactory.GetOpenedConnection()) { StringBuilder queryBuilder = new StringBuilder(); queryBuilder.Append("Update[dbo].[wx_travel_scenic] "); queryBuilder.Append("Set [wid] = @wid"); queryBuilder.Append(",[Name] = @Name"); queryBuilder.Append(",[Description] = @Description"); queryBuilder.Append(",[TemplateId] = @TemplateId"); queryBuilder.Append(",[FirstBgImg] = @FirstBgImg"); queryBuilder.Append(",[IdentifyImg] = @IdentifyImg"); queryBuilder.Append(",[DisplayAction] = @DisplayAction"); queryBuilder.Append(",[SecondBgImg] = @SecondBgImg"); queryBuilder.Append(",[AutoDisplayNextPage] = @AutoDisplayNextPage"); queryBuilder.Append(",[Delay] = @Delay"); queryBuilder.Append(",[AudioPath] = @AudioPath"); queryBuilder.Append(",[AutoPlayAudio] = @AutoPlayAudio"); queryBuilder.Append(",[AudioLoop] = @AudioLoop"); queryBuilder.Append(",[VideoPath] = @VideoPath"); queryBuilder.Append(",[AutoPlayVideo] = @AutoPlayVideo"); queryBuilder.Append(",[extInt1] = @extInt1"); queryBuilder.Append(",[extInt2] = @extInt2"); queryBuilder.Append(",[extStr1] = @extStr1"); queryBuilder.Append(",[extStr2] = @extStr2"); queryBuilder.Append(" Where Id=@Id"); return(db.Execute(queryBuilder.ToString(), model) > 0); } }
private void ShowInfo(int id) { Model.wx_travel_scenic model = _bll.GetModel(id); model.Name = txtName.Text = model.Name; txtDescription.InnerText = model.Description; txtFirstBgImg.Text = model.FirstBgImg; txtIdentifyImg.Text = model.IdentifyImg; rblDiaplayAction.SelectedValue = model.DisplayAction; txtSecondBgImg.Text = model.SecondBgImg; rblAutoDisplayNextPage.SelectedValue = model.AutoDisplayNextPage.HasValue && model.AutoDisplayNextPage.Value ? "1" : "0"; txtDelay.Text = model.Delay.ToString(); }
private static AjaxResult GetScenic(HttpContext context) { wx_travel_scenic scenicBll = new wx_travel_scenic(); wx_travel_scenicDetail scenicDetailBll = new wx_travel_scenicDetail(); int id = MyCommFun.Str2Int(context.Request["id"]); Model.wx_travel_scenic scenic = scenicBll.GetModel(id); List <Model.wx_travel_scenicDetail> details = scenicDetailBll.GetModelByScenicId(id); var result = new { scenic = scenic, details = details }; return(AjaxResult.Success(result)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.wx_travel_scenic model) { using (IDbConnection db = DbFactory.GetOpenedConnection()) { string query = @"Insert Into dbo.wx_travel_scenic (wid,Name,Description,TemplateId,FirstBgImg,IdentifyImg,DisplayAction,SecondBgImg,AutoDisplayNextPage,Delay,AudioPath,AutoPlayAudio,AudioLoop,VideoPath,AutoPlayVideo,extInt1,extInt2,extStr1,extStr2) Values (@wid,@Name,@Description,@TemplateId,@FirstBgImg,@IdentifyImg,@DisplayAction,@SecondBgImg,@AutoDisplayNextPage,@Delay,@AudioPath,@AutoPlayAudio,@AudioLoop,@VideoPath,@AutoPlayVideo,@extInt1,@extInt2,@extStr1,@extStr2) 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_scenic model = _bll.GetModel(id); model.Name = txtName.Text.Trim(); model.Description = txtDescription.InnerText.Trim(); model.TemplateId = 1; model.FirstBgImg = txtFirstBgImg.Text; model.IdentifyImg = txtIdentifyImg.Text; model.DisplayAction = rblDiaplayAction.SelectedItem.Value; model.SecondBgImg = txtSecondBgImg.Text.Trim(); model.AutoDisplayNextPage = rblAutoDisplayNextPage.SelectedItem.Value == "1"; model.Delay = MyCommFun.Str2Int(txtDelay.Text); if (_bll.Update(model)) { AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "微旅游编辑景区导览:" + model.Name); //记录日志 result = true; } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.wx_travel_scenic model) { return(_dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.wx_travel_scenic model) { return(_dal.Add((model))); }