private void MegaOrdersDataGrid_SelectionChanged(object sender, EventArgs e)
{
if (PackagesOrdersManager != null)
{
if (PackagesOrdersManager.MegaOrdersBindingSource.Count > 0)
{
if (((DataRowView)PackagesOrdersManager.MegaOrdersBindingSource.Current)["MegaOrderID"] != DBNull.Value)
{
if (NeedSplash)
{
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
sw.Start();
PackagesOrdersManager.FilterMainOrders(Convert.ToInt32(((DataRowView)PackagesOrdersManager.MegaOrdersBindingSource.Current)["MegaOrderID"]));
sw.Stop();
double G = sw.Elapsed.TotalSeconds;
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
else
{
PackagesOrdersManager.FilterMainOrders(Convert.ToInt32(((DataRowView)PackagesOrdersManager.MegaOrdersBindingSource.Current)["MegaOrderID"]));
}
}
}
}
}
private void ClearPackageButton_Click(object sender, EventArgs e)
{
if (PackagesOrdersManager != null)
{
if (PackagesOrdersManager.MainOrdersBindingSource.Count > 0)
{
if (((DataRowView)PackagesOrdersManager.MainOrdersBindingSource.Current)["MainOrderID"] != DBNull.Value)
{
bool OKCancel = Infinium.LightMessageBox.Show(ref TopForm, true,
"В данном подзаказе очистятся ВСЕ упаковки. Распечатанные этикетки будут недействительны. Продолжить?",
"Внимание");
if (!OKCancel)
{
return;
}
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Очистка упаковок.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
//PackagesOrdersManager.FixOrderEvent(Convert.ToInt32(((DataRowView)PackagesOrdersManager.MainOrdersBindingSource.Current)["MainOrderID"]),
// "Упаковки очищены, UserID=" + Security.CurrentUserID);
PackagesOrdersManager.ClearPackage();
PackagesOrdersManager.SetPackStatus();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
}
}
}
private void btnRemovePermit_Click(object sender, EventArgs e)
{
if (dgvPermits.SelectedRows.Count == 0)
{
return;
}
bool OKCancel = Infinium.LightMessageBox.Show(ref TopForm, true,
"Пропуск будет удален. Продолжить?",
"Удаление пропуска");
if (!OKCancel)
{
return;
}
int PermitID = Convert.ToInt32(dgvPermits.SelectedRows[0].Cells["PermitID"].Value);
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
NeedSplash = false;
PermitsManager.RemovePermit(PermitID);
PermitsManager.SavePermits();
UpdatePermits();
NeedSplash = true;
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
InfiniumTips.ShowTip(this, 50, 85, "Пропуск удален", 1700);
}
private void dgvPermitsDates_SelectionChanged(object sender, EventArgs e)
{
if (PermitsManager == null)
{
return;
}
PermitsManager.ClearPermits();
if (dgvPermitsDates.SelectedRows.Count == 0)
{
return;
}
object Date = PermitsManager.CurrentCreateDate;
if (Date != DBNull.Value)
{
if (NeedSplash)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
NeedSplash = false;
PermitsManager.FilterPermitsByCreateDate(Convert.ToDateTime(Date));
NeedSplash = true;
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
else
{
PermitsManager.FilterPermitsByCreateDate(Convert.ToDateTime(Date));
}
}
}
private void dgvMainOrders_SelectionChanged(object sender, EventArgs e)
{
if (TafelManager == null)
{
return;
}
int GroupType = 0;
int MainOrderID = 0;
if (dgvMainOrders.SelectedRows.Count != 0 && dgvMainOrders.SelectedRows[0].Cells["GroupType"].Value != DBNull.Value)
{
GroupType = Convert.ToInt32(dgvMainOrders.SelectedRows[0].Cells["GroupType"].Value);
}
if (dgvMainOrders.SelectedRows.Count != 0 && dgvMainOrders.SelectedRows[0].Cells["MainOrderID"].Value != DBNull.Value)
{
MainOrderID = Convert.ToInt32(dgvMainOrders.SelectedRows[0].Cells["MainOrderID"].Value);
}
if (NeedSplash)
{
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
TafelManager.FilterOrdersByMainOrder(GroupType, MainOrderID);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
else
{
TafelManager.FilterOrdersByMainOrder(GroupType, MainOrderID);
}
}
private void dgvOperationsGroups_SelectionChanged(object sender, EventArgs e)
{
if (NeedPaintingMaterialManager == null)
{
return;
}
int TechCatalogOperationsGroupID = 0;
if (dgvOperationsGroups.SelectedRows.Count != 0 && dgvOperationsGroups.SelectedRows[0].Cells["TechCatalogOperationsGroupID"].Value != DBNull.Value)
{
TechCatalogOperationsGroupID = Convert.ToInt32(dgvOperationsGroups.SelectedRows[0].Cells["TechCatalogOperationsGroupID"].Value);
}
if (NeedSplash)
{
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
NeedPaintingMaterialManager.FilterOperationsDetail(TechCatalogOperationsGroupID);
NeedPaintingMaterialManager.FilterSummaryStoreDetail(TechCatalogOperationsGroupID);
NeedPaintingMaterialManager.GetStore(TechCatalogOperationsGroupID);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
else
{
NeedPaintingMaterialManager.FilterOperationsDetail(TechCatalogOperationsGroupID);
NeedPaintingMaterialManager.FilterSummaryStoreDetail(TechCatalogOperationsGroupID);
NeedPaintingMaterialManager.GetStore(TechCatalogOperationsGroupID);
}
}
//Упаковочная ведомость (несколько подзаказов)
private void PrintMainOrderStatementContextMenuItem_Click(object sender, EventArgs e)
{
if (ZOVPackagesPrintManager.MegaOrdersBindingSource.Count < 1)
{
return;
}
int[] MainOrders = ZOVPackagesPrintManager.GetSelectedMainOrders();
//PackagesOrdersManager.MainOrdersBindingSource.Position = CurrentRowIndex;
//int MainOrderID = Convert.ToInt32(((DataRowView)PackagesOrdersManager.MainOrdersBindingSource.Current)["MainOrderID"]);
if (MainOrders.Count() == 0)
{
Infinium.LightMessageBox.Show(ref TopForm, false,
"Выбранный заказ пуст",
"Ошибка");
return;
}
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Создание документа Excel.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
PackingList.CreateReport(MainOrders, FrontIDs, ProductIDs);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void kryptonContextMenuItem4_Click(object sender, EventArgs e)
{
DateTime Monday = GetMonday(CurrentWeekNumber);
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Создание отчета.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
NeedSplash = false;
MarketingBatchReport.CreateReport(((DataView)MondayFrontsDG.DataSource).Table,
((DataView)MondayDecorProductsDG.DataSource).Table, "Состояние заказов. " + Monday.ToString("dd MMMM yyyy"));
NeedSplash = true;
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void FilterButton_Click(object sender, EventArgs e)
{
int UserID = 0;
int ModuleID = 0;
if (!AllUsersCheckBox.Checked)
{
UserID = Convert.ToInt32(UsersDataGrid.SelectedRows[0].Cells["UserID"].Value);
}
if (!AllModulesCheckBox.Checked)
{
ModuleID = Convert.ToInt32(ModulesDataGrid.SelectedRows[0].Cells["ModuleID"].Value);
}
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
AdminModulesJournal.FilterLoginJournal(UserID, ModuleID, CalendarFrom.SelectionEnd, CalendarTo.SelectionEnd, CodersCheckBox.Checked);
AdminModulesJournal.FilterModulesJournal(UserID, ModuleID, CalendarFrom.SelectionEnd, CalendarTo.SelectionEnd, CodersCheckBox.Checked);
AdminModulesJournal.GetTotalResultUsersTable();
AdminModulesJournal.GetResultModulesTable();
AdminModulesJournal.GetResultUsersTimeTable(CalendarFrom.SelectionEnd, CalendarTo.SelectionEnd);
Chart.RefreshData();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Сохранение данных.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
int InventoryID = InventoryManager.CurrentInventoryID;
InventoryManager.SaveInventoryDetails(InventoryID);
InventoryManager.SaveStore();
InventoryManager.RefreshStore();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
//FormEvent = eClose;
//AnimateTimer.Enabled = true;
}
private void btnComplete_Click(object sender, EventArgs e)
{
if (dgvAllScanedPackagesDetails.Rows.Count == 0)
{
InfiniumTips.ShowTip(this, 50, 85, "Упаковки не отсканированы", 2000);
return;
}
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref MainForm, "Обновление.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
assemblePackagesManager.AssemblePackages(ClientID);
InfiniumTips.ShowTip(this, 50, 85, "Упаковки подготовлены к отгрузке", 2000);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void FilterComplaints()
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
bool bWithReturn = cbWithReturn.Checked;
bool bWithoutReturn = cbWithoutReturn.Checked;
bool bNotFullyDispatch = cbNotFullyDispatch.Checked;
bool bConfirm = cbConfirm.Checked;
bool bNotConfirm = cbNotConfirm.Checked;
ComplaintsManager.FilterComplaints(bWithReturn, bWithoutReturn, bNotFullyDispatch, bConfirm, bNotConfirm);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void kryptonButton1_Click(object sender, EventArgs e)
{
if (!CanAction)
{
return;
}
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Сохранение данных.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
CheckLabel.DispatchPackages();
CheckLabel.DispatchTrays();
CheckOrdersStatus.SetStatusMarketingForDispatch(DispatchIDs);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void ProfilCheckButton_Click(object sender, EventArgs e)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
FrontsCatalog = new FrontsCatalog(1);
DecorCatalog = new DecorCatalog(1);
FrontsCatalogBinding();
DecorCatalogBinding();
FrontsGridsSettings();
DecorGridsSettings();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void kryptonButton1_Click(object sender, EventArgs e)
{
if (ConnectClientMessage.IsEmptyMessage(richTextBox1.Text))
{
return;
}
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Отправка сообщений.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
ConnectClientMessage.AddMessage(richTextBox1.Text.TrimEnd());
richTextBox1.Clear();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void GroupsDataGrid_SelectionChanged(object sender, EventArgs e)
{
if (InventoryManager == null)
{
return;
}
int TechStoreGroupID = 0;
if (GroupsDataGrid.SelectedRows.Count != 0 && GroupsDataGrid.SelectedRows[0].Cells["TechStoreGroupID"].Value != DBNull.Value)
{
TechStoreGroupID = Convert.ToInt32(GroupsDataGrid.SelectedRows[0].Cells["TechStoreGroupID"].Value);
}
if (NeedSplash)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Обновление данных.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
NeedSplash = false;
InventoryManager.FilterStoreSubGroups(TechStoreGroupID);
NeedSplash = true;
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
else
{
InventoryManager.FilterStoreSubGroups(TechStoreGroupID);
}
}
private void MFSummaryDG_SelectionChanged(object sender, EventArgs e)
{
if (ExpOrdersSummaryCheckBox.Checked)
{
return;
}
if (ExpeditionStatistics != null)
{
if (ExpeditionStatistics.MFSummaryBS.Count > 0)
{
if (((DataRowView)ExpeditionStatistics.MFSummaryBS.Current)["ClientID"] != DBNull.Value)
{
bool Profil = ExpProfilCheckBox.Checked;
bool TPS = ExpTPSCheckBox.Checked;
int FactoryID = 0;
if (Profil && !TPS)
{
FactoryID = 1;
}
if (!Profil && TPS)
{
FactoryID = 2;
}
if (!Profil && !TPS)
{
FactoryID = -1;
}
if (NeedSplash)
{
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
if (ExpClientSummaryCheckBox.Checked)
{
ExpeditionStatistics.FMarketingOrders(FactoryID, Convert.ToInt32(((DataRowView)ExpeditionStatistics.MFSummaryBS.Current)["ClientID"]));
}
else
{
ExpeditionStatistics.FMarketingOrders1(FactoryID, Convert.ToInt32(((DataRowView)ExpeditionStatistics.MFSummaryBS.Current)["MegaOrderID"]));
}
if (!ExpeditionStatistics.HasFronts)
{
ExpeditionStatistics.ClearFrontsOrders();
}
ExpFrontsInfo();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
else
{
if (ExpClientSummaryCheckBox.Checked)
{
ExpeditionStatistics.FMarketingOrders(FactoryID, Convert.ToInt32(((DataRowView)ExpeditionStatistics.MFSummaryBS.Current)["ClientID"]));
}
else
{
ExpeditionStatistics.FMarketingOrders1(FactoryID, Convert.ToInt32(((DataRowView)ExpeditionStatistics.MFSummaryBS.Current)["MegaOrderID"]));
}
if (!ExpeditionStatistics.HasFronts)
{
ExpeditionStatistics.ClearFrontsOrders();
}
ExpFrontsInfo();
}
}
}
}
}
private void kryptonCheckSet2_CheckedButtonChanged(object sender, EventArgs e)
{
if (IncomeMonth == null)
{
return;
}
if (kryptonCheckSet2.CheckedButton.Name == "AllCheckButton")
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
IncomeMonth.Factory = 0;
IncomeMonth.Fill();
IncomeChart.RefreshData();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
if (kryptonCheckSet2.CheckedButton.Name == "ProfilCheckButton")
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
IncomeMonth.Factory = 1;
IncomeMonth.Fill();
IncomeChart.RefreshData();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
if (kryptonCheckSet2.CheckedButton.Name == "TPSCheckButton")
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
IncomeMonth.Factory = 2;
IncomeMonth.Fill();
IncomeChart.RefreshData();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
}
private void cmiSaveDyeingAssignments_Click(object sender, EventArgs e)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Сохранение данных.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
int TechCatalogOperationsGroupID = 0;
if (dgvOperationsGroups.SelectedRows.Count != 0 && dgvOperationsGroups.SelectedRows[0].Cells["TechCatalogOperationsGroupID"].Value != DBNull.Value)
{
TechCatalogOperationsGroupID = Convert.ToInt32(dgvOperationsGroups.SelectedRows[0].Cells["TechCatalogOperationsGroupID"].Value);
}
ControlAssignmentsManager.TechCatalogOperationsGroupID = TechCatalogOperationsGroupID;
if (ControlAssignmentsManager.NewAssignment)
{
switch (ControlAssignmentsManager.GroupType)
{
case 0:
foreach (int item in ControlAssignmentsManager.MainOrders)
{
int MainOrderID = item;
ControlAssignmentsManager.CreateDyeingAssignment(TechCatalogOperationsGroupID);
ControlAssignmentsManager.SaveDyeingAssignments();
ControlAssignmentsManager.UpdateDyeingAssignments(From, To);
FrontsOrdersManager.SaveZOV(ControlAssignmentsManager, MainOrderID);
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.UpdateDyeingCarts(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.RemoveDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID);
for (int i = 0; i < dgvOperationsDetail.Rows.Count; i++)
{
int TechCatalogOperationsDetailID = Convert.ToInt32(dgvOperationsDetail.Rows[i].Cells["TechCatalogOperationsDetailID"].Value);
ControlAssignmentsManager.CreateDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID, TechCatalogOperationsDetailID);
}
ControlAssignmentsManager.SaveDyeingAssignmentBarcodes();
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
}
break;
case 1:
ControlAssignmentsManager.CreateDyeingAssignment(TechCatalogOperationsGroupID);
ControlAssignmentsManager.SaveDyeingAssignments();
ControlAssignmentsManager.UpdateDyeingAssignments(From, To);
ControlAssignmentsManager.SaveDyeingBatch();
FrontsOrdersManager.SaveMarketingReatailFronts(ControlAssignmentsManager);
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.UpdateDyeingCarts(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.RemoveDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID);
for (int i = 0; i < dgvOperationsDetail.Rows.Count; i++)
{
int TechCatalogOperationsDetailID = Convert.ToInt32(dgvOperationsDetail.Rows[i].Cells["TechCatalogOperationsDetailID"].Value);
ControlAssignmentsManager.CreateDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID, TechCatalogOperationsDetailID);
}
ControlAssignmentsManager.SaveDyeingAssignmentBarcodes();
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
break;
case 2:
ControlAssignmentsManager.CreateDyeingAssignment(TechCatalogOperationsGroupID);
ControlAssignmentsManager.SaveDyeingAssignments();
ControlAssignmentsManager.UpdateDyeingAssignments(From, To);
FrontsOrdersManager.SaveBatchFronts(ControlAssignmentsManager);
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.UpdateDyeingCarts(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.RemoveDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID);
for (int i = 0; i < dgvOperationsDetail.Rows.Count; i++)
{
int TechCatalogOperationsDetailID = Convert.ToInt32(dgvOperationsDetail.Rows[i].Cells["TechCatalogOperationsDetailID"].Value);
ControlAssignmentsManager.CreateDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID, TechCatalogOperationsDetailID);
}
ControlAssignmentsManager.SaveDyeingAssignmentBarcodes();
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
break;
case 3:
break;
case 4:
ControlAssignmentsManager.CreateDyeingAssignment(TechCatalogOperationsGroupID);
ControlAssignmentsManager.SaveDyeingAssignments();
ControlAssignmentsManager.UpdateDyeingAssignments(From, To);
FrontsOrdersManager.SaveReOrders(ControlAssignmentsManager);
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.UpdateDyeingCarts(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.RemoveDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID);
for (int i = 0; i < dgvOperationsDetail.Rows.Count; i++)
{
int TechCatalogOperationsDetailID = Convert.ToInt32(dgvOperationsDetail.Rows[i].Cells["TechCatalogOperationsDetailID"].Value);
ControlAssignmentsManager.CreateDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID, TechCatalogOperationsDetailID);
}
ControlAssignmentsManager.SaveDyeingAssignmentBarcodes();
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
break;
default:
break;
}
//ControlAssignmentsManager.NewAssignment = false;
}
else
{
if (ControlAssignmentsManager.GroupType == 1)
{
ControlAssignmentsManager.SaveDyeingBatch();
}
FrontsOrdersManager.SaveDyeingFronts(ControlAssignmentsManager);
ControlAssignmentsManager.ChangeOperationsGroup(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID);
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.UpdateDyeingCarts(ControlAssignmentsManager.DyeingAssignmentID);
ControlAssignmentsManager.RemoveDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID);
for (int i = 0; i < dgvOperationsDetail.Rows.Count; i++)
{
int TechCatalogOperationsDetailID = Convert.ToInt32(dgvOperationsDetail.Rows[i].Cells["TechCatalogOperationsDetailID"].Value);
ControlAssignmentsManager.CreateDyeingAssignmentBarcode(ControlAssignmentsManager.DyeingAssignmentID, TechCatalogOperationsGroupID, TechCatalogOperationsDetailID);
}
ControlAssignmentsManager.SaveDyeingAssignmentBarcodes();
ControlAssignmentsManager.UpdateDyeingAssignmentBarcodes(ControlAssignmentsManager.DyeingAssignmentID);
}
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
InfiniumTips.ShowTip(this, 50, 85, "Сохранено", 1700);
}
private void kryptonContextMenuItem4_Click(object sender, EventArgs e)
{
int ClientID = Convert.ToInt32(((DataRowView)Clients.ClientsBindingSource.Current).Row["ClientID"]);
decimal EURRUBCurrency = 0;
decimal USDRUBCurrency = 0;
decimal EURUSDCurrency = 0;
decimal EURBYRCurrency = 0;
bool fixedPaymentRate = false;
Clients.GetFixedPaymentRate(ClientID, DateTime.Now, ref fixedPaymentRate, ref EURUSDCurrency, ref EURRUBCurrency, ref EURBYRCurrency);
if (fixedPaymentRate)
{
USDRUBCurrency = 1;
}
else
{
EURRUBCurrency = 0;
USDRUBCurrency = 0;
EURUSDCurrency = 0;
EURBYRCurrency = 0;
Clients.CBRDailyRates(DateTime.Now, ref EURRUBCurrency, ref USDRUBCurrency);
Clients.GetDateRates(DateTime.Now, ref EURBYRCurrency);
if (USDRUBCurrency != 0)
{
EURUSDCurrency = Decimal.Round(EURRUBCurrency / USDRUBCurrency, 4, MidpointRounding.AwayFromZero);
}
}
decimal Rate = EURBYRCurrency;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Создание Excel.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
string FileName = "Прейскурант " + ((DataRowView)Clients.ClientsBindingSource.Current).Row["ClientName"].ToString();
decimal PriceGroup = Convert.ToDecimal(((DataRowView)Clients.ClientsBindingSource.Current).Row["PriceGroup"]);
HSSFWorkbook hssfworkbook;
hssfworkbook = new HSSFWorkbook();
FileName = FileName.Replace('/', '-');
FileName = FileName.Replace('\"', '\'');
ClientFrontsPrice obj1 = new ClientFrontsPrice(Rate);
ClientDecorPrice obj = new ClientDecorPrice(Rate);
obj1.CreateReport(ref hssfworkbook, ClientID, PriceGroup);
obj.CreateReport(ref hssfworkbook, ClientID, PriceGroup);
string tempFolder = System.Environment.GetEnvironmentVariable("TEMP");
FileInfo file = new FileInfo(tempFolder + @"\" + FileName + ".xls");
int j = 1;
while (file.Exists == true)
{
file = new FileInfo(tempFolder + @"\" + FileName + "(" + j++ + ").xls");
}
FileStream NewFile = new FileStream(file.FullName, FileMode.Create);
hssfworkbook.Write(NewFile);
NewFile.Close();
System.Diagnostics.Process.Start(file.FullName);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void ConditionOrdersFilter_Click(object sender, EventArgs e)
{
bool OnAgreementOrders = rbtnOnAgreementOrders.Checked;
bool AgreedOrders = rbtnAgreedOrders.Checked;
bool OnProductionOrders = rbtnOnProduction.Checked;
bool InProductionOrders = rbtnInProduction.Checked;
decimal FrontCost = 0;
decimal FrontSquare = 0;
int FrontsCount = 0;
int CurvedCount = 0;
decimal DecorPogon = 0;
decimal DecorCost = 0;
int DecorCount = 0;
DateTime Monday = GetMonday(CurrentWeekNumber);
DateTime Wednesday = GetWednesday(CurrentWeekNumber);
DateTime Friday = GetFriday(CurrentWeekNumber);
FMondayLabel.Text = CurrentWeekNumber + " неделя\r\n" + "Понедельник " + Monday.ToString("dd.MM.yyyy HH:mm");
FWednesdayLabel.Text = CurrentWeekNumber + " неделя\r\n" + "Среда " + Wednesday.ToString("dd.MM.yyyy HH:mm");
FFridayLabel.Text = CurrentWeekNumber + " неделя\r\n" + "Пятница " + Friday.ToString("dd.MM.yyyy HH:mm");
DMondayLabel.Text = CurrentWeekNumber + " неделя\r\n" + "Понедельник " + Monday.ToString("dd.MM.yyyy HH:mm");
DWednesdayLabel.Text = CurrentWeekNumber + " неделя\r\n" + "Среда " + Wednesday.ToString("dd.MM.yyyy HH:mm");
DFridayLabel.Text = CurrentWeekNumber + " неделя\r\n" + "Пятница " + Friday.ToString("dd.MM.yyyy HH:mm");
int FactoryID = 0;
if (CProfilCheckBox.Checked && !CTPSCheckBox.Checked)
{
FactoryID = 1;
}
if (!CProfilCheckBox.Checked && CTPSCheckBox.Checked)
{
FactoryID = 2;
}
if (!CProfilCheckBox.Checked && !CTPSCheckBox.Checked)
{
FactoryID = -1;
}
if (NeedSplash)
{
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
ConditionOrdersStatistics.ClearOrders();
if (Monday < DateTime.Now && MondayCB.Checked)
{
if (OnAgreementOrders)
{
ConditionOrdersStatistics.GetOnAgreementOrders(Monday, FactoryID);
}
if (AgreedOrders)
{
ConditionOrdersStatistics.GetAgreedOrders(Monday, FactoryID);
}
if (OnProductionOrders)
{
ConditionOrdersStatistics.GetOnProductionOrders(Monday, FactoryID);
}
if (InProductionOrders)
{
ConditionOrdersStatistics.GetInProductionOrders(Monday, FactoryID);
}
}
MondayFrontsDG.DataSource = new DataView(ConditionOrdersStatistics.FrontsSummaryDT.Copy());
MondayDecorProductsDG.DataSource = new DataView(ConditionOrdersStatistics.DecorProductsSummaryDT.Copy());
MondayDecorItemsDG.DataSource = new DataView(ConditionOrdersStatistics.DecorItemsSummaryDT.Copy());
((DataView)MondayFrontsDG.DataSource).Sort = "Front, Square DESC";
((DataView)MondayDecorProductsDG.DataSource).Sort = "DecorProduct, Measure ASC, Count DESC";
((DataView)MondayDecorItemsDG.DataSource).Sort = "DecorItem, Count DESC";
FrontCost = 0;
FrontSquare = 0;
FrontsCount = 0;
CurvedCount = 0;
MondayFrontsSquareLabel.Text = string.Empty;
MondayFrontsCostLabel.Text = string.Empty;
MondayFrontsCountLabel.Text = string.Empty;
MondayCurvedCountLabel.Text = string.Empty;
ConditionOrdersStatistics.GetFrontsInfo(ref FrontSquare, ref FrontCost, ref FrontsCount, ref CurvedCount);
MondayFrontsSquareLabel.Text = FrontSquare.ToString("N", nfi2);
MondayFrontsCostLabel.Text = FrontCost.ToString("N", nfi2);
MondayFrontsCountLabel.Text = FrontsCount.ToString();
MondayCurvedCountLabel.Text = CurvedCount.ToString();
DecorPogon = 0;
DecorCost = 0;
DecorCount = 0;
MondayDecorPogonLabel.Text = string.Empty;
MondayDecorCostLabel.Text = string.Empty;
MondayDecorCountLabel.Text = string.Empty;
ConditionOrdersStatistics.GetDecorInfo(ref DecorPogon, ref DecorCost, ref DecorCount);
MondayDecorPogonLabel.Text = DecorPogon.ToString("N", nfi2);
MondayDecorCostLabel.Text = DecorCost.ToString("N", nfi2);
MondayDecorCountLabel.Text = DecorCount.ToString();
ConditionOrdersStatistics.ClearOrders();
if (Wednesday < DateTime.Now && WednesdayCB.Checked)
{
if (OnAgreementOrders)
{
ConditionOrdersStatistics.GetOnAgreementOrders(Wednesday, FactoryID);
}
if (AgreedOrders)
{
ConditionOrdersStatistics.GetAgreedOrders(Wednesday, FactoryID);
}
if (OnProductionOrders)
{
ConditionOrdersStatistics.GetOnProductionOrders(Wednesday, FactoryID);
}
if (InProductionOrders)
{
ConditionOrdersStatistics.GetInProductionOrders(Wednesday, FactoryID);
}
}
WednesdayFrontsDG.DataSource = new DataView(ConditionOrdersStatistics.FrontsSummaryDT.Copy());
WednesdayDecorProductsDG.DataSource = new DataView(ConditionOrdersStatistics.DecorProductsSummaryDT.Copy());
WednesdayDecorItemsDG.DataSource = new DataView(ConditionOrdersStatistics.DecorItemsSummaryDT.Copy());
((DataView)WednesdayFrontsDG.DataSource).Sort = "Front, Square DESC";
((DataView)WednesdayDecorProductsDG.DataSource).Sort = "DecorProduct, Measure ASC, Count DESC";
((DataView)WednesdayDecorItemsDG.DataSource).Sort = "DecorItem, Count DESC";
FrontCost = 0;
FrontSquare = 0;
FrontsCount = 0;
CurvedCount = 0;
WednesdayFrontsSquareLabel.Text = string.Empty;
WednesdayFrontsCostLabel.Text = string.Empty;
WednesdayFrontsCountLabel.Text = string.Empty;
WednesdayCurvedCountLabel.Text = string.Empty;
ConditionOrdersStatistics.GetFrontsInfo(ref FrontSquare, ref FrontCost, ref FrontsCount, ref CurvedCount);
WednesdayFrontsSquareLabel.Text = FrontSquare.ToString("N", nfi2);
WednesdayFrontsCostLabel.Text = FrontCost.ToString("N", nfi2);
WednesdayFrontsCountLabel.Text = FrontsCount.ToString();
WednesdayCurvedCountLabel.Text = CurvedCount.ToString();
DecorPogon = 0;
DecorCost = 0;
DecorCount = 0;
WednesdayDecorPogonLabel.Text = string.Empty;
WednesdayDecorCostLabel.Text = string.Empty;
WednesdayDecorCountLabel.Text = string.Empty;
ConditionOrdersStatistics.GetDecorInfo(ref DecorPogon, ref DecorCost, ref DecorCount);
WednesdayDecorPogonLabel.Text = DecorPogon.ToString("N", nfi2);
WednesdayDecorCostLabel.Text = DecorCost.ToString("N", nfi2);
WednesdayDecorCountLabel.Text = DecorCount.ToString();
ConditionOrdersStatistics.ClearOrders();
if (Friday < DateTime.Now && FridayCB.Checked)
{
if (OnAgreementOrders)
{
ConditionOrdersStatistics.GetOnAgreementOrders(Friday, FactoryID);
}
if (AgreedOrders)
{
ConditionOrdersStatistics.GetAgreedOrders(Friday, FactoryID);
}
if (OnProductionOrders)
{
ConditionOrdersStatistics.GetOnProductionOrders(Friday, FactoryID);
}
if (InProductionOrders)
{
ConditionOrdersStatistics.GetInProductionOrders(Friday, FactoryID);
}
}
FridayFrontsDG.DataSource = new DataView(ConditionOrdersStatistics.FrontsSummaryDT.Copy());
FridayDecorProductsDG.DataSource = new DataView(ConditionOrdersStatistics.DecorProductsSummaryDT.Copy());
FridayDecorItemsDG.DataSource = new DataView(ConditionOrdersStatistics.DecorItemsSummaryDT.Copy());
((DataView)FridayFrontsDG.DataSource).Sort = "Front, Square DESC";
((DataView)FridayDecorProductsDG.DataSource).Sort = "DecorProduct, Measure ASC, Count DESC";
((DataView)FridayDecorItemsDG.DataSource).Sort = "DecorItem, Count DESC";
FrontCost = 0;
FrontSquare = 0;
FrontsCount = 0;
CurvedCount = 0;
FridayFrontsSquareLabel.Text = string.Empty;
FridayFrontsCostLabel.Text = string.Empty;
FridayFrontsCountLabel.Text = string.Empty;
FridayCurvedCountLabel.Text = string.Empty;
ConditionOrdersStatistics.GetFrontsInfo(ref FrontSquare, ref FrontCost, ref FrontsCount, ref CurvedCount);
FridayFrontsSquareLabel.Text = FrontSquare.ToString("N", nfi2);
FridayFrontsCostLabel.Text = FrontCost.ToString("N", nfi2);
FridayFrontsCountLabel.Text = FrontsCount.ToString();
FridayCurvedCountLabel.Text = CurvedCount.ToString();
DecorPogon = 0;
DecorCost = 0;
DecorCount = 0;
FridayDecorPogonLabel.Text = string.Empty;
FridayDecorCostLabel.Text = string.Empty;
FridayDecorCountLabel.Text = string.Empty;
ConditionOrdersStatistics.GetDecorInfo(ref DecorPogon, ref DecorCost, ref DecorCount);
FridayDecorPogonLabel.Text = DecorPogon.ToString("N", nfi2);
FridayDecorCostLabel.Text = DecorCost.ToString("N", nfi2);
FridayDecorCountLabel.Text = DecorCount.ToString();
MondayDecorProductsDG_SelectionChanged(null, null);
WednesdayDecorProductsDG_SelectionChanged(null, null);
FridayDecorProductsDG_SelectionChanged(null, null);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
else
{
}
}
private void FilterExpedition()
{
bool Profil = ExpProfilCheckBox.Checked;
bool TPS = ExpTPSCheckBox.Checked;
int FactoryID = 0;
if (Profil && !TPS)
{
FactoryID = 1;
}
if (!Profil && TPS)
{
FactoryID = 2;
}
if (!Profil && !TPS)
{
FactoryID = -1;
}
if (NeedSplash)
{
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
ExpeditionStatistics.ShowColumns(ref MFSummaryDG, ref MDSummaryDG, Profil, TPS, bExpSummaryClient);
ExpeditionStatistics.FMarketingOrders(FactoryID, -1);
ExpeditionStatistics.DMarketingOrders(FactoryID, -1);
if (!ExpClientSummaryCheckBox.Checked)
{
ExpeditionStatistics.MarketingSummary(FactoryID);
}
else
{
ExpeditionStatistics.ClientSummary(FactoryID);
}
if (!ExpeditionStatistics.HasFronts)
{
ExpeditionStatistics.ClearFrontsOrders();
}
if (!ExpeditionStatistics.HasDecor)
{
ExpeditionStatistics.ClearDecorOrders();
}
ExpFrontsInfo();
ExpDecorInfo();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
}
private void dgvImages_SelectionChanged(object sender, EventArgs e)
{
int ImageID = 0;
if (dgvImages.SelectedRows.Count > 0 && dgvImages.SelectedRows[0].Cells["ImageID"].Value != DBNull.Value)
{
ImageID = Convert.ToInt32(dgvImages.SelectedRows[0].Cells["ImageID"].Value);
}
kryptonRichTextBox1.Text = string.Empty;
kryptonRichTextBox2.Text = string.Empty;
kryptonRichTextBox3.Text = string.Empty;
cbToSite.Checked = false;
if (NeedSplash)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
pcbxImage.Image = null;
Image FinishedProductImage = FinishedImagesCatalogManager.GetImage(ImageID);
if (FinishedProductImage != null)
{
pcbxImage.Image = FinishedProductImage;
if (pcbxImage.Image == null)
{
pcbxImage.Cursor = Cursors.Default;
}
else
{
pcbxImage.Cursor = Cursors.Hand;
}
}
if (ImageID != 0)
{
kryptonRichTextBox6.Text = dgvImages.SelectedRows[0].Cells["Category"].Value.ToString();
kryptonRichTextBox5.Text = dgvImages.SelectedRows[0].Cells["Name"].Value.ToString();
kryptonRichTextBox4.Text = dgvImages.SelectedRows[0].Cells["Color"].Value.ToString();
kryptonRichTextBox1.Text = dgvImages.SelectedRows[0].Cells["Description"].Value.ToString();
kryptonRichTextBox2.Text = dgvImages.SelectedRows[0].Cells["Sizes"].Value.ToString();
kryptonRichTextBox3.Text = dgvImages.SelectedRows[0].Cells["Material"].Value.ToString();
cbToSite.Checked = Convert.ToBoolean(dgvImages.SelectedRows[0].Cells["ToSite"].Value);
cbCatSlider.Checked = Convert.ToBoolean(dgvImages.SelectedRows[0].Cells["CatSlider"].Value);
cbMainSlider.Checked = Convert.ToBoolean(dgvImages.SelectedRows[0].Cells["MainSlider"].Value);
}
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
else
{
pcbxImage.Image = null;
Image FinishedProductImage = FinishedImagesCatalogManager.GetImage(ImageID);
if (FinishedProductImage != null)
{
pcbxImage.Image = FinishedProductImage;
if (pcbxImage.Image == null)
{
pcbxImage.Cursor = Cursors.Default;
}
else
{
pcbxImage.Cursor = Cursors.Hand;
}
}
if (ImageID != 0)
{
kryptonRichTextBox6.Text = dgvImages.SelectedRows[0].Cells["Category"].Value.ToString();
kryptonRichTextBox5.Text = dgvImages.SelectedRows[0].Cells["Name"].Value.ToString();
kryptonRichTextBox4.Text = dgvImages.SelectedRows[0].Cells["Color"].Value.ToString();
kryptonRichTextBox1.Text = dgvImages.SelectedRows[0].Cells["Description"].Value.ToString();
kryptonRichTextBox2.Text = dgvImages.SelectedRows[0].Cells["Sizes"].Value.ToString();
kryptonRichTextBox3.Text = dgvImages.SelectedRows[0].Cells["Material"].Value.ToString();
cbToSite.Checked = Convert.ToBoolean(dgvImages.SelectedRows[0].Cells["ToSite"].Value);
cbCatSlider.Checked = Convert.ToBoolean(dgvImages.SelectedRows[0].Cells["CatSlider"].Value);
cbMainSlider.Checked = Convert.ToBoolean(dgvImages.SelectedRows[0].Cells["MainSlider"].Value);
}
}
}
private void SendReportButton_Click(object sender, EventArgs e)
{
if (OrdersManager.MainOrdersBindingSource.Count == 0)
{
return;
}
DetailsReport.Save = false;
DetailsReport.Send = false;
PhantomForm PhantomForm = new Infinium.PhantomForm();
PhantomForm.Show();
ClientReportMenu = new ClientReportMenu(this);
TopForm = ClientReportMenu;
ClientReportMenu.ShowDialog();
PhantomForm.Close();
DetailsReport.Save = ClientReportMenu.Save;
DetailsReport.Send = ClientReportMenu.Send;
PhantomForm.Dispose();
ClientReportMenu.Dispose();
TopForm = null;
if (!DetailsReport.Save && !DetailsReport.Send)
{
return;
}
int[] SelectedMegaOrders = OrdersManager.GetSelectedMegaOrders();
if (!OrdersManager.AreSelectedMegaOrdersOneClient)
{
Infinium.LightMessageBox.Show(ref TopForm, false,
"Выбраны заказы разных клиентов",
"Создание отчета");
return;
}
if (!OrdersManager.AreSelectedMegaOrdersAgree(SelectedMegaOrders))
{
Infinium.LightMessageBox.Show(ref TopForm, false,
"Выбранные заказы несогласованы",
"Создание отчета");
return;
}
int[] MainOrders = OrdersManager.GetMainOrders(SelectedMegaOrders);
decimal ComplaintProfilCost = 0;
decimal ComplaintTPSCost = 0;
decimal TransportCost = 0;
decimal AdditionalCost = 0;
int CurrencyTypeID = Convert.ToInt32(((DataRowView)OrdersManager.MegaOrdersBindingSource.Current).Row["CurrencyTypeID"]);
decimal Rate = Convert.ToDecimal(((DataRowView)OrdersManager.MegaOrdersBindingSource.Current).Row["PaymentRate"]);
int OrderNumber = Convert.ToInt32(((DataRowView)OrdersManager.MegaOrdersBindingSource.Current).Row["OrderNumber"]);
int ClientID = Convert.ToInt32(((DataRowView)OrdersManager.MegaOrdersBindingSource.Current).Row["ClientID"]);
for (int i = 0; i < MegaOrdersDataGrid.SelectedRows.Count; i++)
{
ComplaintProfilCost += Convert.ToDecimal(MegaOrdersDataGrid.SelectedRows[i].Cells["ComplaintProfilCost"].Value);
ComplaintTPSCost += Convert.ToDecimal(MegaOrdersDataGrid.SelectedRows[i].Cells["ComplaintTPSCost"].Value);
TransportCost += Convert.ToDecimal(MegaOrdersDataGrid.SelectedRows[i].Cells["TransportCost"].Value);
AdditionalCost += Convert.ToDecimal(MegaOrdersDataGrid.SelectedRows[i].Cells["AdditionalCost"].Value);
}
//CheckMainOrdersForm = new CheckMainOrdersForm(this, MainOrders, ref DecorCatalogOrder);
//TopForm = CheckMainOrdersForm;
//CheckMainOrdersForm.ShowDialog();
//int[] CheckedMainOrders = CheckMainOrdersForm.CheckedMainOrders;
//int[] CheckedOrderNumbers = CheckMainOrdersForm.CheckedOrderNumbers;
//PhantomForm.Close();
//PhantomForm.Dispose();
//CheckMainOrdersForm.Dispose();
//TopForm = null;
//if (!CheckMainOrdersForm.IsChecked)
// return;
//REPORT
string ClientName = OrdersManager.GetClientName(ClientID);
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
int[] SelectedOrderNumbers = OrdersManager.GetSelectedOrderNumbers();
string FileName = DetailsReport.Report(SelectedMegaOrders, SelectedOrderNumbers, MainOrders, ClientID, ClientName,
ComplaintProfilCost, ComplaintTPSCost, TransportCost, AdditionalCost,
OrdersManager.GetMainOrdersCost(MainOrders), CurrencyTypeID);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
if (!DetailsReport.Send)
{
return;
}
//SEND
T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Отправка письма.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
SendEmail.Send(ClientID, string.Join(",", SelectedOrderNumbers), DetailsReport.Save, FileName);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
if (SendEmail.Success == false)
{
//MessageBox.Show(ExcMessage);
Infinium.LightMessageBox.Show(ref TopForm, false,
"Отправка отчета невозможна: отсутствует подключение к интернету либо адрес электронной почты указан неверно",
"Отправка письма");
}
if (!DetailsReport.Save)
{
SendEmail.DeleteFile(FileName);
}
}
private void Filter()
{
bool bClient = ClientCheckBox.Checked;
bool NotAgreed = NotAgreedCheckBox.Checked;
bool OnAgreement = OnAgreementCheckBox.Checked;
bool NotConfirm = NotConfirmCheckBox.Checked;
bool Confirm = ConfirmCheckBox.Checked;
bool OnProduction = OnProductionCheckBox.Checked;
bool NotInProduction = NotProductionCheckBox.Checked;
bool InProduction = InProductionCheckBox.Checked;
bool OnStorage = OnStorageCheckBox.Checked;
bool OnExpedition = cbOnExpedition.Checked;
bool Dispatch = DispatchCheckBox.Checked;
bool bsDelayOfPayment = cbDelayOfPayment.Checked;
bool bsHalfOfPayment = cbHalfOfPayment.Checked;
bool bsFullPayment = cbFullPayment.Checked;
bool bsFactoring = cbFactoring.Checked;
bool bsHalfOfPayment2 = kryptonCheckBox1.Checked;
bool bsDelayOfPayment2 = kryptonCheckBox2.Checked;
int ClientID = -1;
if (NeedSplash)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
NeedSplash = false;
if (bClient && FilterClientsDataGrid.SelectedRows.Count > 0)
{
ClientID = Convert.ToInt32(FilterClientsDataGrid.SelectedRows[0].Cells["ClientID"].Value);
}
OrdersManager.GetOrdersInMuttlements(
NotAgreed,
OnAgreement,
NotConfirm,
Confirm,
bsDelayOfPayment, bsHalfOfPayment, bsFullPayment, bsFactoring, bsHalfOfPayment2, bsDelayOfPayment2);
OrdersManager.FilterMegaOrders(
bClient, ClientID,
NotAgreed,
OnAgreement,
NotConfirm,
Confirm,
OnProduction,
NotInProduction,
InProduction,
OnStorage,
OnExpedition,
Dispatch, bsDelayOfPayment, bsHalfOfPayment, bsFullPayment, bsFactoring, bsHalfOfPayment2, bsDelayOfPayment2);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
else
{
if (bClient && FilterClientsDataGrid.SelectedRows.Count > 0)
{
ClientID = Convert.ToInt32(FilterClientsDataGrid.SelectedRows[0].Cells["ClientID"].Value);
}
OrdersManager.GetOrdersInMuttlements(
NotAgreed,
OnAgreement,
NotConfirm,
Confirm,
bsDelayOfPayment, bsHalfOfPayment, bsFullPayment, bsFactoring, bsHalfOfPayment2, bsDelayOfPayment2);
OrdersManager.FilterMegaOrders(
bClient, ClientID,
NotAgreed,
OnAgreement,
NotConfirm,
Confirm,
OnProduction,
NotInProduction,
InProduction,
OnStorage,
OnExpedition,
Dispatch, bsDelayOfPayment, bsHalfOfPayment, bsFullPayment, bsFactoring, bsHalfOfPayment2, bsDelayOfPayment2);
}
}
private void SavePackagesButton_Click(object sender, EventArgs e)
{
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Сохранение упаковок.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
if (!PackagesAllocManager.IsSimpleAndCurved)
{
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
Infinium.LightMessageBox.Show(ref TopForm, false,
"В одной упаковке не могут лежать гнутые и негнутые фасады. Перепакуйте",
"Ошибка сохранения упаковок");
return;
}
if (PackagesAllocManager.IsOverflow == false)
{
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
Infinium.LightMessageBox.Show(ref TopForm, false,
"В упаковке больше 6 позиций. Перепакуйте",
"Ошибка сохранения упаковок");
return;
}
if (PackagesAllocManager.IsConsequence == false)
{
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
Infinium.LightMessageBox.Show(ref TopForm, false,
"Упаковки в заказе непоследовательны!",
"Ошибка сохранения упаковок");
return;
}
if (PackagesAllocManager.IsDifferentPackNumbers == false)
{
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
Infinium.LightMessageBox.Show(ref TopForm, false,
"Фасады и декор находятся в одной упаковке",
"Ошибка сохранения упаковок");
return;
}
if (MainOrdersDataGrid.SelectedRows.Count > 0 &&
Convert.ToInt32(MainOrdersDataGrid.SelectedRows[0].Cells["FactoryID"].Value) == 0)
{
if (PackagesAllocManager.PackagesMainOrdersFrontsOrders.FrontsOrdersBindingSource.Count > 0)
{
if (!PackagesAllocManager.PackagesMainOrdersFrontsOrders.IsPacked)
{
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
Infinium.LightMessageBox.Show(ref TopForm, false,
"Заказ на обеих фирмах. Не все фасады запакованы",
"Ошибка сохранения упаковок");
return;
}
}
if (PackagesAllocManager.PackagesMainOrdersDecorOrders.DecorOrdersBindingSource.Count > 0)
{
if (!PackagesAllocManager.PackagesMainOrdersDecorOrders.IsPacked)
{
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
Infinium.LightMessageBox.Show(ref TopForm, false,
"Заказ на обеих фирмах. Не весь декор запакован",
"Ошибка сохранения упаковок");
return;
}
}
}
PackagesAllocManager.SavePackageDetails();
PackagesAllocManager.SetPackStatus();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
private void dgvWorks_SelectionChanged(object sender, EventArgs e)
{
if (dgvWorks.SelectedRows.Count == 0)
{
_plannedWorkManager.UpdateExecutors(0);
_plannedWorkManager.UpdateFiles(0);
return;
}
int plannedWorkId = 0;
int plannedWorkStatusId = 0;
if (dgvWorks.SelectedRows[0].Cells["PlannedWorkID"].Value != DBNull.Value)
{
plannedWorkId = Convert.ToInt32(dgvWorks.SelectedRows[0].Cells["PlannedWorkID"].Value);
}
if (dgvWorks.SelectedRows[0].Cells["PlannedWorkStatusID"].Value != DBNull.Value)
{
plannedWorkStatusId = Convert.ToInt32(dgvWorks.SelectedRows[0].Cells["PlannedWorkStatusID"].Value);
}
if (NeedSplash)
{
Thread T =
new Thread(
delegate()
{
SplashWindow.CreateSmallSplash(ref _topForm, "Обновление данных.\r\nПодождите...");
});
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
_plannedWorkManager.UpdateExecutors(plannedWorkId);
_plannedWorkManager.UpdateFiles(plannedWorkId);
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
else
{
_plannedWorkManager.UpdateExecutors(plannedWorkId);
_plannedWorkManager.UpdateFiles(plannedWorkId);
}
if (_roleType == RoleTypes.Ordinary)
{
btnConfirm.Enabled = false;
btnStart.Enabled = false;
btnEnd.Enabled = false;
}
else
{
switch (plannedWorkStatusId)
{
case 1:
btnConfirm.Enabled = true;
btnStart.Enabled = false;
btnEnd.Enabled = false;
break;
case 2:
btnConfirm.Enabled = false;
btnStart.Enabled = true;
btnEnd.Enabled = false;
break;
case 3:
btnConfirm.Enabled = false;
btnStart.Enabled = false;
btnEnd.Enabled = true;
break;
case 4:
btnConfirm.Enabled = false;
btnStart.Enabled = false;
btnEnd.Enabled = false;
break;
default:
btnConfirm.Enabled = false;
btnStart.Enabled = false;
btnEnd.Enabled = false;
break;
}
}
}
private void dgvGeneralSummary_SelectionChanged(object sender, EventArgs e)
{
lbAllSFSquare.Text = string.Empty;
lbAllSFCount.Text = string.Empty;
lbAllCFCount.Text = string.Empty;
lbOnProdSFSquare.Text = string.Empty;
lbOnProdSFCount.Text = string.Empty;
lbOnCFCount.Text = string.Empty;
lbInProdSFSquare.Text = string.Empty;
lbInProdSFCount.Text = string.Empty;
lbInCFCount.Text = string.Empty;
lbReadySFSquare.Text = string.Empty;
lbReadySFCount.Text = string.Empty;
lbReadyCFCount.Text = string.Empty;
lbAllDecorPogon.Text = string.Empty;
lbAllDecorCount.Text = string.Empty;
lbOnProdDecorPogon.Text = string.Empty;
lbOnProdDecorCount.Text = string.Empty;
lbInProdDecorPogon.Text = string.Empty;
lbInProdDecorCount.Text = string.Empty;
lbReadyDecorPogon.Text = string.Empty;
lbReadyDecorCount.Text = string.Empty;
if (BatchStatistics == null)
{
return;
}
if (dgvGeneralSummary.Rows.Count == 0)
{
BatchStatistics.ClearProductTables();
return;
}
bool Profil = BatchProfilCheckBox.Checked;
bool TPS = BatchTPSCheckBox.Checked;
int FactoryID = 0;
decimal AllSquare = 0;
decimal OnProdSquare = 0;
decimal InProdSquare = 0;
decimal ReadySquare = 0;
int AllCount = 0;
int OnProdCount = 0;
int InProdCount = 0;
int ReadyCount = 0;
int AllCurvedCount = 0;
int OnProdCurvedCount = 0;
int InProdCurvedCount = 0;
int ReadyCurvedCount = 0;
decimal AllDecorPogon = 0;
decimal OnProdDecorPogon = 0;
decimal InProdDecorPogon = 0;
decimal ReadyDecorPogon = 0;
int AllDecorCount = 0;
int OnProdDecorCount = 0;
int InProdDecorCount = 0;
int ReadyDecorCount = 0;
if (Profil && !TPS)
{
FactoryID = 1;
}
if (!Profil && TPS)
{
FactoryID = 2;
}
if (!Profil && !TPS)
{
FactoryID = -1;
}
int GroupType = -1;
int MegaBatchID = -1;
if (dgvGeneralSummary.SelectedRows.Count != 0 && dgvGeneralSummary.SelectedRows[0].Cells["GroupType"].Value != DBNull.Value)
{
GroupType = Convert.ToInt32(dgvGeneralSummary.SelectedRows[0].Cells["GroupType"].Value);
}
if (dgvGeneralSummary.SelectedRows.Count != 0 && dgvGeneralSummary.SelectedRows[0].Cells["MegaBatchID"].Value != DBNull.Value)
{
MegaBatchID = Convert.ToInt32(dgvGeneralSummary.SelectedRows[0].Cells["MegaBatchID"].Value);
}
if (NeedSplash)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
if (cbtnSimpleFronts.Checked)
{
BatchStatistics.FilterSimpleFrontsOrders(GroupType, MegaBatchID, FactoryID);
BatchStatistics.GetSimpleFrontsInfo(ref AllSquare, ref OnProdSquare, ref InProdSquare, ref ReadySquare,
ref AllCount, ref OnProdCount, ref InProdCount, ref ReadyCount);
}
if (cbtnCurvedFronts.Checked)
{
BatchStatistics.FilterCurvedFrontsOrders(GroupType, MegaBatchID, FactoryID);
BatchStatistics.GetCurvedFrontsInfo(ref AllCurvedCount, ref OnProdCurvedCount, ref InProdCurvedCount, ref ReadyCurvedCount);
}
if (cbtnDecor.Checked)
{
BatchStatistics.FilterDecorOrders(GroupType, MegaBatchID, FactoryID);
BatchStatistics.GetDecorInfo(ref AllDecorPogon, ref OnProdDecorPogon, ref InProdDecorPogon, ref ReadyDecorPogon,
ref AllDecorCount, ref OnProdDecorCount, ref InProdDecorCount, ref ReadyDecorCount);
}
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
else
{
if (cbtnSimpleFronts.Checked)
{
BatchStatistics.FilterSimpleFrontsOrders(GroupType, MegaBatchID, FactoryID);
BatchStatistics.GetSimpleFrontsInfo(ref AllSquare, ref OnProdSquare, ref InProdSquare, ref ReadySquare,
ref AllCount, ref OnProdCount, ref InProdCount, ref ReadyCount);
}
if (cbtnCurvedFronts.Checked)
{
BatchStatistics.FilterCurvedFrontsOrders(GroupType, MegaBatchID, FactoryID);
BatchStatistics.GetCurvedFrontsInfo(ref AllCurvedCount, ref OnProdCurvedCount, ref InProdCurvedCount, ref ReadyCurvedCount);
}
if (cbtnDecor.Checked)
{
BatchStatistics.FilterDecorOrders(GroupType, MegaBatchID, FactoryID);
BatchStatistics.GetDecorInfo(ref AllDecorPogon, ref OnProdDecorPogon, ref InProdDecorPogon, ref ReadyDecorPogon,
ref AllDecorCount, ref OnProdDecorCount, ref InProdDecorCount, ref ReadyDecorCount);
}
}
NumberFormatInfo nfi1 = new NumberFormatInfo()
{
CurrencyGroupSeparator = " ",
CurrencySymbol = string.Empty,
CurrencyDecimalDigits = 2,
CurrencyDecimalSeparator = ".",
NumberGroupSeparator = " ",
NumberDecimalDigits = 2,
NumberDecimalSeparator = ","
};
NumberFormatInfo nfi2 = new NumberFormatInfo()
{
NumberGroupSeparator = " ",
NumberDecimalSeparator = ","
};
lbAllSFSquare.Text = AllSquare.ToString("N", nfi1);
lbAllSFCount.Text = AllCount.ToString();
lbAllCFCount.Text = AllCurvedCount.ToString();
lbOnProdSFSquare.Text = OnProdSquare.ToString("N", nfi1);
lbOnProdSFCount.Text = OnProdCount.ToString();
lbOnCFCount.Text = OnProdCurvedCount.ToString();
lbInProdSFSquare.Text = InProdSquare.ToString("N", nfi1);
lbInProdSFCount.Text = InProdCount.ToString();
lbInCFCount.Text = InProdCurvedCount.ToString();
lbReadySFSquare.Text = ReadySquare.ToString("N", nfi1);
lbReadySFCount.Text = ReadyCount.ToString();
lbReadyCFCount.Text = ReadyCurvedCount.ToString();
lbAllDecorPogon.Text = AllDecorPogon.ToString("N", nfi1);
lbAllDecorCount.Text = AllDecorCount.ToString();
lbOnProdDecorPogon.Text = OnProdDecorPogon.ToString("N", nfi1);
lbOnProdDecorCount.Text = OnProdDecorCount.ToString();
lbInProdDecorPogon.Text = InProdDecorPogon.ToString("N", nfi1);
lbInProdDecorCount.Text = InProdDecorCount.ToString();
lbReadyDecorPogon.Text = ReadyDecorPogon.ToString("N", nfi1);
lbReadyDecorCount.Text = ReadyDecorCount.ToString();
}
//Распечатать все этикетки в одном заказе
private void PrintMegaOrderContextMenuItem_Click(object sender, EventArgs e)
{
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Создание этикеток.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
if (MarketingPackagesPrintManager.MegaOrdersBindingSource.Count < 1)
{
return;
}
MarketingPackagesPrintManager.MegaOrdersBindingSource.Position = CurrentRowIndex;
//Проверка
int MegaOrderID = Convert.ToInt32(((DataRowView)MarketingPackagesPrintManager.MegaOrdersBindingSource.Current).Row["MegaOrderID"]);
int MainOrderID = 0;
if (!MarketingPackagesPrintManager.IsMegaOrderPacked(MegaOrderID, ref MainOrderID))
{
Infinium.LightMessageBox.Show(ref TopForm, false,
"Этикетки распечатать нельзя. Подзаказ № " + MainOrderID + " должен быть полностью распределен на обеих фирмах",
"Ошибка печати");
return;
}
int[] MainOrders = MarketingPackagesPrintManager.GetMainOrders();
int PackNumber = 0;
int PackageID = 0;
int ProductType = 0;
ArrayList PackageIDs = new ArrayList();
PackageLabel.ClearLabelInfo();
DataTable TempPackagesDataTable = new DataTable();
for (int j = 0; j < MainOrders.Count(); j++)
{
TempPackagesDataTable = MarketingPackagesPrintManager.TempPackages(MainOrders[j], FrontIDs, ProductIDs).Copy();
for (int i = 0; i < TempPackagesDataTable.Rows.Count; i++)
{
DataTable DT = new DataTable();
Infinium.Modules.Packages.Marketing.Info LabelInfo = new Modules.Packages.Marketing.Info();
ProductType = Convert.ToInt32(TempPackagesDataTable.Rows[i]["ProductType"]);
PackNumber = Convert.ToInt32(TempPackagesDataTable.Rows[i]["PackNumber"]);
PackageID = Convert.ToInt32(TempPackagesDataTable.Rows[i]["PackageID"]);
PackageIDs.Add(PackageID);
if (ProductType == 0)
{
ProductType = 0;
GetPackageInfo(MainOrders[j], PackNumber, ProductType, PackageID, ref LabelInfo);
LabelInfo.ProductType = ProductType;
PrintBarCode.FilterFrontsOrders(MainOrders[j], PackageID);
LabelInfo.TechnoInset = PrintBarCode.TechnoInset;
DT = PrintBarCode.FillFrontsDataTable().Copy();
}
if (ProductType == 1)
{
ProductType = 1;
GetPackageInfo(MainOrders[j], PackNumber, ProductType, PackageID, ref LabelInfo);
LabelInfo.ProductType = ProductType;
PrintBarCode.FilterDecorOrders(MainOrders[j], PackageID);
DT = PrintBarCode.FillDecorDataTable().Copy();
}
LabelInfo.OrderData = DT;
LabelInfo.GroupType = "М";
PackageLabel.AddLabelInfo(0, ref LabelInfo);
MarketingPackagesPrintManager.FilterPackages(MainOrders[j], FrontIDs, ProductIDs);
}
}
PrintDialog.Document = PackageLabel.PD;
if (PrintDialog.ShowDialog() == DialogResult.OK)
{
for (int i = 0; i < PackageIDs.Count; i++)
{
PackageID = Convert.ToInt32(PackageIDs[i]);
MarketingPackagesPrintManager.PrintedCountUp(PackageID);
}
PackageLabel.Print();
}
TempPackagesDataTable.Dispose();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
}
private void FilterExpedition()
{
bool Profil = ExpProfilCheckBox.Checked;
bool TPS = ExpTPSCheckBox.Checked;
int FactoryID = 0;
if (Profil && !TPS)
{
FactoryID = 1;
}
if (!Profil && TPS)
{
FactoryID = 2;
}
if (!Profil && !TPS)
{
FactoryID = -1;
}
if (NeedSplash)
{
NeedSplash = false;
Thread T = new Thread(delegate() { SplashWindow.CreateSmallSplash(ref TopForm, "Загрузка данных с сервера.\r\nПодождите..."); });
T.Start();
while (!SplashWindow.bSmallCreated)
{
;
}
StorageStatistics.ShowColumns(ref PrepareFSummaryDG, ref PrepareCurvedFSummaryDG, ref PrepareDSummaryDG, Profil, TPS);
StorageStatistics.PrepareOrders(FactoryID);
PrepareFSummaryDG.BringToFront();
PrepareCurvedFSummaryDG.BringToFront();
PrepareDSummaryDG.BringToFront();
FrontsPrepareLabel.Visible = true;
FrontsZOVLabel.Visible = false;
DecorPrepareLabel.Visible = true;
DecorZOVLabel.Visible = false;
if (!StorageStatistics.HasCurvedFronts)
{
StorageStatistics.ClearCurvedFrontsOrders(2);
}
if (!StorageStatistics.HasFronts)
{
StorageStatistics.ClearFrontsOrders(2);
}
if (!StorageStatistics.HasDecor)
{
StorageStatistics.ClearDecorOrders(2);
}
ExpCurvedFrontsInfo();
ExpFrontsInfo();
ExpDecorInfo();
while (SplashWindow.bSmallCreated)
{
SmallWaitForm.CloseS = true;
}
NeedSplash = true;
}
}
