/* Обновление данных в остатках ----------------------------------------*/
/* Увеличение остатков */
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);
}
}
