コード例 #1
1
        private void UC_PlcDataState_Load(object sender, EventArgs e)
        {
            //다른 쓰레드에서 윈폼 컨트롤 사용가능 (비동기 작업에서 사용)
            //Control.CheckForIllegalCrossThreadCalls = false;

            if (!Directory.Exists(MyApp.RootRef))
            {
                Directory.CreateDirectory(MyApp.RootRef);
            }
            if (File.Exists(_PLCRefPath))
            {
                try
                {
                    int    iArrcnt = 0;
                    string Connstr = MyApp.RootMDB(_PLCRefPath);
                    using (OleDbConnection connDB = new OleDbConnection(Connstr))
                    {
                        connDB.Open();
                        foreach (string tbName in Share.GetMDBTable(connDB))
                        {
                            string sql = $"Select *from {tbName} " + "Order by PlcName ASC,BlockNum ASC,IndexNo ASC";

                            Array.Resize(ref tabPage, iArrcnt + 1);
                            Array.Resize(ref Uc_dgv, iArrcnt + 1);

                            tabPage[iArrcnt] = new TabPage();
                            AddTabpage(tbName, iArrcnt);

                            Uc_dgv[iArrcnt] = new UC_DGV();
                            AddDGV(iArrcnt);

                            using (DataSet dsData = new DataSet())
                            {
                                OleDbDataAdapter oledbAdapter = new OleDbDataAdapter(sql, connDB);
                                oledbAdapter.Fill(dsData);

                                //.DoubleBuffered(True)
                                Stopwatch Tchk = new Stopwatch();
                                Tchk.Start();

                                Uc_dgv[iArrcnt].DGVPlc.DataSource = dsData.Tables[0];
                                DataGridViewTextBoxColumn addrCol = new DataGridViewTextBoxColumn();

                                addrCol.Name       = "PLCVal";
                                addrCol.HeaderText = "PLCVal";

                                Uc_dgv[iArrcnt].DGVPlc.Columns.Add(addrCol);

                                Tchk.Stop();
                                Debug.Print(Tchk.Elapsed.ToString());

                                //DetailsView.Dispose();
                                oledbAdapter.Dispose();
                                oledbAdapter = null;

                                for (int i = 0; i < Uc_dgv[iArrcnt].DGVPlc.Columns.Count; i++)
                                {
                                    Uc_dgv[iArrcnt].DGVPlc.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
                                }
                            }
                            Uc_dgv[iArrcnt].DGVPlc.DoubleBuffered();
                            iArrcnt++;
                        }
                        connDB.Close();
                        connDB.Dispose();
                    }
                }
                catch (Exception ex)
                {
                    StackTrace trace      = new StackTrace(ex, true);
                    StackFrame stackFrame = trace.GetFrame(trace.FrameCount - 1);
                    int        lineNumber = stackFrame.GetFileLineNumber();

                    I_Sub.ErrorLog(($"({lineNumber}) : {ex.ToString()}"));
                }
            }
        }
コード例 #2
0
        private void BindingPLCRefFile()
        {
            string sql;

            if (File.Exists(gs_PLCRefPath))
            {
                connDB = new OleDbConnection(Connstr);
                connDB.Open();
                int iArrcnt = 0;
                foreach (string tbName in Share.GetMDBTable(connDB))
                {
                    sql = $"Select *from {tbName} " + "Order by PlcName ASC,BlockNum ASC,IndexNo ASC";
                    try
                    {
                        Array.Resize(ref tabPage, iArrcnt + 1);
                        Array.Resize(ref Uc_dgv, iArrcnt + 1);
                        Array.Resize(ref oledbAdapter, iArrcnt + 1);

                        tabPage[iArrcnt] = new TabPage();
                        AddTabpage(tbName, iArrcnt);

                        Uc_dgv[iArrcnt] = new UC_DGV();
                        AddDGV(iArrcnt);

                        oledbAdapter[iArrcnt] = new OleDbDataAdapter(sql, connDB);
                        oledbAdapter[iArrcnt].Fill(dsData, tbName);

                        //dsData.(strFolerPath & "\PLCAddress.mdb")
                        DataTableCollection tables      = dsData.Tables;
                        DataView            DetailsView = new DataView(tables[tbName]);

                        //DataGridView1.AutoGenerateColumns = False
                        Uc_dgv[iArrcnt].DGVPlc.DataSource = DetailsView;
                        iArrcnt++;
                    }
                    catch (Exception ex)
                    {
                        StackTrace trace      = new StackTrace(ex, true);
                        StackFrame stackFrame = trace.GetFrame(trace.FrameCount - 1);
                        int        lineNumber = stackFrame.GetFileLineNumber();

                        frm.ErrorLog(($"({lineNumber}) : {ex.ToString()}"));
                    }
                }
            }
        }