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)));
}
