private void FrmPayOperationLogReport_ItemSearching(object sender, EventArgs e)
{
APMLogSearchCondition con = new APMLogSearchCondition();
con.RecordDateTimeRange = new DateTimeRange(ucDateTimeInterval1.StartDateTime, ucDateTimeInterval1.EndDateTime);
con.SerialNum = txtSerialNum.Text;
con.CardID = txtCardID.Text;
con.MID = comAPM.Text;
con.Description = txtDescription.Text;
con.Types = new List <BusinessModel.Enum.APMLogType>();
if (chkMessage.Checked)
{
con.Types.Add(BusinessModel.Enum.APMLogType.Message);
}
if (chkAlarm.Checked)
{
con.Types.Add(BusinessModel.Enum.APMLogType.Alarm);
}
if (chkError.Checked)
{
con.Types.Add(BusinessModel.Enum.APMLogType.Error);
}
GridView.Rows.Clear();
List <APMLog> items = (new APMLogBll(AppSettings.CurrentSetting.ParkConnect)).GetItems(con).QueryObjects;
foreach (APMLog item in items)
{
int row = this.GridView.Rows.Add();
ShowPayOperationLogOnRow(GridView.Rows[row], item);
}
}
protected override List <APMLog> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is APMLogSearchCondition)
{
IQueryable <APMLog> result = parking.GetTable <APMLog>();
APMLogSearchCondition condition = search as APMLogSearchCondition;
result = result.Where(item => item.LogDateTime >= condition.RecordDateTimeRange.Begin &&
item.LogDateTime <= condition.RecordDateTimeRange.End);
if (!string.IsNullOrEmpty(condition.SerialNum))
{
result = result.Where(item => item.SerialNumber == condition.SerialNum);
}
if (!string.IsNullOrEmpty(condition.MID))
{
result = result.Where(item => item.MID == condition.MID);
}
if (!string.IsNullOrEmpty(condition.CardID))
{
result = result.Where(item => item.CardID == condition.CardID);
}
if (!string.IsNullOrEmpty(condition.Description))
{
result = result.Where(item => item.Description.Contains(condition.Description));
}
if (condition.Types != null && condition.Types.Count > 0)
{
result = result.Where(item => condition.Types.Contains(item.LogType));
}
return(result.ToList());
}
return(new List <APMLog>());
}
private void ItemSearching_Handler(object sender, EventArgs e)
{
APMLogSearchCondition con = new APMLogSearchCondition();
con.RecordDateTimeRange = new DateTimeRange(ucDateTimeInterval1.StartDateTime, ucDateTimeInterval1.EndDateTime);
con.SerialNum = txtSerialNum.Text;
con.CardID = txtCardID.Text;
con.MID = comAPM.Text;
con.CardCertificate = this.txtCertificate.Text;
con.Operator = this.operatorCombobox1.SelectecOperator;
con.StationID = this.workStationCombobox1.Text;
GridView.Rows.Clear();
List <APMRefundRecord> items = (new APMRefundRecordBll(AppSettings.CurrentSetting.ParkConnect)).GetAPMRefundRecords(con).QueryObjects;
foreach (APMRefundRecord item in items)
{
int row = this.GridView.Rows.Add();
ShowAPMRefundRecordOnRow(GridView.Rows[row], item);
}
this.txtCount.Text = items.Count.ToString();
this.txtTurnBackMoney.Text = items.Sum(c => c.RefundMoney).ToString();
}
protected override List <APMRefundRecord> GetingItems(ParkDataContext parking, SearchCondition search)
{
if (search is RecordSearchCondition)
{
RecordSearchCondition con = search as RecordSearchCondition;
IQueryable <APMRefundRecord> result = parking.APMRefundRecord;
if (con.RecordDateTimeRange != null)
{
result = result.Where(c => c.RefundDateTime >= con.RecordDateTimeRange.Begin).AsQueryable();
result = result.Where(c => c.RefundDateTime <= con.RecordDateTimeRange.End).AsQueryable();
}
if (con.Operator != null)
{
result = result.Where(c => c.OperatorID == con.Operator.OperatorName);
}
if (con.StationID != null && con.StationID != "")
{
result = result.Where(c => c.StationID == con.StationID);
}
if (!string.IsNullOrEmpty(con.CardID))
{
result = result.Where(c => c.CardID.Contains(con.CardID));
}
if (!string.IsNullOrEmpty(con.CardCertificate))
{
result = result.Where(c => c.CardCertificate.Contains(con.CardCertificate));
}
if (!string.IsNullOrEmpty(con.OwnerName))
{
result = result.Where(c => c.OwnerName.Contains(con.OwnerName));
}
if (!string.IsNullOrEmpty(con.CarPlate))
{
result = result.Where(c => c.CarPlate.Contains(con.CarPlate));
}
if (con.IsUnSettled != null)
{
if (con.IsUnSettled.Value)
{
result = result.Where(c => c.SettleDateTime == null);
}
else
{
result = result.Where(c => c.SettleDateTime != null);
}
}
if (con.SettleDateTime != null)
{
result = result.Where(c => c.SettleDateTime == con.SettleDateTime.Value);
}
if (search is APMLogSearchCondition)
{
APMLogSearchCondition condition = search as APMLogSearchCondition;
if (!string.IsNullOrEmpty(condition.MID))
{
result = result.Where(c => c.MID == condition.MID);
}
if (!string.IsNullOrEmpty(condition.SerialNum))
{
result = result.Where(c => c.PaymentSerialNumber == condition.SerialNum);
}
}
return(result.ToList());
}
return(new List <APMRefundRecord>());
}
public QueryResultList <APMLog> GetItems(APMLogSearchCondition con)
{
return(_Provider.GetItems(con));
}
