public Zakazchik(string ID)
{
InitializeComponent();
MySqlQueries = new MySqlQueries();
MySqlOperations = new MySqlOperations(MySqlQueries);
this.ID_Org = ID;
}
public Sostav_Zakaza(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
ID = iD;
}
public Organizacii(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD = null)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
ID = iD;
}
public Zakaz(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD_Org = null, string iD_Zakaza = null)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
ID_Org = iD_Org;
ID_Zakaza = iD_Zakaza;
}
public Product(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD = null)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
ID = iD;
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Sklad_ComboBox, comboBox1);
}
public Zayavka(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD_Zakaza = null)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
ID_Zakaza = iD_Zakaza;
dateTimePicker1.Value = DateTime.Now;
dateTimePicker1.MinDate = DateTime.Now;
dateTimePicker1.MaxDate = DateTime.Now;
}
public void Print_Zayavka(MySqlQueries mySqlQueries, DataGridView dataGridView, SaveFileDialog saveFileDialog, string ID = null)
{
ExcelApplication ExcelApp = null;
Workbooks workbooks = null;
Workbook workbook = null;
Worksheet worksheet = null;
string output = null;
string fileName = null;
Select_Text(mySqlQueries.Select_Zayavka_PrintShapka, ref output, ID);
saveFileDialog.Title = "Сохранить заявку как";
saveFileDialog.FileName = "Заявка на отгрузку № " + output.Split(';')[0] + " (" + output.Split(';')[1] + ')';
saveFileDialog.InitialDirectory = Application.StartupPath + "\\Отчеты\\";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
fileName = saveFileDialog.FileName;
try
{
ExcelApp = new ExcelApplication();
workbooks = ExcelApp.Workbooks;
workbook = workbooks.Open(Application.StartupPath + "\\Blanks\\Zayavka.xlsx");
worksheet = workbook.Worksheets.get_Item(1) as Worksheet;
ExcelApp.Cells[1, 1] = "ЗАЯВКА №" + output.Split(';')[0] + " от " + output.Split(';')[1];
ExcelApp.Cells[4, 2] = output.Split(';')[2];
ExcelApp.Cells[5, 2] = output.Split(';')[3];
ExcelApp.Cells[6, 2] = output.Split(';')[4];
ExcelApp.Cells[7, 2] = output.Split(';')[5];
Select_DataGridView(mySqlQueries.Select_Zayavka_PrintTable, dataGridView, ID);
int ExRow = 12;
int ExCol = 1;
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
for (int j = 0; j < dataGridView.Columns.Count; j++)
{
ExcelApp.Cells[ExRow, ExCol] = dataGridView.Rows[i].Cells[j].Value.ToString();
ExCol++;
}
ExCol = 1;
ExRow++;
}
var cells = worksheet.get_Range("A12 ", "E" + (ExRow - 1).ToString());
cells.Borders[XlBordersIndex.xlInsideVertical].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlInsideHorizontal].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlEdgeTop].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlEdgeRight].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlEdgeLeft].LineStyle = XlLineStyle.xlContinuous;
cells.Borders[XlBordersIndex.xlEdgeBottom].LineStyle = XlLineStyle.xlContinuous;
workbook.SaveAs(fileName);
ExcelApp.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Marshal.ReleaseComObject(workbook);
Marshal.ReleaseComObject(workbooks);
Marshal.ReleaseComObject(ExcelApp);
}
}
}
public MySqlOperations(MySqlQueries sqlQueries)
{
this.Queries = sqlQueries;
}
public Postavschik()
{
InitializeComponent();
MySqlQueries = new MySqlQueries();
MySqlOperations = new MySqlOperations(MySqlQueries);
}
public Login()
{
InitializeComponent();
MySqlQueries = new MySqlQueries();
MySqlOperations = new MySqlOperations(MySqlQueries);
}