public System.Data.DataSet GetConsumeLogs(Model.Entity.ConsumeLogQueryEntity 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.ICNo.Trim()))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" ICNo like '%{0}%' ", entity.ICNo);
}
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(" StoreID = {0} ", entity.StoreID);
}
if ((!string.IsNullOrEmpty(entity.StartDate.ToString())) && (!string.IsNullOrEmpty(entity.EndDate.ToString())))
{
if (strSql1.Length > 0)
{
strSql1.AppendFormat(" And ");
}
strSql1.AppendFormat(" CreatedDate between {0} and {1} ", entity.StartDate, entity.EndDate);
}
string strWhere = strSql1.ToString();
return(_daoConsumeLog.GetList(strWhere));
}
public List <Model.VO.ConsumeQueryVO> GetConsumeLog(Model.Entity.ConsumeLogQueryEntity entity)
{
ConsumeLogData consumeLogData = new ConsumeLogData();
List <ConsumeQueryVO> consumeQueryVOList = new List <ConsumeQueryVO>();
DataSet ds = consumeLogData.GetConsumeLogs(entity);
List <ConsumeLogPO> consumeLogPOList = ds.GetEntity <List <ConsumeLogPO> >();
consumeLogPOList.ForEach(i =>
{
consumeQueryVOList.Add(Mapper.Map <ConsumeLogPO, ConsumeQueryVO>(i));
});
return(consumeQueryVOList);
}
