コード例 #1
0
        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);
        }
コード例 #2
0
        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);
        }