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