Ejemplo n.º 1
0
        // Update Plug base information by PlugID
        public static bool UpdatePlugBasicInfoByPlugID(PlugDevice plugdev, string dbPath)
        {
            try
            {
                using (SQLiteConnection conn = new SQLiteConnection("Data Source=" + dbPath + ";"))
                {
                    conn.Open();
                    SQLiteCommand cmd = conn.CreateCommand();
                    cmd.CommandText = @"UPDATE PlugList set PlugName=@PlugName1, PlugMac=@PlugMac1, UserCode=@UserCode1, Voltage=@Voltage1, Power=@Power1, DayBudget=@DayBudget1, 
                                        Description=@Description1 where PlugID=@PlugID1;";
                    cmd.Parameters.Add(new SQLiteParameter("PlugID1", plugdev.PlugID));
                    cmd.Parameters.Add(new SQLiteParameter("PlugName1", plugdev.PlugName));
                    cmd.Parameters.Add(new SQLiteParameter("PlugMac1", plugdev.PlugMac));
                    cmd.Parameters.Add(new SQLiteParameter("UserCode1", plugdev.UserCode));
                    cmd.Parameters.Add(new SQLiteParameter("Voltage1", plugdev.Voltage));
                    cmd.Parameters.Add(new SQLiteParameter("Power1", plugdev.Power));
                    cmd.Parameters.Add(new SQLiteParameter("DayBudget1", plugdev.DayBudget));
                    cmd.Parameters.Add(new SQLiteParameter("Description1", plugdev.Description));

                    int i = cmd.ExecuteNonQuery();
                    return(i == 1);
                }
            }
            catch (ArgumentException ae)
            {
                MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace);
                return(false);
            }
            catch (Exception ex)
            {
                //Do any logging operation here if necessary
                MessageBox.Show(ex.Message);
                return(false);
            }
        }
Ejemplo n.º 2
0
        private void btnUpdateSche_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (NightBudgetTextBox.Text == "" || MorningBudgetTextBox.Text == "" || AfternoonBudgetTextBox.Text == "" || EveningBudgetTextBox.Text == "")
                {
                    MessageBox.Show("请输入预算使用的电能量!", "提示", MessageBoxButton.OK);
                    return;
                }
                int selectindex = DeviceScheList.SelectedIndex;

                if (selectindex != -1)
                {
                    PlugDevice plugdev = new PlugDevice();
                    plugdev.PlugID          = Convert.ToInt64(PlugDeviceTable.Rows[selectindex]["PlugID"]);
                    plugdev.NightBudget     = Convert.ToSingle(NightBudgetTextBox.Text);
                    plugdev.MorningBudget   = Convert.ToSingle(MorningBudgetTextBox.Text);
                    plugdev.AfternoonBudget = Convert.ToSingle(AfternoonBudgetTextBox.Text);
                    plugdev.EveningBudget   = Convert.ToSingle(AfternoonBudgetTextBox.Text);
                    plugdev.NightSaving     = NightSavingSwitch.IsChecked;
                    plugdev.MorningSaving   = MorningSavingSwitch.IsChecked;
                    plugdev.AfternoonSaving = AfternoonSavingSwitch.IsChecked;
                    plugdev.EveningSaving   = EveningSavingSwitch.IsChecked;

                    bool success = SmartPlugDAL.UpdatePlugScheduleInfoByPlugID(plugdev, SqliteDBPath);
                    if (success == true)
                    {
                        PlugDeviceTable    = SmartPlugDAL.GetAllPlugDevice(SqliteDBPath, ref success);
                        BudgettedEnergy[0] = Convert.ToSingle(NightBudgetTextBox.Text);
                        BudgettedEnergy[1] = Convert.ToSingle(MorningBudgetTextBox.Text);
                        BudgettedEnergy[2] = Convert.ToSingle(AfternoonBudgetTextBox.Text);
                        BudgettedEnergy[3] = Convert.ToSingle(EveningBudgetTextBox.Text);
                        UpdateBudgettedUsedChart();
                        MessageBox.Show("更新成功!", "提示", MessageBoxButton.OK);
                    }
                    else
                    {
                        MessageBox.Show("无法更新,请检查设置!", "提示", MessageBoxButton.OK);
                    }
                }
            }
            catch (ArgumentException ae)
            {
                MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace);
            }
            catch (Exception ex)
            {
                //Do any logging operation here if necessary
                throw new Exception(ex.Message);
            }
        }
