protected override GetVipListRD ProcessRequest(DTO.Base.APIRequest <GetVipListRP> pRequest)
{
var rd = new GetVipListRD();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var vipBLL = new VipBLL(loggingSessionInfo);
var unitBLL = new t_unitBLL(loggingSessionInfo);
int type = 0; //是否有条件查询
//条件参数
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
//条件查询，支持跨门店
if (!string.IsNullOrWhiteSpace(para.VipCardCode) || !string.IsNullOrWhiteSpace(para.VipName) || !string.IsNullOrWhiteSpace(para.Phone))
{
//跨门店查询
if (!string.IsNullOrEmpty(para.VipCardCode))
{
if (para.VipTypeID == 1)
{
complexCondition.Add(new DirectCondition("vc.VipCardISN='" + para.VipCardCode + "' "));
}
else
{
complexCondition.Add(new DirectCondition("( vc.VipCardCode like '" + para.VipCardCode + "%' OR v.VipCode like '" + para.VipCardCode + "%')"));
}
}
if (!string.IsNullOrEmpty(para.VipName))
{
complexCondition.Add(new DirectCondition("(v.VipName like '" + para.VipName + "%' OR v.VipRealName like '" + para.VipName + "%')"));
}
if (!string.IsNullOrEmpty(para.Phone))
{
complexCondition.Add(new DirectCondition("v.Phone like '" + para.Phone + "%' "));
}
type = 1;
}//默认查询，不支持跨门店
//else
//{
////门店对象
//t_unitEntity unitData = unitBLL.GetByID(loggingSessionInfo.CurrentUserRole.UnitId);
//string type_id = unitData == null ? "" : unitData.type_id;
////总部
//if (type_id != "2F35F85CF7FF4DF087188A7FB05DED1D")
//complexCondition.Add(new LikeCondition() { FieldName = "ul.dst_unit_id", Value = "%" + loggingSessionInfo.CurrentUserRole.UnitId + "%" });
//}
complexCondition.Add(new EqualsCondition()
{
FieldName = "v.ClientID", Value = loggingSessionInfo.ClientID
});
//排序参数
List <OrderBy> lstOrder = new List <OrderBy> {
};
lstOrder.Add(new OrderBy()
{
FieldName = "v.CreateTime", Direction = OrderByDirections.Desc
});
//调用会员卡管理列表查询
var tempList = vipBLL.GetVipList(complexCondition.ToArray(), lstOrder.ToArray(), type, para.PageSize, para.PageIndex);
rd.TotalPageCount = tempList.PageCount;
rd.TotalCount = tempList.RowCount;
rd.VipInfoList = tempList.Entities.Select(t => new VipInfo()
{
VipCardID = t.VipCardID,
VIPID = t.VIPID,
VipCode = t.VipCode,
VipCardCode = t.VipCardCode == null ? t.VipCode : t.VipCardCode,
VipName = t.VipName ?? "",
VipRealName = t.VipRealName ?? "",
Phone = t.Phone,
Gender = t.Gender,
VipCardTypeName = t.VipCardTypeName,
VipCardStatusId = t.VipCardStatusId,
MembershipTime = t.CreateTime.Value.ToString("yyyy-MM-dd HH:mm"),
MembershipUnitName = t.UnitName == null ? "" : t.UnitName
}).ToList();
return(rd);
}
