/// <summary> /// 添加一条记录 /// </summary> public int Add(BannerList entity, IDbTransaction tran) { string sql = @"insert into [BannerList] ([bannerimg], [linkurl], [orderid], [adid],[recommendedinfo]) values (@bannerimg, @linkurl, @orderid, @adid,@recommendedinfo)"; object param = new { bannerimg = entity.Bannerimg, linkurl = entity.Linkurl, orderid = entity.Orderid, adid = entity.Adid, recommendedinfo=entity.Recommendedinfo }; int count = tran.Connection.Execute(sql, param, tran); return count; }
/// <summary> /// 添加一条记录 /// </summary> public int Add(BannerList entity) { string sql = @"insert into [BannerList] ([bannerimg], [linkurl], [orderid], [adid],[recommendedinfo]) values (@bannerimg, @linkurl, @orderid, @adid,@recommendedinfo)"; object param = new { bannerimg = entity.Bannerimg, linkurl = entity.Linkurl, orderid = entity.Orderid, adid = entity.Adid, recommendedinfo=entity.Recommendedinfo }; using (IDbConnection conn = OpenConnection()) { int count = conn.Execute(sql, param); return count; } }
/// <summary> /// 添加一条记录 /// </summary> public ResultSet Add(BannerList entity) { Func<BannerList, ResultStatus> validate = (_entity) => { return new ResultStatus(); }; Func<BannerList, ResultStatus> op = (_entity) => { int ret = new BannerListDal().Add(entity); if (ret > 0) return new ResultStatus(); else return new ResultStatus() { Success = false, Code = StatusCollection.AddFailed.Code, Description = StatusCollection.AddFailed.Description }; }; return HandleBusiness(entity, op, validate); }
public int Update(BannerList entity) { //GetUpdateSql2 string sql = @"update [BannerList] set bannerimg=@bannerimg, linkurl=@linkurl, orderid=@orderid, adid=@adid,recommendedinfo=@recommendedinfo where id=@id "; object param = new { id = entity.Id, bannerimg = entity.Bannerimg, linkurl = entity.Linkurl, orderid = entity.Orderid, adid = entity.Adid, recommendedinfo=entity.Recommendedinfo }; using (IDbConnection conn = OpenConnection()) { int count = conn.Execute(sql, param); return count; } }