private void OKButton_Click(object sender, EventArgs e)
        {
            General.CreateCounterpartyAccount(Counterparty);


            SaledShopMaterials SaledMaterials = new SaledShopMaterials();

            SaledMaterials.InsertRecords(titlebox.Text, textBox3.Text, textBox1.Text, textBox2.Text, textBox5.Text, DateTime.Today.ToString(), "Vella", Counterparty);
            SaledMaterials.Close();

            General.DeleteFromSQLDataBase("ResidueShopMaterials", "Имя", titlebox.Text);

            CounterpartyAccount CpAcc = new CounterpartyAccount();

            CpAcc.LoadString           = Counterparty;
            CpAcc.ProductName          = titlebox.Text;
            CpAcc.PriceString          = textBox1.Text;
            CpAcc.CountString          = textBox2.Text;
            CpAcc.SumString            = textBox4.Text;
            CpAcc.InsertRecordsBoolean = true;
            CpAcc.Date = dateTimePicker1.Text;
            CpAcc.ShowDialog(this);
        }
示例#2
0
        private void OKButton_Click(object sender, EventArgs e)
        {
            try
            {
                Price       = PriceValue;
                Count       = Count - CountValue;
                Summ        = Summ - SummValue;
                CratesCount = CratesCount - CratesCountBalue;
                Mass        = Mass - MassValue;

                if (!File.Exists(Application.StartupPath + "//Shop.Residue.Data.xml"))
                {
                    General.ShowErrorBox("Список продуктов цеха отсутствует!\nВозможно была потеря данных, обратитесь к администрации программы!");
                }
                else
                {
                    XmlDocument xDoc = new XmlDocument();
                    xDoc.Load(Application.StartupPath + "//Shop.Residue.Data.xml");
                    XmlElement xRoot     = xDoc.DocumentElement;
                    XmlNode    childnode = xRoot.SelectSingleNode(String.Format("ShopResidue[Имя='{0}']", titlebox.Text));
                    if (childnode != null)
                    {
                        XmlNode nameChildNode = childnode.SelectSingleNode("Имя");
                        string  elemNameStr   = "NONE";
                        if (nameChildNode != null)
                        {
                            elemNameStr = nameChildNode.InnerText;
                            XmlNode massElem   = childnode.SelectSingleNode("Масса");
                            XmlNode countElem  = childnode.SelectSingleNode("Количество");
                            XmlNode cratesElem = childnode.SelectSingleNode("КоличествоКаробок");
                            XmlNode pricesElem = childnode.SelectSingleNode("Цена");
                            XmlNode summElem   = childnode.SelectSingleNode("Сумма");

                            if (massElem != null && countElem != null && cratesElem != null && pricesElem != null && summElem != null)
                            {
                                massElem.InnerText   = Mass.ToString();
                                countElem.InnerText  = Count.ToString();
                                cratesElem.InnerText = CratesCount.ToString();
                                pricesElem.InnerText = Price.ToString();
                                summElem.InnerText   = Summ.ToString();
                            }
                        }
                    }
                    xDoc.Save(Application.StartupPath + "//Shop.Residue.Data.xml");
                }

                //General.UpdateCellData("ResidueShopMaterials", "Масса", textBox3.Text, Convert.ToInt32(ID));
                //General.UpdateCellData("ResidueShopMaterials", "Цена", textBox1.Text, Convert.ToInt32(ID));
                //General.UpdateCellData("ResidueShopMaterials", "Количество", textBox2.Text, Convert.ToInt32(ID));
                //General.UpdateCellData("ResidueShopMaterials", "КоличествоКаробок", textBox5.Text, Convert.ToInt32(ID));
                //General.UpdateCellData("ResidueShopMaterials", "Сумма", textBox4.Text, Convert.ToInt32(ID));


                Date = DateControl.Text.ToString();
                if (ProviderTextBox.Text != null)
                {
                    Provider = ProviderTextBox.Text;
                }

                if (RecipientTextBox.Text != null)
                {
                    Recipient = RecipientTextBox.Text;
                }


                SaledShopMaterials RRMF = new SaledShopMaterials();
                RRMF.InsertRecords(titlebox.Text, textBox3.Text, textBox1.Text, textBox2.Text, textBox5.Text, Date, Provider, Recipient);
                RRMF.ShowDialog(this);

                try
                {
                    General.CreateTable(Recipient, String.Format("ID int IDENTITY (1, 1) not null, Продукт nchar(25) not null, Цена float not null, Количество float not null, Сумма float not null, Дата nvarchar(15), constraint PK_{0} primary key clustered([ID] ASC)", Recipient));
                    InsertRecordsToCouterparty(titlebox.Text, PriceValue, CountValue, SummValue, Date);
                }
                catch (Exception)
                {
                    General.Connection.Close();
                }
                this.Close();
            }
            catch (Exception) { }
        }