form1.cs

用于SIEMENS的WINCC项目数据库读写

                                szState = row["TxtAck"].ToString();
                                break;
                            default:
                                szState = String.Format("0x{0:X}", row["State"]).PadLeft(10);
                                break;

                        }//switch row["State"]
                        newRow["State"] = szState;
                        newRow["Text1"] = row["Text1"];
                        newRow["Text3"] = row["Text3"];
                        newRow["localDateTimeFrom"] = localDateTimeFrom;
                        newRow["localDateTimeTo"] = localDateTimeTo;
                        newRow["univDateTimeFrom"] = univDateTimeFrom;
                        newRow["univDateTimeTo"] = univDateTimeTo;

                        myTableAlarmsModify.Rows.Add(newRow);
  }//foreach(DataRow)

                    myGrid.DataSource = myTableAlarmsModify;
//                    myGrid.DataSource = myTableAlarms;

                    //
                    lblAnz.Text = (myGrid.RowCount - 1).ToString() + " Rows Found ";
                    myConnection.Close();
                    //
                    //   Activating Crystal-Report
                    CRAlarmLogging myDataReportAlarms = new CRAlarmLogging();
                    myDataReportAlarms.SetDataSource(myTableAlarmsModify);
                    crystalReportViewer1.ReportSource = myDataReportAlarms;

                }
                return (myGrid.RowCount);
            }
            catch (Exception ex)
            {
                MessageBox.Show("#E210: ALG_Connect() - Failed connect to the database.\n{0}", ex.Message);
                return (-1);
            }
        }//ALG_Connect()
        
        //==============================================
        /// <get archived Data>
        /// 
        /// <depending on selected Archive: Alarms/Tags>
        /// <creating select-statement, considering fro/to time >
        /// <calling Fuction for access to database>
        /// 
        ///========================================== 
        public void GetData()
        {
            string timeStep = "";
            string mySelectQuery = "";
            int cntData = 0;

            //covert to universal time (utc)
            localDateTimeFrom = dtpFrom.Value;
            localDateTimeFrom = System.DateTime.Parse(localDateTimeFrom.ToString());
            univDateTimeFrom = localDateTimeFrom.ToUniversalTime();
            string tfrom = dtpFrom.Value.Year.ToString() + "-"
                        + string.Format("{0:MM}", univDateTimeFrom.Month.ToString()) + "-"
                        + string.Format("{0:dd}", univDateTimeFrom.Day.ToString()) + " "
                        + string.Format("{0:HH}", univDateTimeFrom.Hour.ToString()) + ":"
                        + string.Format("{0:mm}", univDateTimeFrom.Minute.ToString()) + ":"
                        +string.Format("{0:ss}", univDateTimeFrom.Second.ToString());

            //covert to universal time (utc)
            localDateTimeTo = dtpTo.Value;
            localDateTimeTo = System.DateTime.Parse(localDateTimeTo.ToString());
            univDateTimeTo = localDateTimeTo.ToUniversalTime();
            string tto = dtpTo.Value.Year.ToString() + "-"
                        + string.Format("{0:MM}", univDateTimeTo.Month.ToString()) + "-"
                        + string.Format("{0:dd}", univDateTimeTo.Day.ToString()) + " "
                        + string.Format("{0:HH}", univDateTimeTo.Hour.ToString()) + ":"
                        + string.Format("{0:mm}", univDateTimeTo.Minute.ToString()) + ":"
                        + string.Format("{0:ss}", univDateTimeTo.Second.ToString());
            switch (iArchiveSel)
            {
                case 1://TagLogging
                    if (cmbInterpol.SelectedValue.ToString() != "0")
                    {
                        timeStep = ",'TIMESTEP=" + txtStep.Text + "," + cmbInterpol.SelectedValue.ToString() + "'";
                    }

//                    mySelectQuery = "TAG:R," + cmbTags.SelectedIndex.ToString() + ",'" + tfrom + "','" + tto + "'" + timeStep;
                    mySelectQuery = "TAG:R," + cmbTags.SelectedValue.ToString() + ",'" + tfrom + "','" + tto + "'" + timeStep;
                    try
                    {
                        cntData = TLG_Connect(mySelectQuery);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("#E120: TLG_Connect() - Failed to retrieve the required data from database.\n{0}", ex.Message);
                        return;
                    }
                    break;
                case 2://Alarm Logging
                    mySelectQuery = "ALARMVIEW:SELECT * FROM AlgViewDeu Where DateTime>'" + tfrom + "' AND DateTime<'" + tto + "'";
                    try
                    {
                        cntData = ALG_Connect(mySelectQuery);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("#E220: ALG_Connect() - Failed to retrieve the required data from the database.\n{0}", ex.Message);
                        return;
                    }
                    break;
                case 3://User Archive
                    mySelectQuery = "SELECT iID,szName, iCount, fWeight FROM UA#Products" ;
                    try
                    {
                        cntData = UA_Connect(mySelectQuery);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("#E320: UA_Connect() - Failed to retrieve the required data from the database.\n{0}", ex.Message);
                        return;
                    }
                    break;
                default:
                    MessageBox.Show("#E920:invalid choice (" + iArchiveSel.ToString() + ")!");
                    break;
            }//switch (iArchiveSel)
        }//GetData()
        
        //=========================================
        /// <reading IDs/Names of archived Tags>
        /// 
        /// <access by OleDB of SQL-Server>
        /// <needed for the choise of archived Tag>
        //=========================================
        private void btnTags_Click(object sender, EventArgs e)
        {
                        TLG_Archive();
        }

        private void lblFro_Click(object sender, EventArgs e)
        {

        }

        private void lblCatalog_Click(object sender, EventArgs e)
        {

        }

        private void toolStripLblAlarms_Click(object sender, EventArgs e)
        {

        }

        private void lblCatalog_Click_1(object sender, EventArgs e)
        {

        }
  

        private void btnRead_Click(object sender, EventArgs e)
        {
            btnRead.UseWaitCursor = true;
            GetData();
            btnRead.UseWaitCursor = false;
        }

        private void dtpFrom_ValueChanged(object sender, EventArgs e)
        {

        }

        private void cmbTags_SelectedIndexChanged(object sender, EventArgs e)
        {
            //using trim() inorder to remove whitespaces!!
            //replace() in order to replace '\' by '#'; '\' is not a valid character in filename
            szValueName = cmbTags.Text.Trim().Replace('\\', '#');
            txtExportFile.Text = szValueName + ".txt";  
            //ermitteln der aktuellen ValueID
            TLG_ArchiveGetID(cmbTags.Text.Trim());           
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void label1_Click_1(object sender, EventArgs e)
        {

        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {

        }

        private void label2_Click(object sender, EventArgs e)
        {

        }
        private void toolStripLblAlarmLogging_Click(object sender, EventArgs e)
        {
            // selection archive type; 1=Tag Logging, 2=Alarm Logging, 3 User Archives
            iArchiveSel = 2;
            ChangeComponent();
        }

        private void toolStripLblTagLogging_Click(object sender, EventArgs e)
        {
            // selection archive type; 1=Tag Logging, 2=Alarm Logging, 3 User Archives
            iArchiveSel = 1;
            ChangeComponent();
        }

        private void toolStripLblUserArchives_Click(object sender, EventArgs e)
        {
            // selection archive type; 1=Tag Logging, 2=Alarm Logging, 3 User Archives
            iArchiveSel = 3;
            ChangeComponent();
        }

        private void grpConnection_Enter(object sender, EventArgs e)
        {

        }

        private void myGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void crystalReportViewer1_Load(object sender, EventArgs e)
        {

        }

        private void grpDataSelection_Enter(object sender, EventArgs e)
        {

        }

        private void groupBox1_Enter(object sender, EventArgs e)
        {

        }

        private void label3_Click(object sender, EventArgs e)
        {

        }

        private void label3_Click_1(object sender, EventArgs e)
        {

        }
    }
}