private void DeleteItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Ви дійсно бажаєте відалити цей запис з довідника?", "Підтвердіть видалення", MessageBoxButtons.YesNo, MessageBoxIcon.Information) != DialogResult.Yes)
{
return;
}
switch (focused_tree_node.GType)
{
case 1:
var u = UsersGridView.GetFocusedRow() as v_Users;
using (var db = DB.SkladBase())
{
db.DeleteWhere <Users>(w => w.UserId == u.UserId);
}
break;
//case 3: SkladData->DBList->Delete(); break ;
case 5: //if(cxGrid4->ActiveLevel->Index == 0 ) OperLog->Delete();
//if(cxGrid4->ActiveLevel->Index == 1) PrintLog->Delete();
if (xtraTabControl2.SelectedTabPageIndex == 2)
{
var er = ErrorLogGridView.GetFocusedRow() as v_ErrorLog;
using (var db = DB.SkladBase())
{
db.DeleteWhere <ErrorLog>(w => w.Id == er.Id);
}
}
break;
}
RefrechItemBtn.PerformClick();
}
private void wbStartDate_EditValueChanged(object sender, EventArgs e)
{
// if (OnDateEdit.ContainsFocus || whKagentList.ContainsFocus)
// {
RefrechItemBtn.PerformClick();
// }
}
private void DeleteItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var pd_row = MoneyMoveGridView.GetFocusedRow() as MoneyMoveList_Result;
using (var db = new BaseEntities())
{
try
{
switch (focused_tree_node.GType)
{
case 2: db.Database.SqlQuery <PayDoc>("SELECT * from PayDoc WITH (UPDLOCK) where PayDocId = {0}", pd_row.PayDocId).FirstOrDefault(); break;
}
if (MessageBox.Show(Resources.delete_wb, "Відалення документа", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
switch (focused_tree_node.GType)
{
case 2:
var pd = db.PayDoc.Find(pd_row.PayDocId);
db.PayDoc.Remove(pd);
break;
}
db.SaveChanges();
}
}
catch
{
MessageBox.Show(Resources.deadlock);
}
}
RefrechItemBtn.PerformClick();
}
private void ExecuteItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (focused_tree_node == null)
{
return;
}
switch (focused_tree_node.GType)
{
case 2:
var pd_row = MoneyMoveGridView.GetFocusedRow() as MoneyMoveList_Result;
using (var db = new BaseEntities())
{
var pd = db.PayDoc.Find(pd_row.PayDocId);
pd.Checked = pd_row.Checked == 0 ? 1 : 0;
var pd_to = db.PayDoc.FirstOrDefault(w => w.OperId == pd.OperId);
if (pd_to != null)
{
pd_to.Checked = pd.Checked;
}
db.SaveChanges();
}
break;
}
RefrechItemBtn.PerformClick();
}
private void wbStartDate_EditValueChanged(object sender, EventArgs e)
{
if (wbStartDate.ContainsFocus || wbEndDate.ContainsFocus || wbStatusList.ContainsFocus || PayDocTypeEdit.CanFocus)
{
RefrechItemBtn.PerformClick();
}
}
private void whKagentList_EditValueChanged(object sender, EventArgs e)
{
if (OnDateEdit.ContainsFocus || whKagentList.ContainsFocus)
{
RefrechItemBtn.PerformClick();
}
}
private void CopyItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
switch (focused_tree_node.GType)
{
case 2:
var dr = MoneyMoveGridView.GetFocusedRow() as MoneyMoveList_Result;
var doc = DB.SkladBase().DocCopy(dr.Id, DBHelper.CurrentUser.KaId).FirstOrDefault();
if (dr.DocType == 6)
{
using (var money_corr = new frmMoneyCorrecting(doc.out_wbill_id))
{
money_corr.ShowDialog();
}
}
if (dr.DocType == 3)
{
using (var money_move = new frmMoneyMove(doc.out_wbill_id))
{
money_move.ShowDialog();
}
}
break;
}
RefrechItemBtn.PerformClick();
}
private void FinancesTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
DeleteItemBtn.Enabled = false;
ExecuteItemBtn.Enabled = false;
EditItemBtn.Enabled = false;
CopyItemBtn.Enabled = false;
PrintItemBtn.Enabled = false;
cur_wtype = focused_tree_node.WType != null ? focused_tree_node.WType.Value : 0;
RefrechItemBtn.PerformClick();
wbContentTab.SelectedTabPageIndex = focused_tree_node.GType.Value;
if (focused_tree_node.FunId != null)
{
History.AddEntry(new HistoryEntity {
FunId = focused_tree_node.FunId.Value, MainTabs = 3
});
if (FinancesTreeList.ContainsFocus)
{
Settings.Default.LastFunId = focused_tree_node.FunId.Value;
}
}
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (var frm = new frmMoneyMove())
{
frm.ShowDialog();
}
RefrechItemBtn.PerformClick();
}
private void NewItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (var frm = new frmMoneyCorrecting())
{
frm.ShowDialog();
}
RefrechItemBtn.PerformClick();
}
private void checkedComboBoxEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (e.Button.Index == 1)
{
for (int i = 0; i < checkedComboBoxEdit1.Properties.Items.Count; i++)
{
checkedComboBoxEdit1.Properties.Items[i].CheckState = CheckState.Unchecked;
}
RefrechItemBtn.PerformClick();
}
}
private void DeleteItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var dr = WbGridView.GetFocusedRow() as GetWayBillListWh_Result;
if (dr == null)
{
return;
}
using (var db = new BaseEntities())
{
try
{
switch (focused_tree_node.GType)
{
case 2: db.Database.SqlQuery <WaybillList>("SELECT * from WaybillList WITH (UPDLOCK) where WbillId = {0}", dr.WBillId).FirstOrDefault();
break;
}
if (MessageBox.Show(Resources.delete_wb, "Видалити докумен", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
switch (focused_tree_node.GType)
{
case 2:
var wb = db.WaybillList.FirstOrDefault(w => w.WbillId == dr.WBillId.Value && w.SessionId == null);
if (wb != null)
{
db.WaybillList.Remove(wb);
}
else
{
MessageBox.Show(Resources.deadlock);
}
break;
}
db.SaveChanges();
}
}
catch
{
MessageBox.Show(Resources.deadlock);
}
/* finally
* {
* // trans.Commit();
* }*/
}
RefrechItemBtn.PerformClick();
}
private void EditItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (var db = new BaseEntities())
{
switch (focused_tree_node.GType)
{
case 2:
WhDocEdit.WBEdit(WbGridView.GetFocusedRow() as GetWayBillListWh_Result);
break;
}
}
RefrechItemBtn.PerformClick();
}
private void checkedComboBoxEdit1_EditValueChanged(object sender, EventArgs e)
{
if (checkedComboBoxEdit1.ContainsFocus)
{
wh_list = checkedComboBoxEdit1.Properties.Items.Any(w => w.CheckState == CheckState.Checked) ? "" : "*";
foreach (var item in checkedComboBoxEdit1.Properties.Items.Where(w => w.CheckState == CheckState.Checked))
{
wh_list += item.Value.ToString() + ",";
}
RefrechItemBtn.PerformClick();
}
}
private void WHTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
DeleteItemBtn.Enabled = false;
ExecuteItemBtn.Enabled = false;
EditItemBtn.Enabled = false;
CopyItemBtn.Enabled = false;
PrintItemBtn.Enabled = false;
focused_tree_node = WHTreeList.GetDataRecordByNode(e.Node) as GetWhTree_Result;
cur_wtype = focused_tree_node.WType != null ? focused_tree_node.WType.Value : 0;
/* if (focused_tree_node.GType.Value == 1 && wh_mat_list != null && ByGrpBtn.Down && wh_mat_list.Any())
* {
* if (ViewDetailTree.Down && ByGrpBtn.Down && focused_tree_node.Num != 0)
* {
* var grp = DB.SkladBase().GetMatGroupTree(focused_tree_node.Num).ToList().Select(s => s.GrpId);
* WhMatGetBS.DataSource = wh_mat_list.Where(w => grp.Contains(w.OutGrpId));
* }
* else
* {
* WhMatGetBS.DataSource = wh_mat_list.Where(w => w.OutGrpId == focused_tree_node.Num || focused_tree_node.Num == 0);
* }
* }
* else
* {
* RefrechItemBtn.PerformClick();
* }*/
RefrechItemBtn.PerformClick();
whContentTab.SelectedTabPageIndex = focused_tree_node.GType.Value;
if (focused_tree_node.FunId != null)
{
History.AddEntry(new HistoryEntity {
FunId = focused_tree_node.FunId.Value, MainTabs = 2
});
if (WHTreeList.ContainsFocus)
{
Settings.Default.LastFunId = focused_tree_node.FunId.Value;
}
}
}
private void NewItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (focused_tree_node == null)
{
return;
}
switch (focused_tree_node.GType.Value)
{
case 1:
using (var wb_make = new frmWBManufacture(null))
{
wb_make.ShowDialog();
}
break;
case 3:
using (var wb_make = new frmWBDeboning(null))
{
wb_make.ShowDialog();
}
break;
case 4:
using (var wb_pp = new frmProductionPlans(null))
{
wb_pp.ShowDialog();
}
break;
case 5:
using (var wb_pc = new frmPlannedCalculation())
{
wb_pc.ShowDialog();
}
break;
case 6:
using (var wb_make = new frmPreparationRawMaterials(null))
{
wb_make.ShowDialog();
}
break;
}
RefrechItemBtn.PerformClick();
}
private void EditItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (focused_tree_node == null)
{
return;
}
switch (focused_tree_node.GType)
{
case 2:
var dr = MoneyMoveGridView.GetFocusedRow() as MoneyMoveList_Result;
DocEdit.FinDocEdit(dr);
break;
}
RefrechItemBtn.PerformClick();
}
private void CopyItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
switch (focused_tree_node.GType)
{
case 1:
var doc = DB.SkladBase().DocCopy(focused_row.Id, DBHelper.CurrentUser.KaId).FirstOrDefault();
using (var wb_in = new frmWBManufacture(doc.out_wbill_id))
{
wb_in.is_new_record = true;
wb_in.ShowDialog();
}
break;
case 3:
var doc2 = DB.SkladBase().DocCopy(focused_row.Id, DBHelper.CurrentUser.KaId).FirstOrDefault();
using (var wb_in = new frmWBDeboning(doc2.out_wbill_id))
{
wb_in.is_new_record = true;
wb_in.ShowDialog();
}
break;
case 4:
var new_pp = DB.SkladBase().DocCopy(pp_focused_row.Id, DBHelper.CurrentUser.KaId).FirstOrDefault();
using (var wb_in = new frmProductionPlans(new_pp.out_doc_id))
{
wb_in.is_new_record = true;
wb_in.ShowDialog();
}
break;
case 5:
var pc_copy = DB.SkladBase().DocCopy(pc_focused_row.Id, DBHelper.CurrentUser.KaId).FirstOrDefault();
using (var pc = new frmPlannedCalculation(pc_copy.out_doc_id))
{
pc.is_new_record = true;
pc.ShowDialog();
}
break;
}
RefrechItemBtn.PerformClick();
}
private void EditItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
switch (focused_tree_node.GType)
{
case 1:
var u = UsersGridView.GetFocusedRow() as v_Users;
new frmUserEdit(u.UserId).ShowDialog();
RefrechItemBtn.PerformClick();
break;
/* case 3: frmDBEdit = new TfrmDBEdit(Application);
* SkladData->DBList->Open();
* SkladData->DBList->Edit();
* if (frmDBEdit->ShowModal() == mrOk)
* {
* SkladData->DBList->Post();
* if (SkladData->DBListdef->Value == 1)
* {
* int id = SkladData->DBListDBID->Value;
* for (SkladData->DBList->First(); !SkladData->DBList->Eof; SkladData->DBList->Next())
* {
* if (id != SkladData->DBListDBID->Value)
* {
* SkladData->DBList->Edit();
* SkladData->DBListdef->Value = 0;
* SkladData->DBList->Post();
* }
* }
* SkladData->DBList->Locate("DBID", id, TLocateOptions());
* }
*
* }
* else SkladData->DBList->Cancel();
* delete frmDBEdit;
* break;*/
case 5:
var f = new frmOperLogDet();
f.OperLogDetBS.DataSource = OprLogGridView.GetFocusedRow();
f.ShowDialog();
break;
}
}
private void EditItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (var db = new BaseEntities())
{
switch (focused_tree_node.GType)
{
case 1:
ManufDocEdit.WBEdit(focused_row.WType, focused_row.WbillId);
break;
case 3:
ManufDocEdit.WBEdit(focused_row.WType, focused_row.WbillId);
break;
case 4:
var row = ProductionPlansGridView.GetFocusedRow() as ProductionPlansList_Result;
using (var f = new frmProductionPlans(row.Id))
{
f.ShowDialog();
}
break;
case 5:
var pc_row = PlannedCalculationGridView.GetFocusedRow() as v_PlannedCalculation;
using (var f = new frmPlannedCalculation(pc_row.Id))
{
f.ShowDialog();
}
break;
case 6:
ManufDocEdit.WBEdit(focused_prep_raw_mat_row.WType, focused_prep_raw_mat_row.WbillId);
break;
}
}
RefrechItemBtn.PerformClick();
}
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as GetServiceTree_Result;
RefrechItemBtn.PerformClick();
mainContentTab.SelectedTabPageIndex = focused_tree_node.GType.Value;
if (focused_tree_node.FunId != null)
{
History.AddEntry(new HistoryEntity {
FunId = focused_tree_node.FunId.Value, MainTabs = 6
});
if (DirTreeList.ContainsFocus)
{
Settings.Default.LastFunId = focused_tree_node.FunId.Value;
}
}
}
private void NewItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
switch (focused_tree_node.GType)
{
case 2:
if (focused_tree_node.Id == 48)
{
using (var wb_move = new frmWayBillMove())
{
wb_move.ShowDialog();
}
}
if (focused_tree_node.Id == 58)
{
using (var wb_on = new frmWBWriteOn())
{
wb_on.ShowDialog();
}
}
if (focused_tree_node.Id == 54)
{
using (var wb_on = new frmWBWriteOff())
{
wb_on.ShowDialog();
}
}
if (focused_tree_node.Id == 104)
{
using (var wb_inv = new frmWBInventory())
{
wb_inv.ShowDialog();
}
}
break;
}
RefrechItemBtn.PerformClick();
}
private void ExecuteItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (var db = new BaseEntities())
{
switch (focused_tree_node.GType)
{
case 2:
if (focused_row == null)
{
return;
}
var wb = db.WaybillList.Find(focused_row.WBillId);
if (wb == null)
{
MessageBox.Show(Resources.not_find_wb);
return;
}
if (wb.SessionId != null)
{
MessageBox.Show(Resources.deadlock);
return;
}
if (wb.Checked == 1)
{
DBHelper.StornoOrder(db, focused_row.WBillId.Value);
}
else
{
DBHelper.ExecuteOrder(db, focused_row.WBillId.Value);
}
break;
}
}
RefrechItemBtn.PerformClick();
}
private void NewItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
switch (focused_tree_node.GType)
{
case 1:
new frmUserEdit().ShowDialog();
RefrechItemBtn.PerformClick();
break;
/* case 3: frmDBEdit = new TfrmDBEdit(Application);
* SkladData->DBList->Open();
* SkladData->DBList->Append();
* if(frmDBEdit->ShowModal()== mrOk)
* {
* SkladData->DBList->Post();
* } else SkladData->DBList->Cancel();
* delete frmDBEdit;
* break;*/
}
RefrechItemBtn.PerformClick();
}
private void StopProcesBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
using (var db = DB.SkladBase())
{
var wb_id = 0;
switch (focused_tree_node.GType)
{
case 1:
case 3:
wb_id = focused_row.WbillId;
break;
case 6:
wb_id = focused_prep_raw_mat_row.WbillId;
break;
}
var wbl = db.WaybillList.FirstOrDefault(w => w.WbillId == wb_id);
if (wbl == null)
{
return;
}
if (wbl.Checked == 2)
{
using (var f = new frmWBWriteOn())
{
var result = f._db.ExecuteWayBill(wbl.WbillId, null, DBHelper.CurrentUser.KaId).ToList().FirstOrDefault();
f.is_new_record = true;
f.doc_id = result.NewDocId;
f.TurnDocCheckBox.Checked = true;
f.ShowDialog();
}
}
}
RefrechItemBtn.PerformClick();
}
private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
dynamic s = gridView2.GetFocusedRow();
using (var db = DB.SkladBase())
{
Guid id = s.Id;
var wb = db.WaybillList.FirstOrDefault(w => w.Id == id);
if (wb != null)
{
wb.SessionId = null;
}
var pp = db.ProductionPlans.Find(id);
if (pp != null)
{
pp.SessionId = null;
}
db.SaveChanges();
RefrechItemBtn.PerformClick();
}
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var wbl = DB.SkladBase().WaybillList.FirstOrDefault(w => w.WbillId == focused_wb.WBillId);
if (wbl == null)
{
return;
}
if (wbl.Checked == 1 && !DB.SkladBase().GetRelDocList(wbl.Id).Any(w => w.DocType == -5) && wbl.WType == 7)
{
using (var f = new frmWBWriteOff())
{
var result = f._db.ExecuteWayBill(wbl.WbillId, -5, DBHelper.CurrentUser.KaId).ToList().FirstOrDefault();
f.doc_id = result.NewDocId;
f.TurnDocCheckBox.Checked = true;
f.is_new_record = true;
f.ShowDialog();
}
}
RefrechItemBtn.PerformClick();
}
private void DocsTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
focused_tree_node = DocsTreeList.GetDataRecordByNode(e.Node) as GetManufactureTree_Result;
NewItemBtn.Enabled = (focused_tree_node != null && focused_tree_node.CanInsert == 1);
CopyItemBtn.Enabled = false;
DeleteItemBtn.Enabled = false;
ExecuteItemBtn.Enabled = false;
EditItemBtn.Enabled = false;
PrintItemBtn.Enabled = false;
AddTechProcBtn.Enabled = false;
DelTechProcBtn.Enabled = false;
EditTechProcBtn.Enabled = false;
AddIntermediateWeighing.Enabled = false;
EditIntermediateWeighing.Enabled = false;
DelIntermediateWeighing.Enabled = false;
_cur_wtype = focused_tree_node.WType != null ? focused_tree_node.WType.Value : 0;
RefrechItemBtn.PerformClick();
wbContentTab.SelectedTabPageIndex = focused_tree_node.GType.Value;
if (focused_tree_node.FunId != null)
{
History.AddEntry(new HistoryEntity {
FunId = focused_tree_node.FunId.Value, MainTabs = 1
});
if (DocsTreeList.ContainsFocus)
{
Settings.Default.LastFunId = focused_tree_node.FunId.Value;
}
}
}
private void CopyItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
switch (focused_tree_node.GType)
{
case 2:
var dr = WbGridView.GetFocusedRow() as GetWayBillListWh_Result;
var doc = DB.SkladBase().DocCopy(dr.Id, DBHelper.CurrentUser.KaId).FirstOrDefault();
if (cur_wtype == 5) //Ввведення залишків
{
using (var wb_in = new frmWBWriteOn(doc.out_wbill_id))
{
wb_in.ShowDialog();
}
}
if (cur_wtype == -5) //Акти списання товару
{
using (var wb_in = new frmWBWriteOff(doc.out_wbill_id))
{
wb_in.ShowDialog();
}
}
if (cur_wtype == 4) // Накладна переміщення
{
using (var wb_re_in = new frmWayBillMove(doc.out_wbill_id))
{
wb_re_in.ShowDialog();
}
}
break;
}
RefrechItemBtn.PerformClick();
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var dr = WbGridView.GetRow(WbGridView.FocusedRowHandle) as WBListMake_Result;
if (dr == null)
{
return;
}
using (var f = new frmTechProcDet(dr.WbillId))
{
if (f.ShowDialog() == DialogResult.OK)
{
if (DB.SkladBase().WaybillList.Any(a => a.WbillId == dr.WbillId))
{
RefreshTechProcDet(dr.WbillId);
}
else
{
RefrechItemBtn.PerformClick();
}
}
}
}
