private void AddCombBoxForDEV() { try { // 搜索设备类型 CBtype.Items.Add(" "); CBtype.Items.Add(DeviceType.固定辊台 + " : 固定辊台"); CBtype.Items.Add(DeviceType.摆渡车 + " : 摆渡车"); CBtype.Items.Add(DeviceType.运输车 + " : 运输车"); CBtype.Items.Add(DeviceType.行车 + " : 行车"); CBtype.Items.Add(DeviceType.包装线辊台 + " : 包装线辊台"); CBtype.SelectedIndex = 0; // 搜索设备区域 CBarea.Items.Add(" "); CBarea.SelectedIndex = 0; String sql = "select distinct AREA from wcs_config_area"; DataTable dt = CommonSQL.mysql.SelectAll(sql); if (CommonSQL.IsNoData(dt)) { return; } List <WCS_CONFIG_AREA> areaList = dt.ToDataList <WCS_CONFIG_AREA>(); foreach (WCS_CONFIG_AREA area in areaList) { CBarea.Items.Add(area.AREA); } } catch (Exception e) { Notice.Show(e.Message, "错误", 3, MessageBoxIcon.Error); } }
private void AddCombBox() { try { // 搜索任务类型 CBtype.Items.Add(" "); CBtype.Items.Add((int)TaskTypeEnum.无 + ":" + TaskTypeEnum.无); CBtype.Items.Add((int)TaskTypeEnum.入库 + ":" + TaskTypeEnum.入库); CBtype.Items.Add((int)TaskTypeEnum.出库 + ":" + TaskTypeEnum.出库); CBtype.SelectedIndex = 0; // 搜索任务区域 CBarea.Items.Add(" "); CBarea.SelectedIndex = 0; String sql = "select distinct AREA from wcs_config_area"; DataTable dt = CommonSQL.mysql.SelectAll(sql); if (CommonSQL.IsNoData(dt)) { return; } List <WCS_CONFIG_AREA> areaList = dt.ToDataList <WCS_CONFIG_AREA>(); foreach (WCS_CONFIG_AREA area in areaList) { CBarea.Items.Add(area.AREA); } } catch (Exception e) { Notice.Show(e.Message, "错误", 3, MessageBoxIcon.Error); } }
/// <summary> /// 检查是否存在 /// </summary> /// <param name="i"></param> /// <returns></returns> public bool CheckExist(NDCItem i) { string sql = string.Format(@"select id from WCS_NDC_TASK where TASKID = '{0}'", i._mTask.TASKID); DataTable dt = mysql.SelectAll(sql); if (CommonSQL.IsNoData(dt)) { return(false); } return(true); }
/// <summary> /// 读取未完成NDC任务信息 /// </summary> public bool ReadUnFinishTask(out List <WCS_NDC_TASK> list) { list = new List <WCS_NDC_TASK>(); DataTable dt = mysql.SelectAll("SELECT ID,TASKID,IKEY,ORDERINDEX,LOADSITE,UNLOADSITE,REDIRECTSITE,NDCLOADSITE,NDCUNLOADSITE,NDCREDIRECTSITE,CREATETIME FROM WCS_NDC_TASK"); if (CommonSQL.IsNoData(dt)) { return(false); } list = dt.ToDataList <WCS_NDC_TASK>(); return(true); }
public bool ReadTempTask(out List <WCS_NDC_TASK_TEMP> list) { list = new List <WCS_NDC_TASK_TEMP>(); string sql = "SELECT ID,NDCINDEX,IKEY,CARRIERID FROM WCS_NDC_TASK_TEMP t"; DataTable dt = mysql.SelectAll(sql); if (CommonSQL.IsNoData(dt)) { return(false); } list = dt.ToDataList <WCS_NDC_TASK_TEMP>(); return(true); }
/// <summary> /// 选项 /// </summary> private void AddCombBoxForDEV() { try { // 设备类型 CBtype.Items.Add(_type); CBtype.Items.Add(DeviceType.固定辊台 + " : 固定辊台"); CBtype.Items.Add(DeviceType.摆渡车 + " : 摆渡车"); CBtype.Items.Add(DeviceType.运输车 + " : 运输车"); CBtype.Items.Add(DeviceType.行车 + " : 行车"); CBtype.Items.Add(DeviceType.包装线辊台 + " : 包装线辊台"); CBtype.SelectedIndex = 0; // 设备区域 CBarea.Items.Add(_area); CBarea.SelectedIndex = 0; String sql = "select distinct AREA from wcs_config_area"; DataTable dt = CommonSQL.mysql.SelectAll(sql); if (CommonSQL.IsNoData(dt)) { return; } List <WCS_CONFIG_AREA> areaList = dt.ToDataList <WCS_CONFIG_AREA>(); foreach (WCS_CONFIG_AREA area in areaList) { CBarea.Items.Add(area.AREA); } // 设备属性 CBflag.Items.Add(_flag); CBflag.Items.Add("1:仅负责入库/靠近入库口"); CBflag.Items.Add("2:仅负责出库/远离入库口"); CBflag.SelectedIndex = 0; // 工作状态 CBlock.Items.Add(_lock); CBlock.Items.Add("0:空闲"); CBlock.Items.Add("1:锁定"); CBlock.SelectedIndex = 0; // 使用状态 CBuser.Items.Add(_user); CBuser.Items.Add("0:失效"); CBuser.Items.Add("1:可用"); CBuser.SelectedIndex = 0; } catch (Exception e) { Notice.Show(e.Message, "错误", 3, MessageBoxIcon.Error); } }
/// <summary> /// 读取未完成NDC任务信息 /// </summary> public bool ReadUnFinishTask(out List <WCS_NDC_TASK> list) { list = new List <WCS_NDC_TASK>(); string str = "SELECT ID,TASKID,CARRIERID,IKEY,NDCINDEX,LOADSITE,UNLOADSITE,REDIRECTSITE,NDCLOADSITE,NDCUNLOADSITE," + "NDCREDIRECTSITE,CREATETIME FROM WCS_NDC_TASK WHERE FINISH = '{0}'"; string sql = string.Format(@str, No); DataTable dt = mysql.SelectAll(sql); if (CommonSQL.IsNoData(dt)) { return(false); } list = dt.ToDataList <WCS_NDC_TASK>(); return(true); }
/// <summary> /// 读取WCS与NDC位置对应关系 /// </summary> public void ReadWcsNdcSite(out Dictionary <string, string> loadsite, out Dictionary <string, string> unloadsite) { loadsite = new Dictionary <string, string>(); unloadsite = new Dictionary <string, string>(); DataTable dt = mysql.SelectAll("SELECT TYPE,WCSSITE,NDCSITE FROM WCS_NDC_SITE"); if (CommonSQL.IsNoData(dt)) { return; } List <WCS_NDC_SITE> list = dt.ToDataList <WCS_NDC_SITE>(); foreach (WCS_NDC_SITE site in list) { if (site.TYPE.Equals("loadsite")) { loadsite.Add(site.WCSSITE, site.NDCSITE); } else { unloadsite.Add(site.WCSSITE, site.NDCSITE); } } }
private void BtnExport_Click(object sender, EventArgs e) { //打开文件对话框 System.Windows.Forms.OpenFileDialog fd = new System.Windows.Forms.OpenFileDialog { //过滤exl文件 Filter = @"Excel文件 (*.xls; *.xlsx)|*.xls; *.xlsx|All Files (*.*)|*.*" }; if (fd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string fileName = fd.FileName;//文件名 try { // Excel --> DataTable _Data = new DataTable(); _Data = CommonSQL.GetExcelData(fileName); if (CommonSQL.IsNoData(_Data)) { Notice.Show("空数据!", "错误", 3, Panuon.UI.Silver.MessageBoxIcon.Error); } // 清空数据 DGloc.ItemsSource = null; // 获取数据 DGloc.ItemsSource = _Data.DefaultView; // 保存按钮 BtnInsertDB.IsEnabled = true; } catch (Exception ex) { Notice.Show(ex.Message, "错误", 3, Panuon.UI.Silver.MessageBoxIcon.Error); } } }