private void WaybillDetInGridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { var dr = WaybillDetInGridView.GetRow(e.RowHandle) as GetWaybillDetIn_Result; var wbd = _db.WaybillDet.Find(dr.PosId); wbd.Amount = Convert.ToDecimal(e.Value); wbd.Checked = 1; var wmt = _db.WMatTurn.FirstOrDefault(w => w.SourceId == wbd.PosId && w.TurnType == 3); if (wmt != null) { // if (wb.WType == 16) // { // удаляем резерв з видаткових документів _db.DeleteWhere <WMatTurn>(w => w.PosId == wbd.PosId); _db.WMatTurn.Add(new WMatTurn() { SourceId = wbd.PosId, PosId = wbd.PosId, WId = wbd.WId.Value, MatId = wbd.MatId, OnDate = wbd.OnDate.Value, TurnType = 3, Amount = wbd.Amount }); // } } _db.SaveChanges(); IHelper.MapProp(_db.GetWaybillDetIn(_wbill_id).AsNoTracking().FirstOrDefault(w => w.PosId == wbd_row.PosId), wbd_row); // var dd = WayBillsController.GetWaybillDetIn(_db, _wbill_id); }
private void EditMaterialBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var row = WaybillDetInGridView.GetFocusedRow() as v_ProductionPlanDet; new frmProductionPlanDet(_db, row.Id, pp).ShowDialog(); RefreshDet(); }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var dr = WaybillDetInGridView.GetFocusedRow() as GetWaybillDetIn_Result; if (dr != null) { IHelper.ShowMatRSV(dr.MatId, _db); } }
private void frmWayBillIn_Load(object sender, EventArgs e) { WaybillDetInGridView.RestoreLayoutFromRegistry(IHelper.reg_layout_path + "frmWayBillIn\\WaybillDetInGridView"); if (_wbill_id == null && doc_id == null) { is_new_record = true; wb = _db.WaybillList.Add(new WaybillList() { Id = Guid.NewGuid(), WType = _wtype, OnDate = DBHelper.ServerDateTime(), Num = "", CurrId = 2, OnValue = 1, PersonId = DBHelper.CurrentUser.KaId, Nds = DBHelper.Enterprise.NdsPayer == 1 ? DBHelper.CommonParam.Nds : 0, UpdatedBy = DBHelper.CurrentUser.UserId, EntId = DBHelper.Enterprise.KaId, }); _db.SaveChanges(); } else { wb = _db.WaybillList.FirstOrDefault(f => f.Id == doc_id || f.WbillId == _wbill_id); } if (wb != null) { DBHelper.UpdateSessionWaybill(wb.WbillId); if (is_new_record) //Після копіювання згенерувати новий номер { wb.Num = new BaseEntities().GetDocNum("wb_in").FirstOrDefault(); } WaybillListBS.DataSource = wb; GetDocValue(wb); } KagentComboBox.Properties.DataSource = DBHelper.Kagents; PersonComboBox.Properties.DataSource = DBHelper.Persons; CurrencyLookUpEdit.Properties.DataSource = _db.Currency.ToList(); var wh_list = DBHelper.WhList; WHComboBox.Properties.DataSource = wh_list; WHComboBox.EditValue = wh_list.Where(w => w.Def == 1).Select(s => s.WId).FirstOrDefault(); RefreshDet(); }
private void WaybillDetInGridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { var row = WaybillDetInGridView.GetFocusedRow() as v_IntermediateWeighingDet; var wbd = _db.IntermediateWeighingDet.Find(row.Id); if (e.Column.FieldName == "Amount") { } if (e.Column.FieldName == "Total") { } _db.SaveChanges(); RefreshDet(); }
private void DelMaterialBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var row = WaybillDetInGridView.GetFocusedRow() as v_ProductionPlanDet; if (row != null) { var det = _db.ProductionPlanDet.Find(row.Id); if (det != null) { _db.ProductionPlanDet.Remove(det); } _db.SaveChanges(); WaybillDetInGridView.DeleteSelectedRows(); } GetOk(); }
private void DelMaterialBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (wbd_row != null) { if (wbd_row.PosId > 0) { _db.DeleteWhere <WaybillDet>(w => w.PosId == wbd_row.PosId); } else { _db.DeleteWhere <WayBillSvc>(w => w.PosId == wbd_row.PosId * -1); } _db.Save(wb.WbillId); WaybillDetInGridView.DeleteSelectedRows(); } }
private void frmWayBillIn_FormClosed(object sender, FormClosedEventArgs e) { WaybillDetInGridView.SaveLayoutToRegistry(IHelper.reg_layout_path + "frmWayBillIn\\WaybillDetInGridView"); DBHelper.UpdateSessionWaybill(_wbill_id.Value, true); if (is_new_record) { _db.DeleteWhere <WaybillList>(w => w.WbillId == _wbill_id); // current_transaction.Commit(); } /* if (current_transaction.UnderlyingTransaction.Connection != null) * { * current_transaction.Rollback(); * }*/ _db.Dispose(); // current_transaction.Dispose(); }
private void DelMaterialBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (iw_det_row != null && _db.GetWayBillMakeDet(iw_det_row.WbillId).Any(a => a.MatId == iw_det_row.MatId && a.Rsv == 0)) { var det = _db.IntermediateWeighingDet.Find(iw_det_row.Id); if (det != null) { _db.IntermediateWeighingDet.Remove(det); } _db.SaveChanges(); WaybillDetInGridView.DeleteSelectedRows(); } else { MessageBox.Show("Видаляти заборонено, сировина вже зарезервована"); } GetOk(); }
private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (wbd_row.PosType == 0) { var wbd = _db.WaybillDet.Find(wbd_row.PosId); if (wbd != null) { if (wbd.Checked == 1) { wbd.Checked = 0; wbd_row.Checked = 0; } else { wbd.Checked = 1; wbd_row.Checked = 1; } } } if (wbd_row.PosType == 2) { var wbt = _db.WayBillTmc.Find(wbd_row.PosId); if (wbt != null) { if (wbt.Checked == 1) { wbt.Checked = 0; wbd_row.Checked = 0; } else { wbt.Checked = 1; wbd_row.Checked = 1; } } } _db.SaveChanges(); WaybillDetInGridView.RefreshRow(WaybillDetInGridView.FocusedRowHandle); }
private void WaybillDetInGridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { var row = WaybillDetInGridView.GetFocusedRow() as v_ProductionPlanDet; var wbd = _db.ProductionPlanDet.Find(row.Id); if (e.Column.FieldName == "Amount") { wbd.Amount = Convert.ToDecimal(e.Value); var real_amount = wbd.Amount.Value - wbd.Remain.Value; var tmp_amount = (real_amount / (row.ResipeOut == 0 ? 100.00m : row.ResipeOut)) * 100; // real_amount + (real_amount - (real_amount * row.ResipeOut / 100)); wbd.Total = Math.Ceiling(tmp_amount / row.RecipeAmount) * row.RecipeAmount; } if (e.Column.FieldName == "Total") { wbd.Total = Convert.ToDecimal(e.Value); } _db.SaveChanges(); RefreshDet(); }
private void EditMaterialBtn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var dr = WaybillDetInGridView.GetRow(WaybillDetInGridView.FocusedRowHandle) as GetWaybillDetIn_Result; if (dr != null) { if (dr.PosId > 0) { using (var wb_det = new frmWayBillDetIn(_db, dr.PosId, wb)) { wb_det.ShowDialog(); } } else { using (var svc_det = new frmWaybillSvcDet(_db, dr.PosId * -1, wb)) { svc_det.ShowDialog(); } } RefreshDet(); } }
private void WaybillDetInGridView_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e) { wbd_row = WaybillDetInGridView.GetRow(WaybillDetInGridView.FocusedRowHandle) as GetWaybillDetIn_Result; }