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