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