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);
}
}
}
