public System.Data.DataSet GetRechargeLogs(Model.Entity.RechargeLogQueryEntity entity) { StringBuilder strSql1 = new StringBuilder(); //if (!string.IsNullOrEmpty(entity.MobileNo.Trim())) //{ // strSql1.AppendFormat(" MobileNo like '%{0}%' ", entity.MobileNo); //} if (!string.IsNullOrEmpty(entity.CustName.Trim())) { if (strSql1.Length > 0) { strSql1.AppendFormat(" And "); } strSql1.AppendFormat(" CustName like '%{0}%' ", entity.CustName); } if (!string.IsNullOrEmpty(entity.Creator.Trim())) { if (strSql1.Length > 0) { strSql1.AppendFormat(" And "); } strSql1.AppendFormat(" creatorid like '%{0}%' ", entity.Creator); } if (!string.IsNullOrEmpty(entity.ClubCardNO.Trim())) { if (strSql1.Length > 0) { strSql1.AppendFormat(" And "); } strSql1.AppendFormat(" ClubCardNO like '%{0}%' ", entity.ClubCardNO); } if (!string.IsNullOrEmpty(entity.StoreID.Trim())) { if (strSql1.Length > 0) { strSql1.AppendFormat(" And "); } strSql1.AppendFormat(" RechargeStore like '%{0}%' ", entity.StoreID); } if ((entity.StartDate != null) && (entity.EndDate != null)) { if (strSql1.Length > 0) { strSql1.AppendFormat(" And "); } strSql1.AppendFormat(" CreatedDate between '{0}' and '{1}' ", entity.StartDate.ToString(), entity.EndDate.ToString()); } string strWhere = strSql1.ToString(); return(_daoRechargeLog.GetList(strWhere)); }
public List <RechargeLogPO> GetRechargeCashLog(Model.Entity.RechargeLogQueryEntity entity) { RechargeLogData rechargeLogData = new RechargeLogData(); //List<CashRechargeQueryVO> cashRechargeQueryVOList = new List<CashRechargeQueryVO>(); DataSet ds = rechargeLogData.GetRechargeLogs(entity); List <RechargeLogPO> rechargeLogPOList = ds.GetEntity <List <RechargeLogPO> >(); //rechargeLogPOList.ForEach(i => //{ // cashRechargeQueryVOList.Add(Mapper.Map<RechargeLogPO, CashRechargeQueryVO>(i)); //}); return(rechargeLogPOList); }
public List <PkgRechargeQueryVO> GetRechargePkgLog(Model.Entity.RechargeLogQueryEntity entity) { throw new NotImplementedException(); }