/// <summary>
/// 编辑焦点广告图
/// </summary>
/// <param name="model">The model.</param>
/// <returns></returns>
public static bool EditFocusPic(FocusPicModel model)
{
using (var dal = FactoryDispatcher.FocusFactory())
{
if (model.ID > 0)
{
return(dal.UpdateFocusPic(model));
}
else
{
return(dal.AddFocusPic(model) > 0);
}
}
}
/// <summary>
/// 添加焦点广告图
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
/// <exception cref="System.NotImplementedException"></exception>
public int AddFocusPic(FocusPicModel model)
{
string strSql = @"insert into BM_BannerManage(Type,Title,PicUrl,Description,IsEnable,Sort,LinkUrl) values(@Type,@Title,@PicUrl,@Description,@IsEnable,@Sort,@LinkUrl)";
var param = new[] {
new SqlParameter("@Title", model.Title),
new SqlParameter("@PicUrl", model.PicUrl),
new SqlParameter("@Description", model.Description),
new SqlParameter("@IsEnable", model.IsEnable),
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@LinkUrl", model.LinkUrl),
new SqlParameter("@Type", model.Type)
};
return(DbHelperSQLP.ExecuteNonQuery(WebConfig.getConnectionString(), CommandType.Text, strSql, param));
}
/// <summary>
/// 更新焦点广告图
/// </summary>
/// <param name="model">The model.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="System.NotImplementedException"></exception>
public bool UpdateFocusPic(FocusPicModel model)
{
string strSql = @"update BM_BannerManage set
Title = @Title,PicUrl = @PicUrl,Description = @Description,IsEnable = @IsEnable,Sort = @Sort,LinkUrl = @LinkUrl
where ID = @ID";
var param = new[] {
new SqlParameter("@Title", model.Title),
new SqlParameter("@PicUrl", model.PicUrl),
new SqlParameter("@Description", model.Description),
new SqlParameter("@IsEnable", model.IsEnable),
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@LinkUrl", model.LinkUrl),
new SqlParameter("@ID", model.ID)
};
return(DbHelperSQLP.ExecuteNonQuery(WebConfig.getConnectionString(), CommandType.Text, strSql, param) > 0);
}
/// <summary>
/// 编辑焦点广告图
/// </summary>
private void EditFocusPic()
{
FocusPicModel model = new FocusPicModel()
{
ID = GetFormValue("focusid", 0),
Title = GetFormValue("focustitle", ""),
LinkUrl = GetFormValue("focuslinkurl", ""),
PicUrl = GetFormValue("focuspicurl", ""),
Type = GetFormValue("type", 0),
IsEnable = GetFormValue("focusenable", 0),
Sort = GetFormValue("focussort", 0),
Description = GetFormValue("focusdescription", "")
};
if (FocusPicLogic.EditFocusPic(model))
{
json = JsonHelper.JsonSerializer(new ResultModel(ApiStatusCode.OK));
}
else
{
json = JsonHelper.JsonSerializer(new ResultModel(ApiStatusCode.操作失败));
}
}
