public static bool GetShopDocData(ComboBoxEx Op1Combobox, out Dictionary <DB_TEMain, IList <Com_ShopDoc> > DicShopDocData)
{
DicShopDocData = new Dictionary <DB_TEMain, IList <Com_ShopDoc> >();
try
{
for (int i = 0; i < OutputForm.TEPanel.Rows.Count; i++)
{
if (((bool)OutputForm.TEPanel.GetCell(i, 0).Value) == false || OutputForm.TEPanel.GetCell(i, 1).Value.ToString() != "ShopDoc")
{
continue;
}
Sys_TEExcel teExcelSrNo = session.QueryOver <Sys_TEExcel>()
.Where(x => x.teExcelType == OutputForm.TEPanel.GetCell(i, 1).Value.ToString())
.SingleOrDefault <Sys_TEExcel>();
if (teExcelSrNo == null)
{
continue;
}
Com_TEMain comTEMain = session.QueryOver <Com_TEMain>()
.Where(x => x.comPartOperation == (Com_PartOperation)Op1Combobox.SelectedItem)
.Where(x => x.sysTEExcel == teExcelSrNo)
.Where(x => x.ncGroupName == OutputForm.TEPanel.GetCell(i, 2).Value.ToString())
.SingleOrDefault <Com_TEMain>();
DB_TEMain sDB_TEMain = new DB_TEMain();
IList <Com_ShopDoc> comDimension = session.QueryOver <Com_ShopDoc>()
.Where(x => x.comTEMain == comTEMain)
.List <Com_ShopDoc>();
sDB_TEMain.comTEMain = comTEMain;
sDB_TEMain.excelTemplateFilePath = string.Format(@"{0}\{1}\{2}\{3}\{4}.xls"
, OutputForm.EnvVariables.env
, "TE_Config"
, "Config"
, OutputForm.TEPanel.GetCell(i, 1).Value.ToString()
, OutputForm.TEPanel.GetCell(i, 3).Value.ToString());
sDB_TEMain.ncGroupName = comTEMain.ncGroupName;
sDB_TEMain.factory = OutputForm.TEPanel.GetCell(i, 3).Value.ToString();
sDB_TEMain.partDesc = (session.QueryOver <Com_PEMain>()
.Where(x => x.peSrNo == ((Com_PartOperation)Op1Combobox.SelectedItem).comPEMain.peSrNo)
.SingleOrDefault <Com_PEMain>()).partDes;
DicShopDocData.Add(sDB_TEMain, comDimension);
//sDB_TEMain.comTEMain = comTEMain;
//sDB_TEMain.excelTemplateFilePath = string.Format(@"{0}\{1}.xls", OutputForm.serverTEConfig, OutputForm.TEPanel.GetCell(i, 3).Value.ToString());
//sDB_TEMain.factory = OutputForm.TEPanel.GetCell(i, 3).Value.ToString();
//DicShopDocData.Add(sDB_TEMain, comDimension);
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
return(true);
}
public static bool SetTEPanelData(Com_PartOperation comPartOperation, string cus, string partNo, string cusVer, string opVer, string op1, ref GridPanel TEPanel)
{
try
{
List <string> ExcelData = new List <string>();
GridComboBoxExEditControl singleCell;
IList <Com_TEMain> comTEMain = session.QueryOver <Com_TEMain>()
.Where(x => x.comPartOperation == comPartOperation).List <Com_TEMain>();
int TECount = -1;
foreach (Com_TEMain i in comTEMain)
{
#region 由teExcelSrNo取得對應的ExcelType
Sys_TEExcel sysTEExcel = session.QueryOver <Sys_TEExcel>()
.Where(x => x.teExcelSrNo == i.sysTEExcel.teExcelSrNo).SingleOrDefault <Sys_TEExcel>();
ExcelData = new List <string>();
status = GetExcelForm.GetTEExcelForm(sysTEExcel.teExcelType, out ExcelData);
if (!status)
{
return(false);
}
#endregion
#region 插入Panel
TECount++;
object[] o = new object[] { false, sysTEExcel.teExcelType, i.ncGroupName, ""
, string.Format("{0}_{1}_{2}資料夾"
, partNo
, cusVer
, opVer) };
TEPanel.Rows.Add(new GridRow(o));
TEPanel.GetCell(TECount, 0).Value = false;
TEPanel.GetCell(TECount, 3).EditorType = typeof(GridComboBoxExEditControl);
singleCell = TEPanel.GetCell(TECount, 3).EditControl as GridComboBoxExEditControl;
//singleCell.Items.Add("");
foreach (string tempStr in ExcelData)
{
singleCell.Items.Add(tempStr);
}
if (singleCell.Items.Count == 1)
{
TEPanel.GetCell(TECount, 3).Value = singleCell.Items[0].ToString();
}
else
{
TEPanel.GetCell(TECount, 3).Value = "(雙擊)選擇表單";
}
#endregion
}
#region 取得ToolList的表單格式
ExcelData = new List <string>();
status = GetExcelForm.GetTEExcelForm("ToolList", out ExcelData);
if (!status)
{
return(false);
}
#endregion
foreach (Com_TEMain i in comTEMain)
{
#region 找ToolList資料，並插入Panel
IList <Com_ToolList> comToolList = session.QueryOver <Com_ToolList>().Where(x => x.comTEMain == i).List();
if (comToolList.Count == 0)
{
continue;
}
else
{
TECount++;
object[] o = new object[] { false, "ToolList", i.ncGroupName, ""
, string.Format("{0}_{1}_{2}資料夾"
, partNo
, cusVer
, opVer) };
TEPanel.Rows.Add(new GridRow(o));
TEPanel.GetCell(TECount, 0).Value = false;
TEPanel.GetCell(TECount, 3).EditorType = typeof(GridComboBoxExEditControl);
singleCell = TEPanel.GetCell(TECount, 3).EditControl as GridComboBoxExEditControl;
//singleCell.Items.Add("");
foreach (string tempStr in ExcelData)
{
singleCell.Items.Add(tempStr);
}
if (singleCell.Items.Count == 1)
{
TEPanel.GetCell(TECount, 3).Value = singleCell.Items[0].ToString();
}
else
{
TEPanel.GetCell(TECount, 3).Value = "(雙擊)選擇表單";
}
}
#endregion
}
#region 找NC資料夾，並插入Panel
string CAMFolderPath = string.Format(@"{0}\{1}\{2}\{3}\{4}\{5}\{6}", OutputForm.EnvVariables.env_Task, cus, partNo, cusVer, opVer, "OP" + op1, "CAM");
//string CAMFolderPath = string.Format(@"{0}\{1}\{2}\{3}\{4}\{5}\{6}", CaxEnv.GetGlobaltekEnvDir() + "\\Task", cus, partNo, cusVer, opVer, "OP" + op1, "CAM");
string[] NCFolder = Directory.GetDirectories(CAMFolderPath);
foreach (string item in NCFolder)
{
if (!item.Contains("NC"))
{
continue;
}
TECount++;
object[] o = new object[] { false, "NC程式", Path.GetFileNameWithoutExtension(item), ""
, string.Format("{0}_{1}_{2}資料夾"
, partNo
, cusVer
, opVer) };
TEPanel.Rows.Add(new GridRow(o));
}
#endregion
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
return(true);
}