PagingControl.cs 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Drawing;
  5. using System.Data;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using CoreFS.CA06;
  10. using Core.Mes.Client.Comm.Server;
  11. using Core.Mes.Client.Comm.Tool;
  12. namespace Core.StlMes.Client.PlnSaleOrd.工序排产.control
  13. {
  14. public partial class PagingControl : UserControl
  15. {
  16. /// <summary>
  17. /// sql语句ID
  18. /// </summary>
  19. string sqlId = "";
  20. /// <summary>
  21. /// sql参数(此参数必须与sql一致)
  22. /// </summary>
  23. string[] parameters = null;
  24. /// <summary>
  25. /// 每页显示行数
  26. /// </summary>
  27. int pageSize = 0;
  28. /// <summary>
  29. /// ob
  30. /// </summary>
  31. OpeBase ob = null;
  32. /// <summary>
  33. /// 绑定数据源
  34. /// </summary>
  35. BindingSource bs = null;
  36. /// <summary>
  37. /// 总页数
  38. /// </summary>
  39. int pageCount = 0;
  40. /// <summary>
  41. /// 当前页
  42. /// </summary>
  43. int pageCurrent = 0;
  44. Object T = null;
  45. public PagingControl()
  46. {
  47. this.Dock = DockStyle.Bottom;
  48. InitializeComponent();
  49. }
  50. public void InitData(string sqlId, string[] parameters, int pageSize, BindingSource bs,Object T, OpeBase ob)
  51. {
  52. this.sqlId = sqlId;
  53. this.parameters = parameters;
  54. this.pageSize = pageSize;
  55. this.bs = bs;
  56. this.ob = ob;
  57. this.T = T;
  58. }
  59. private void PagingControl_Load(object sender, EventArgs e)
  60. {
  61. }
  62. private void InitPage()
  63. {
  64. ultraLabel3.Text = pageCurrent + "/" + pageCount;
  65. ultraLabel6.Text = pageSize.ToString();
  66. double pageAll = pageCount / pageSize;
  67. ultraLabel8.Text = Math.Ceiling(pageAll).ToString();
  68. }
  69. private void ControlPage()
  70. {
  71. double pageN = pageCount / pageSize;
  72. if (pageCurrent <= 1)
  73. {
  74. this.buttonFrist.Enabled = false;
  75. this.buttonUp.Enabled = false;
  76. }
  77. if (pageCurrent == Math.Ceiling(pageN))
  78. {
  79. }
  80. }
  81. private void QueryPageSize()
  82. {
  83. DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.PageingControl.queryPageSize", new object[] { sqlId, parameters }, this.ob);
  84. if (dt != null && dt.Rows.Count > 0)
  85. {
  86. pageCount = Convert.ToInt32(dt.Rows[0][0].ToString());
  87. }
  88. }
  89. private void Query<T>(int beSize, int endSize)
  90. {
  91. List<T> listSource = EntityHelper.GetData<T>("com.steering.pss.plnsaleord.processOrder.base.PageingControl.queryPageSize", new object[] { }, this.ob);
  92. bs.DataSource = listSource;
  93. }
  94. private void buttonFrist_Click(object sender, EventArgs e)
  95. {
  96. }
  97. private void buttonUp_Click(object sender, EventArgs e)
  98. {
  99. }
  100. private void buttonDown_Click(object sender, EventArgs e)
  101. {
  102. }
  103. private void buttonEnd_Click(object sender, EventArgs e)
  104. {
  105. }
  106. private void buttonGo_Click(object sender, EventArgs e)
  107. {
  108. }
  109. }
  110. }