//获取日志查询
public void GetProductChannelMemberPriceLogs(
ProductChannelMemberQueryVM model, int PageSize, int PageIndex, string SortField
, EventHandler <RestClientEventArgs <dynamic> > callback)
{
ProductChannelInfoMemberQueryFilter filter =
model.ConvertVM <ProductChannelMemberQueryVM, ProductChannelInfoMemberQueryFilter>();
filter.PagingInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
_restClient.QueryDynamicData(GetProductChannelMemberPriceLogsUrl, filter, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
if (!(args.Result == null || args.Result.Rows == null))
{
foreach (var item in args.Result.Rows)
{
item.DisplayMemberPricePercent = item.MemberPricePercent != null && item.MemberPricePercent > 0
? String.Format("{0}%", item.MemberPricePercent.ToString().Split('.')[0]) : String.Empty;
item.InDate = item.InDate.ToString("yyyy-MM-dd HH:mm:ss");
item.DisplayOperationType = item.OperationType == "A" ? "新增"
: item.OperationType == "E" ? "编辑" : "作废";
}
}
callback(obj, args);
});
}
//查询日志信息
public DataTable GetProductChannelMemberPriceLogs(
ProductChannelInfoMemberQueryFilter queryCriteria, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetProductChannelMemberLogResult");
cmd.SetParameterValue("@ProductID", queryCriteria.ProductID);
cmd.SetParameterValue("@ChannelName", queryCriteria.ChannelName);
cmd.SetParameterValue("@StartTime", queryCriteria.StartDay);
cmd.SetParameterValue("@EndTime", queryCriteria.EndDay);
cmd.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
cmd.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
cmd.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);
DataTable dt = cmd.ExecuteDataTable();
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
public QueryResult GetProductChannelMemberPriceInfoUrl(ProductChannelInfoMemberQueryFilter request)
{
if (request == null)
{
//利用资源文件显示错误信息
throw new BizException(ResouceManager.GetMessageString(
"IM.ProductChannelInfo", "ProductChannelInfoCondtionIsNull"));
}
int totalCount;
var data = ObjectFactory <IProductChannelMemberInfoDA> .Instance
.GetProductChannelMemberPriceInfoUrl(request, out totalCount);
var source = new QueryResult {
Data = data, TotalCount = totalCount
};
return(source);
}
public QueryResult GetProductChannelMemberPriceLogs(ProductChannelInfoMemberQueryFilter request)
{
if (request == null)
{
//利用资源文件显示错误信息
throw new BizException(ResouceManager.GetMessageString(
"IM.ProductChannelInfo", "ProductChannelInfoCondtionIsNull"));
}
request.ChannelName =
request.ChannelSysNo > 0 ?
ObjectFactory <ProductChannelMemberInfoAppService>
.Instance.ChannelMemberInfoByChannelNo[request.ChannelSysNo]
: String.Empty;
int totalCount;
var data = ObjectFactory <IProductChannelMemberInfoDA> .Instance
.GetProductChannelMemberPriceLogs(request, out totalCount);
var source = new QueryResult {
Data = data, TotalCount = totalCount
};
return(source);
}
// 查询渠道会员价格表
public void GetProductChannelMemberPriceInfo(ProductChannelMemberQueryVM model
, int PageSize, int PageIndex, string SortField
, EventHandler <RestClientEventArgs <dynamic> > callback)
{
//过滤器转换成服务层的过滤器
ProductChannelInfoMemberQueryFilter filter =
model.ConvertVM <ProductChannelMemberQueryVM, ProductChannelInfoMemberQueryFilter>();
filter.PagingInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
_restClient.QueryDynamicData(GetProductChannelMemberPriceInfoUrl, filter, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
if (!(args.Result == null || args.Result.Rows == null))
{
foreach (var item in args.Result.Rows)
{
item.IsChecked = false;
item.DisplayMemberPricePercent = item.MemberPricePercent != null && item.MemberPricePercent > 0
? String.Format("{0}%", item.MemberPricePercent.ToString().Split('.')[0]) : String.Empty;
item.Discount = (item.MemberPrice != null && item.MemberPrice > 0)
? (item.CurrentPrice - item.MemberPrice).ToString("0.00")
: (item.CurrentPrice * (1 - item.MemberPricePercent / 100)).ToString("0.00");
item.CurrentPrice = item.CurrentPrice.ToString("0.00");
}
}
callback(obj, args);
});
}
// 查询会员渠道信息
public DataTable GetProductChannelMemberPriceInfoUrl(ProductChannelInfoMemberQueryFilter queryCriteria
, out int totalCount)
{
var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetProductChannelMemberPriceResult");
var pagingInfo = new PagingInfoEntity
{
SortField = queryCriteria.PagingInfo.SortBy,
StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize,
MaximumRows = queryCriteria.PagingInfo.PageSize
};
using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "B.SysNo DESC"))
{
if (queryCriteria.ChannelSysNo > 0)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"M.SysNo",
DbType.Int32, "@ChannelSysNo",
QueryConditionOperatorType.Equal,
queryCriteria.ChannelSysNo);
}
if (queryCriteria.C1SysNo != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"C1.Sysno",
DbType.Int32, "@C1SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.C1SysNo.Value);
}
if (queryCriteria.C2SysNo != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"C2.Sysno",
DbType.Int32, "@C2SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.C2SysNo.Value);
}
if (queryCriteria.C3SysNo != null)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"C3.Sysno",
DbType.Int32, "@C3SysNo",
QueryConditionOperatorType.Equal,
queryCriteria.C3SysNo.Value);
}
if (!string.IsNullOrEmpty(queryCriteria.ProductID))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"p.ProductID",
DbType.String, "@ProductID",
QueryConditionOperatorType.Equal,
queryCriteria.ProductID);
}
//动态生成SQL语句
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
DataTable dt = dataCommand.ExecuteDataTable();
totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount"));
return(dt);
}
}
