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