Ejemplo n.º 3
0
        // Get Plug by PlugID
        public static PlugDevice GetPlugDeviceByPlugID(Int64 plugid, string dbPath)
        {
            try
            {
                using (SQLiteConnection conn = new SQLiteConnection("Data Source=" + dbPath + ";"))
                {
                    conn.Open();
                    SQLiteCommand cmd = conn.CreateCommand();
                    cmd.CommandText = "select * from PlugList where PlugID=@PlugID;";
                    cmd.Parameters.Add(new SQLiteParameter("PlugID", plugid));
                    SQLiteDataReader dr = cmd.ExecuteReader();
                    if (dr.Read())
                    {
                        PlugDevice plugdev = new PlugDevice();
                        plugdev.PlugID          = dr.GetInt64(0);
                        plugdev.PlugName        = dr.GetString(1);
                        plugdev.PlugMac         = dr.GetString(2);
                        plugdev.UserCode        = (UInt16)dr.GetInt32(3);
                        plugdev.Voltage         = dr.GetFloat(4);
                        plugdev.Power           = dr.GetFloat(5);
                        plugdev.DayBudget       = dr.GetFloat(6);
                        plugdev.NightBudget     = dr.GetFloat(7);
                        plugdev.MorningBudget   = dr.GetFloat(8);
                        plugdev.AfternoonBudget = dr.GetFloat(9);
                        plugdev.EveningBudget   = dr.GetFloat(10);
                        plugdev.NightSaving     = dr.GetBoolean(11);
                        plugdev.MorningSaving   = dr.GetBoolean(12);
                        plugdev.AfternoonSaving = dr.GetBoolean(13);
                        plugdev.EveningSaving   = dr.GetBoolean(14);
                        plugdev.Description     = dr.GetString(15);
                        plugdev.CreateDateTime  = dr.GetDateTime(16);

                        return(plugdev);
                    }
                    else
                    {
                        return(null);
                    }
                }
            }
            catch (ArgumentException ae)
            {
                MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace);
                return(null);
            }
            catch (Exception ex)
            {
                //Do any logging operation here if necessary
                throw new Exception(ex.Message);
            }
        }
