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