public void LoadPage() { string strSql = ""; int intSkip = 1; intSkip = _mintCurrentPage; SqlConnection conn = new SmartDB().Connection; SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); try { conn.Open(); cmd = new SqlCommand("REPORT METER_PAGING", conn); cmd.Parameters.Add(new SqlParameter("@PageNumber", intSkip)); cmd.Parameters.Add(new SqlParameter("@RowspPage", _mintPageSize)); cmd.Parameters.Add(new SqlParameter("@Query", string.IsNullOrWhiteSpace(TextBoxSearch.Text) ? TextBoxSerialNumber.Text : TextBoxSearch.Text)); cmd.CommandType = CommandType.StoredProcedure; da.SelectCommand = cmd; da.Fill(dt); DataGridViewMeter.Invoke((Action) delegate { DataGridViewMeter.DataSource = dt; }); lblStatus.Invoke((Action) delegate { lblStatus.Text = (_mintCurrentPage) + " / " + _mintPageCount; }); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cmd.Dispose(); conn.Close(); } }
public void Paging_Equal_10() { //Arrange SqlConnection conn = new SmartDB().Connection; SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); try { conn.Open(); cmd = new SqlCommand("REPORT METER_PAGING", conn); cmd.Parameters.Add(new SqlParameter("@PageNumber", 1)); cmd.Parameters.Add(new SqlParameter("@RowspPage", 10)); cmd.Parameters.Add(new SqlParameter("@Query", "")); cmd.CommandType = CommandType.StoredProcedure; da.SelectCommand = cmd; da.Fill(dt); } catch (Exception) { } finally { cmd.Dispose(); conn.Close(); } //Act //var createCity = _city.Create(new SmartDB(), ref city); //bool flag = createCity.Code == ErrorEnum.NoError; int x = dt.Rows.Count; //Assert Assert.AreEqual(x, 9); }