Ejemplo n.º 4
0
        // Add Plug to DataBase
        public static bool AddPlugDevice(PlugDevice plugdev, string dbPath)
        {
            try
            {
                SQLiteConnection conn = new SQLiteConnection("Data Source=" + dbPath + ";");
                conn.Open();
                SQLiteCommand cmd = conn.CreateCommand();
                cmd.CommandText = @"INSERT INTO PlugList(PlugID, PlugName, PlugMac, UserCode, Voltage, Power, DayBudget, NightBudget, MorningBudget, AfternoonBudget, EveningBudget,
                                     NightSaving, MorningSaving, AfternoonSaving, EveningSaving, Description, CreateDateTime) 
                                     VALUES(@PlugID1, @PlugName1, @PlugMac1, @UserCode1, @Voltage1, @Power1, @DayBudget1, @NightBudget1, @MorningBudget1, @AfternoonBudget1, @EveningBudget1, 
                                     @NightSaving1, @MorningSaving1, @AfternoonSaving1, @EveningSaving1, @Description1, @CreateDateTime1)";

                cmd.Parameters.Add(new SQLiteParameter("PlugID1", plugdev.PlugID));
                cmd.Parameters.Add(new SQLiteParameter("PlugName1", plugdev.PlugName));
                cmd.Parameters.Add(new SQLiteParameter("PlugMac1", plugdev.PlugMac));
                cmd.Parameters.Add(new SQLiteParameter("UserCode1", plugdev.UserCode));
                cmd.Parameters.Add(new SQLiteParameter("Voltage1", plugdev.Voltage));
                cmd.Parameters.Add(new SQLiteParameter("Power1", plugdev.Power));
                cmd.Parameters.Add(new SQLiteParameter("DayBudget1", plugdev.DayBudget));
                cmd.Parameters.Add(new SQLiteParameter("NightBudget1", plugdev.NightBudget));
                cmd.Parameters.Add(new SQLiteParameter("MorningBudget1", plugdev.MorningBudget));
                cmd.Parameters.Add(new SQLiteParameter("AfternoonBudget1", plugdev.AfternoonBudget));
                cmd.Parameters.Add(new SQLiteParameter("EveningBudget1", plugdev.EveningBudget));
                cmd.Parameters.Add(new SQLiteParameter("NightSaving1", plugdev.NightSaving));
                cmd.Parameters.Add(new SQLiteParameter("MorningSaving1", plugdev.MorningSaving));
                cmd.Parameters.Add(new SQLiteParameter("AfternoonSaving1", plugdev.AfternoonSaving));
                cmd.Parameters.Add(new SQLiteParameter("EveningSaving1", plugdev.EveningSaving));
                cmd.Parameters.Add(new SQLiteParameter("Description1", plugdev.Description));
                cmd.Parameters.Add(new SQLiteParameter("CreateDateTime1", plugdev.CreateDateTime));

                int i = cmd.ExecuteNonQuery();
                return(i == 1);
            }
            catch (SQLiteException se)
            {
                MessageBox.Show(se.Message + " \n\n" + se.Source + "\n\n" + se.StackTrace + "\n\n" + se.Data);
                return(false);
            }
            catch (ArgumentException ae)
            {
                MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace + "\n\n" + ae.Data);
                return(false);
            }
            catch (Exception ex)
            {
                //Do any logging operation here if necessary
                MessageBox.Show(ex.Message + "\n\n" + ex.Source + "\n\n" + ex.StackTrace + "\n\n" + ex.Data);
                return(false);
            }
        }
Ejemplo n.º 5
0
        //更新插座表
        private void btnUpdateDev_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (Add_IDTextBox.Text != "")
                {
                    PlugDevice plugdev = new PlugDevice();
                    plugdev.PlugID      = Convert.ToInt64(Add_IDTextBox.Text);
                    plugdev.PlugName    = Add_NameTextBox.Text;
                    plugdev.PlugMac     = Add_MACTextBox.Text;
                    plugdev.UserCode    = (UInt16)(256 * Convert.ToUInt16(Add_UserCodeTextBox1.Text) + Convert.ToUInt16(Add_UserCodeTextBox2.Text));
                    plugdev.Voltage     = Convert.ToSingle(Add_VoltageTextBox.Text);
                    plugdev.Power       = Convert.ToSingle(Add_PowerTextBox.Text);
                    plugdev.DayBudget   = Convert.ToSingle(Add_BudgettedEnergyTextBox.Text);
                    plugdev.Description = Add_DescriptionTextBox.Text;

                    bool success = SmartPlugDAL.UpdatePlugBasicInfoByPlugID(plugdev, SqliteDBPath);

                    if (success == true)
                    {
                        RefreshPlugInfo();
                        MessageBox.Show("更新成功!", "提示", MessageBoxButton.OK);
                    }
                    else
                    {
                        MessageBox.Show("更新失败,请检查设置!", "提示", MessageBoxButton.OK);
                    }
                }
            }
            catch (ArgumentException ae)
            {
                MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace);
            }
            catch (Exception ex)
            {
                //Do any logging operation here if necessary
                throw new Exception(ex.Message);
            }
        }
