public JsonResult GetGiftPromotionList()
{
GiftPromotionListQueryFilter queryFilter = BuildQueryFilterEntity <GiftPromotionListQueryFilter>((s) =>
{
s.VendorSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
s.CompanyCode = UserAuthHelper.GetCurrentUser().CompanyCode;
});
var result = GiftPromotionService.QueryGiftPromotionActivityList(queryFilter);
return(AjaxGridJson(result));
}
/// <summary>
/// 查询赠品促销列表
/// </summary>
/// <param name="queryFilter"></param>
/// <returns></returns>
public static QueryResult <GiftPromotionListQueryResult> QueryGiftPromotionActivityList(GiftPromotionListQueryFilter queryFilter)
{
return(GiftPromotionDA.QueryGiftPromotionActivityList(queryFilter));
}
public static QueryResult <GiftPromotionListQueryResult> QueryGiftPromotionActivityList(GiftPromotionListQueryFilter queryFilter)
{
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("SaleGift_QueryGift");
using (var sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, queryFilter, string.IsNullOrEmpty(queryFilter.SortFields) ? "SysNo DESC" : queryFilter.SortFields))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.VendorSysNo", DbType.Int32,
"@VendorSysNo", QueryConditionOperatorType.Equal, queryFilter.VendorSysNo);
if (!string.IsNullOrEmpty(queryFilter.CompanyCode))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.CompanyCode", DbType.AnsiStringFixedLength,
"@CompanyCode", QueryConditionOperatorType.Equal, queryFilter.CompanyCode);
}
//主商品编号:
if (!string.IsNullOrEmpty(queryFilter.MainProductSysNo))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.ProductSysNo",
DbType.Int32, "@MasterProductSysNo", QueryConditionOperatorType.Equal, queryFilter.MainProductSysNo);
}
//赠品编号:
if (!string.IsNullOrEmpty(queryFilter.GiftProductSysNo))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C.ProductSysNo",
DbType.Int32, "@GiftProductSysNo", QueryConditionOperatorType.Equal, queryFilter.GiftProductSysNo);
}
if (!string.IsNullOrEmpty(queryFilter.ActivitySysNo))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.SysNo",
DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, queryFilter.ActivitySysNo);
}
if (!string.IsNullOrEmpty(queryFilter.ActivityName))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.PromotionName",
DbType.String, "@PromotionName", QueryConditionOperatorType.Like, queryFilter.ActivityName);
}
if (!string.IsNullOrEmpty(queryFilter.ActivityStatus))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Status",
DbType.AnsiStringFixedLength, "@Status", QueryConditionOperatorType.Equal, queryFilter.ActivityStatusEnumText);
}
if (!string.IsNullOrEmpty(queryFilter.ActivityType))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Type",
DbType.AnsiStringFixedLength, "@Type", QueryConditionOperatorType.Equal, queryFilter.ActivityTypeEnumText);
}
if (!string.IsNullOrEmpty(queryFilter.ActivityDateFrom))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.BeginDate",
DbType.DateTime, "@BeginDate", QueryConditionOperatorType.MoreThanOrEqual, Convert.ToDateTime(queryFilter.ActivityDateFrom));
}
if (!string.IsNullOrEmpty(queryFilter.ActivityDateTo))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.EndDate",
DbType.DateTime, "@EndDate", QueryConditionOperatorType.LessThan, Convert.ToDateTime(queryFilter.ActivityDateTo).AddDays(1));
}
command.CommandText = sqlBuilder.BuildQuerySql();
List <GiftPromotionListQueryResult> resultList = command.ExecuteEntityList <GiftPromotionListQueryResult>();
int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(new QueryResult <GiftPromotionListQueryResult>()
{
PageInfo = new PageInfo()
{
PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields
}, ResultList = resultList
});
}
}