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<FilterEntity> _filterList = new List<FilterEntity>();
|
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);
|
}
|
|
/// <summary>
|
/// 分页事件
|
/// </summary>
|
/// <param name="curPage"></param>
|
/// <param name="pageSize"></param>
|
private void PageBar1_PagerEvent(int curPage, int pageSize)
|
{
|
getPageList(curPage);
|
}
|
/// <summary>
|
/// 查询事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
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();
|
}
|
/// <summary>
|
/// 查询回调
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void Frm_UpdateParent(object sender, UpdateParentEventArgs e)
|
{
|
_filterList = e.FilterList;
|
getPageList(1);
|
}
|
|
/// <summary>
|
/// 刷新事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
|
{
|
getPageList(this.pageBar1.CurrentPage);
|
}
|
|
/// <summary>
|
///
|
/// </summary>
|
/// <param name="curPage">第几页</param>
|
/// <param name="pageSize">每页几条</param>
|
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<PageListModel> 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);
|
}
|
}
|
}
|
}
|
