using DevComponents.DotNetBar.Layout; using DevComponents.DotNetBar.SuperGrid; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using WCS_Client.UC; using WCS_Client.Utility; namespace WCS_Client.Frm { public partial class FrmAgvCachePostionInfo : Form { public FrmAgvCachePostionInfo() { InitializeComponent(); InitFrm(); } private void InitFrm() { List GCList = new List() { SuperGridUtil.Get_GridColumn("ID", "ID", 80), SuperGridUtil.Get_GridColumn("CachePosNo", "缓存位置名称", 100), SuperGridUtil.Get_GridColumn("ConvPostionNo", "车间入库口", 80), SuperGridUtil.Get_GridColumn("CachePH_Status", "缓存位光电信号", 120), SuperGridUtil.Get_GridColumn("WorkshopNo", "车间编号", 80), SuperGridUtil.Get_GridColumn("ProLineNo", "生产线", 80), SuperGridUtil.Get_GridColumn("UpdateUser", "修改用户", 100), SuperGridUtil.Get_GridColumn("UpdateDate", "修改时间", 150), SuperGridUtil.Get_GridColumn("Remark", "备注", 120) }; List LCIList = new List(); LCIList.Add(LCItemUtil.Add_TextboxX("TASK_NO", "车间编号:", 20, SubmitMethods, null)); LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "WorkshopNo like '%{0}%'" }; LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "查询", 80, 30, SubmitMethods)); LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 80, 30, SubmitMethods)); uC_QueryPage1.Init_QueryPage(60, true, true, "", GCList, LCIList, QueryPageDataMethods, RefreshRoleMethods, DoubleClikMethod, null, null); uC_QueryPage1.ClearLCItemValue(); CommonShow.ShowProcessing("正在处理中,请稍候...", this, (obj) => { uC_QueryPage1.RefreshData(1, 0); }, null); } private PageData QueryPageDataMethods(int PageIndex, int PageSize) { string _SQLText = @"SELECT [ID],[CachePosNo],[ConvPostionNo],[CachePH_Status],[WorkshopNo],[ProLineNo],[UpdateUser],[UpdateDate],[Remark] FROM [YONGGUAN_WCS].[dbo].[Middle_CachePostionInfo] where 1=1 "; string _Orderby = "CachePosNo asc"; PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, uC_QueryPage1.GetQueryWhere(), PageIndex, PageSize); return pd; } private void RefreshRoleMethods(bool ChkValue) { } private void DoubleClikMethod(DataRow dr) { //wcs_task_no = Convert.ToInt32(dr["TASK_NO"].ToString()); //FrmWCS_TaskDIS_DTL Frm = new FrmWCS_TaskDIS_DTL(wcs_task_no); //Frm.Show(); } private void SubmitMethods(string LCName) { if (LCName == "btn_QDB") { uC_QueryPage1.RefreshData(); } else if (LCName == "btn_QClear") { uC_QueryPage1.ShowOpaqueLayer(); uC_QueryPage1.ClearLCItemValue(); uC_QueryPage1.RefreshData(1, 0); uC_QueryPage1.HideOpaqueLayer(); } } } }