Ejemplo n.º 6
0
        // Update Plug Schedule infor by PlugID
        public static bool UpdatePlugScheduleInfoByPlugID(PlugDevice plugdev, string dbPath)
        {
            try
            {
                using (SQLiteConnection conn = new SQLiteConnection("Data Source=" + dbPath + ";"))
                {
                    conn.Open();
                    SQLiteCommand cmd = conn.CreateCommand();
                    cmd.CommandText = @"UPDATE PlugList set NightBudget=@NightBudget1, MorningBudget=@MorningBudget1, AfternoonBudget=@AfternoonBudget1, EveningBudget=@EveningBudget1, 
                                        NightSaving=@NightSaving1, MorningSaving=@MorningSaving1, AfternoonSaving=@AfternoonSaving1, EveningSaving=@EveningSaving1 where PlugID=@PlugID1;";

                    cmd.Parameters.Add(new SQLiteParameter("PlugID1", plugdev.PlugID));
                    cmd.Parameters.Add(new SQLiteParameter("NightBudget1", plugdev.NightBudget));
                    cmd.Parameters.Add(new SQLiteParameter("MorningBudget1", plugdev.MorningBudget));
                    cmd.Parameters.Add(new SQLiteParameter("AfternoonBudget1", plugdev.AfternoonBudget));
                    cmd.Parameters.Add(new SQLiteParameter("EveningBudget1", plugdev.EveningBudget));
                    cmd.Parameters.Add(new SQLiteParameter("NightSaving1", plugdev.NightSaving));
                    cmd.Parameters.Add(new SQLiteParameter("MorningSaving1", plugdev.MorningSaving));
                    cmd.Parameters.Add(new SQLiteParameter("AfternoonSaving1", plugdev.AfternoonSaving));
                    cmd.Parameters.Add(new SQLiteParameter("EveningSaving1", plugdev.EveningSaving));

                    int i = cmd.ExecuteNonQuery();
                    return(i == 1);
                }
            }
            catch (ArgumentException ae)
            {
                MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace);
                return(false);
            }
            catch (Exception ex)
            {
                //Do any logging operation here if necessary
                MessageBox.Show(ex.Message);
                return(false);
            }
        }
Ejemplo n.º 7
0
        //添加插座
        private void btnAddDev_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (Add_NameTextBox.Text == "")
                {
                    MessageBox.Show("建议不要将名称设置为空!", "提示", MessageBoxButton.OK);
                }
                if (Add_IDTextBox.Text == "")
                {
                    MessageBox.Show("ID不能为空!", "提示", MessageBoxButton.OK);
                    return;
                }
                if (Add_MACTextBox.Text == "")
                {
                    MessageBox.Show("建议不要将MAC地址设置为空!", "提示", MessageBoxButton.OK);
                }
                if (Add_UserCodeTextBox1.Text == "" || Add_UserCodeTextBox2.Text == "")
                {
                    MessageBox.Show("建议不要将用户码设置为空!", "提示", MessageBoxButton.OK);
                }
                if (Add_VoltageTextBox.Text == "")
                {
                    MessageBox.Show("建议不要将额定电压设置为空!", "提示", MessageBoxButton.OK);
                }
                if (Add_PowerTextBox.Text == "")
                {
                    MessageBox.Show("建议不要将额定功率设置为空!", "提示", MessageBoxButton.OK);
                }

                PlugDevice plugdev = new PlugDevice();
                plugdev.PlugID         = Convert.ToInt64(Add_IDTextBox.Text);
                plugdev.PlugName       = Add_NameTextBox.Text;
                plugdev.PlugMac        = Add_MACTextBox.Text;
                plugdev.UserCode       = (UInt16)(256 * Convert.ToUInt16(Add_UserCodeTextBox1.Text) + Convert.ToUInt16(Add_UserCodeTextBox2.Text));
                plugdev.Voltage        = Convert.ToSingle(Add_VoltageTextBox.Text);
                plugdev.Power          = Convert.ToSingle(Add_PowerTextBox.Text);
                plugdev.DayBudget      = Convert.ToSingle(Add_BudgettedEnergyTextBox.Text);
                plugdev.Description    = Add_DescriptionTextBox.Text;
                plugdev.CreateDateTime = DateTime.Now;

                bool success = SmartPlugDAL.AddPlugDevice(plugdev, SqliteDBPath);

                if (success == true)
                {
                    RefreshPlugInfo(); //更新列表
                    AddedDeviceList.SelectedIndex = PlugDeviceTable.Rows.Count - 1;
                    MessageBox.Show("成功添加该插座!", "提示", MessageBoxButton.OK);
                }
                else
                {
                    MessageBox.Show("无法添加该插座,请检查设置!", "提示", MessageBoxButton.OK);
                }
            }
            catch (ArgumentException ae)
            {
                MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace);
            }
            catch (Exception ex)
            {
                //Do any logging operation here if necessary
                throw new Exception(ex.Message);
            }
        }