void GetDiscountList()
{
_db.SaveChanges();
var list = _db.DiscountList(_ka.KaId).ToList();
DiscountGridControl.DataSource = list;
tree.RemoveAll(r => r.ParentId == 4);
foreach (var item in list)
{
tree.Add(new CatalogTreeList
{
Id = tree.Max(m => m.Id) + 1,
ParentId = 4,
Text = item.Name,
ImgIdx = item.ImgIdx == 0 ? 7 : 8,
TabIdx = item.ImgIdx == 0 ? 10 : 11,
DataSetId = item.DiscId
});
}
DirTreeList.DataSource = null;
DirTreeList.DataSource = TreeListBS;
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
var focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as CatalogTreeList;
switch (focused_tree_node.Id)
{
case 1:
case 3:
UserTreeAccessBS.DataSource = _db.GetUserAccessTree(_user_id).ToList();
xtraTabControl2.SelectedTabPageIndex = 0;
break;
case 4:
UserAccessWhGridControl.DataSource = _db.GetUserAccessWh(_user_id).ToList();
xtraTabControl2.SelectedTabPageIndex = 1;
break;
case 5:
xtraTabControl2.SelectedTabPageIndex = 2;
break;
case 6:
RefreshUserAccessCashDesks();
xtraTabControl2.SelectedTabPageIndex = 3;
break;
}
xtraTabControl1.SelectedTabPageIndex = focused_tree_node.TabIdx;
}
private void GetPersons()
{
var list = _db.BanksPersons.Where(w => w.BankId == bank.BankId).Select(s => new
{
s.PersonId,
s.Name,
s.Job,
}).ToList();
BanksPersonsGridControl.DataSource = list;
tree.RemoveAll(r => r.ParentId == 0);
foreach (var item in list)
{
tree.Add(new CatalogTreeList
{
Id = tree.Count + 1,
ParentId = 0,
Text = item.Name,
ImgIdx = 2,
TabIdx = 2,
DataSetId = item.PersonId
});
}
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
xtraTabControl1.SelectedTabPageIndex = 11;
var mat_grp_disc = _db.KAMatGroupDiscount.Add(new KAMatGroupDiscount
{
DiscId = Guid.NewGuid(),
KAId = _ka.KaId,
OnValue = 0,
GrpId = DB.SkladBase().MatGroup.FirstOrDefault().GrpId
});
KAMatGroupDiscountDS.DataSource = mat_grp_disc;
_db.SaveChanges();
GetDiscountList();
DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", mat_grp_disc.DiscId);
/*
* DiscountList->Append();
* DiscountListIMG_IDX->Value = 1;
* MemTableEh1->Append();
* MemTableEh1ImgIdx->Value = 8;
* MemTableEh1Parent_ID->Value = 3;
* // MemTableEh1Text->Value = " ("+DiscountListONVALUE->AsString+"%) "+DiscountListNAME->Value ;
* MemTableEh1TabIdx->Value = 11;
* MemTableEh1DataSetID->Value = DiscountListDISCID->Value;
* MemTableEh1->Post();*/
}
private void GetMatChange()
{
var result = _db.GetMatChange(_mat_id).ToList();
GetMatChangeBS.DataSource = result;
tree.RemoveAll(r => r.ParentId == 3);
foreach (var item in result)
{
var node = new CatalogTreeList
{
Id = tree.Max(m => m.Id) + 1,
ParentId = 4,
Text = item.MatChangeName,
ImgIdx = 14,
TabIdx = 3,
DataSetId = item.ChangeId
};
TreeListBS.Add(node);
}
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
private void GetTechProcDetail()
{
var list = _db.MatRecipeTechProcDet.Where(w => w.RecId == _mr.RecId).Select(s => new
{
s.Id,
s.Num,
s.ExpectedOut,
s.TechProcess.Name,
s.ProcId
}).OrderBy(o => o.Num).ToList();
MatRecTechProcGridControl.DataSource = list;
tree.RemoveAll(r => r.ParentId == 1);
foreach (var item in list)
{
tree.Add(new CatalogTreeList
{
Id = tree.Max(m => m.Id) + 1,
ParentId = 1,
Text = item.Name,
ImgIdx = 2,
TabIdx = 4,
DataSetId = item.Id
});
}
DirTreeList.DataSource = null;
DirTreeList.DataSource = TreeListBindingSource;
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
private void simpleButton12_Click(object sender, EventArgs e)
{
_db.KAgentAccount.Remove(KAgentAccountBS.DataSource as KAgentAccount);
_db.SaveChanges();
GetAccounts();
DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("Id")) == 7);
}
private void GetRecDetail()
{
var list = _db.MatRecDet.Where(w => w.RecId == _mr.RecId).Select(s => new
{
s.DetId,
s.Materials.Name,
s.Materials.Measures.ShortName,
s.Amount,
s.Coefficient
}).ToList();
MatRecDetGridControl.DataSource = list;
tree.RemoveAll(r => r.ParentId == 0);
foreach (var item in list)
{
tree.Add(new CatalogTreeList
{
Id = tree.Max(m => m.Id) + 1,
ParentId = 0,
Text = item.Name,
ImgIdx = 2,
TabIdx = 2,
DataSetId = item.DetId
});
}
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
private void GetRecDetail()
{
var list = _db.MatRecDet.Where(w => w.RecId == _mr.RecId).Select(s => new MatRecDetList
{
DetId = s.DetId,
Name = s.Materials.Name,
ShortName = s.Materials.Measures.ShortName,
Amount = s.Amount,
Coefficient = s.Coefficient,
Deviation = s.Deviation,
MatGroupName = s.Materials.MatGroup.Name
}).ToList();
MatRecDetListBS.DataSource = list;
MatRecDetGridView.ExpandAllGroups();
tree.RemoveAll(r => r.ParentId == 0);
foreach (var item in list)
{
tree.Add(new CatalogTreeList
{
Id = tree.Max(m => m.Id) + 1,
ParentId = 0,
Text = item.Name,
ImgIdx = 2,
TabIdx = 2,
DataSetId = item.DetId
});
}
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
private void simpleButton11_Click(object sender, EventArgs e)
{
_db.KAgentPersons.Remove(PersonBS.DataSource as KAgentPersons);
_db.SaveChanges();
GetPersons();
DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("Id", 6);
}
private void frmMatGroupEdit_Load(object sender, EventArgs e)
{
xtraTabControl1.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False;
TreeListBS.Add(new CatalogTreeList {
Id = 0, ParentId = 255, Text = "Основна інформація", ImgIdx = 0, TabIdx = 0
});
TreeListBS.Add(new CatalogTreeList {
Id = 1, ParentId = 255, Text = "Ціноутворення ", ImgIdx = 1, TabIdx = 1
});
TreeListBS.Add(new CatalogTreeList {
Id = 2, ParentId = 255, Text = "Оподаткування", ImgIdx = 2, TabIdx = 2
});
TreeListBS.Add(new CatalogTreeList {
Id = 3, ParentId = 255, Text = "Примітка", ImgIdx = 3, TabIdx = 3
});
if (_grp_id == null)
{
_mg = _db.MatGroup.Add(new MatGroup
{
Deleted = 0,
Nds = 0,
PId = 0,
Name = ""
});
_db.SaveChanges();
_grp_id = _mg.GrpId;
_mg.PId = _pid ?? _mg.GrpId;
}
else
{
_mg = _db.MatGroup.Find(_grp_id);
}
if (_mg != null)
{
checkEdit4.Checked = (_mg.GrpId == _mg.PId);
GrpIdEdit.Properties.TreeList.DataSource = DB.SkladBase().MatGroup.Select(s => new { s.GrpId, s.PId, s.Name, ImageIndex = 7 }).ToList();
MatGroupDS.DataSource = _mg;
}
GetTreeMatPrices();
#region Init
checkEdit3_CheckedChanged(sender, e);
PricePanel.Enabled = false;
NdsEdit.EditValue = _mg.Nds == -1 ? null : _mg.Nds;
#endregion
DirTreeList.ExpandAll();
}
private void AddRecDetBtn_Click(object sender, EventArgs e)
{
xtraTabControl1.SelectedTabPageIndex = 2;
var new_det = _db.BanksPersons.Add(new BanksPersons {
BankId = bank.BankId, Name = ""
});
BanksPersonsBS.DataSource = new_det;
_db.SaveChanges();
GetPersons();
DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == new_det.PersonId);
}
private void EditTecProcDetBtn_Click(object sender, EventArgs e)
{
dynamic det_item = MatRecTechProcGridView.GetFocusedRow();
if (det_item == null)
{
return;
}
xtraTabControl1.SelectedTabPageIndex = 4;
MatRecipeTechProcDetBS.DataSource = _db.MatRecipeTechProcDet.Find(det_item.Id);
DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == det_item.Id && Convert.ToInt32(w.GetValue("ParentId")) == 1);
}
private void ChangeName()
{
var rd = MatRecDetBS.DataSource as MatRecDet;
rd.MatId = Convert.ToInt32(MatLookUpEdit.EditValue);
_db.SaveChanges();
var det = tree.FirstOrDefault(w => Convert.ToInt32(w.DataSetId) == rd.DetId);
if (det != null)
{
det.Text = _db.Materials.Find(rd.MatId).Name;
DirTreeList.RefreshDataSource();
}
}
private void EditRecDetBtn_Click(object sender, EventArgs e)
{
dynamic det_item = BanksPersonsGridView.GetFocusedRow();
if (det_item == null)
{
return;
}
xtraTabControl1.SelectedTabPageIndex = 2;
BanksPersonsBS.DataSource = _db.BanksPersons.Find(det_item.PersonId);
DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == det_item.PersonId);
}
private void EditPersonBtn_Click(object sender, EventArgs e)
{
dynamic det_item = KAgentPersonsGridView.GetFocusedRow();
if (det_item == null)
{
return;
}
xtraTabControl1.SelectedTabPageIndex = 8;
PersonBS.DataSource = _db.KAgentPersons.Find(det_item.PersonId);
DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", det_item.PersonId);
}
private void ReportUserControl_Load(object sender, EventArgs e)
{
mainContentTab.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False;
if (!DesignMode)
{
using (var db = new BaseEntities())
{
// repositoryItemLookUpEdit1.DataSource = DBHelper.WhList;
DirTreeList.DataSource = db.GetReportTree(DBHelper.CurrentUser.UserId).ToList();
DirTreeList.ExpandToLevel(1);
}
}
}
private void AddPersonBtn_Click(object sender, EventArgs e)
{
xtraTabControl1.SelectedTabPageIndex = 8;
var new_det = _db.KAgentPersons.Add(new KAgentPersons
{
KAId = _ka.KaId,
Name = ""
});
PersonBS.DataSource = new_det;
_db.SaveChanges();
GetPersons();
DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", new_det.PersonId);
}
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
_db.SaveChanges();
var focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as CatalogTreeList;
if (focused_tree_node.ParentId == 0)
{
MatRecDetBS.DataSource = _db.MatRecDet.Find(focused_tree_node.DataSetId);
}
if (focused_tree_node.ParentId == 1)
{
MatRecipeTechProcDetBS.DataSource = _db.MatRecipeTechProcDet.Find(focused_tree_node.DataSetId);
}
if (focused_tree_node.Id == 0)
{
MatRecDetListBS.DataSource = _db.MatRecDet.Where(w => w.RecId == _mr.RecId).Select(s => new MatRecDetList
{
DetId = s.DetId,
Name = s.Materials.Name,
ShortName = s.Materials.Measures.ShortName,
Amount = s.Amount,
Coefficient = s.Coefficient,
Deviation = s.Deviation,
MatGroupName = s.Materials.MatGroup.Name
}).ToList();
MatRecDetGridView.ExpandAllGroups();
}
if (focused_tree_node.Id == 1)
{
MatRecTechProcGridControl.DataSource = _db.MatRecipeTechProcDet.Where(w => w.RecId == _mr.RecId).Select(s => new
{
s.Id,
s.Num,
s.ExpectedOut,
s.TechProcess.Name,
s.ProcId
}).OrderBy(o => o.Num).ToList();
}
xtraTabControl1.SelectedTabPageIndex = focused_tree_node.TabIdx;
}
private void AddRecDetBtn_Click(object sender, EventArgs e)
{
xtraTabControl1.SelectedTabPageIndex = 2;
var new_det = _db.MatRecDet.Add(new MatRecDet
{
RecId = _mr.RecId,
Amount = 0,
Coefficient = 0,
MatId = DB.SkladBase().MaterialsList.FirstOrDefault().MatId
});
MatRecDetBS.DataSource = new_det;
_db.SaveChanges();
GetRecDetail();
DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == new_det.DetId);
}
private void AddTecProcDetBtn_Click(object sender, EventArgs e)
{
xtraTabControl1.SelectedTabPageIndex = 4;
var new_det = _db.MatRecipeTechProcDet.Add(new MatRecipeTechProcDet
{
RecId = _mr.RecId,
Num = _db.MatRecipeTechProcDet.Count(w => w.RecId == _mr.RecId) + 1,
ExpectedOut = 100,
ProcId = DB.SkladBase().TechProcess.FirstOrDefault().ProcId
});
MatRecipeTechProcDetBS.DataSource = new_det;
_db.SaveChanges();
GetTechProcDetail();
DirTreeList.FocusedNode = DirTreeList.GetNodeList().FirstOrDefault(w => Convert.ToInt32(w.GetValue("DataSetId")) == new_det.Id);
}
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as GetReportTree_Result;
using (var db = DB.SkladBase())
{
RepGridControl.DataSource = null;
RepGridControl.DataSource = db.Reports.Where(w => w.GrpId == focused_tree_node.Id && w.Fil == 1)
.Join(db.RepLng.Where(r => r.LangId == 2), rep => rep.RepId, lng => lng.RepId, (rep, lng) => new
{
ImgIndex = 23,
rep.RepId,
lng.Name,
lng.Notes,
rep.Num
}).OrderBy(o => o.Num).ToList();
}
}
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
_db.SaveChanges();
var focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as CatalogTreeList;
if (_ka != null && focused_tree_node.Id == 4)
{
DiscountGridControl.DataSource = _db.DiscountList(_ka.KaId).ToList();
}
if (focused_tree_node.ParentId == 4)
{
if (focused_tree_node.ImgIdx == 7) //Товар
{
MatDiscountDS.DataSource = _db.KAMatDiscount.Find(focused_tree_node.DataSetId);
}
else
{
KAMatGroupDiscountDS.DataSource = _db.KAMatGroupDiscount.Find(focused_tree_node.DataSetId);
}
}
if (focused_tree_node.ParentId == 7)
{
KAgentAccountBS.DataSource = _db.KAgentAccount.Find(focused_tree_node.DataSetId);
}
if (focused_tree_node.Id == 7)
{
GetAcc();
}
if (focused_tree_node.Id == 6)
{
KAgentPersonsBS.DataSource = _db.KAgentPersons.AsNoTracking().Where(w => w.KAId == _ka.KaId).ToList();
}
if (focused_tree_node.ParentId == 6)
{
PersonBS.DataSource = _db.KAgentPersons.Find(focused_tree_node.DataSetId);
}
xtraTabControl1.SelectedTabPageIndex = focused_tree_node.TabIdx;
}
private void AddAccBtn_Click(object sender, EventArgs e)
{
xtraTabControl1.SelectedTabPageIndex = 9;
var new_det = _db.KAgentAccount.Add(new KAgentAccount
{
KAId = _ka.KaId,
AccNum = "",
TypeId = _db.AccountType.FirstOrDefault().TypeId,
BankId = _db.Banks.FirstOrDefault().BankId,
Def = _db.KAgentAccount.Any(a => a.KAId == _ka.KaId) ? 0 : 1
});
KAgentAccountBS.DataSource = new_det;
_db.SaveChanges();
GetAccounts();
DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", new_det.AccId);
}
private void GetAccounts()
{
tree.RemoveAll(r => r.ParentId == 7);
foreach (var item in GetAcc())
{
tree.Add(new CatalogTreeList
{
Id = tree.Max(m => m.Id) + 1,
ParentId = 7,
Text = item.AccNum,
ImgIdx = 6,
TabIdx = 9,
DataSetId = item.AccId
});
}
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
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 ServiceUserControl_Load(object sender, EventArgs e)
{
mainContentTab.ShowTabHeader = DevExpress.Utils.DefaultBoolean.False;
delTurnDate.DateTime = DateTime.Now;
if (!DesignMode)
{
using (var db = new BaseEntities())
{
// repositoryItemLookUpEdit1.DataSource = DBHelper.WhList;
DirTreeList.DataSource = db.GetServiceTree(DBHelper.CurrentUser.UserId).ToList();
DirTreeList.ExpandToLevel(1);
wbStartDate.DateTime = DateTime.Now.Date; //DateTimeDayOfMonthExtensions.FirstDayOfMonth(DateTime.Now);
wbEndDate.DateTime = DateTime.Now.Date.AddDays(1);
UserComboBox.Properties.DataSource = new List <object>()
{
new { UserId = -1, Name = "Усі" }
}.Concat(new BaseEntities().Users.Select(s => new { s.UserId, s.Name })).ToList();
UserComboBox.EditValue = -1;
wTypeList.Properties.DataSource = new List <object>()
{
new { FunId = (int?)-1, Name = "Усі" }
}
.Concat(new BaseEntities().ViewLng.Where(w => w.LangId == 2 && (w.UserTreeView.Functions.TabId == 24 || w.UserTreeView.Functions.TabId == 27 || w.UserTreeView.Functions.TabId == 51)).Select(s => new { s.UserTreeView.FunId, s.Name })).ToList();
wTypeList.EditValue = -1;
}
/* using (var s = new UserSettingsRepository(UserSession.UserId))
* {
* ComPortNameEdit.Text = s.ComPortName;
* ComPortSpeedEdit.Text = s.ComPortSpeed;
* }*/
}
DeviceNameRMKTextEdit.Text = Settings.Default.barcode_scanner_name;
}
private void simpleButton7_Click(object sender, EventArgs e)
{
var row = DiscountGridView.GetFocusedRow() as DiscountList_Result;
if (row == null)
{
return;
}
if (row.ImgIdx == 0)
{
MatDiscountDS.DataSource = _db.KAMatDiscount.FirstOrDefault(w => w.DiscId == row.DiscId);
xtraTabControl1.SelectedTabPageIndex = 10;
}
else
{
KAMatGroupDiscountDS.DataSource = _db.KAMatGroupDiscount.FirstOrDefault(w => w.DiscId == row.DiscId);
xtraTabControl1.SelectedTabPageIndex = 11;
}
DirTreeList.FocusedNode = DirTreeList.FindNodeByFieldValue("DataSetId", row.DiscId);
}
private void GetPersons()
{
var list = _db.KAgentPersons.AsNoTracking().Where(w => w.KAId == _ka.KaId).ToList();
KAgentPersonsBS.DataSource = list;
tree.RemoveAll(r => r.ParentId == 6);
foreach (var item in list)
{
tree.Add(new CatalogTreeList
{
Id = tree.Max(m => m.Id) + 1,
ParentId = 6,
Text = item.Name,
ImgIdx = 6,
TabIdx = 8,
DataSetId = item.PersonId
});
}
DirTreeList.RefreshDataSource();
DirTreeList.ExpandAll();
}
private void DirTreeList_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
_db.SaveChanges();
var focused_tree_node = DirTreeList.GetDataRecordByNode(e.Node) as CatalogTreeList;
if (focused_tree_node.ParentId == 0)
{
BanksPersonsBS.DataSource = _db.BanksPersons.Find(focused_tree_node.DataSetId);
}
if (focused_tree_node.Id == 0)
{
var list = _db.BanksPersons.Where(w => w.BankId == bank.BankId).Select(s => new
{
s.PersonId,
s.Name,
s.Job,
}).ToList();
BanksPersonsGridControl.DataSource = list;
}
xtraTabControl1.SelectedTabPageIndex = focused_tree_node.TabIdx;
}
