public List <Model.VO.ClubCardVO> GetClubCards(Model.Entity.ClubCardQueryEntity entity)
{
ClubCardData clubCardData = new ClubCardData();
List <ClubCardVO> clubCardVOList = new List <ClubCardVO>();
DataSet ds = clubCardData.GetClubCards(entity);
List <ClubCardPO> clubCardPOList = ds.GetEntity <List <ClubCardPO> >();
if (clubCardPOList == null)
{
clubCardPOList = new List <ClubCardPO>();
}
clubCardPOList.ForEach(i =>
{
clubCardVOList.Add(Mapper.Map <ClubCardPO, ClubCardVO>(i));
});
return(clubCardVOList);
}
public int GetClubCardRecordCount(Model.Entity.ClubCardQueryEntity filter)
{
StringBuilder strSql1 = new StringBuilder();
if (!string.IsNullOrEmpty(filter.ClubCardNo.Trim()))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" ClubCardNo like '%{0}%' ", filter.ClubCardNo);
}
if (!string.IsNullOrEmpty(filter.Name.Trim()))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" Name like '%{0}%' ", filter.Name);
}
if (!string.IsNullOrEmpty(filter.MobileNo.Trim()))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" MobileNO like '%{0}%' ", filter.MobileNo);
}
//if (strSql1.Length > 0)
// strSql1.AppendFormat(" And ");
//strSql1.AppendFormat(" ClubCardTypeID like %{0}% ", entity.ClubCardTypeID);
if (filter.ClubCardTypeID > 0)
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" clubcardtypeid = {0} ", filter.ClubCardTypeID);
}
//if (strSql1.Length > 0)
// strSql1.AppendFormat(" And ");
//strSql1.AppendFormat(" OpenCardStore = {0} ", entity.StoreID);
if (!string.IsNullOrEmpty(filter.StoreName))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" opencardstore like '%{0}%'", filter.StoreName);
}
if (filter.CardStatus >= 0)
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" cardstatus ={0} ", filter.CardStatus);
}
return(_daoClubCard.GetRecordCount(strSql1.ToString()));
}
public System.Data.DataSet GetClubCards(Model.Entity.ClubCardQueryEntity entity)
{
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (!string.IsNullOrEmpty(entity.ClubCardNo.Trim()))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" ClubCardNo like '%{0}%' ", entity.ClubCardNo);
}
if (!string.IsNullOrEmpty(entity.Name.Trim()))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" Name like '%{0}%' ", entity.Name);
}
if (!string.IsNullOrEmpty(entity.MobileNo.Trim()))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" MobileNO like '%{0}%' ", entity.MobileNo);
}
//if (strSql1.Length > 0)
// strSql1.AppendFormat(" And ");
//strSql1.AppendFormat(" ClubCardTypeID like %{0}% ", entity.ClubCardTypeID);
if (entity.ClubCardTypeID > 0)
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" clubcardtypeid = {0} ", entity.ClubCardTypeID);
}
//if (strSql1.Length > 0)
// strSql1.AppendFormat(" And ");
//strSql1.AppendFormat(" OpenCardStore = {0} ", entity.StoreID);
if (!string.IsNullOrEmpty(entity.StoreName))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" opencardstore like '%{0}%'", entity.StoreName);
}
if (entity.CardStatus >= 0)
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" cardstatus ={0} ", entity.CardStatus);
}
if (!string.IsNullOrEmpty(entity.SortName.Trim()))
{
strSql2.Append(entity.SortName);
strSql2.Append(" ");
strSql2.Append(entity.SortOrder.Trim());
}
string strWhere = strSql1.ToString();
string orderby = strSql2.ToString();
int startIndex = entity.Start;
int endIndex = startIndex + entity.Length;
return(_daoClubCard.GetListByPage(strWhere, orderby, startIndex + 1, endIndex));
}
public int GetClubCardRecordCount(Model.Entity.ClubCardQueryEntity filter)
{
ClubCardData clubCarddal = new ClubCardData();
return(clubCarddal.GetClubCardRecordCount(filter));
}
