/// <summary> /// 查询分销商等级 /// </summary> /// <param name="status">分销商等级状态</param> /// <returns>分销商等级列表</returns> /// <remarks> /// 2013-11-04 郑荣华 创建 /// </remarks> public override IList <DsDealerLevel> GetDsDealerLevelList(DistributionStatus.分销商等级状态 status) { const string sql = @"select t.* from DsDealerLevel t where status=@0"; return(Context.Sql(sql, (int)status) .QueryMany <DsDealerLevel>()); }
/// <summary> /// 分销商等级状态更新 /// </summary> /// <param name="sysNo">分销商等级系统编号</param> /// <param name="status">分销商等级息状态</param> /// <param name="lastUpdateBy">最后更新人</param> /// <param name="lastUpdateDate">最后更新时间</param> /// <returns>受影响的行数</returns> /// <remarks> /// 2013-09-04 郑荣华 创建 /// </remarks> public int UpdateStatus(int sysNo, DistributionStatus.分销商等级状态 status, int lastUpdateBy, DateTime lastUpdateDate) { var r = IDsDealerLevelDao.Instance.UpdateStatus(sysNo, status, lastUpdateBy, lastUpdateDate); if (r > 0) { Log.SysLog.Instance.Info(LogStatus.系统日志来源.后台, "修改分销商等级状态", LogStatus.系统日志目标类型.分销商等级, sysNo); } return(r); }
/// <summary> /// 查询分销商等级 /// </summary> /// <param name="status">分销商等级状态</param> /// <returns>分销商等级列表</returns> /// <remarks> /// 2013-11-04 郑荣华 创建 /// </remarks> public abstract IList <DsDealerLevel> GetDsDealerLevelList(DistributionStatus.分销商等级状态 status);
/// <summary> /// 分销商等级状态更新 /// </summary> /// <param name="sysNo">分销商等级系统编号</param> /// <param name="status">分销商等级息状态</param> /// <param name="lastUpdateBy">最后更新人</param> /// <param name="lastUpdateDate">最后更新时间</param> /// <returns>受影响的行数</returns> /// <remarks> /// 2013-09-04 郑荣华 创建 /// </remarks> public abstract int UpdateStatus(int sysNo, DistributionStatus.分销商等级状态 status, int lastUpdateBy, DateTime lastUpdateDate);
/// <summary> /// 分销商等级状态更新 /// </summary> /// <param name="sysNo">分销商等级系统编号</param> /// <param name="status">分销商等级息状态</param> /// <param name="lastUpdateBy">最后更新人</param> /// <param name="lastUpdateDate">最后更新时间</param> /// <returns>受影响的行数</returns> /// <remarks> /// 2013-09-04 郑荣华 创建 /// </remarks> public override int UpdateStatus(int sysNo, DistributionStatus.分销商等级状态 status, int lastUpdateBy, DateTime lastUpdateDate) { return(Context.Sql("update DsDealerLevel set status=@0,lastupdateby=@1,lastupdatedate=@2 where sysno=@3", (int)status, lastUpdateBy, lastUpdateDate, sysNo) .Execute()); }
/// <summary> /// 查询分销商等级 /// </summary> /// <param name="status">分销商等级状态</param> /// <returns>分销商等级列表</returns> /// <remarks> /// 2013-11-04 郑荣华 创建 /// </remarks> public IList <DsDealerLevel> GetDsDealerLevelList(DistributionStatus.分销商等级状态 status) { return(IDsDealerLevelDao.Instance.GetDsDealerLevelList(status)); }