private void IntermediateWeighingGridView_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e)
{
focused_row = WbGridView.GetFocusedRow() as WBListMake_Result;
DelIntermediateWeighing.Enabled = ((focused_row != null && focused_row.Checked == 0 /* && focused_tree_node.CanModify == 1*/) && IntermediateWeighingGridView.DataRowCount > 0);
EditIntermediateWeighing.Enabled = (focused_row != null && focused_row.Checked == 0 /* && focused_tree_node.CanModify == 1*/ && IntermediateWeighingGridView.DataRowCount > 0);
}
private void TechProcGridView_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e)
{
focused_row = WbGridView.GetFocusedRow() as WBListMake_Result;
DelTechProcBtn.Enabled = ((focused_row != null && focused_row.Checked != 1 && focused_tree_node.CanModify == 1) && TechProcGridView.DataRowCount > 0);
EditTechProcBtn.Enabled = (focused_row != null && focused_tree_node.CanModify == 1 && TechProcGridView.DataRowCount > 0 /*&& focused_row.Checked != 1*/);
}
private void barButtonItem3_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var dr = WbGridView.GetRow(WbGridView.FocusedRowHandle) as WBListMake_Result;
var f = new frmWayBillMakePropsDet(dr.WbillId);
if (f.ShowDialog() == DialogResult.OK)
{
RefreshAtribute(dr.WbillId);
}
}
private void ManufacturingUserControl_Load(object sender, EventArgs e)
{
WbGridView.RestoreLayoutFromRegistry(IHelper.reg_layout_path + "ManufacturingUserControl\\WbGridView");
DeboningGridView.RestoreLayoutFromRegistry(IHelper.reg_layout_path + "ManufacturingUserControl\\DeboningGridView");
if (!DesignMode)
{
wbContentTab.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False;
WhComboBox.Properties.DataSource = new List <object>()
{
new { WId = "*", Name = "Усі" }
}.Concat(DBHelper.WhList.Select(s => new { WId = s.WId.ToString(), s.Name }).ToList());
WhComboBox.EditValue = "*";
DebWhComboBox.Properties.DataSource = WhComboBox.Properties.DataSource;
DebWhComboBox.EditValue = "*";
PrepRawMatWhList.Properties.DataSource = WhComboBox.Properties.DataSource;
PrepRawMatWhList.EditValue = "*";
wbSatusList.Properties.DataSource = new List <object>()
{
new { Id = -1, Name = "Усі" }, new { Id = 0, Name = "Актуальний" }, new { Id = 2, Name = "Розпочато виробництво" }, new { Id = 1, Name = "Закінчено виробництво" }
};
wbSatusList.EditValue = -1;
DebSatusList.Properties.DataSource = wbSatusList.Properties.DataSource;
DebSatusList.EditValue = -1;
PrepRawMatStatusList.Properties.DataSource = wbSatusList.Properties.DataSource;
PrepRawMatStatusList.EditValue = -1;
lookUpEdit2.Properties.DataSource = new List <object>()
{
new { Id = -1, Name = "Усі" }, new { Id = 1, Name = "Розпочато виробництво" }, new { Id = 0, Name = "Актуальний" }
};
lookUpEdit2.EditValue = -1;
wbStartDate.EditValue = DateTime.Now.Date.AddDays(-1);
wbEndDate.EditValue = DateTime.Now.Date.SetEndDay();
DebStartDate.EditValue = DateTime.Now.Date.AddDays(-1);
DebEndDate.EditValue = DateTime.Now.Date.SetEndDay();
PrepRawMatStartDate.EditValue = DateTime.Now.Date.AddDays(-1);
PrepRawMatEndDate.EditValue = DateTime.Now.Date.SetEndDay();
PlanStartDate.EditValue = DateTime.Now.Date.AddDays(-1);
PlanEndDate.EditValue = DateTime.Now.Date.SetEndDay();
dateEdit2.EditValue = DateTime.Now.Date.AddDays(-30);
dateEdit1.EditValue = DateTime.Now.Date.SetEndDay();
DocsTreeList.DataSource = DB.SkladBase().GetManufactureTree(DBHelper.CurrentUser.UserId).ToList();
DocsTreeList.ExpandAll(); //ExpandToLevel(0);
}
}
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 PrintItemBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
switch (focused_tree_node.GType)
{
case 2:
var dr = WbGridView.GetFocusedRow() as GetWayBillListWh_Result;
if (dr == null)
{
return;
}
PrintDoc.Show(dr.Id.Value, dr.WType.Value, DB.SkladBase());
break;
}
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var dr = TechProcGridView.GetRow(TechProcGridView.FocusedRowHandle) as v_TechProcDet;
if (dr != null)
{
using (var f = new frmTechProcDet(dr.WbillId, dr.DetId))
{
var row = WbGridView.GetFocusedRow() as WBListMake_Result;
f.OkButton.Enabled = (row.Checked != 1);
if (f.ShowDialog() == DialogResult.OK)
{
RefreshTechProcDet(dr.WbillId);
}
}
}
}
void GetWBListMake()
{
if (wbSatusList.EditValue == null || WhComboBox.EditValue == null || DocsTreeList.FocusedNode == null)
{
return;
}
var satrt_date = wbStartDate.DateTime < DateTime.Now.AddYears(-100) ? DateTime.Now.AddYears(-100) : wbStartDate.DateTime;
var end_date = wbEndDate.DateTime < DateTime.Now.AddYears(-100) ? DateTime.Now.AddYears(100) : wbEndDate.DateTime;
var dr = WbGridView.GetRow(WbGridView.FocusedRowHandle) as WBListMake_Result;
int top_row = WbGridView.TopRowIndex;
WBListMakeBS.DataSource = DB.SkladBase().WBListMake(satrt_date, end_date, (int)wbSatusList.EditValue, WhComboBox.EditValue.ToString(), focused_tree_node.Num, -20).ToList();
WbGridView.TopRowIndex = top_row;
}
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();
}
}
}
}
public void SaveGridLayouts()
{
WbGridView.SaveLayoutToRegistry(IHelper.reg_layout_path + "WarehouseUserControl\\WbGridView");
WhMatGridView.SaveLayoutToRegistry(IHelper.reg_layout_path + "WarehouseUserControl\\WhMatGridView");
}
private void WarehouseUserControl_Load(object sender, EventArgs e)
{
WbGridView.RestoreLayoutFromRegistry(IHelper.reg_layout_path + "WarehouseUserControl\\WbGridView");
WhMatGridView.RestoreLayoutFromRegistry(IHelper.reg_layout_path + "WarehouseUserControl\\WhMatGridView");
if (!DesignMode)
{
custom_mat_list = new List <CustomMatListWH>();
MatListGridControl.DataSource = custom_mat_list;
whContentTab.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False;
OnDateEdit.DateTime = DateTime.Now;
whKagentList.Properties.DataSource = DBHelper.KagentsList;// new List<object>() { new { KaId = 0, Name = "Усі" } }.Concat(new BaseEntities().Kagent.Select(s => new { s.KaId, s.Name }));
if (whKagentList.EditValue == null || whKagentList.EditValue == DBNull.Value)
{
whKagentList.EditValue = 0;
}
WhComboBox.Properties.DataSource = new List <checkedWhList>()
{
new checkedWhList {
WId = "*", Name = "Усі", IsChecked = false
}
}.Concat(new BaseEntities().Warehouse.Select(s => new checkedWhList {
WId = s.WId.ToString(), Name = s.Name, IsChecked = false
}).ToList());
WhComboBox.EditValue = "*";
var whlist = new BaseEntities().Warehouse.Select(s => new checkedWhList {
WId = s.WId.ToString(), Name = s.Name, IsChecked = false
}).ToList();
foreach (var item in whlist)
{
checkedComboBoxEdit1.Properties.Items.Add(item.WId, item.Name, item.IsChecked ? CheckState.Checked : CheckState.Unchecked, true);
}
wbSatusList.Properties.DataSource = new List <object>()
{
new { Id = -1, Name = "Усі" }, new { Id = 1, Name = "Проведені" }, new { Id = 0, Name = "Непроведені" }
};
wbSatusList.EditValue = -1;
wbStartDate.EditValue = DateTime.Now.Date.AddDays(-1);
wbEndDate.EditValue = DateTime.Now.Date.SetEndDay();
repositoryItemLookUpEdit1.DataSource = DBHelper.WhList;
repositoryItemLookUpEdit2.DataSource = DB.SkladBase().PriceTypes.ToList();
AvgMatPriceGridColumn.Visible = (DBHelper.CurrentUser.ShowPrice == 1);
AvgMatPriceGridColumn.OptionsColumn.ShowInCustomizationForm = AvgMatPriceGridColumn.Visible;
SumMatRemainGridColumn.Visible = AvgMatPriceGridColumn.Visible;
SumMatRemainGridColumn.OptionsColumn.ShowInCustomizationForm = AvgMatPriceGridColumn.Visible;
if (WHTreeList.DataSource == null)
{
GetTree(1);
}
bandedGridColumn2.Caption = $"{bandedGridColumn2.Caption}, {DBHelper.NationalCurrency.ShortName}";
var user_settings = new UserSettingsRepository(DBHelper.CurrentUser.UserId, new BaseEntities());
WbGridView.Appearance.Row.Font = new Font(user_settings.GridFontName, (float)user_settings.GridFontSize);
WhMatGridView.Appearance.Row.Font = new Font(user_settings.GridFontName, (float)user_settings.GridFontSize);
MatListGridView.Appearance.Row.Font = new Font(user_settings.GridFontName, (float)user_settings.GridFontSize);
}
whContentTab.Visible = true;
}
public void SaveGridLayouts()
{
WbGridView.SaveLayoutToRegistry(IHelper.reg_layout_path + "ManufacturingUserControl\\WbGridView");
DeboningGridView.SaveLayoutToRegistry(IHelper.reg_layout_path + "ManufacturingUserControl\\DeboningGridView");
}
