using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Drawing;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Text;
|
using System.Windows.Forms;
|
using HH.WMS.Client;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using HH.WMS.Entitys.Func;
|
using HH.WMS.Client.Common;
|
using HH.WMS.Entitys.Basic;
|
using DevComponents.DotNetBar;
|
|
namespace WindowsApp.MyControl
|
{
|
/// <summary>
|
/// ÉêÃ÷ίÍÐ
|
/// </summary>
|
/// <param name="e"></param>
|
/// <returns></returns>
|
public delegate int EventPagingHandler(EventPagingArg e);
|
/// <summary>
|
/// ·ÖÒ³¿Ø¼þ³ÊÏÖ
|
/// </summary>
|
public partial class Pager : UserControl
|
{
|
public Pager()
|
{
|
InitializeComponent();
|
}
|
public event EventPagingHandler EventPaging;
|
/// <summary>
|
/// ÿҳÏÔʾ¼Ç¼Êý
|
/// </summary>
|
private int _pageSize = 50;
|
/// <summary>
|
/// ÿҳÏÔʾ¼Ç¼Êý
|
/// </summary>
|
public int PageSize
|
{
|
get { return _pageSize; }
|
set
|
{
|
_pageSize = value;
|
GetPageCount();
|
}
|
}
|
|
private int _nMax = 0;
|
/// <summary>
|
/// ×ܼǼÊý
|
/// </summary>
|
public int NMax
|
{
|
get { return _nMax; }
|
set
|
{
|
_nMax = value;
|
GetPageCount();
|
}
|
}
|
|
private int _pageCount = 0;
|
/// <summary>
|
/// Ò³Êý=×ܼǼÊý/ÿҳÏÔʾ¼Ç¼Êý
|
/// </summary>
|
public int PageCount
|
{
|
get { return _pageCount; }
|
set { _pageCount = value; }
|
}
|
|
private int _pageCurrent = 0;
|
/// <summary>
|
/// µ±Ç°Ò³ºÅ
|
/// </summary>
|
public int PageCurrent
|
{
|
get { return _pageCurrent; }
|
set { _pageCurrent = value; }
|
}
|
|
public BindingNavigator ToolBar
|
{
|
get { return this.bindingNavigator; }
|
}
|
|
private void GetPageCount()
|
{
|
if (this.NMax > 0)
|
{
|
this.PageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(this.NMax) / Convert.ToDouble(this.PageSize)));
|
}
|
else
|
{
|
this.PageCount = 0;
|
}
|
}
|
|
/// <summary>
|
/// ·Ò³¿Ø¼þÊý¾Ý°ó¶¨µÄ·½·¨
|
/// </summary>
|
public void Bind()
|
{
|
this._pageSize = Convert.ToInt32(this.ComPageSize.Text);
|
if (this.EventPaging != null)
|
{
|
this.NMax = this.EventPaging(new EventPagingArg(this.PageCurrent));
|
}
|
|
if (this.PageCurrent > this.PageCount)
|
{
|
this.PageCurrent = this.PageCount;
|
}
|
if (this.PageCount == 1)
|
{
|
this.PageCurrent = 1;
|
}
|
lblPageCount.Text = this.PageCount.ToString();
|
this.lblMaxPage.Text = "¹²" + this.NMax.ToString() + "Ìõ¼Ç¼";
|
this.txtCurrentPage.Text = this.PageCurrent.ToString();
|
|
if (this.PageCurrent == 1)
|
{
|
this.btnPrev.Enabled = false;
|
this.btnFirst.Enabled = false;
|
}
|
else
|
{
|
btnPrev.Enabled = true;
|
btnFirst.Enabled = true;
|
}
|
|
if (this.PageCurrent == this.PageCount)
|
{
|
this.btnLast.Enabled = false;
|
this.btnNext.Enabled = false;
|
}
|
else
|
{
|
btnLast.Enabled = true;
|
btnNext.Enabled = true;
|
}
|
|
if (this.NMax == 0)
|
{
|
btnNext.Enabled = false;
|
btnLast.Enabled = false;
|
btnFirst.Enabled = false;
|
btnPrev.Enabled = false;
|
}
|
|
//GetComboxPageSize();
|
}
|
//·ÖÒ³´óСÏÂÀ¿ò
|
public void GetComboxPageSize()
|
{
|
this.ComPageSize.Items.Add("50");
|
this.ComPageSize.Items.Add("200");
|
this.ComPageSize.Items.Add("500");
|
this.ComPageSize.Items.Add("1000");
|
this.ComPageSize.Items.Add("2000");
|
//this.ComPageSize.SelectedIndex = 0;
|
}
|
|
private void btnFirst_Click(object sender, EventArgs e)
|
{
|
PageCurrent = 1;
|
this.Bind();
|
}
|
|
private void btnPrev_Click(object sender, EventArgs e)
|
{
|
PageCurrent -= 1;
|
if (PageCurrent <= 0)
|
{
|
PageCurrent = 1;
|
}
|
this.Bind();
|
}
|
|
private void btnNext_Click(object sender, EventArgs e)
|
{
|
this.PageCurrent += 1;
|
if (PageCurrent > PageCount)
|
{
|
PageCurrent = PageCount;
|
}
|
this.Bind();
|
}
|
|
private void btnLast_Click(object sender, EventArgs e)
|
{
|
PageCurrent = PageCount;
|
this.Bind();
|
}
|
|
private void btnGo_Click(object sender, EventArgs e)
|
{
|
if (this.txtCurrentPage.Text != null && txtCurrentPage.Text != "")
|
{
|
if (Int32.TryParse(txtCurrentPage.Text, out _pageCurrent))
|
{
|
this.Bind();
|
}
|
else
|
{
|
MessageBox.Show("ÊäÈëÊý×Ö¸ñʽ´íÎó£¡");
|
}
|
}
|
}
|
|
private void txtCurrentPage_KeyDown(object sender, KeyEventArgs e)
|
{
|
if (e.KeyCode == Keys.Enter)
|
{
|
this.Bind();
|
}
|
}
|
|
private void ComPageSize_TextChanged(object sender, EventArgs e)
|
{
|
this.Bind();
|
}
|
}
|
/// <summary>
|
/// ×Ô¶¨ÒåʼþÊý¾Ý»ùÀà
|
/// </summary>
|
public class EventPagingArg : EventArgs
|
{
|
private int _intPageIndex;
|
public EventPagingArg(int PageIndex)
|
{
|
_intPageIndex = PageIndex;
|
}
|
}
|
/// <summary>
|
/// Êý¾ÝÔ´Ìṩ
|
/// </summary>
|
public class PageData
|
{
|
private int _PageSize = 10;
|
private int _PageIndex = 1;
|
private int _PageCount = 0;
|
private int _TotalCount = 0;
|
private string _TableName;//±íÃû
|
private string _QueryFieldName = "*";//±í×Ö¶ÎFieldStr
|
private string _OrderStr = string.Empty; //ÅÅÐò_SortStr
|
private string _QueryCondition = string.Empty;//²éѯµÄÌõ¼þ RowFilter
|
private string _PrimaryKey = string.Empty;//Ö÷¼ü
|
private bool _isQueryTotalCounts = true;//ÊÇ·ñ²éѯ×ܵļǼÌõÊý
|
/// <summary>
|
/// ÊÇ·ñ²éѯ×ܵļǼÌõÊý
|
/// </summary>
|
public bool IsQueryTotalCounts
|
{
|
get { return _isQueryTotalCounts; }
|
set { _isQueryTotalCounts = value; }
|
}
|
/// <summary>
|
/// ÏÔʾҳÊý
|
/// </summary>
|
public int PageSize
|
{
|
get
|
{
|
return _PageSize;
|
|
}
|
set
|
{
|
_PageSize = value;
|
}
|
}
|
/// <summary>
|
/// µ±Ç°Ò³
|
/// </summary>
|
public int PageIndex
|
{
|
get
|
{
|
return _PageIndex;
|
}
|
set
|
{
|
_PageIndex = value;
|
}
|
}
|
/// <summary>
|
/// ×ÜÒ³Êý
|
/// </summary>
|
public int PageCount
|
{
|
get
|
{
|
return _PageCount;
|
}
|
}
|
/// <summary>
|
/// ×ܼǼÊý
|
/// </summary>
|
public int TotalCount
|
{
|
get
|
{
|
return _TotalCount;
|
}
|
}
|
/// <summary>
|
/// ±íÃû£¬°üÀ¨ÊÓͼ
|
/// </summary>
|
public string TableName
|
{
|
get
|
{
|
return _TableName;
|
}
|
set
|
{
|
_TableName = value;
|
}
|
}
|
/// <summary>
|
/// ±í×Ö¶ÎFieldStr
|
/// </summary>
|
public string QueryFieldName
|
{
|
get
|
{
|
return _QueryFieldName;
|
}
|
set
|
{
|
_QueryFieldName = value;
|
}
|
}
|
/// <summary>
|
/// ÅÅÐò×Ö¶Î
|
/// </summary>
|
public string OrderStr
|
{
|
get
|
{
|
return _OrderStr;
|
}
|
set
|
{
|
_OrderStr = value;
|
}
|
}
|
/// <summary>
|
/// ²éѯÌõ¼þ
|
/// </summary>
|
public string QueryCondition
|
{
|
get
|
{
|
return _QueryCondition;
|
}
|
set
|
{
|
_QueryCondition = value;
|
}
|
}
|
/// <summary>
|
/// Ö÷¼ü
|
/// </summary>
|
public string PrimaryKey
|
{
|
get
|
{
|
return _PrimaryKey;
|
}
|
set
|
{
|
_PrimaryKey = value;
|
}
|
}
|
/// <summary>
|
/// ÎïÁϱàÂë
|
/// </summary>
|
public string CN_S_ITEM_CODE { get; set; }
|
public string CN_S_ITEM_NAME { get; set; }
|
public string CN_S_MODEL { get; set; }
|
|
#region ·ÖÒ³×¢ÊÍ
|
//public DataSet QueryDataTable()
|
//{
|
// SqlParameter[] parameters = {
|
// new SqlParameter("@Tables", SqlDbType.VarChar, 255),
|
// new SqlParameter("@PrimaryKey" , SqlDbType.VarChar , 255),
|
// new SqlParameter("@Sort", SqlDbType.VarChar , 255 ),
|
// new SqlParameter("@CurrentPage", SqlDbType.Int),
|
// new SqlParameter("@PageSize", SqlDbType.Int),
|
// new SqlParameter("@Fields", SqlDbType.VarChar, 255),
|
// new SqlParameter("@Filter", SqlDbType.VarChar,1000),
|
// new SqlParameter("@Group" ,SqlDbType.VarChar , 1000 )
|
// };
|
// parameters[0].Value = _TableName;
|
// parameters[1].Value = _PrimaryKey;
|
// parameters[2].Value = _OrderStr;
|
// parameters[3].Value = PageIndex;
|
// parameters[4].Value = PageSize;
|
// parameters[5].Value = _QueryFieldName;
|
// parameters[6].Value = _QueryCondition;
|
// parameters[7].Value = string.Empty;
|
// DataSet ds = DbHelperSQL.RunProcedure("SP_Pagination", parameters, "dd");
|
// if (_isQueryTotalCounts)
|
// {
|
// _TotalCount = GetTotalCount();
|
// }
|
// if (_TotalCount == 0)
|
// {
|
// _PageIndex = 0;
|
// _PageCount = 0;
|
// }
|
// else
|
// {
|
// _PageCount = _TotalCount % _PageSize == 0 ? _TotalCount / _PageSize : _TotalCount / _PageSize + 1;
|
// if (_PageIndex > _PageCount)
|
// {
|
// _PageIndex = _PageCount;
|
|
// parameters[4].Value = _PageSize;
|
|
// ds = QueryDataTable();
|
// }
|
// }
|
// return ds;
|
//}
|
|
|
//ALTER PROCEDURE SP_Pagination
|
///**//*
|
//***************************************************************
|
//** ǧÍòÊýÁ¿¼¶·ÖÒ³´æ´¢¹ý³Ì **
|
//***************************************************************
|
//²ÎÊý˵Ã÷:
|
//1.Tables :±íÃû³Æ,ÊÓͼ
|
//2.PrimaryKey :Ö÷¹Ø¼ü×Ö
|
//3.Sort :ÅÅÐòÓï¾ä£¬²»´øOrder By ±ÈÈ磺NewsID Desc,OrderRows Asc
|
//4.CurrentPage :µ±Ç°Ò³Âë
|
//5.PageSize :·ÖÒ³³ß´ç
|
//6.Filter :¹ýÂËÓï¾ä£¬²»´øWhere
|
//7.Group :GroupÓï¾ä,²»´øGroup By
|
//Ч¹ûÑÝʾ£ºhttp://www.cn5135.com/_App/Enterprise/QueryResult.aspx
|
//***************************************************************/
|
//(
|
//@Tables varchar(2000),
|
//@PrimaryKey varchar(500),
|
//@Sort varchar(500) = NULL,
|
//@CurrentPage int = 1,
|
//@PageSize int = 10,
|
//@Fields varchar(2000) = '*',
|
//@Filter varchar(1000) = NULL,
|
//@Group varchar(1000) = NULL
|
//)
|
//AS
|
///**//*ĬÈÏÅÅÐò*/
|
//IF @Sort IS NULL OR @Sort = ''
|
//SET @Sort = @PrimaryKey
|
//DECLARE @SortTable varchar(1000)
|
//DECLARE @SortName varchar(1000)
|
//DECLARE @strSortColumn varchar(1000)
|
//DECLARE @operator char(2)
|
//DECLARE @type varchar(1000)
|
//DECLARE @prec int
|
///**//*É趨ÅÅÐòÓï¾ä.*/
|
//IF CHARINDEX('DESC',@Sort)>0
|
//BEGIN
|
//SET @strSortColumn = REPLACE(@Sort, 'DESC', '')
|
//SET @operator = '<='
|
//END
|
//ELSE
|
//BEGIN
|
//IF CHARINDEX('ASC', @Sort) = 0
|
//SET @strSortColumn = REPLACE(@Sort, 'ASC', '')
|
//SET @operator = '>='
|
//END
|
//IF CHARINDEX('.', @strSortColumn) > 0
|
//BEGIN
|
//SET @SortTable = SUBSTRING(@strSortColumn, 0, CHARINDEX('.',@strSortColumn))
|
//SET @SortName = SUBSTRING(@strSortColumn, CHARINDEX('.',@strSortColumn) + 1, LEN(@strSortColumn))
|
//END
|
//ELSE
|
//BEGIN
|
//SET @SortTable = @Tables
|
//SET @SortName = @strSortColumn
|
//END
|
//SELECT @type=t.name, @prec=c.prec
|
//FROM sysobjects o
|
//JOIN syscolumns c on o.id=c.id
|
//JOIN systypes t on c.xusertype=t.xusertype
|
//WHERE o.name = @SortTable AND c.name = @SortName
|
//IF CHARINDEX('char', @type) > 0
|
//SET @type = @type + '(' + CAST(@prec AS varchar) + ')'
|
//DECLARE @strPageSize varchar(500)
|
//DECLARE @strStartRow varchar(500)
|
//DECLARE @strFilter varchar(1000)
|
//DECLARE @strSimpleFilter varchar(1000)
|
//DECLARE @strGroup varchar(1000)
|
///**//*ĬÈϵ±Ç°Ò³*/
|
//IF @CurrentPage < 1
|
//SET @CurrentPage = 1
|
///**//*ÉèÖ÷ÖÒ³²ÎÊý.*/
|
//SET @strPageSize = CAST(@PageSize AS varchar(500))
|
//SET @strStartRow = CAST(((@CurrentPage - 1)*@PageSize + 1) AS varchar(500))
|
///**//*ɸѡÒÔ¼°·Ö×éÓï¾ä.*/
|
//IF @Filter IS NOT NULL AND @Filter != ''
|
//BEGIN
|
//SET @strFilter = ' WHERE ' + @Filter + ' '
|
//SET @strSimpleFilter = ' AND ' + @Filter + ' '
|
//END
|
//ELSE
|
//BEGIN
|
//SET @strSimpleFilter = ''
|
//SET @strFilter = ''
|
//END
|
//IF @Group IS NOT NULL AND @Group != ''
|
//SET @strGroup = ' GROUP BY ' + @Group + ' '
|
//ELSE
|
//SET @strGroup = ''
|
///**//*Ö´ÐвéѯÓï¾ä*/
|
//EXEC(
|
//'
|
//DECLARE @SortColumn ' + @type + '
|
//SET ROWCOUNT ' + @strStartRow + '
|
//SELECT @SortColumn=' + @strSortColumn + ' FROM ' + @Tables + @strFilter + ' ' + @strGroup + ' ORDER BY ' + @Sort + '
|
//SET ROWCOUNT ' + @strPageSize + '
|
//SELECT ' + @Fields + ' FROM ' + @Tables + ' WHERE ' + @strSortColumn + @operator + ' @SortColumn ' + @strSimpleFilter + ' ' + @strGroup + ' ORDER BY ' + @Sort + '
|
//'
|
//)
|
#endregion ·ÖÒ³×¢ÊÍ
|
|
|
public List<AutoBomItemEntity> QueryDataTable()
|
{
|
List<AutoBomItemEntity> dt = new List<AutoBomItemEntity>();
|
try
|
{
|
var userInfo = new AccountEntity();
|
var ss = userInfo.Token;
|
string str = WebApiManager.HttpWMS_Get("/api/Common/GetListItemByCode?itemCode=" + CN_S_ITEM_CODE + "&itemName=" + CN_S_ITEM_NAME + "&model=" + CN_S_MODEL + "&pageIndex=" + _PageIndex + "&pageSize=" + _PageSize);
|
|
OperateResult results = JsonConvert.DeserializeObject<OperateResult>(str);
|
|
if (results.Status == ResultStatus.Success)
|
{
|
JObject obj = null;
|
|
obj = (JObject)results.Data;
|
|
if (_isQueryTotalCounts)
|
{
|
_TotalCount = Convert.ToInt32(obj["total"]);
|
}
|
if (_TotalCount == 0)
|
{
|
_PageIndex = 0;
|
_PageCount = 0;
|
}
|
else
|
{
|
_PageCount = _TotalCount % _PageSize == 0 ? _TotalCount / _PageSize : _TotalCount / _PageSize + 1;
|
if (_PageIndex > _PageCount)
|
{
|
_PageIndex = _PageCount;
|
dt = QueryDataTable();
|
}
|
}
|
dt = JsonConvert.DeserializeObject<List<AutoBomItemEntity>>(obj["rows"].ToString());
|
foreach (AutoBomItemEntity entity in dt)
|
{
|
entity.CN_S_MODEL= entity.CN_S_MODEL.Replace("'", "\"");
|
}
|
return dt;
|
}
|
else
|
{
|
MessageBoxEx.Show(results.Msg);
|
return dt;
|
}
|
}
|
catch(Exception ex)
|
{
|
MessageBoxEx.Show(ex.Message);
|
return dt;
|
}
|
}
|
}
|
}
|
