public Page<MemberBaseInfo> GetMemberList(MemberSeachCondition searchCondition)
{
Session["MemberSerachCondition"] = searchCondition;
MemberManageBLL memberBLL = new MemberManageBLL();
Page<MemberBaseInfo> memberPageInfo=new Page<MemberBaseInfo> ();
memberPageInfo = memberBLL.GetMemberInfoList(searchCondition);
return memberPageInfo;
}
public Page<MemberFeeManage> GetMemberFeeList(MemberSeachCondition searchCondition)
{
Session["MemberFeeSearch"] = searchCondition;
MemberFeeBLL memberFeeBLL = new MemberFeeBLL();
Page<MemberFeeManage> memberPageInfo = new Page<MemberFeeManage>();
memberPageInfo = memberFeeBLL.GetMemberFeeList(searchCondition,false);
return memberPageInfo;
}
// Methods
public Page<MemberFeeManage> GetMemberFeeList(MemberSeachCondition searchCondition, bool isPrint)
{
ICriteria criteria = this.IMemberFeeManage.NativeHibernateSession.CreateCriteria(typeof(MemberFeeManage));
Page<MemberFeeManage> memberPageInfo = new Page<MemberFeeManage>
{
CurrentPageIndex = searchCondition.PageNum
};
try
{
criteria = this.IMemberFeeManage.GetICriteriaByLgCondition<DateTime, DateTime>("FeeDate", criteria, searchCondition.FeeBeginDate, searchCondition.FeeEndDate).AddOrder(Order.Desc("LastUpdateDate")).AddOrder(Order.Desc("FeeStatus")).CreateCriteria("MemberInfo");
if (searchCondition.MemberTypeId > 0)
{
criteria.CreateCriteria("MemberTypeInfo").Add(Restrictions.Eq("MemberTypeId", searchCondition.MemberTypeId));
}
if (searchCondition.FeeRegionId > 0)
{
criteria.CreateCriteria("RegionInfo").Add(Restrictions.Eq("RegionId", searchCondition.FeeRegionId));
}
if (searchCondition.ManageRegionId > 0)
{
criteria.CreateCriteria("ManageRegionInfo").Add(Restrictions.Eq("RegionId", searchCondition.ManageRegionId));
}
Dictionary<string, string> condtionLikeDic = new Dictionary<string, string>();
if (searchCondition.MemberName != "")
{
condtionLikeDic.Add("MemberName", searchCondition.MemberName);
}
if (searchCondition.MemberNameEng != "")
{
condtionLikeDic.Add("MemberNameEng", searchCondition.MemberNameEng);
}
criteria = this.IMemberFeeManage.GetICriteriaByLikeCondition(condtionLikeDic, criteria);
criteria = this.IMemberFeeManage.GetICriteriaByLgCondition<string, string>("MemberCode", criteria, searchCondition.MemberCodeMin, searchCondition.MemberCodeMax);
memberPageInfo.TotalCount = criteria.SetResultTransformer(CriteriaUtil.DistinctRootEntity).List<MemberFeeManage>().Count;
if (isPrint)
{
memberPageInfo.Data = criteria.SetResultTransformer(CriteriaUtil.DistinctRootEntity).List<MemberFeeManage>();
return memberPageInfo;
}
memberPageInfo.Data = criteria.SetResultTransformer(CriteriaUtil.DistinctRootEntity).SetFirstResult((memberPageInfo.CurrentPageIndex - 1) * memberPageInfo.PageSize).SetMaxResults(memberPageInfo.PageSize).List<MemberFeeManage>();
}
catch (Exception)
{
memberPageInfo = null;
}
return memberPageInfo;
}