/* Обновление данных в остатках ----------------------------------------*/ /* Увеличение остатков */ public static void BalancePlus(DataSet ResourceDS) { MsSQLFull _mySql = new MsSQLFull(); DataSet _dataSet = new DataSet(); _dataSet.Clear(); _dataSet.DataSetName = "balance"; _mySql.SelectSqlCommand = "SELECT id_balance, balance_tmc, balance_date, balance_number FROM balance"; _mySql.InsertSqlCommand = "INSERT INTO balance (balance_tmc, balance_date, balance_number) VALUES (@balance_tmc, @balance_date, @balance_number)"; _mySql.InsertParametersAdd("@balance_tmc", SqlDbType.VarChar, 250, "balance_tmc", UpdateRowSource.None); _mySql.InsertParametersAdd("@balance_date", SqlDbType.Date, 10, "balance_date", UpdateRowSource.None); _mySql.InsertParametersAdd("@balance_number", SqlDbType.Float, 10, "balance_number", UpdateRowSource.None); _mySql.UpdateSqlCommand = "UPDATE balance SET balance_tmc = @balance_tmc, balance_date = @balance_date, balance_number = @balance_number WHERE (id_balance = @id_balance)"; _mySql.UpdateParametersAdd("@balance_tmc", SqlDbType.VarChar, 250, "balance_tmc", UpdateRowSource.None); _mySql.UpdateParametersAdd("@balance_date", SqlDbType.Date, 10, "balance_date", UpdateRowSource.None); _mySql.UpdateParametersAdd("@balance_number", SqlDbType.Float, 10, "balance_number", UpdateRowSource.None); _mySql.UpdateParametersAdd("@id_balance", SqlDbType.SmallInt, 11, "id_balance", UpdateRowSource.None); _mySql.DeleteSqlCommand = "DELETE FROM balance WHERE (id_balance = @id_balance)"; _mySql.DeleteParametersAdd("@id_balance", SqlDbType.SmallInt, 11, "id_balance", UpdateRowSource.None); if (_mySql.ExecuteFill(_dataSet, "balance")) { // Ввод остатков foreach (DataRow rowTS in ResourceDS.Tables["tabularsection"].Rows) { foreach (DataRow rowBalance in _dataSet.Tables["balance"].Rows) { if (rowTS["tabularSection_tmc"].ToString() == rowBalance["balance_tmc"].ToString()) { double sum = ClassConversion.StringToDouble(rowBalance["balance_number"].ToString()) + ClassConversion.StringToDouble(rowTS["tabularSection_number"].ToString()); rowBalance["balance_number"] = sum; } } } if (_mySql.ExecuteUpdate(_dataSet, "balance")) { ClassForms.Rapid_Client.MessageConsole("Остатки: Успешное обновление остатков.", false); } else { ClassForms.Rapid_Client.MessageConsole("Остатки: Ошибка ввод и сохранения новых остатков.", true); } } else { ClassForms.Rapid_Client.MessageConsole("Остатки: Ошибка обращения к остаткам.", true); } }
/*---------------------------------------------------------*/ /* Загрузка табличной части */ void LoadTabularSection() { // Формируем табличную часть ComingTS_DataSet.Clear(); ComingTS_DataSet.DataSetName = "tabularsection"; ComingTS_MySQL.SelectSqlCommand = "SELECT id_tabularSection, tabularSection_tmc, tabularSection_units, tabularSection_number, tabularSection_price, tabularSection_NDS, tabularSection_sum, tabularSection_total, tabularSection_id_doc FROM tabularsection WHERE (tabularSection_id_doc = '" + DocID + "')"; ComingTS_MySQL.InsertSqlCommand = "INSERT INTO tabularsection (tabularSection_tmc, tabularSection_units, tabularSection_number, tabularSection_price, tabularSection_NDS, tabularSection_sum, tabularSection_total, tabularSection_id_doc) " + "VALUES (@tabularSection_tmc, @tabularSection_units, @tabularSection_number, @tabularSection_price, @tabularSection_NDS, @tabularSection_sum, @tabularSection_total, @tabularSection_id_doc)"; ComingTS_MySQL.InsertParametersAdd("@tabularSection_tmc", SqlDbType.VarChar, 250, "tabularSection_tmc", UpdateRowSource.None); ComingTS_MySQL.InsertParametersAdd("@tabularSection_units", SqlDbType.VarChar, 250, "tabularSection_units", UpdateRowSource.None); ComingTS_MySQL.InsertParametersAdd("@tabularSection_number", SqlDbType.Float, 10, "tabularSection_number", UpdateRowSource.None); ComingTS_MySQL.InsertParametersAdd("@tabularSection_price", SqlDbType.Float, 10, "tabularSection_price", UpdateRowSource.None); ComingTS_MySQL.InsertParametersAdd("@tabularSection_NDS", SqlDbType.Float, 10, "tabularSection_NDS", UpdateRowSource.None); ComingTS_MySQL.InsertParametersAdd("@tabularSection_sum", SqlDbType.Float, 10, "tabularSection_sum", UpdateRowSource.None); ComingTS_MySQL.InsertParametersAdd("@tabularSection_total", SqlDbType.Float, 10, "tabularSection_total", UpdateRowSource.None); ComingTS_MySQL.InsertParametersAdd("@tabularSection_id_doc", SqlDbType.VarChar, 250, "tabularSection_id_doc", UpdateRowSource.None); ComingTS_MySQL.UpdateSqlCommand = "UPDATE tabularsection SET tabularSection_tmc = @tabularSection_tmc, tabularSection_units = @tabularSection_units, tabularSection_number = @tabularSection_number, tabularSection_price = @tabularSection_price, tabularSection_NDS = @tabularSection_NDS, tabularSection_sum = @tabularSection_sum, tabularSection_total = @tabularSection_total, tabularSection_id_doc = @tabularSection_id_doc WHERE (id_tabularSection = @id_tabularSection)"; ComingTS_MySQL.UpdateParametersAdd("@tabularSection_tmc", SqlDbType.VarChar, 250, "tabularSection_tmc", UpdateRowSource.None); ComingTS_MySQL.UpdateParametersAdd("@tabularSection_units", SqlDbType.VarChar, 250, "tabularSection_units", UpdateRowSource.None); ComingTS_MySQL.UpdateParametersAdd("@tabularSection_number", SqlDbType.Float, 10, "tabularSection_number", UpdateRowSource.None); ComingTS_MySQL.UpdateParametersAdd("@tabularSection_price", SqlDbType.Float, 10, "tabularSection_price", UpdateRowSource.None); ComingTS_MySQL.UpdateParametersAdd("@tabularSection_NDS", SqlDbType.Float, 10, "tabularSection_NDS", UpdateRowSource.None); ComingTS_MySQL.UpdateParametersAdd("@tabularSection_sum", SqlDbType.Float, 10, "tabularSection_sum", UpdateRowSource.None); ComingTS_MySQL.UpdateParametersAdd("@tabularSection_total", SqlDbType.Float, 10, "tabularSection_total", UpdateRowSource.None); ComingTS_MySQL.UpdateParametersAdd("@tabularSection_id_doc", SqlDbType.VarChar, 250, "tabularSection_id_doc", UpdateRowSource.None); ComingTS_MySQL.UpdateParametersAdd("@id_tabularSection", SqlDbType.SmallInt, 11, "id_tabularSection", UpdateRowSource.None); ComingTS_MySQL.DeleteSqlCommand = "DELETE FROM tabularsection WHERE (id_tabularSection = @id_tabularSection)"; ComingTS_MySQL.DeleteParametersAdd("@id_tabularSection", SqlDbType.SmallInt, 11, "id_tabularSection", UpdateRowSource.None); if (ComingTS_MySQL.ExecuteFill(ComingTS_DataSet, "tabularsection")) { // формируем табличную часть dataGrid1.DataSource = ComingTS_DataSet; //.Tables["tabularsection"]; dataGrid1.DataMember = "tabularsection"; } else { ClassForms.Rapid_Client.MessageConsole("Приходная Накладная: Ошибка формирования пустой табличной части.", true); } }