123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392 |
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.IO;
- using System.Windows.Forms;
- using UAS_MES_NEW.DataOperate;
- using UAS_MES_NEW.Entity;
- namespace UAS_MES_NEW.CustomControl.Pagination
- {
- public partial class Pagination : UserControl
- {
- #region 变量
-
- int PageSize;
-
-
-
- public int Current_Page;
-
-
-
- int TotalPageCount;
-
-
-
- int RowCount;
-
-
-
- string Table_ID;
-
-
-
- string TableName;
- string Caller;
-
-
-
- string Field;
-
-
-
- DataGridViewImageColumn dgic = null;
- string Condition = "";
-
-
-
- bool DeleteEnable1;
-
-
-
- bool AddEnable1;
- DataGridView Dgv;
- DataTable dt;
- DataHelper dh = SystemInf.dh;
- public bool DeleteEnable
- {
- get
- {
- return DeleteEnable1;
- }
- set
- {
- DeleteEnable1 = value;
- }
- }
- public bool AddEnable
- {
- get
- {
- return AddEnable1;
- }
- set
- {
- AddEnable1 = value;
- }
- }
- #endregion
- public Pagination()
- {
- InitializeComponent();
-
- toolTip1.SetToolTip(DownLoadTemplet, "下载模板");
- toolTip1.SetToolTip(UpLoadData, "上传数据");
- toolTip1.SetToolTip(ExportExcel, "导出数据");
- toolTip1.SetToolTip(Delete, "删除数据");
- toolTip1.SetToolTip(FirstPage, "第一页");
- toolTip1.SetToolTip(PreviousPage, "上一页");
- toolTip1.SetToolTip(NextPage, "下一页");
- toolTip1.SetToolTip(LastPage, "最后一页");
- }
- public delegate void OnCheckedChange(object sender, EventArgs e);
-
- public event OnCheckedChange UserControlCheckedChanged;
-
-
-
-
-
-
- public void BindDataToNavigator(DataGridView dgv, string tableName, string field, string ID, string caller, string condition, params DataGridViewImageColumn[] operate)
- {
-
- Dgv = dgv;
- TableName = tableName;
- Table_ID = ID;
- Caller = caller;
- Field = field;
- Condition = condition;
-
- PageSize = int.Parse(this.ShowItemsNum.Text);
-
- Current_Page = int.Parse(this.CurrentPage.Text);
-
- RowCount = dh.getRowCount(TableName);
-
- dt = dh.getFieldsDatasByPageing(TableName, field, Current_Page, PageSize, Caller, condition);
-
- RefreshTotalCount();
-
- dgv.DataSource = dt;
- dt.Dispose();
- for (int i = 0; i < operate.Length; i++)
- {
- dgic = operate[i];
- AddOperateColumnToDgv();
- }
- }
-
- public void GetPageData()
- {
- this.TotalPage.Text = "/ " + TotalPageCount.ToString();
- CurrentPage.Text = Current_Page.ToString();
-
- dt = dh.getFieldsDatasByPageing(TableName, Field, Current_Page, PageSize, Caller, Condition);
-
- Dgv.DataSource = dt;
- AddOperateColumnToDgv();
- }
-
- private void AddOperateColumnToDgv()
- {
- if (dgic != null)
- {
- if (Dgv.Columns[dgic.Name] != null)
- {
- Dgv.Columns.Remove(Dgv.Columns[dgic.Name]);
- }
- dgic.DisplayIndex = Dgv.Columns.Count;
- Dgv.Columns.Add(dgic);
- }
- }
-
- private void FirstPage_Click(object sender, EventArgs e)
- {
- Current_Page = 1;
- GetPageData();
- RefreshTotalCount();
- }
-
- private void PreviousPage_Click(object sender, EventArgs e)
- {
- if (Current_Page > 1)
- {
- Current_Page--;
- }
- GetPageData();
- RefreshTotalCount();
- }
-
- private void NextPage_Click(object sender, EventArgs e)
- {
- if (Current_Page < TotalPageCount)
- {
- Current_Page++;
- }
- GetPageData();
- RefreshTotalCount();
- }
-
- private void LastPage_Click(object sender, EventArgs e)
- {
- Current_Page = TotalPageCount;
- CurrentPage.Text = TotalPageCount.ToString();
- GetPageData();
- RefreshTotalCount();
- }
- private void ExportExcel_Click(object sender, EventArgs e)
- {
- ExcelExport("Data");
- }
-
- private void CurrentPage_KeyDown(object sender, KeyEventArgs e)
- {
-
- if (e.KeyValue == (int)Keys.Enter)
- {
-
- if (IsNumOrNull(CurrentPage.Text))
- {
- Current_Page = int.Parse(CurrentPage.Text);
-
- if (Current_Page >= 1 && Current_Page <= TotalPageCount)
- {
- GetPageData();
- }
- else
- {
- MessageBox.Show("请输入正确的页码");
- }
- }
- else
- {
- CurrentPage.Text = "1";
- MessageBox.Show("页码必须是不为空的正整数");
- }
- }
- }
-
- private bool IsNumOrNull(object Num)
- {
-
- foreach (char c in Num.ToString())
- {
- if (!char.IsDigit(c))
- {
- return false;
- }
- }
-
- if (Num.ToString() == "")
- {
- return false;
- }
- return true;
- }
-
- private void RefreshTotalCount()
- {
-
- if (Condition.Trim() != "")
- {
- RowCount = dh.getRowCount(TableName, Condition);
- }
- else
- {
- RowCount = dh.getRowCount(TableName);
- }
-
- TotalPageCount = RowCount / PageSize + 1;
-
- TotalPage.Text = "/ " + TotalPageCount.ToString();
- }
-
- private void Delete_Click(object sender, EventArgs e)
- {
-
- Delete.Focus();
- UserControlCheckedChanged?.Invoke(sender, new EventArgs());
- {
- List<string> DeleteID = new List<string>();
- for (int i = 0; i < Dgv.Rows.Count; i++)
- {
- if (Dgv.Rows[i].Cells["Choose"].FormattedValue.ToString() == "True")
- {
- DeleteID.Add(Dgv.Rows[i].Cells[Table_ID].FormattedValue.ToString());
- }
- }
- if (DeleteID.ToArray().Length > 0)
- {
-
- string tablename = TableName;
- if (TableName.Contains("join"))
- {
- tablename = TableName.Substring(0, TableName.IndexOf("left")).Trim();
- }
- dh.DeleteDataByID(tablename, Table_ID, DeleteID.ToArray());
- GetPageData();
- RefreshTotalCount();
- }
- }
- }
-
- private void Add_Click(object sender, EventArgs e)
- {
- ((DataTable)Dgv.DataSource).Rows.Add();
- }
- private void DownLoadTemplet_Click(object sender, EventArgs e)
- {
- ExcelExport("Templet");
- }
-
- private void ExcelExport(string DataOrTemplet)
- {
-
-
- folderBrowserDialog1.Description = "选择导出的路径";
- DialogResult result = folderBrowserDialog1.ShowDialog();
- if (result == DialogResult.OK)
- {
- string FolderPath = folderBrowserDialog1.SelectedPath;
- ExcelHandler eh = new ExcelHandler();
- DataTable dt = new DataTable();
- if (DataOrTemplet == "Data")
- {
- dt = dh.getFieldsDatas(TableName, Field);
- }
- else
- {
-
- dt = dh.GetColumnDataType(TableName);
- dt = dh.DataTypeColumnToDataTable(dt);
- }
-
- string filePath = eh.ExportExcel(dt, FolderPath);
-
- MessageBoxButtons messButton = MessageBoxButtons.YesNo;
- string openFile = MessageBox.Show(this.ParentForm, "是否打开文件", "提示", messButton).ToString();
- if (openFile == "Yes")
- {
- System.Diagnostics.Process.Start(filePath);
- }
- }
- }
- private void UpLoadData_Click(object sender, EventArgs e)
- {
- openFileDialog1.Title = "选择需要导入的Excel";
- if (openFileDialog1.ShowDialog() == DialogResult.OK)
- {
- string ChoosedExcel = openFileDialog1.FileName;
- ExcelHandler eh = new ExcelHandler();
- Console.WriteLine(ChoosedExcel);
- eh.ImportExcel(ChoosedExcel, "test");
- }
- }
- private void ShowItemsNum_SelectedValueChanged(object sender, EventArgs e)
- {
- if (IsNumOrNull(ShowItemsNum.SelectedItem))
- {
- PageSize = int.Parse(ShowItemsNum.SelectedItem.ToString());
-
-
- if (PageSize >= 1)
- {
- RefreshTotalCount();
- GetPageData();
- }
- else
- {
- MessageBox.Show("请输入正确的数字");
- }
- }
- else
- {
- MessageBox.Show("页码必须是不为空的正整数");
- }
- }
- private void Pagination_Load(object sender, EventArgs e)
- {
- Delete.Enabled = DeleteEnable1;
- Add.Enabled = AddEnable1;
- }
- }
- }
|