/// <summary>
/// 查询
/// </summary>
private void Query()
{
StringBuilder strSB = new StringBuilder();
strSB.Append(" 1=1 ");
string carNo = this.tbCarNo.Text.Trim();
if (!string.IsNullOrEmpty(carNo))
{
strSB.Append(" AND VEHICLE_NO LIKE '%" + carNo + "%' ");
}
string cardNum = this.tbCardNum.Text.Trim();
if (!string.IsNullOrEmpty(cardNum))
{
strSB.Append(" AND CAR_EC_NO LIKE '%" + cardNum + "%' ");
}
string dtInTime = Convert.ToDateTime(this.dtInTime.Text).ToString("yyyy-MM-dd");
string dtOutTime = Convert.ToDateTime(this.dtOutTime.Text).ToString("yyyy-MM-dd");
strSB.Append(" AND CONVERT(varchar(100), IN_TIME, 23) >= '" + dtInTime + "' and CONVERT(varchar(100), IN_TIME, 23) <='" + dtOutTime + "'");
if (cmbCardType.SelectedValue.ToString() != "-1")
{
strSB.Append(" AND CREDENTIALS_TYPE=" + Convert.ToInt32(cmbCardType.SelectedValue.ToString()) + " ");
}
var carInfoList = bllRecord.GetInSideList(strSB.ToString(), currPage, pageSize, out sizeCount, out pageCount);
this.pagingControl.PageSize = pageSize.ToString();
this.pagingControl.PageCount = pageCount.ToString();
this.pagingControl.RecordCount = sizeCount.ToString();
this.pagingControl.CurrPage = (currPage + 1).ToString();
BeginInvoke((Action) delegate()
{
GC.Collect();
this.pCarPic.Controls.Clear();
int i = 0;
foreach (var temp in carInfoList)
{
CarControl control = new CarControl(temp.ID);
control.UserControlBtnClicked += new CarControl.BtnClickHandle(control_UserControlBtnClicked);
control.Tag = temp.ID;
control.VEHICLE_NO = temp.VEHICLE_NO;
control.IN_CHANNEL_CODE = temp.IN_CHANNEL_CODE;
control.IMG_URL = temp.IMG_URL;
control.IN_TIME = temp.IN_TIME.ToString("yyyy-MM-dd HH:mm:ss");
control.Location = getLocation(i, control.Width, control.Height);
this.pCarPic.Controls.Add(control);
i++;
}
});
}
/// <summary>
/// 场内车查询
/// </summary>
private void QueryCarInSide()
{
int length = 3;
string Key = string.Empty;
string carNo = this.tbCarNo.Text.Trim();
if (!string.IsNullOrEmpty(carNo))
{
List <CarInSideInfo> carInfoList = new List <CarInSideInfo>();
for (int i = 0; i < carNo.Length; i++)
{
if (i + length <= carNo.Length)
{
Key = carNo.Substring(i, length);
StringBuilder strSB = new StringBuilder();
strSB.Append(" 1=1 ");
if (!string.IsNullOrEmpty(carNo))
{
strSB.Append(" AND VEHICLE_NO LIKE '%" + Key + "%' ");
}
var carInfoTemp = bllRecord.GetInSideList(strSB.ToString(), currPage, pageSize, out sizeCount, out pageCount);
carInfoTemp.ForEach((CarInSideInfo x) =>
{
if (0 == carInfoList.Where(k => k.VEHICLE_NO == x.VEHICLE_NO).Count())
{
carInfoList.Add(x);
}
});
}
}
this.pagingControl.PageSize = pageSize.ToString();
this.pagingControl.PageCount = pageCount.ToString();
this.pagingControl.RecordCount = sizeCount.ToString();
this.pagingControl.CurrPage = (currPage + 1).ToString();
BeginInvoke((Action) delegate()
{
GC.Collect();
this.pCarPic.Controls.Clear();
int i = 0;
foreach (var temp in carInfoList)
{
CarControl control = new CarControl(temp.ID);
control.UserControlBtnClicked += new CarControl.BtnClickHandle(control_UserControlBtnClicked);
control.Tag = temp.ID;
control.VEHICLE_NO = temp.VEHICLE_NO;
control.IN_CHANNEL_CODE = temp.IN_CHANNEL_CODE;
control.IMG_URL = temp.IMG_URL;
control.IN_TIME = temp.IN_TIME.ToString("yyyy-MM-dd HH:mm:ss");
control.Location = getLocation(i, control.Width, control.Height);
this.pCarPic.Controls.Add(control);
i++;
}
});
}
else
{
Query();
}
}
