/// <summary> /// 添加广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddBanner(BaseBannerModel model) { const string sql = @"INSERT INTO `base_banner` (innerid, title, picurl, linkurl, autoenabletime, autodisabletime, sort, remark, isenabled, createrid, createdtime, modifierid, modifiedtime) VALUES (@innerid, @title, @picurl, @linkurl, @autoenabletime, @autodisabletime, @sort, @remark, @isenabled, @createrid, @createdtime, @modifierid, @modifiedtime);"; using (var conn = Helper.GetConnection()) { var tran = conn.BeginTransaction(); try { conn.Execute(sql, model, tran); tran.Commit(); return 1; } catch (Exception ex) { tran.Rollback(); return 0; } } }
/// <summary> /// 更新广告 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateBanner(BaseBannerModel model) { var sql = new StringBuilder("update `base_banner` set "); sql.Append(Helper.CreateField(model).Trim().TrimEnd(',')); sql.Append(" where innerid = @innerid"); int result; try { result = Helper.Execute(sql.ToString(), model); } catch (Exception ex) { result = 0; } return result; }