public void RefreshList(string dataCata)
{
try
{
switch (dataCata)
{
case "产品高度字典":
{
DataTable dt = heightDefBll.GetAllList().Tables[0];
view.DispHeightDeflist(dt);
break;
}
case "产品包装尺寸字典":
{
DataTable dt = packsizeDefBll.GetAllList().Tables[0];
view.DispPacksizeDeflist(dt);
break;
}
case "产品型号配置":
{
DataTable dt = productCfgBll.GetAllList().Tables[0];
view.DispProductCfgList(dt);
break;
}
}
}
catch (Exception ex)
{
view.ShowPopupMes(ex.ToString());
}
}
private void toolStripButtonExport_Click(object sender, EventArgs e)
{
DataTable dt = productCfgBll.GetAllList().Tables[0];
Dictionary <string, string> dicColnames = new Dictionary <string, string>();
dicColnames["productCataCode"] = "物料码";
dicColnames["productName"] = "型号名称";
dicColnames["cataSeq"] = "物料编号";
dicColnames["packageSize"] = "包装尺寸";// + "." + dr.ItemArray[4].ToString()
// dicColnames["productHeight"] = "产品高度";
dicColnames["robotProg"] = "机器人配方编号";
// dicColnames["volt1"] = @"强档电压";
// dicColnames["volt2"] = "弱档电压";
// dicColnames["frequency1"] = "频率";
dicColnames["power1"] = "合格功率";
dicColnames["mark"] = "备注";
List <string> exportCols = new List <string>();
foreach (DataColumn dc in dt.Columns)
{
if (dicColnames.Keys.Contains(dc.ColumnName))
{
dc.ColumnName = dicColnames[dc.ColumnName];
exportCols.Add(dc.ColumnName);
}
}
ExportDtToExcel(dt, exportCols, "烟机线型号数据");
}
private void toolStripButtonExport_Click(object sender, EventArgs e)
{
DataTable dt = productCfgBll.GetAllList().Tables[0];
dt.Columns["productCataCode"].ColumnName = "物料码";
dt.Columns["cataSeq"].ColumnName = "物料编号";
dt.Columns["productName"].ColumnName = "型号名称";
dt.Columns["gasName"].ColumnName = "气源类型";
dt.Columns["productHeight"].ColumnName = "产品高度";
dt.Columns["packageSize"].ColumnName = "包装尺寸";
dt.Columns["baseSizeLevel"].ColumnName = "大小底盘";
dt.Columns["tag1"].ColumnName = "下线配方编号";
dt.Columns["facePanelSize"].ColumnName = "面板宽";
dt.Columns["mark"].ColumnName = "备注";
dt.Columns.Remove("tag2");
dt.Columns.Remove("tag3");
dt.Columns.Remove("tag4");
dt.Columns.Remove("tag5");
ExportDtToExcel(dt, "灶具二线产品数据表(新条码)");
}
private void toolStripButtonExport_Click(object sender, EventArgs e)
{
DataTable dt = productCfgBll.GetAllList().Tables[0];
ExportDtToExcel(dt, "灶具二线产品数据表(新条码)");
}