private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
var dr = PriceListGrid.GetRow(e.RowHandle) as GetPriceListDet_Result;
var pld = _db.PriceListDet.Find(dr.PlDetId);
if (e.Column.FieldName == "Price")
{
//dr.MatId
pld.Price = Convert.ToDecimal(e.Value);
}
if (e.Column.FieldName == "Discount")
{
pld.Discount = Convert.ToDecimal(e.Value);
}
if (e.Column.FieldName == "Notes")
{
pld.Notes = Convert.ToString(e.Value);
}
if (e.Column.FieldName == "WId")
{
pld.WId = Convert.ToInt32(e.Value);
}
}
void GetDetail()
{
int top_row = PriceListGrid.TopRowIndex;
PriceListDetBS.DataSource = _db.GetPriceListDet(_pl_id);
PriceListGrid.ExpandAllGroups();
PriceListGrid.TopRowIndex = top_row;
}
private void barButtonItem11_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var dr = PriceListGrid.GetFocusedRow() as GetPriceListDet_Result;
var pld = _db.PriceListDet.Find(dr.PlDetId);
pld.Price = GetPrice(dr.MatId.Value);
dr.Price = pld.Price;
_db.SaveChanges();
PriceListGrid.RefreshRow(PriceListGrid.FocusedRowHandle);
}
private void PriceListPopupMenu_BeforePopup(object sender, CancelEventArgs e)
{
var dr = PriceListGrid.GetFocusedRow() as GetPriceListDet_Result;
if (PriceListGrid.IsGroupRow(PriceListGrid.FocusedRowHandle))
{
DelMaterialBtn.Caption = "Видалити групу товарів";
}
else
{
DelMaterialBtn.Caption = "Видалити";
}
}
private void PriceListGrid_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e)
{
if (e.RowHandle < 0)
{
return;
}
var wh_row = PriceListGrid.GetRow(e.RowHandle) as GetPriceListDet_Result;
if (wh_row != null && wh_row.Price < wh_row.LastInPrice)
{
e.Appearance.ForeColor = Color.Red;
}
}
private void barButtonItem10_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
for (int i = 0; PriceListGrid.RowCount > i; i++)
{
var row = PriceListGrid.GetRow(i) as GetPriceListDet_Result;
if (row != null)
{
var wbd = _db.PriceListDet.Find(row.PlDetId);
wbd.Num = i + 1;
}
}
_db.SaveChanges();
GetDetail();
}
private void DelMaterialBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var dr = PriceListGrid.GetFocusedRow() as GetPriceListDet_Result;
if (PriceListGrid.IsGroupRow(PriceListGrid.FocusedRowHandle))
{
if (MessageBox.Show($"Ви дійсно бажаєте відалити групу товарів {dr.GrpName} ?", "Підтвердіть видалення", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
_db.DeleteWhere <PriceListDet>(w => w.GrpId == dr.GrpId && w.PlId == _pl_id);
}
}
else
{
_db.DeleteWhere <PriceListDet>(w => w.PlDetId == dr.PlDetId);
}
GetDetail();
}
private void BarCodeEdit1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13 && !String.IsNullOrEmpty(BarCodeEdit1.Text))
{
var BarCodeText = BarCodeEdit1.Text.Split('+');
string kod = BarCodeText[0];
int rowHandle = PriceListGrid.LocateByValue("BarCode", kod);
if (rowHandle != DevExpress.XtraGrid.GridControl.InvalidRowHandle)
{
PriceListGrid.FocusedRowHandle = rowHandle;
PriceListGrid.FocusedColumn = colPrice;
PriceListGrid.ShowEditor();
BarCodeEdit1.BackColor = Color.PaleGreen;
}
else
{
BarCodeEdit1.BackColor = Color.Pink;
}
BarCodeEdit1.Text = "";
}
}
private void MatInfoBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var dr = PriceListGrid.GetFocusedRow() as GetPriceListDet_Result;
IHelper.ShowMatInfo(dr.MatId);
}
