private void TSBFirstPage_Click(object sender, EventArgs e) { dataGridView_Archive_Print.DataSource = Class_SQL_Deal.DataTable_Query(SQL_Query, TableName, 0, PrintRows); StartRows = 0; Now_Pages = 1; Get_RowClick = -1; TStripLabel_Count.Text = Convert.ToString(Now_Pages); }
private void TSBLastPage_Click(object sender, EventArgs e) { if (All_Pages > 0) { Get_RowClick = -1; Now_Pages = All_Pages; StartRows = (All_Pages - 1) * PrintRows; dataGridView_Archive_Print.DataSource = Class_SQL_Deal.DataTable_Query(SQL_Query, TableName, StartRows, PrintRows); TStripLabel_Count.Text = Convert.ToString(Now_Pages); } }
/// <summary> /// 查询Tables /// </summary> private void PrintDatas(DataGridView Get_DataGridView, string AllRows_SQL, string Query_SQL, string TableName) { Set_Page_Button(0); Class_SQL_Deal.Open_Connection(); Get_DataGridView.DataSource = null; // Get_DataGridView.Columns.Clear(); Get_DataGridView.Rows.Clear(); // All_Rows = Class_SQL_Deal.Query_AllRows("Archive_Table", AllRows_SQL); // if (All_Rows == 0)//只有一页 { #region 查不到信息时提示信息 Get_DataGridView.Columns.Add("Message", ""); Get_DataGridView.Rows.Add("亲,查询不到信息哦!"); #endregion TSLPagesPrint.Text = "0"; TStripLabel_Count.Text = "0"; return; } else if (All_Rows > 0 && All_Rows <= PrintRows) { Get_DataGridView.DataSource = Class_SQL_Deal.DataTable_Query(Query_SQL, TableName, StartRows, PrintRows); TSLPagesPrint.Text = "1"; TStripLabel_Count.Text = Convert.ToString(Now_Pages); return; } else { JudgeElse = All_Rows % PrintRows;//整页 if (JudgeElse == 0) { Set_Page_Button(1); All_Pages = All_Rows / PrintRows; Get_DataGridView.DataSource = Class_SQL_Deal.DataTable_Query(Query_SQL, TableName, StartRows, PrintRows); TSLPagesPrint.Text = Convert.ToString(All_Pages); TStripLabel_Count.Text = Convert.ToString(Now_Pages); } else//一页半的情况 { Set_Page_Button(1); All_Pages = All_Rows / PrintRows + 1; Get_DataGridView.DataSource = Class_SQL_Deal.DataTable_Query(Query_SQL, TableName, StartRows, PrintRows); TSLPagesPrint.Text = Convert.ToString(All_Pages); TStripLabel_Count.Text = Convert.ToString(Now_Pages); } } }