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)); }