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