private void bt_create_arr_Click(object sender, RoutedEventArgs e)
{
try
{
//Вытаскиваем ID поставщика
FbCommand sqlforcombsrav = new FbCommand("select ID from GET_ID_CONTR where SN ='" + cb_prov.Text + "'", con.preh.fb);
FbDataReader readercombsrav = sqlforcombsrav.ExecuteReader();
DataTable wdf = new DataTable();
wdf.Load(readercombsrav);
//Команда добавления
FbCommand sqlforin = new FbCommand("IUD_DOCUMENT_ARRIVE", con.preh.fb);
sqlforin.CommandType = System.Data.CommandType.StoredProcedure;
sqlforin.Parameters.Add("@FLAG", FbDbType.Char).Value = "I";
sqlforin.Parameters.Add("@ID", FbDbType.Integer).Value = 0;
sqlforin.Parameters.Add("@CREATOR", FbDbType.Date).Value = con.preh.id_main_res.ToString();
sqlforin.Parameters.Add("@COMMENT", FbDbType.VarChar).Value = comment_arr.Text;
sqlforin.Parameters.Add("@CONTRACTOR", FbDbType.Integer).Value = wdf.Rows[0][0].ToString();
sqlforin.Parameters.Add("@ID_WH", FbDbType.Integer).Value = con.preh.id_main_war.ToString();
//FbDataReader reader_ret_id = sqlforin.ExecuteReader();
//DataTable dt_ret_id = new DataTable();
//dt_ret_id.Load(reader_ret_id);
//con.return_id_doc = dt_ret_id.Rows[0][0].ToString();
sqlforin.ExecuteNonQuery();
//dp_cr_date_arr.Text =DateTime.Today.ToString();
//cb_prov.Clear();
//comment_arr.Clear();
this.Close();
con.gc_arrive_list.ItemsSource = con.dt_grid_list_arrived();
con.prop_grid_arr(con.gc_arrive_list);
System.Windows.MessageBox.Show("Запись успешно добавлена!");
//add_details_arr open_add_det = new add_details_arr();
//open_add_det.con1 = this;
//open_add_det.ShowDialog();
}
catch
{
System.Windows.MessageBox.Show("Не все поля заполнены или заполненны некорректно!");
}
}
private void bt_add_det_Click(object sender, RoutedEventArgs e)
{
try
{
//Команда добавления
FbCommand sqlforin = new FbCommand("IUD_DOC_DETAIL_ARRIVE", con.preh.fb);
sqlforin.CommandType = System.Data.CommandType.StoredProcedure;
sqlforin.Parameters.Add("@FLAG", FbDbType.Char).Value = "I";
sqlforin.Parameters.Add("@ID", FbDbType.Integer).Value = null;
sqlforin.Parameters.Add("@ID_DOCUMENT", FbDbType.Integer).Value = con.gc_arrive_list.GetFocusedRowCellValue("ID").ToString();
sqlforin.Parameters.Add("@ID_CHAR", FbDbType.Integer).Value = id_selected_char.ToString();
sqlforin.Parameters.Add("@COUNT_", FbDbType.Integer).Value = culc_sum.Text;
sqlforin.ExecuteNonQuery();
this.Close();
con.gc_arrive_list.ItemsSource = con.dt_grid_list_arrived();
con.prop_grid_arr(con.gc_arrive_list);
System.Windows.MessageBox.Show("Товар успешно добавлен!");
}
catch { System.Windows.MessageBox.Show("Невозможно добавить номенклатуру!"); }
}
