ILOVA
Salon dasturining listiningi
using System;
using System.Reflection;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Text;
using System.IO;
using System.Windows.Forms;
namespace Storehouse
{
public partial class MainForm : Form
{
public MainForm()
{
InitializeComponent();
}
#region Variables
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\base\rohat.mdb;Persist Security Info=True");
OleDbDataAdapter dataAdapter = new OleDbDataAdapter("", @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\base\rohat.mdb;Persist Security Info=True");
string currentState = "";
#endregion
///
/// Not finished Buttons Excel
///
private void PrintButton_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
switch (currentState)
{
case "naklad":
//
break;
case "selldoc":
#region Table create for excel
System.Data.DataTable table = new System.Data.DataTable("table");
table.Columns.Add("Модель");
table.Columns.Add("Номер кузова (VIN номер)");
table.Columns.Add("Отпускная цена");
table.Columns.Add("Розничная цена");
table.Columns.Add("Розничная цена (долл. США)");
table.Columns.Add("№ пласт. Карточки");
table.Columns.Add("Дата отпуска автомобиля");
table.Columns.Add("Ф.И.О. покупателя");
table.Columns.Add("Адрес");
table.Columns.Add("Тел.");
#endregion
dataAdapter.SelectCommand.CommandText = "select * from [auto] where [status]=1";
System.Data.DataTable dt = new System.Data.DataTable("dt");
dataAdapter.Fill(dt);
System.Data.DataTable dtCustomer = new System.Data.DataTable("customer");
//string inn = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
dtCustomer.Clear();
dataAdapter.SelectCommand.CommandText = "select * from customer where inn=" + dt.Rows[i]["inn"].ToString();
dataAdapter.Fill(dtCustomer);
table.Rows.Add(
dt.Rows[i][1].ToString() + " " + dt.Rows[i][2].ToString(),
dt.Rows[i][3].ToString(),
dt.Rows[i][7].ToString(),
dt.Rows[i][8].ToString(),
"$$$$",
"4790 XXXX XXXX 92",
"06.06.2009",
dtCustomer.Rows[0][2].ToString() + " " + dtCustomer.Rows[0][3].ToString() + " " + dtCustomer.Rows[0][4].ToString(),
dtCustomer.Rows[0][6].ToString(),
dtCustomer.Rows[0][7].ToString());
}
#region Opening Excel
excel.Workbooks.Open(Directory.GetCurrentDirectory() + @"\xls\rasxod.xls",
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value);
int ColumnIndex = 0;
int rowIndex = 7;
#endregion
#region Filling data into Excel
foreach (DataRow row in table.Rows)
{
rowIndex++;
ColumnIndex = -1;
#region New option adding
foreach (DataColumn col in table.Columns)
{
ColumnIndex++;
if (ColumnIndex < 11)
{
excel.Cells[rowIndex, ColumnIndex + 3] = row[ColumnIndex].ToString();
}
else
{
ColumnIndex++;
}
}
#endregion
}
#endregion
excel.Visible = true;
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)excel.ActiveSheet;
worksheet.Activate();
this.TopMost = false;
worksheet = null;
excel = null;
break;
}
}
private void buttonOstatka_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
#region Table create for excel
System.Data.DataTable table = new System.Data.DataTable("table");
table.Columns.Add("От кого получено");
table.Columns.Add("Модель");
table.Columns.Add("Мод-я");
table.Columns.Add("Опции");
table.Columns.Add("Цвет");
table.Columns.Add("Номер кузова (VIN номер)");
table.Columns.Add("Номер двигателя");
table.Columns.Add("Документ по приходу № накл");
table.Columns.Add("Документ по приходу Дата");
table.Columns.Add("Отпускная цена в сумах");
table.Columns.Add("Розничная цена в сумах");
#endregion
dataAdapter.SelectCommand.CommandText = "select * from [auto] where [status]=0";
System.Data.DataTable dt = new System.Data.DataTable("dt");
System.Data.DataTable dtNaklad = new System.Data.DataTable("naklad");
dataAdapter.Fill(dt);
for (int i = 0; i < dt.Rows.Count; i++)
{
dtNaklad.Clear();
dataAdapter.SelectCommand.CommandText = "select * from naklad where no_naklad='" + dt.Rows[i][10].ToString() + "'";
dataAdapter.Fill(dtNaklad);
table.Rows.Add(
dtNaklad.Rows[0][0].ToString(),
dt.Rows[i][1].ToString(),
dt.Rows[i][2].ToString(),
dt.Rows[i][3].ToString(),
dt.Rows[i][6].ToString(),
dt.Rows[i][4].ToString(),
dt.Rows[i][5].ToString(),
dt.Rows[i][10].ToString(),
dtNaklad.Rows[0][4].ToString(),
dt.Rows[i][7].ToString(),
dt.Rows[i][8].ToString());
}
#region Opening Excel
excel.Workbooks.Open(Directory.GetCurrentDirectory() + @"\xls\ostatok.xls",
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value);
int ColumnIndex = 0;
int rowIndex = 9;
//string model = "";
#endregion
#region Filling data into Excel
//excel.Cells[3, 4] = "(действуют с " + DateTime.Now.ToShortDateString() + " г.)";
foreach (DataRow row in table.Rows)
{
rowIndex++;
ColumnIndex = -1;
#region New option adding
foreach (DataColumn col in table.Columns)
{
ColumnIndex++;
//Microsoft.Office.Interop.Excel.Range celModif = (Microsoft.Office.Interop.Excel.Range)excel.Cells[rowIndex, ColumnIndex];
//if (ColumnIndex == 2 || ColumnIndex == 3)
//{
// celModif.Font.Bold = true;
//}
//else
//{
// celModif.Font.Bold = false;
//}
//celModif.Font.Size = 10;
if (ColumnIndex < 11 )
{
excel.Cells[rowIndex, ColumnIndex+2 ] = row[ColumnIndex ].ToString();
}
else
{
ColumnIndex++;
}
}
#endregion
}
#endregion
excel.Visible = true;
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)excel.ActiveSheet;
worksheet.Activate();
this.TopMost = false;
worksheet = null;
excel = null;
}
private void IncomeReportMenuItem_Click(object sender, EventArgs e)
{
//
}
private void OutcomeReportMenuItem_Click(object sender, EventArgs e)
{
//
}
private void BalanceMenuItem_Click(object sender, EventArgs e)
{
//
}
///
/// ///////////////////////////////////////////////////////////////////////////
///
private void FSELLDOCLOAD()
{
dataGridCome.Rows.Clear();
dataGridAuto.Rows.Clear();
#region Selldoc read
switch (comboTypeAuto.Text)
{
case "Все":
dataAdapter.SelectCommand.CommandText = @"select * from " + currentState;
break;
default:
dataAdapter.SelectCommand.CommandText = @"select * from " + currentState + " where type_auto_name='" + comboTypeAuto.Text + "'";
break;
}
System.Data.DataTable dtSelldoc = new System.Data.DataTable(currentState);
dataAdapter.Fill(dtSelldoc);
#endregion
#region Customer read
dataAdapter.SelectCommand.CommandText = "select * from customer";
System.Data.DataTable dtCustomer = new System.Data.DataTable("customer");
dataAdapter.Fill(dtCustomer);
#endregion
#region Selldoc add
string fio = "";
string address = "";
string telefon = "";
for (int i = 0; i < dtSelldoc.Rows.Count; i++)
{
fio = "";
address = "";
telefon = "";
#region Find Customer
for (int j = 0; j < dtCustomer.Rows.Count; j++)
{
if (dtSelldoc.Rows[i]["id_customer"].ToString() == dtCustomer.Rows[j]["id_customer"].ToString())
{
fio = dtCustomer.Rows[j]["first_name"].ToString() + " " + dtCustomer.Rows[j]["second_name"].ToString() + " " + dtCustomer.Rows[j]["last_name"].ToString();
address = dtCustomer.Rows[j]["address"].ToString();
telefon = dtCustomer.Rows[j]["telephone"].ToString();
break;
}
}
#endregion
if (dateCompare(dateStart.Text, dtSelldoc.Rows[i]["date_doc"].ToString(), dateEnd.Text))
{
dataGridCome.Rows.Add
(
i + 1,
dtSelldoc.Rows[i]["date_doc"].ToString(),
dtSelldoc.Rows[i]["no_doc"].ToString(),
fio,
address,
telefon,
dtSelldoc.Rows[i]["id_selldoc"].ToString()
);
}
}
#endregion
EditStatus();
}
private void EditStatus()
{
if (dataGridCome.Rows.Count != 0)
{
DeleteButtonItem.Enabled = true;
EditButtonItem.Enabled = true;
}
else
{
DeleteButtonItem.Enabled = false;
EditButtonItem.Enabled = false;
}
}
private void FNAKLADLOAD()
{
#region Naklad read
switch (comboTypeAuto.Text)
{
case "Все":
dataAdapter.SelectCommand.CommandText = @"select * from " + currentState;
break;
default:
dataAdapter.SelectCommand.CommandText = @"select * from " + currentState + " where type_auto_name='" + comboTypeAuto.Text + "'";
break;
}
System.Data.DataTable dtNaklad = new System.Data.DataTable(currentState);
dataAdapter.Fill(dtNaklad);
#endregion
#region Add row
for (int i = 0; i < dtNaklad.Rows.Count; i++)
{
if (dateCompare(dateStart.Text, dtNaklad.Rows[i]["date_naklad"].ToString(), dateEnd.Text))
{
dataGridCome.Rows.Add
(
i + 1,
dtNaklad.Rows[i]["date_naklad"].ToString(),
dtNaklad.Rows[i]["no_naklad"].ToString(),
dtNaklad.Rows[i]["date_fact"].ToString(),
dtNaklad.Rows[i]["no_fact"].ToString(),
dtNaklad.Rows[i]["supplier_name"].ToString(),
dtNaklad.Rows[i]["shop_name"].ToString(),
dtNaklad.Rows[i]["type_auto_name"].ToString(),
dtNaklad.Rows[i]["id_naklad"].ToString()
);
}
}
#endregion
EditStatus();
}
private void FLOAD()
{
DataTable dtAuto = new DataTable("auto");
dtAuto.Clear();
dataAdapter.Fill(dtAuto);
#region Rates read
System.Data.DataTable dtRates = new System.Data.DataTable("rates");
dataAdapter.SelectCommand.CommandText = "select * from rates order by id_rate asc";
dataAdapter.Fill(dtRates);
#endregion
double a = Convert.ToDouble(dtRates.Rows[1][2].ToString());
double b = Convert.ToDouble(dtRates.Rows[2][2].ToString());
double[] Variables = new double[7];
for (int i = 0; i < dtAuto.Rows.Count; i++)
{
#region Calculation
Variables[0] = Convert.ToInt32(dtAuto.Rows[i]["otp_price"].ToString());
Variables[2] = Convert.ToInt32(dtAuto.Rows[i]["roz_price"].ToString());
Variables[1] = Math.Round((100 * Variables[2]) / (100 + a));
Variables[3] = Math.Round((a * Variables[2]) / (100 + a));
Variables[4] = Math.Round(Variables[3] / 6);
Variables[5] = Variables[1] - Variables[0];
Variables[6] = Math.Round((Variables[1] * b) / 100, MidpointRounding.AwayFromZero);
#endregion
#region AddCode
dataGridAuto.Rows.Add
(
i + 1,
dtAuto.Rows[i]["model_name"].ToString(),
dtAuto.Rows[i]["modif_name"].ToString(),
dtAuto.Rows[i]["option"].ToString(),
dtAuto.Rows[i]["no_prod"].ToString(),
dtAuto.Rows[i]["no_body"].ToString(),
dtAuto.Rows[i]["no_engine"].ToString(),
dtAuto.Rows[i]["color_name"].ToString(),
Variables[0],
Variables[1],
Variables[2],
Variables[3],
Variables[4],
Variables[5],
Variables[6]
);
#endregion
}
StatusLabel.Text = "Количество машины: " + dataGridAuto.Rows.Count.ToString() + " шт.";
}
private bool dateCompare(string dStart, string dOriginal, string dEnd)
{
if (Convert.ToInt32(dStart.Substring(6, 4)) < Convert.ToInt32(dOriginal.Substring(6, 4)) &&
Convert.ToInt32(dOriginal.Substring(6, 4)) < Convert.ToInt32(dEnd.Substring(6, 4)))
{ return true; }
else
{
if (Convert.ToInt32(dStart.Substring(6, 4)) == Convert.ToInt32(dOriginal.Substring(6, 4)) &&
Convert.ToInt32(dOriginal.Substring(6, 4)) == Convert.ToInt32(dEnd.Substring(6, 4)))
{
if (Convert.ToInt32(dStart.Substring(3, 2)) < Convert.ToInt32(dOriginal.Substring(3, 2)) &&
Convert.ToInt32(dOriginal.Substring(3, 2)) < Convert.ToInt32(dEnd.Substring(3, 2)))
{ return true; }
else
{
if (Convert.ToInt32(dStart.Substring(3, 2)) == Convert.ToInt32(dOriginal.Substring(3, 2)) &&
Convert.ToInt32(dOriginal.Substring(3, 2)) == Convert.ToInt32(dEnd.Substring(3, 2)))
{
if (Convert.ToInt32(dStart.Substring(0, 2)) <= Convert.ToInt32(dOriginal.Substring(0, 2)) &&
Convert.ToInt32(dOriginal.Substring(0, 2)) <= Convert.ToInt32(dEnd.Substring(0, 2)))
{ return true; }
else
{ return false; }
}
else
{
if (Convert.ToInt32(dStart.Substring(3, 2)) == Convert.ToInt32(dOriginal.Substring(3, 2)))
{
if (Convert.ToInt32(dStart.Substring(0, 2)) <= Convert.ToInt32(dOriginal.Substring(0, 2)))
{ return true; }
else
{ return false; }
}
else
{
if (Convert.ToInt32(dEnd.Substring(3, 2)) == Convert.ToInt32(dOriginal.Substring(3, 2)))
{
if (Convert.ToInt32(dEnd.Substring(0, 2)) >= Convert.ToInt32(dOriginal.Substring(0, 2)))
{ return true; }
else
{ return false; }
}
else
{ return false; }
}
}
}
}
else
{
if (Convert.ToInt32(dStart.Substring(6, 4)) == Convert.ToInt32(dOriginal.Substring(6, 4)))
{
if (Convert.ToInt32(dStart.Substring(3, 2)) <= Convert.ToInt32(dOriginal.Substring(3, 2)) &&
Convert.ToInt32(dStart.Substring(0, 2)) <= Convert.ToInt32(dOriginal.Substring(0, 2)))
{ return true; }
else
{ return false; }
}
else
{
if (Convert.ToInt32(dEnd.Substring(6, 4)) == Convert.ToInt32(dOriginal.Substring(6, 4)))
{
if (Convert.ToInt32(dEnd.Substring(3, 2)) >= Convert.ToInt32(dOriginal.Substring(3, 2)) &&
Convert.ToInt32(dEnd.Substring(0, 2)) >= Convert.ToInt32(dOriginal.Substring(0, 2)))
{ return true; }
else
{ return false; }
}
else
{ return false; }
}
}
}
}
private void MainForm_Load(object sender, EventArgs e)
{
splitIn.Panel2Collapsed = true;
splitIn.Panel1Collapsed = false;
buttonMain.Enabled = false;
#region type_auto Load
dataAdapter.SelectCommand.CommandText = "select type_auto_name from type_auto order by id_type_auto asc";
System.Data.DataTable dtTAuto = new System.Data.DataTable("type_auto");
dataAdapter.Fill(dtTAuto);
comboTypeAuto.Items.Add("Все");
comboTypeAuto.Text = comboTypeAuto.Items[0].ToString();
for (int i = 0; i < dtTAuto.Rows.Count; i++)
{
comboTypeAuto.Items.Add(dtTAuto.Rows[i][0].ToString());
}
#endregion
#region Temp Auto Clear
OleDbCommand cmd = new OleDbCommand("update [auto] set status=0 where status=2", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
#endregion
DateTimeLabel.Text = "Дата: " + DateTime.Now.ToShortDateString() + " Время: " + DateTime.Now.ToShortTimeString();
Vaqt.Enabled = true;
dateEnd.Text = DateTime.Now.ToShortDateString();
dateStart.Text = "01." + DateTime.Now.Month.ToString() + "." + DateTime.Now.Year.ToString();
}
private void buttonCome_Click(object sender, EventArgs e)
{
splitIn.Panel2Collapsed = false;
splitIn.Panel1Collapsed = true;
currentState = (sender as System.Windows.Forms.Button).Tag.ToString();
StatusLabel.Text = "Количество машины: 0 шт.";
dataGridCome.Columns.Clear();
dataGridAuto.Rows.Clear();
switch (currentState)
{
case "naklad":
buttonIncome.Enabled = false;
buttonOutcome.Enabled = true;
buttonMain.Enabled = true;
this.Text = "Приход";
FormNameLabel.Text = "Приход";
#region Column add
dataGridCome.Columns.Add("column0", "№");
dataGridCome.Columns.Add("column1", "Дата накладной");
dataGridCome.Columns.Add("column2", "№ накладной");
dataGridCome.Columns.Add("column3", "Дата счет фактуры");
dataGridCome.Columns.Add("column4", "№ счет фактуры");
dataGridCome.Columns.Add("column5", "От кого");
dataGridCome.Columns.Add("column6", "Получатель");
dataGridCome.Columns.Add("column7", "Тип автомобиля");
dataGridCome.Columns.Add("id_naklad", "id_naklad");
dataGridCome.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader;
dataGridCome.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dataGridCome.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dataGridCome.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dataGridCome.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dataGridCome.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridCome.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridCome.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dataGridCome.Columns[8].Visible = false;
#endregion
FNAKLADLOAD();
break;
case "selldoc":
buttonOutcome.Enabled = false;
buttonIncome.Enabled = true;
buttonMain.Enabled = true;
this.Text = "Расход";
FormNameLabel.Text = "Расход";
#region Column add
dataGridCome.Columns.Add("column0", "№");
dataGridCome.Columns.Add("column1", "Дата документа");
dataGridCome.Columns.Add("column2", "№ документа");
dataGridCome.Columns.Add("column3", "Получатель");
dataGridCome.Columns.Add("column4", "Адрес");
dataGridCome.Columns.Add("column5", "Телефон");
dataGridCome.Columns.Add("id_selldoc", "id_selldoc");
dataGridCome.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader;
dataGridCome.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridCome.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridCome.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridCome.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridCome.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridCome.Columns[6].Visible = false;
#endregion
FSELLDOCLOAD();
break;
case "main":
splitIn.Panel1Collapsed = false;
splitIn.Panel2Collapsed = true;
buttonMain.Enabled = false;
buttonIncome.Enabled = true;
buttonOutcome.Enabled = true;
#region Dealer Load
dataAdapter.SelectCommand.CommandText = "select dealer from dealer";
DataTable dt = new DataTable("dt");
dataAdapter.Fill(dt);
#endregion
StatusLabel.Text = dt.Rows[0][0].ToString();
this.Text = "Главное окно";
FormNameLabel.Text = "Главное окно";
break;
}
}
private void dataGridCome_CellClick(object sender, DataGridViewCellEventArgs e)
{
dataGridAuto.Rows.Clear();
if (dataGridCome.Rows.Count > 0)
{
if (dataGridCome.SelectedRows[0].Index < dataGridCome.Rows.Count)
{
string id = dataGridCome.Rows[dataGridCome.SelectedRows[0].Index].Cells["id_" + currentState].Value.ToString();
dataAdapter.SelectCommand.CommandText = "select * from [auto] where id_" + currentState + "=" + id;
FLOAD();
}
else
{
StatusLabel.Text = "Количество машины: 0 шт.";
}
}
}
#region FULLLOAD Method
private void FULLLOAD()
{
dataGridCome.Rows.Clear();
dataGridAuto.Rows.Clear();
switch (currentState)
{
case "naklad":
FNAKLADLOAD();
break;
case "selldoc":
FSELLDOCLOAD();
break;
}
}
private void AddButtonItem_Click(object sender, EventArgs e)
{
switch (currentState)
{
case "naklad":
NakladForm NakladF = new NakladForm();
NakladF.ShowDialog();
break;
case "selldoc":
SellDocument SelldocF = new SellDocument();
SelldocF.ShowDialog();
break;
}
FULLLOAD();
}
private void DeleteButtonItem_Click(object sender, EventArgs e)
{
if (dataGridCome.Rows.Count != 0)
{
if (DialogResult.OK == MessageBox.Show("Are you sure ?", "Info", MessageBoxButtons.OKCancel, MessageBoxIcon.Information))
{
OleDbCommand cmd = new OleDbCommand("", con);
con.Open();
cmd.CommandText = "delete from " + currentState + " where id_" + currentState + "=" + dataGridCome.SelectedRows[0].Cells["id_" + currentState].Value.ToString();
cmd.ExecuteNonQuery();
cmd.CommandText = "update [auto] set [status]=0, id_selldoc=null, id_customer=null where id_selldoc=" + dataGridCome.Rows[dataGridAuto.SelectedRows[0].Index].Cells["id_selldoc"].Value.ToString();
cmd.ExecuteNonQuery();
con.Close();
}
FULLLOAD();
EditStatus();
}
}
private void EditButtonItem_Click(object sender, EventArgs e)
{
switch (currentState)
{
case "naklad":
NakladForm NakladF = new NakladForm();
NakladF.update = true;
NakladF.groupDoc.Tag = dataGridCome.SelectedRows[0].Cells["id_naklad"].Value.ToString();
NakladF.ShowDialog();
break;
case "selldoc":
SellDocument SelldocF = new SellDocument();
SelldocF.update = true;
SelldocF.groupDoc.Tag = dataGridCome.SelectedRows[0].Cells["id_selldoc"].Value.ToString();
SelldocF.ShowDialog();
break;
}
FULLLOAD();
}
private void date_ValueChanged(object sender, EventArgs e)
{
bool change = false;
#region StartEndDate
if (Convert.ToInt32(dateStart.Text.Substring(6, 4)) > Convert.ToInt32(dateEnd.Text.Substring(6, 4)))
{
change = true;
}
else
{
if (Convert.ToInt32(dateStart.Text.Substring(6, 4)) == Convert.ToInt32(dateEnd.Text.Substring(6, 4)))
{
if (Convert.ToInt32(dateStart.Text.Substring(3, 2)) > Convert.ToInt32(dateEnd.Text.Substring(3, 2)))
{
change = true;
}
else
{
if (Convert.ToInt32(dateStart.Text.Substring(3, 2)) == Convert.ToInt32(dateEnd.Text.Substring(3, 2)))
{
if (Convert.ToInt32(dateStart.Text.Substring(0, 2)) > Convert.ToInt32(dateEnd.Text.Substring(0, 2)))
{
change = true;
}
}
}
}
}
if (change)
{
switch ((sender as DateTimePicker).Name)
{
case "dateStart":
dateEnd.Text = dateStart.Text;
break;
case "dateEnd":
dateStart.Text = dateEnd.Text;
break;
}
}
#endregion
FULLLOAD();
}
private void comboTypeAuto_TextChanged(object sender, EventArgs e)
{
FULLLOAD();
}
#endregion
private void time_Tick(object sender, EventArgs e)
{
DateTimeLabel.Text = "Дата: " + DateTime.Now.ToShortDateString() + " Время: " + DateTime.Now.ToShortTimeString();
}
private void comboTypeAuto_KeyPress(object sender, KeyPressEventArgs e)
{
e.Handled = true;
}
#region MenuItemClicks
private void priceMenuItem_Click(object sender, EventArgs e)
{
PriceApp.PriceForm PriceF = new PriceApp.PriceForm();
PriceF.ShowDialog();
}
private void ReferencesMenuItem_Click(object sender, EventArgs e)
{
little.LittleForm ReferenceF = new little.LittleForm();
ReferenceF.ShowDialog();
}
private void IncomeMenuItem_Click(object sender, EventArgs e)
{
buttonCome_Click(buttonIncome, e);
}
private void OutcomeMenuItem_Click(object sender, EventArgs e)
{
buttonCome_Click(buttonOutcome, e);
}
private void CurrencyRateMenuItem_Click(object sender, EventArgs e)
{
Pricelist.RatesForm RateF = new Pricelist.RatesForm();
RateF.ShowDialog();
}
private void InfoDealerMenuItem_Click(object sender, EventArgs e)
{
DealerForm DealerF = new DealerForm();
DealerF.ShowDialog();
}
private void CustomersMenuItem_Click(object sender, EventArgs e)
{
CListForm CListF = new CListForm();
CListF.ShowDialog();
}
private void ExitMenuItem_Click(object sender, EventArgs e)
{
Application.Exit();
}
#endregion
}
|
