/// <summary>
/// 更新一条记录
/// </summary>
/// <UpdateBy>hulingbo</UpdateBy>
/// <UpdateTime>20150609</UpdateTime>
/// <param name="businessBalanceRecord">参数实体</param>
public void Update(BusinessClienterRelationPM businessClienterRelation)
{
const string updateSql = @"
update BusinessClienterRelation
set IsEnable=1,IsBind=1,UpdateBy=@UpdateBy,UpdateTime=getdate()
where BusinessId=@BusinessId and ClienterId=@ClienterId";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("BusinessId", businessClienterRelation.BusinessId);
dbParameters.AddWithValue("ClienterId", businessClienterRelation.ClienterId);
dbParameters.AddWithValue("UpdateBy", businessClienterRelation.UpdateBy);
DbHelper.ExecuteNonQuery(SuperMan_Write, updateSql, dbParameters);
}
/// <summary>
/// 获取商户骑士对应关系
/// </summary>
/// <UpdateBy>hulingbo</UpdateBy>
/// <UpdateTime>20150609</UpdateTime>
/// <param name="id"></param>
/// <returns></returns>
public BusinessClienterRelation GetDetails(BusinessClienterRelationPM businessClienterRelation)
{
BusinessClienterRelation model = null;
string querySql = @"
select Id,BusinessId,ClienterId,IsEnable,CreateBy,CreateTime,UpdateBy,UpdateTime,IsBind
from dbo.[BusinessClienterRelation] (nolock )
where IsEnable=1 and BusinessId=@BusinessId and ClienterId=@ClienterId";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("BusinessId", businessClienterRelation.BusinessId);
dbParameters.AddWithValue("ClienterId", businessClienterRelation.ClienterId);
DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, querySql, dbParameters));
if (DataTableHelper.CheckDt(dt) && dt.Rows.Count > 0)
{
model = MapRows <BusinessClienterRelation>(dt)[0];
}
return(model);
}
/// <summary>
/// 获取商户骑士对应关系
/// </summary>
/// <UpdateBy>hulingbo</UpdateBy>
/// <UpdateTime>20150609</UpdateTime>
/// <param name="model"></param>
/// <returns></returns>
public BusinessClienterRelation GetDetails(BusinessClienterRelationPM businessClienterRelation)
{
return(businessClienterRelationDao.GetDetails(businessClienterRelation));
}
/// <summary>
/// 更新一条记录
/// </summary>
/// <UpdateBy>hulingbo</UpdateBy>
/// <UpdateTime>20150609</UpdateTime>
/// <param name="model"></param>
/// <returns></returns>
public void Modify(BusinessClienterRelationPM businessClienterRelation)
{
businessClienterRelationDao.Update(businessClienterRelation);
}
