private void frmMain_Load(object sender, EventArgs e)
{
try
{
StreamWriter sw = new StreamWriter(prop.Dir_net_export + "\\Exchanger_" + Environment.MachineName + "_" + Environment.UserName + ".info", false, Encoding.GetEncoding(1251));
sw.Write("Date: " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() +
"\nMashine: " + Environment.MachineName +
"\nUser: "******"\nExchanger mod: " + Application.ProductVersion);
sw.Close();
}
catch
{
}
if (!Checking.checkVersion(Modules.Exchanger, Application.ProductVersion))
if (MessageBox.Show("Внимание! Существует более новая версия модуля!\nУстановить обновление?", "Контроль обновлений", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
System.Diagnostics.Process.Start(System.Environment.GetCommandLineArgs()[0].Substring(
0,
System.Environment.GetCommandLineArgs()[0].LastIndexOf('\\')
) + "\\PSA.Update.cmd");
if (!PSA.Lib.Util.Semaphore.semInventory)
{
this.WindowState = FormWindowState.Maximized;
txtDateBegin.Value = DateTime.Now.AddDays(-20);
txtDateEnd.Value = DateTime.Now.AddDays(5);
txtDateBeginPr.Value = DateTime.Now.AddDays(-20);
txtDateEndPr.Value = DateTime.Now.AddDays(5);
bool tmp_login_ok = false;
bool tmp_exit = false;
// Если ограничение на запуск одной копии пройдено, то продолжаем...
// Открываем соединение с базой
try
{
db_connection.ConnectionString = prop.Connection_string;
db_connection.Open();
}
catch (Exception ex)
{
ErrorNfo.WriteErrorInfo(ex);
// Если не удалось подключиться к базе, то
// выдаем сообщение об ошибке и открываем форму
// подключения к базе данных
MessageBox.Show("Ошибка подключения к базе данных!\n" + ex.Message + "\n" + ex.Source + "\nПроверьте настройки подключения!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
try
{
frmSetup fOptions = new frmSetup();
fOptions.ShowDialog();
prop = new PSA.Lib.Util.Settings();
// Опять пробуем подключиться к базе
db_connection.ConnectionString = prop.Connection_string;
db_connection.Open();
}
catch (Exception exc)
{
ErrorNfo.WriteErrorInfo(exc);
// Если после второй попытки не удалось подключиться, то закрываем программу.
MessageBox.Show("Ошибка подключения к базе данных!\n" + exc.Message + "\n" + exc.Source, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
tmp_exit = true;
}
}
if (!tmp_exit)
{
// открываем окно запроса пользователя
PSA.Lib.Interface.frmLogin fLogin = new PSA.Lib.Interface.frmLogin();
// спрашиваем пока не угадает пароль или не надоест угадывать
while (!tmp_login_ok)
{
switch (fLogin.ShowDialog())
{
case DialogResult.Cancel:
{
tmp_login_ok = true;
tmp_exit = true;
break;
}
case DialogResult.OK:
{
tmp_login_ok = true;
if (fLogin.usr.prmCanLoginAcceptance)
{
this.Show();
}
else
{
tmp_exit = true;
MessageBox.Show("Доступ в модуль приемка заперщен!", "Вход в программу", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
break;
}
}
}
if (!tmp_exit)
{
// если мы уже тут, значит пароль все же угадали
// Получаем данные о пользователе
usr = fLogin.usr;
// Показываем окно
this.Focus();
SqlCommand cmd_status = new SqlCommand("SELECT [order_status], [status_desc] FROM [order_status] ORDER BY [status_desc]", db_connection);
SqlDataAdapter da_status = new SqlDataAdapter(cmd_status);
DataTable dt_status = new DataTable("status");
da_status.Fill(dt_status);
checkStatus.DataSource = dt_status;
checkStatus.DisplayMember = "status_desc";
checkStatus.ValueMember = "order_status";
for (int i = 0; i < checkStatus.Items.Count; i++)
{
checkStatus.SetSelected(i, true);
//checkStatus.SelectedItem = i;
if (checkStatus.SelectedValue.ToString().Trim() == "000000")
checkStatus.SetItemChecked(i, true);
}
checkFilterInput.Checked = true;
checkFilter();
FilterR = new FilterRowLike(GridOder);
}
else
{
Application.Exit();
}
}
else
{
Application.Exit();
}
}
else
{
MessageBox.Show("В момент проведения инвентаризации вход в модуль запрещен!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Application.Exit();
}
}
private void frmLostOrders_Load(object sender, EventArgs e)
{
db_connection = new SqlConnection(prop.Connection_string);
LoadData();
if (fRow == null)
fRow = new FilterRowLike(data);
}
private void frmAcceptanceTable_Load(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
txtDateBegin.Value = DateTime.Now.AddDays(-7);
txtDateEnd.Value = DateTime.Now.AddDays(3);
txtDateBeginPr.Value = DateTime.Now.AddDays(-7);
txtDateEndPr.Value = DateTime.Now.AddDays(3);
checkFilterOutput.Checked = true;
checkFilterInput.Checked = true;
checkFilter();
FilterR = new FilterRowLike(GridOder);
if (prop.UpdateOrderTableInAcceptance > 0)
{
tmr.Interval = 1000 * prop.UpdateOrderTableInAcceptance;
checkAutoUpdate.Checked = true;
tmr.Start();
}
else
{
tmr.Interval = 10000;
checkAutoUpdate.Checked = false;
tmr.Stop();
}
LoadGrid();
tmrcls.Start();
}
private void FillOrderList()
{
if (CheckState(db_connection))
{
int selid = 0;
try
{
selid = int.Parse(gridOrderList.GetData(gridOrderList.Row, 1).ToString());
}
catch (Exception ex)
{
//ErrorNfo.WriteErrorInfo(ex);
}
db_table_orders.Rows.Clear();
string tmpF_Good = "", tmpF_Crop = "", tmpF_Paper = "";
if (txtFilterGoods.SelectedValue.ToString() != "0")
tmpF_Good = " AND [id_good] = '" + txtFilterGoods.SelectedValue + "'";
else
tmpF_Good = "";
db_command_orders = new SqlCommand("SELECT DISTINCT [id_order], [number], [status], [input_date], [expected_date], [id_user_designer] FROM [vwOrderListDesigner] WHERE (([id_order] > 0) " + tmpF_Good + ") ORDER BY [expected_date]", db_connection);
db_command_orders.CommandTimeout = 900;
db_adapter_orders = new SqlDataAdapter(db_command_orders);
db_adapter_orders.Fill(db_table_orders);
lblLoaded.Text = "Загружено " + db_table_orders.Rows.Count.ToString("N0", new CultureInfo("de-DE")) + " зак.";
gridOrderList.DataSource = db_table_orders;
/*
* 1 [id_order],
* 2 [number],
* 3 [status],
* 4 [input_date],
* 5 [expected_date]
*/
gridOrderList.Cols[1].Visible = false;
gridOrderList.Cols[2].Visible = false;
gridOrderList.Cols[3].Visible = false;
gridOrderList.Cols[4].Visible = false;
gridOrderList.Cols[5].Visible = false;
gridOrderList.Cols[6].Visible = false;
gridOrderList.Cols[2].Visible = true;
gridOrderList.Cols[2].Width = 120;
gridOrderList.Cols[2].AllowDragging = false;
gridOrderList.Cols[2].AllowEditing = false;
gridOrderList.Cols[2].AllowMerging = false;
gridOrderList.Cols[2].AllowResizing = true;
gridOrderList.Cols[2].AllowSorting = true;
gridOrderList.Cols[2].Caption = "Заказ №";
gridOrderList.Cols[4].Visible = true;
gridOrderList.Cols[4].Width = 110;
gridOrderList.Cols[4].AllowDragging = false;
gridOrderList.Cols[4].AllowEditing = false;
gridOrderList.Cols[4].AllowMerging = false;
gridOrderList.Cols[4].AllowResizing = true;
gridOrderList.Cols[4].AllowSorting = true;
gridOrderList.Cols[4].Caption = "Прием";
gridOrderList.Cols[4].Format = "g";
gridOrderList.Cols[5].Visible = true;
gridOrderList.Cols[5].Width = 110;
gridOrderList.Cols[5].AllowDragging = false;
gridOrderList.Cols[5].AllowEditing = false;
gridOrderList.Cols[5].AllowMerging = false;
gridOrderList.Cols[5].AllowResizing = true;
gridOrderList.Cols[5].AllowSorting = true;
gridOrderList.Cols[5].Caption = "Выдача";
gridOrderList.Cols[5].Format = "g";
if (fRow == null)
fRow = new FilterRowLike(gridOrderList);
int selrow = 2;
for (int i = 2; i < gridOrderList.Rows.Count; i++)
{
try
{
if (selid == int.Parse(gridOrderList.GetData(i, 1).ToString()))
selrow = i;
}
catch (Exception ex)
{
ErrorNfo.WriteErrorInfo(ex);
}
if (gridOrderList[i, 6].ToString().Trim() == "0")
gridOrderList.Rows[i].Style = gridOrderList.Styles["MyNull"];
else if (gridOrderList[i, 6].ToString().Trim() == usr.Id_user.ToString().Trim())
gridOrderList.Rows[i].Style = gridOrderList.Styles["MyMy"];
else if (gridOrderList[i, 6].ToString().Trim() != usr.Id_user.ToString().Trim())
gridOrderList.Rows[i].Style = gridOrderList.Styles["MyNotMy"];
if ((gridOrderList[i, 3].ToString().Trim() == "000211") || (gridOrderList[i, 3].ToString().Trim() == "000212"))
gridOrderList.Rows[i].Style = gridOrderList.Styles["MyOK"];
if (gridOrderList[i, 3].ToString().Trim() == "000111")
gridOrderList.Rows[i].Style = gridOrderList.Styles["In"];
}
if (selrow < gridOrderList.Rows.Count)
gridOrderList.Select(selrow, 2);
}
}
private void frmAcceptanceTable_Load(object sender, EventArgs e)
{
this.WindowState = FormWindowState.Maximized;
txtDateBegin.Value = DateTime.Now.AddDays(-7);
txtDateEnd.Value = DateTime.Now.AddDays(3);
txtDateBeginPr.Value = DateTime.Now.AddDays(-7);
txtDateEndPr.Value = DateTime.Now.AddDays(3);
SqlCommand cmd_status = new SqlCommand("SELECT [order_status], [status_desc] FROM [order_status] ORDER BY [status_desc]", db_connection);
SqlDataAdapter da_status = new SqlDataAdapter(cmd_status);
DataTable dt_status = new DataTable("status");
da_status.Fill(dt_status);
checkStatus.DataSource = dt_status;
checkStatus.DisplayMember = "status_desc";
checkStatus.ValueMember = "order_status";
for (int i = 0; i < checkStatus.Items.Count; i++)
{
checkStatus.SetItemChecked(i, true);
}
checkFilterOutput.Checked = true;
checkFilter();
FilterR = new FilterRowLike(GridOder);
if (prop.UpdateOrderTableInAcceptance > 0)
{
tmr.Interval = 1000 * prop.UpdateOrderTableInAcceptance;
checkAutoUpdate.Checked = true;
tmr.Start();
}
else
{
tmr.Interval = 10000;
checkAutoUpdate.Checked = false;
tmr.Stop();
}
LoadGrid();
tmrcls.Start();
}
