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