コード例 #1
0
ファイル: StaticXML.cs プロジェクト: nacss/main
        /// <summary>
        /// Zapis danych do pliku XML.
        /// </summary>
        /// <param name="path">Adres pliku do odczytu.</param>
        /// <param name="cCollection">Argument zawieraj¹cy kolekcjê odczytów.</param>
        /// <param name="SaveFile">Okreœla poprawnoœæ zapisu danych.</param>
        public static void WriteToXml(string path, CountersCollection cCollection, out bool SaveFile)
        {
            try
            {
                System.Xml.Serialization.XmlSerializer writer =
                        new System.Xml.Serialization.XmlSerializer(typeof(CountersCollection));

                System.IO.StreamWriter file = new System.IO.StreamWriter(path);
                writer.Serialize(file, cCollection);
                file.Close();
                SaveFile = false;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                SaveFile = true;
            }
        }
コード例 #2
0
ファイル: StaticXML.cs プロジェクト: nacss/main
        /// <summary>
        /// Wczytywanie rekordów z pliku XML.
        /// </summary>
        /// <param name="path">Adres pliku do odczytu.</param>
        /// <param name="cCollection">Argument wejœciowo/wyjœciowy zawieraj¹cy kolekcjê odczytów.</param>
        /// <param name="toDataBase">Argument informuj¹cy o koniecznoœci zapisu danych do bazy.</param>
        public static void ReadFromXml(string path, bool toDataBase, out CountersCollection cCollection)
        {
            cCollection = null;
            try
            {
                XmlSerializer serializer = new XmlSerializer(typeof(CountersCollection));

                StreamReader reader = new StreamReader(path);
                cCollection = (CountersCollection)serializer.Deserialize(reader);
                reader.Close();
                if (cCollection != null && toDataBase)
                    cCollection.AddNewElementsToDataBase();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
コード例 #3
0
ファイル: CheckCounters.cs プロジェクト: rafaliusz/main
        /// <summary>
        /// Metoda inicjalizująca wyświetlanie listy rekordów.
        /// </summary>
        public void InitializeForm()
        {
            listViewC = new ListView();
            cCollection = new CountersCollection();
            cCollection.collectorId = this.collectorId;
            int i = 1;

            using (var dataBase = new CollectorsManagementSystemEntities())
            {
                var items = from collector in dataBase.Collectors
                            join area in dataBase.Areas on collector.CollectorId equals area.CollectorId
                            join address in dataBase.Addresses on area.AreaId equals address.AreaId
                            join counter in dataBase.Counters on address.AddressId equals counter.AddressId
                            where collector.CollectorId == this.collectorId
                            select new
                            {
                                CounterNo = counter.CounterNo,
                                CircuitNo = counter.CircuitNo,
                                CounterAddress = area.Street + " " + address.HouseNo + "/" + address.FlatNo,
                                CustomerId = counter.CustomerId
                            };

                foreach (var element in items)
                {
                    var dateSub = DateTime.Now.Subtract(new TimeSpan(30, 0, 0, 0));

                    var firstMethod = from read in dataBase.Readings
                                      where read.Date > dateSub
                                      where read.CounterNo == element.CounterNo
                                      select read;

                    if (firstMethod.Count() == 0)
                    {

                        string date, value, collectorId, collectorName, customerName;

                        date = value = collectorName = String.Empty;

                        var lastReading = from read in dataBase.Readings
                                          where read.CounterNo == element.CounterNo
                                          select read;

                        if (lastReading.Count() > 0)
                        {
                            var lastRead = lastReading.OrderByDescending(x => x.Date).FirstOrDefault();

                            date = lastRead.Date.ToShortDateString() ?? String.Empty;
                            value = lastRead.Value.ToString() ?? String.Empty;
                            collectorId = lastRead.CollectorId ?? String.Empty;

                            try
                            {
                                var collectorRead = (from collector in dataBase.Collectors
                                                     where collector.CollectorId == collectorId
                                                     select new { collector.Name, collector.LastName }).FirstOrDefault();

                                collectorName = collectorId + " " + collectorRead.Name + " " + collectorRead.LastName;
                            }
                            catch
                            {
                                collectorName = "---";
                            }
                        }
                        else
                            date = value = collectorName = String.Empty;

                        var cutomerRead = (from customer in dataBase.Customers
                                           where element.CustomerId == customer.CustomerId
                                           select new { customer.Name, customer.LastName }).FirstOrDefault();

                        if (cutomerRead != null)
                            customerName = cutomerRead.Name + " " + cutomerRead.LastName;
                        else
                            customerName = String.Empty;

                        {
                            CounterXML newItem = new CounterXML();
                            newItem.ReadId = i++.ToString();
                            newItem.CounterNo = element.CounterNo.ToString();
                            newItem.CircuitNo = element.CircuitNo.ToString();
                            newItem.Customer = customerName;
                            newItem.Address = element.CounterAddress;
                            newItem.LastReadDate = date;
                            newItem.LastValue = value;
                            newItem.LastCollector = collectorName;
                            newItem.NewValue = String.Empty;
                            cCollection.AddNewElement(newItem);
                            nrOfCounters++;
                        }
                    }
                }
            }

            listViewC = ListViewConfig.ListViewInit(columnList, this.GetType().Name);

            if ( cCollection.RecordsCount > 0 )
                foreach (var element in cCollection.counter)
                    ListViewConfig.AddItem(listViewC, element.PrintStringArray);

            listViewC.MultiSelect = false;
            listViewC.Size = new System.Drawing.Size(750, 450);
            if (nrOfCounters == 0)
                btExport.Enabled = false;
            this.Controls.Add(listViewC);
        }
コード例 #4
0
ファイル: CheckCounters.cs プロジェクト: rafaliusz/main
        /// <summary>
        /// Export ( wysłanie ) danych do pliku XML.
        /// </summary>
        /// <param name="sender">Obiekt eventu.</param>
        /// <param name="e">Argument eventu.</param>
        private void btExport_Click(object sender, EventArgs e)
        {
            CountersCollection collection = new CountersCollection();
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.InitialDirectory = @"C:\";
            saveFileDialog.DefaultExt = "xml";
            saveFileDialog.Filter = "XML file|*.xml";
            saveFileDialog.FilterIndex = 1;
            saveFileDialog.Title = "Zapisz dane";
            DialogResult check = saveFileDialog.ShowDialog();

            if (saveFileDialog.FileName == String.Empty && check == DialogResult.OK)
                MessageBox.Show(LangPL.CountersWarnings["wrongFileName"]);
            else if (check == DialogResult.OK)
            {
                bool test;
                StaticXML.WriteToXml(saveFileDialog.FileName, cCollection, out test);
            }
        }