private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (barButtonItem2.Down)
{
var row = MatTreeList.GetDataRecordByNode(MatTreeList.FocusedNode) as GetMatTree_Result;
if (row.Id < 0)
{
var grp = MatTreeList.DataSource as List <GetMatTree_Result>;
var grp_ids = _db.GetMatGroupTree(row.Id * -1).ToList().Select(s => s.GrpId * -1).ToList();
foreach (var item in grp.Where(w => grp_ids.Contains(w.Pid)))
{
AddMat(item);
}
}
else
{
AddMat(row);
}
}
if (barButtonItem3.Down)
{
var row = MatTreeList.GetDataRecordByNode(MatTreeList.FocusedNode) as GetSvcTree_Result;
if (row.Id < 0)
{
var grp = MatTreeList.DataSource as List <GetSvcTree_Result>;
foreach (var item in grp.Where(w => w.Pid == row.Id))
{
AddSvc(item);
}
}
else
{
AddSvc(row);
}
}
_db.SaveChanges();
GetDetail();
}
private void GetMatTree()
{
var sql = @"
select mats.matid as Id, -1*mats.grpid as Pid, mats.Name, mats.Artikul as art, msr.shortname as MsrName, 0 as ImgIndex,
0.00 Price
from materials mats, measures msr
where msr.mid=mats.mid and mats.deleted=0
union all
select -1*mg.grpid as id, -1*mg.pid as pid, mg.name ,'', '', 2 , 0
from matgroup mg
where mg.deleted=0";
int?p_type = PTypeEdit.EditValue == null || PTypeEdit.EditValue == DBNull.Value ? null : (int?)PTypeEdit.EditValue;
var list = _db.GetMatTree(p_type, 2).ToList();
// var list = _db.Database.SqlQuery<GetMatTree_Result>(sql).ToList();
MatTreeList.BeginUpdate();
MatTreeList.DataSource = list;
MatTreeList.EndUpdate();
}
private void textEdit1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13 && AddMaterialBtn.Enabled && !String.IsNullOrEmpty(BarCodeEdit.Text))
{
var BarCodeText = BarCodeEdit.Text.Split('+');
string kod = BarCodeText[0];
var item = _db.Materials.Where(w => w.BarCode == kod || w.Name.Contains(kod)).Select(s => s.MatId).FirstOrDefault();
if (item > 0)
{
BarCodeEdit.BackColor = Color.PaleGreen;
MatTreeList.FocusedNode = MatTreeList.FindNodeByFieldValue("Id", item);
barButtonItem5.PerformClick();
}
else
{
BarCodeEdit.BackColor = Color.Pink;
}
BarCodeEdit.Text = "";
}
}
