private void ShowInfo(int id)
{
hidid.Value = id.ToString();
Model.wx_travel_picture model = _bll.GetModel(id);
txtName.Text = model.Name;
txtContent.Value = model.Content;
txtOrderNo.Text = model.OrderNo.ToString();
//封面图片
if (model.PicPath != null && model.PicPath.Trim() != "/images/noneimg.jpg")
{
txtImgUrl.Text = model.PicPath;
imgfacePicPic.ImageUrl = model.PicPath;
}
}
public bool Update(Model.wx_travel_picture model)
{
using (IDbConnection db = DbFactory.GetOpenedConnection())
{
StringBuilder queryBuilder = new StringBuilder();
queryBuilder.Append("Update [dbo].[wx_travel_picture]");
queryBuilder.Append(" Set [DetailId] = @DetailId");
queryBuilder.Append(",[Name] = @Name");
queryBuilder.Append(",[PicPath] = @PicPath");
queryBuilder.Append(",[Content] = @Content");
queryBuilder.Append(",[OrderNo] = @OrderNo");
queryBuilder.Append(",[CreateDate] = @CreateDate");
queryBuilder.Append(" Where Id=@Id");
return(db.Execute(queryBuilder.ToString(), model) > 0);
}
}
private bool DoEdit(int id)
{
bool result = false;
Model.wx_travel_picture model = _bll.GetModel(id);
model.DetailId = DetailId;
model.Name = txtName.Text.Trim();
model.PicPath = txtImgUrl.Text.Trim();
model.Content = txtContent.InnerText;
model.OrderNo = MyCommFun.Str2Int(txtOrderNo.Text.Trim());
model.CreateDate = DateTime.Now;
if (_bll.Update(model))
{
AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "微旅游编辑景点图片:" + model.Name); //记录日志
result = true;
}
return(result);
}
public int Add(Model.wx_travel_picture model)
{
using (IDbConnection db = DbFactory.GetOpenedConnection())
{
StringBuilder queryBuilder = new StringBuilder();
queryBuilder.Append("Insert Into [dbo].[wx_travel_picture]");
queryBuilder.Append(" ([DetailId],[Name],[PicPath],[Content],[OrderNo],[CreateDate])");
queryBuilder.Append("Values");
queryBuilder.Append(" (@DetailId,@Name,@PicPath,@Content,@OrderNo,@CreateDate)");
queryBuilder.Append("Select @Id=Scope_Identity()");
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.AddDynamicParams(model);
dynamicParameters.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output);
db.Execute(queryBuilder.ToString(), dynamicParameters);
return(dynamicParameters.Get <int>("@Id"));
}
}
private bool DoAdd()
{
bool result = false;
Model.wx_travel_picture model = new Model.wx_travel_picture
{
DetailId = DetailId,
Name = txtName.Text.Trim(),
PicPath = txtImgUrl.Text.Trim(),
Content = txtContent.InnerText,
OrderNo = MyCommFun.Str2Int(txtOrderNo.Text.Trim()),
CreateDate = DateTime.Now
};
if (_bll.Add(model) > 0)
{
AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "微旅游添加景点图片:" + model.Name); //记录日志
result = true;
}
return(result);
}
public bool Update(Model.wx_travel_picture model)
{
return(_dal.Update(model));
}
public int Add(Model.wx_travel_picture model)
{
return(_dal.Add(model));
}
