/// <summary> /// 返利记录信息 /// </summary> /// <param name="filter">返利记录信息</param> /// <returns>返回返利记录信息</returns> /// <remarks>2015-09-15 王耀发 创建</remarks> public override IList <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordView(ParaDealerRebatesRecordFilter filter) { string sqlWhere = "1=1"; if (filter.OrderSysNo > 0) { sqlWhere += " and a.OrderSysNo = @OrderSysNo"; } //判断是否绑定所有分销商 if (!filter.IsBindAllDealer) { //判断是否绑定分销商 if (filter.IsBindDealer) { sqlWhere += " and rd.SysNo = @DealerSysNo"; } else { sqlWhere += " and rd.CreatedBy = @DealerCreatedBy"; } } if (filter.SelectedDealerSysNo != -1) { sqlWhere += " and rd.SysNo = @SelectedDealerSysNo"; } string sql = @"select a.*, b.Account as RecommendAccount,b.Name as RecommendName,c.Account as ComplyAccount,c.Name as ComplyName,rd.DealerName as RDealerName from CrCustomerRebatesRecord a left join CrCustomer b on a.RecommendSysNo = b.SysNo left join CrCustomer c on a.ComplySysNo = c.SysNo left join DsDealer rd on b.DealerSysNo = rd.SysNo where " + sqlWhere; var items = Context.Sql(sql) .Parameter("OrderSysNo", filter.OrderSysNo) .Parameter("DealerSysNo", filter.DealerSysNo) .Parameter("DealerCreatedBy", filter.DealerCreatedBy) .Parameter("SelectedDealerSysNo", filter.SelectedDealerSysNo) .QueryMany <CBDsDealerRebatesRecord>(); return(items); }
/// <summary> /// 返利记录信息 /// </summary> /// <param name="filter">返利记录信息</param> /// <returns>返回返利记录信息</returns> /// <remarks>2015-09-15 王耀发 创建</remarks> public IList <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordView(ParaDealerRebatesRecordFilter filter) { return(IDsDealerRebatesRecordDao.Instance.GetDsDealerRebatesRecordView(filter)); }
/// <summary> /// 分页获取返利记录 /// </summary> /// <param name="filter">筛选条件</param> /// <returns>分页列表</returns> /// <remarks>2015-08-06 王耀发 创建</remarks> public Pager <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordList(ParaDealerRebatesRecordFilter filter) { return(IDsDealerRebatesRecordDao.Instance.GetDsDealerRebatesRecordList(filter)); }
/// <summary> /// 返利记录信息 /// </summary> /// <param name="filter">返利记录信息</param> /// <returns>返回返利记录信息</returns> /// <remarks>2015-09-15 王耀发 创建</remarks> public abstract IList <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordView(ParaDealerRebatesRecordFilter filter);
/// <summary> /// 获取返利记录列表 /// </summary> /// <param name="sysNo">返利记录系统编号</param> /// <returns>返利记录列表</returns> /// <remarks>2015-08-30 王耀发 创建</remarks> public abstract Pager <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordList(ParaDealerRebatesRecordFilter filter);
/// <summary> /// 返利记录信息 /// </summary> /// <param name="filter">返利记录信息</param> /// <returns>返回返利记录信息</returns> /// <remarks>2015-09-15 王耀发 创建</remarks> public override Pager <CBDsDealerRebatesRecord> GetDsDealerRebatesRecordList(ParaDealerRebatesRecordFilter filter) { string sqlWhere = "1=1"; //判断是否绑定所有分销商 if (!filter.IsBindAllDealer) { //判断是否绑定分销商 if (filter.IsBindDealer) { sqlWhere += " and rd.SysNo = " + filter.DealerSysNo; } else { sqlWhere += " and rd.CreatedBy = " + filter.DealerCreatedBy; } } if (filter.SelectedAgentSysNo != -1) { if (filter.SelectedDealerSysNo != -1) { sqlWhere += " and rd.SysNo = " + filter.SelectedDealerSysNo; } else { sqlWhere += " and rd.CreatedBy = " + filter.SelectedAgentSysNo; } } ///订单数据不为空的时候 if (!string.IsNullOrEmpty(filter.Condition)) { sqlWhere += " and (c.Name like '%" + filter.Condition.Replace("\'", "") + "%' or b.Name like '%" + filter.Condition.Replace("\'", "") + "%' or Convert(varchar(50), a.OrderSysNo) = '" + filter.Condition.Replace("\'", "") + "' or c.Account like '%" + filter.Condition.Replace("\'", "") + "%' or b.Account like '%" + filter.Condition.Replace("\'", "") + "%' ) "; } if (!string.IsNullOrEmpty(filter.RebatesType)) { sqlWhere += " and ( a.Genre = '" + filter.RebatesType + "' ) "; } string sql = @"(select a.*, b.Account as RecommendAccount,b.Name as RecommendName,c.Account as ComplyAccount,c.Name as ComplyName,rd.DealerName as RDealerName from CrCustomerRebatesRecord a left join CrCustomer b on a.RecommendSysNo = b.SysNo left join CrCustomer c on a.ComplySysNo = c.SysNo left join SoOrder so on a.OrderSysNo=so.SysNo left join DsDealer rd on so.DealerSysNo = rd.SysNo where " + sqlWhere + " ) tb"; var dataList = Context.Select <CBDsDealerRebatesRecord>("tb.*").From(sql); var dataCount = Context.Select <int>("count(1)").From(sql); //var paras = new object[] // { // filter.OrderSysNo, // filter.OrderSysNo // }; //dataList.Parameters(paras); //dataCount.Parameters(paras); var pager = new Pager <CBDsDealerRebatesRecord> { CurrentPage = filter.Id, PageSize = filter.PageSize }; var totalRows = dataCount.QuerySingle(); var rows = dataList.OrderBy("tb.OrderSysNo desc,tb.RebatesTime desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany(); pager.TotalRows = totalRows; pager.Rows = rows; return(pager); }