using DevExpress.XtraTreeList.Data; using Gs.DevApp.Entity; using Gs.DevApp.ToolBox; using Gs.DevApp.UserControl; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Data; using System.Threading.Tasks; using System.Windows.Forms; using static DevExpress.DataProcessing.InMemoryDataProcessor.AddSurrogateOperationAlgorithm; using static System.Windows.Forms.VisualStyles.VisualStyleElement; namespace Gs.DevApp.DevFrm { public partial class YS_zjhscjd : DevExpress.XtraEditors.XtraForm { //入库检报表 string _webServiceName = "YS_rkjreport/"; List _filterList = new List(); public YS_zjhscjd() { InitializeComponent(); this.toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick; this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick; this.toolBarMenu1.getXmlConfig(); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, null, this, "", "", (value) => { }); Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) => { }, (value) => { getPageList(this.pageBar1.CurrentPage); }); getPageList(1); pageBar1.PagerEvent += PageBar1_PagerEvent; } private async void GridView1_ColumnFilterChanged(object sender, EventArgs e) { _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1); await Task.Delay(100); getPageList(1); } /// /// 分页事件 /// /// /// private void PageBar1_PagerEvent(int curPage, int pageSize) { getPageList(curPage); } /// /// 查询事件 /// /// /// private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e) { gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; gridView1.ActiveFilter.Clear(); gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; var frm = new ShowFilter(gridView1.Columns, _filterList, this.GetType().FullName); frm.UpdateParent += Frm_UpdateParent; frm.ShowDialog(); } /// /// 查询回调 /// /// /// private void Frm_UpdateParent(object sender, UpdateParentEventArgs e) { _filterList = e.FilterList; getPageList(1); } /// /// 刷新事件 /// /// /// private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e) { getPageList(this.pageBar1.CurrentPage); } /// /// /// /// 第几页 /// 每页几条 private void getPageList(int curPage) { gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "week_start_date", "desc", "", _sbSqlWhere.ToString()); string json = JsonConvert.SerializeObject(pgq); try { var strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPageWeeklyProductionScheduleReport", json); ReturnModel dd = UtilityHelper.ReturnToTablePage(strReturn); if (dd.rtnCode > 0) { DataTable dt = dd.rtnData.list; //-- ====================================================================== //--英文列名(English Column Name) | 中文列名(Chinese Column Name) | 说明(Description) //-- ====================================================================== //--1.week_start_date | 周日期 | 工单的排产日期或报工日期所在的周 //-- 2.workshop_name | 车间名称 | 生产车间名称 //-- 3.work_order_no | 工单号 | 生产工单编号 //-- 4.work_order_status | 工单状态 | 工单当前状态(新建 / 已排产 / 生产中 / 已完工 / 已关闭) //--5.material_code | 物料编码 | 生产物料的编码 //-- 6.material_name | 物料名称 | 生产物料的名称 //-- 7.material_spec | 物料规格 | 生产物料的规格 //-- 8.plan_quantity | 工单数量 | 工单计划生产数量 //-- 9.kit_flag | 齐套标识 | 物料是否齐套(是 / 否) //--10.report_quantity | 报工数量 | 已报工数量 //-- 11.inspection_quantity | 检验数量 | 已检验数量 //-- 12.storage_quantity | 入库数量 | 已入库数量 //-- 13.barcode_count | 条码张数 | 已打印的条码数量 //-- 14.unreported_quantity | 未报工数 | 工单数量 - 报工数量 //-- 15.uninspected_quantity | 未检验数 | 报工数量 - 检验数量 //-- 16.unstored_quantity | 未入库数 | 检验数量 - 入库数量 //-- 17.manual_complete_flag | 手动完工标识 | 是否手动标记为完工(是 / 否) gcMain1.BindingContext = new BindingContext(); gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; if (dt.Rows.Count > 0) { gcMain1.DataSource = dt; gcMain1.ForceInitialize(); gridView1.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView1); } else UtilityHelper.SetDefaultTable(gcMain1, gridView1); gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; pageBar1.TotalPages = dd.rtnData.pages;//总页 pageBar1.CurrentPage = curPage;//当前页 pageBar1.RecordCount = dd.rtnData.total;//总记录数 } else { ToolBox.MsgHelper.ShowError("提示:" + dd.rtnMsg); } } catch (Exception ex) { ToolBox.MsgHelper.ShowError("提示:" + ex.Message); } } } }