Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Data.SqlClient;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- namespace FormsVokuev
- {
- public partial class Form1 : Form
- {
- DataSet ds;
- SqlDataAdapter adapter;
- private string connectionString = @"Data Source=DESKTOP-3F2B3B3\SQLEXPRESS;Initial Catalog=DfLessonDb;Integrated Security=True";
- public Form1()
- {
- InitializeComponent();
- }
- private void Form1_Load(object sender, EventArgs e)
- {
- // TODO: данная строка кода позволяет загрузить данные в таблицу "dfLessonDbDataSet.SupplyOfMaterials". При необходимости она может быть перемещена или удалена.
- this.supplyOfMaterialsTableAdapter.Fill(this.dfLessonDbDataSet.SupplyOfMaterials);
- // TODO: данная строка кода позволяет загрузить данные в таблицу "dfLessonDbDataSet.AvailabilityStock". При необходимости она может быть перемещена или удалена.
- this.availabilityStockTableAdapter.Fill(this.dfLessonDbDataSet.AvailabilityStock);
- // TODO: данная строка кода позволяет загрузить данные в таблицу "dfLessonDbDataSet.Stock". При необходимости она может быть перемещена или удалена.
- this.stockTableAdapter.Fill(this.dfLessonDbDataSet.Stock);
- }
- private void availabilityStockGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
- {
- bindingNavigator1.BindingSource = availabilityStockBindingSource;
- lblTable.Text = "Наличие материала";
- this.availabilityStockGridView.DataSource = availabilityStockBindingSource;
- this.supplyOfMaterialsGridView.DataSource = fkSupplyOfMaterialsWarehousesavailabilityBindingSource;
- }
- private void supplyOfMaterialsGridView_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
- {
- bindingNavigator1.BindingSource = supplyOfMaterialsBindingSource;
- lblTable.Text = "Учет материала";
- this.supplyOfMaterialsGridView.DataSource = supplyOfMaterialsBindingSource;
- }
- private void availabilityStockGridView_CurrentCellChanged_1(object sender, EventArgs e)
- {
- if (availabilityStockGridView.CurrentCell != null)
- {
- int nRow = availabilityStockGridView.CurrentCell.RowIndex;
- }
- }
- private void btnSave_Click(object sender, EventArgs e)
- {
- this.availabilityStockTableAdapter.Update(this.dfLessonDbDataSet.AvailabilityStock);
- this.availabilityStockTableAdapter.Fill(this.dfLessonDbDataSet.AvailabilityStock);
- this.availabilityStockGridView_CurrentCellChanged_1(availabilityStockGridView, e);
- }
- private void btnRefresh_Click(object sender, EventArgs e)
- {
- this.availabilityStockTableAdapter.Fill(dfLessonDbDataSet.AvailabilityStock);
- this.availabilityStockGridView_CurrentCellChanged_1(availabilityStockGridView, e);
- }
- private void StockGridView_CellClick(object sender, DataGridViewCellEventArgs e)
- {
- bindingNavigator1.BindingSource = stockBindingSource;
- this.availabilityStockGridView.DataSource = fkwhavailabilityBindingSource;
- lblTable.Text = "Склады";
- }
- private void btnproc_Click(object sender, EventArgs e)
- {
- int a = Convert.ToInt32(textBox1.Text);
- using (SqlConnection connection = new SqlConnection(connectionString))
- {
- string sql = string.Format(@"declare @answer int
- exec count_material {0}, @answer output
- select @answer", a);
- connection.Open();
- adapter = new SqlDataAdapter(sql, connection);
- ds = new DataSet();
- adapter.Fill(ds);
- //dataGridView1.DataSource = ds.Tables[0];
- label1.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
- }
- }
- private void button1_Click(object sender, EventArgs e)
- {
- Form2 fr2 = new Form2();
- fr2.Show();
- Hide();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement