static public void ShowMatListByWH3(BaseEntities db, WaybillList wb, String WID) { using (var f = new frmWhCatalog(1)) { f.uc.xtraTabPage4.PageVisible = false; f.uc.xtraTabPage5.PageVisible = false; f.uc.xtraTabPage9.PageVisible = false; f.uc.MatListTabPage.PageVisible = true; f.uc.xtraTabControl1.SelectedTabPageIndex = 4; f.uc.gridColumn49.Visible = false; f.uc.gridColumn51.Visible = false; f.uc.gridColumn52.Visible = false; f.uc.MatListGridColumnWh.Visible = (WID == "*"); f.uc.bar3.Visible = false; f.uc.ByWhBtn.Down = true; f.uc.splitContainerControl1.SplitterPosition = 0; using (var _db = new BaseEntities()) { int wid; if (int.TryParse(WID, out wid)) { f.uc.WHTreeList.DataSource = _db.GetWhTree(DBHelper.CurrentUser.UserId, 2).Where(w => w.GType == 1 && w.Num == wid).ToList(); } else { f.uc.WHTreeList.DataSource = _db.GetWhTree(DBHelper.CurrentUser.UserId, 2).Where(w => w.GType == 1).ToList(); } f.uc.GrpNameGridColumn.GroupIndex = 0; } f.uc.wb = wb; f.uc.isMatList = true; if (f.ShowDialog() == DialogResult.OK) { foreach (var item in f.uc.custom_mat_list) { var wbd = db.WaybillDet.Add(new WaybillDet { WbillId = wb.WbillId, OnDate = wb.OnDate, MatId = item.MatId, WId = (WID != "*") ? Convert.ToInt32(WID) : item.WId, Amount = item.Amount, Price = item.AvgPrice,// item.Price , Discount = wb.WType == -20 ? item.Amount : 0, Nds = wb.Nds, CurrId = wb.CurrId, OnValue = wb.OnValue, BasePrice = item.AvgPrice,// item.Price, PosKind = 0, PosParent = 0, DiscountKind = 0 }); } db.SaveChanges(); } } }
public frmAttEdit(WaybillList wb) { InitializeComponent(); _wb = wb; WaybillListBS.DataSource = wb; }
public frmCashboxCheckout(BaseEntities db, WaybillList wb) { InitializeComponent(); _db = db; _wb = wb; }
public frmWayBillTMCDet(BaseEntities db, int?PosId, WaybillList wb) { InitializeComponent(); _db = db; _PosId = PosId; _wb = wb; }
static public void ShowMatListByWH(BaseEntities db, WaybillList wb, DiscCards disc_card = null) { var f = new frmWhCatalog(1, disc_card); // f.uc.xtraTabPage3.PageVisible = false; f.uc.xtraTabPage4.PageVisible = false; f.uc.xtraTabPage5.PageVisible = false; f.uc.xtraTabPage9.PageVisible = false; f.uc.xtraTabPage11.PageVisible = false; f.uc.MatListTabPage.PageVisible = true; f.uc.xtraTabControl1.SelectedTabPageIndex = 4; f.uc.wb = wb; f.uc.isMatList = true; if (f.ShowDialog() == DialogResult.OK) { var num = wb.WaybillDet.Count(); foreach (var item in f.uc.custom_mat_list) { var wbd = new WaybillDet { WbillId = wb.WbillId, Num = ++num, OnDate = wb.OnDate, MatId = item.MatId, WId = item.WId, Amount = item.Amount, Price = item.Price - (item.Price * item.Discount / 100), PtypeId = item.PTypeId, Discount = item.Discount, Nds = wb.Nds, CurrId = wb.CurrId, OnValue = wb.OnValue, BasePrice = item.Price + Math.Round(item.Price.Value * wb.Nds.Value / 100, 2), PosKind = 0, PosParent = 0, DiscountKind = disc_card != null ? 2 : 0, }; db.WaybillDet.Add(wbd); db.SaveChanges(); if (wb.WType == 16) { 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(); } }
public frmWBReturnDetOut(BaseEntities db, int?PosId, WaybillList wb, int ka_id) { InitializeComponent(); _db = db; _PosId = PosId; _wb = wb; _ka_id = ka_id; }
public frmWBMoveDet(BaseEntities db, int?PosId, WaybillList wb) { InitializeComponent(); _db = db; _PosId = PosId; _wb = wb; _ka_id = 0; }
public frmWBInventoryDet(BaseEntities db, int?PosId, WaybillList wb) { InitializeComponent(); _db = db; _PosId = PosId; _wb = wb; WHComboBox.Properties.DataSource = DBHelper.WhList; // MatComboBox.Properties.DataSource = db.MaterialsList.ToList(); }
public frmWayBillDetIn(BaseEntities db, int?PosId, WaybillList wb) { InitializeComponent(); _db = db; _wb = wb; _PosId = PosId; WHComboBox.Properties.DataSource = DBHelper.WhList; MatComboBox.Properties.DataSource = db.MaterialsList.ToList(); ProducerTextEdit.Properties.Items.AddRange(_db.WayBillDetAddProps.Where(w => w.Producer != null).Select(s => s.Producer).Distinct().ToList()); }
static public void ShowMatListByWH2(BaseEntities db, WaybillList wb, int ka_id) { //Не доделано var f = new frmWhCatalog(1); f.uc.xtraTabPage4.PageVisible = false; f.uc.xtraTabPage5.PageVisible = false; f.uc.xtraTabPage9.PageVisible = false; f.uc.MatListTabPage.PageVisible = true; f.uc.xtraTabControl1.SelectedTabPageIndex = 4; f.uc.gridColumn49.Visible = false; f.uc.gridColumn51.Visible = false; f.uc.gridColumn52.Visible = false; f.uc.bar3.Visible = false; f.uc.ByWhBtn.Down = true; f.uc.splitContainerControl1.SplitterPosition = 0; f.uc.whKagentList.EditValue = ka_id; f.uc.whKagentList.Enabled = false; f.uc.WHTreeList.DataSource = new BaseEntities().GetWhTree(DBHelper.CurrentUser.UserId, 2).Where(w => w.GType == 1).ToList(); f.uc.GrpNameGridColumn.GroupIndex = 0; f.uc.wb = wb; f.uc.isMatList = true; if (f.ShowDialog() == DialogResult.OK) { foreach (var item in f.uc.custom_mat_list) { var wbd = db.WaybillDet.Add(new WaybillDet { WbillId = wb.WbillId, OnDate = wb.OnDate, MatId = item.MatId, WId = item.WId, Amount = item.Amount, Price = item.Price, Discount = 0, Nds = wb.Nds, CurrId = wb.CurrId, OnValue = wb.OnValue, BasePrice = item.Price, PosKind = 0, PosParent = 0, DiscountKind = 0 }); } db.SaveChanges(); } }
public frmWBReturnDetIn(BaseEntities db, int?PosId, WaybillList wb, int?wid, DateTime start_date) { InitializeComponent(); _db = db; _PosId = PosId; _wb = wb; _def_wid = wid; _start_date = start_date; WHComboBox.Properties.DataSource = DBHelper.WhList; com_port = new ComPortHelper(Settings.Default.com_port_name, Convert.ToInt32(Settings.Default.com_port_speed)); }
private void GetDocValue(WaybillList wb) { _wbill_id = wb.WbillId; NumEdit.Text = wb.Num; OnDateDBEdit.DateTime = wb.OnDate; KagentComboBox.EditValue = wb.KaId; PersonComboBox.EditValue = wb.PersonId; TurnDocCheckBox.Checked = Convert.ToBoolean(wb.Checked); ReasonEdit.Text = wb.Reason; NotesEdit.Text = wb.Notes; PersonComboBox.EditValue = wb.PersonId; payDocUserControl1.OnLoad(_db, wb); KagentComboBox.Enabled = !payDocUserControl1.IsPayDoc(); }
public frmWayBillDetOut(BaseEntities db, int?PosId, WaybillList wb, DiscCards cart) { InitializeComponent(); _db = db; _PosId = PosId; _wb = wb; _cart = cart; WHComboBox.Properties.DataSource = DBHelper.WhList; MatComboBox.Properties.DataSource = db.MaterialsList.ToList(); PriceTypesEdit.Properties.DataSource = DB.SkladBase().PriceTypes.ToList(); ProducerTextEdit.Properties.Items.AddRange(_db.WayBillDetAddProps.Where(w => w.Producer != null).Select(s => s.Producer).Distinct().ToList()); panel3.Visible = barCheckItem1.Checked; if (!barCheckItem1.Checked) { Height -= panel3.Height; } panel4.Visible = barCheckItem2.Checked; if (!barCheckItem2.Checked) { Height -= panel4.Height; } panel5.Visible = barCheckItem3.Checked; if (!barCheckItem3.Checked) { Height -= panel5.Height; } if (DBHelper.CurrentUser.ShowPrice == 0) { if (barCheckItem2.Checked) { barCheckItem2.PerformClick(); } barCheckItem2.Visibility = BarItemVisibility.Never; } BasePriceEdit.Enabled = new UserSettingsRepository(DBHelper.CurrentUser.UserId, _db).AccessEditPrice; PriceTypesEdit.Enabled = BasePriceEdit.Enabled; panelControl4.Enabled = BasePriceEdit.Enabled; }
public override IEnumerable <Waybill> GetAll() { connection.Command.Parameters.Clear(); connection.Command.CommandText = "select * from путевые_листы"; WaybillList list = new WaybillList(); using (MySqlDataReader reader = connection.Command.ExecuteReader()) { if (reader.HasRows) // если есть данные { while (reader.Read()) { list.Add(new Waybill((int)reader.GetValue(0), (double)reader.GetValue(3), (DateTime)reader.GetValue(4), (int)reader.GetValue(1), (int)reader.GetValue(2))); } } } return(list); }
public frmSetCustomDiscount(BaseEntities db, WaybillList wb) { InitializeComponent(); _db = db; _wb = wb; }
public frmSetWBNote(WaybillList wb) { InitializeComponent(); _wb = wb; }
public void OnLoad(BaseEntities db, WaybillList wb) { _db = db; _wb = wb; if (new int[] { -1, -6, 2, -16 }.Contains(_wb.WType)) // Вхідний платіж { _user_Access = _db.GetUserAccessTree(DBHelper.CurrentUser.UserId).ToList().FirstOrDefault(w => w.FunId == 26); } else { _user_Access = _db.GetUserAccessTree(DBHelper.CurrentUser.UserId).ToList().FirstOrDefault(w => w.FunId == 25); //Вихідні платежі } panelControl1.Visible = _user_Access.CanView == 1; var rel = db.GetRelDocList(wb.Id).FirstOrDefault(w => w.DocType == -3 || w.DocType == 3); if (rel != null) { try { var PayDocId = db.PayDoc.AsNoTracking().FirstOrDefault(f => f.Id == rel.Id).PayDocId; _pd = db.Database.SqlQuery <PayDoc>("select * from PayDoc WITH (UPDLOCK, NOWAIT) where PayDocId = {0}", PayDocId).FirstOrDefault(); } catch { panelControl1.Enabled = false; } if (_pd != null) { _db.Entry(_pd).State = System.Data.Entity.EntityState.Modified; ExecPayCheckBox.EditValue = _pd.Checked; NumEdit.EditValue = _pd.DocNum; PTypeComboBox.EditValue = _pd.PTypeId; CashEditComboBox.EditValue = _pd.CashId; ChargeTypesEdit.EditValue = _pd.CTypeId; SumEdit.EditValue = _pd.Total; CurrencyLookUpEdit.EditValue = _pd.CurrId; AccountEdit.EditValue = _pd.AccId; } } else { ExecPayCheckBox.EditValue = 0; PTypeComboBox.EditValue = 1; CurrencyLookUpEdit.EditValue = DBHelper.Currency.Where(w => w.Def == 1).Select(s => s.CurrId).FirstOrDefault(); //Валюта по умолчанию if (DBHelper.CashDesks.Any(w => w.Def == 1)) { CashEditComboBox.EditValue = DBHelper.CashDesks.FirstOrDefault(w => w.Def == 1).CashId; } else if (DBHelper.CashDesks.Any()) { CashEditComboBox.EditValue = DBHelper.CashDesks.FirstOrDefault().CashId; } } panelControl1.Enabled = (_user_Access.CanModify == 1 || (_user_Access.CanInsert == 1 && _pd == null)) && DBHelper.CashDesks.Any() && DBHelper.CashDesks.Any(a => a.CashId == Convert.ToInt32(CashEditComboBox.EditValue)); ExecPayCheckBox.Enabled = _user_Access.CanPost == 1 || (_user_Access.CanInsert == 1 && _pd == null); PTypeComboBox.Properties.DataSource = DBHelper.PayTypes; CashEditComboBox.Properties.DataSource = panelControl1.Enabled ? DBHelper.CashDesks : DBHelper.AllCashDesks; ChargeTypesEdit.Properties.DataSource = DBHelper.ChargeTypes; if (DBHelper.ChargeTypes.Any(a => a.Def == 1)) { ChargeTypesEdit.EditValue = DBHelper.ChargeTypes.FirstOrDefault(f => f.Def == 1).CTypeId; } CurrencyLookUpEdit.Properties.DataSource = _db.Currency.ToList(); var ent_id = DBHelper.Enterprise.KaId; user_acc_list = _db.EnterpriseAccount.Where(w => w.KaId == ent_id).Select(s => new user_acc { AccId = s.AccId, AccNum = s.AccNum, Name = s.BankName, ExtDocType = 1 }).ToList() /*.Concat(_db.KAgentAccount.Where(w => w.KAId == _wb.KaId).Select(s => new user_acc * { * AccId = s.AccId, * AccNum = s.AccNum, * Name = s.Kagent.Name, * ExtDocType = -1 * }).ToList()).ToList()*/; AccountEdit.Properties.DataSource = user_acc_list; }
public double GetDistance(WaybillList WBList) { return(WBList.GetFullDistanceForDriverId(Id)); }
static public void ShowMatList(BaseEntities db, WaybillList wb) { var f = new frmCatalog(2); f.uc.xtraTabPage3.PageVisible = false; f.uc.xtraTabPage4.PageVisible = false; f.uc.xtraTabPage5.PageVisible = false; f.uc.xtraTabPage12.PageVisible = false; f.uc.xtraTabPage13.PageVisible = false; f.uc.xtraTabPage14.PageVisible = true; f.uc.wb = wb; f.uc.isMatList = true; if (f.ShowDialog() == DialogResult.OK) { foreach (var item in f.uc.custom_mat_list.OrderBy(o => o.Num).ToList()) { var price = (item.Price ?? 0); var wbd = db.WaybillDet.Add(new WaybillDet { WbillId = wb.WbillId, Num = wb.WaybillDet.Count(), MatId = item.MatId, WId = item.WId, Amount = item.Amount, Price = price, Discount = 0, Nds = wb.Nds, CurrId = wb.CurrId, OnDate = wb.OnDate, OnValue = wb.OnValue, BasePrice = price + Math.Round(price * wb.Nds.Value / 100, 2), PosKind = 0, PosParent = 0, DiscountKind = 0 }); if (wb.WType == -16) { var dis = db.GetDiscount(wb.KaId, item.MatId).FirstOrDefault() ?? 0.00m; wbd.Discount = dis; wbd.Price = item.Price - Math.Round((item.Price.Value * dis / 100), 2); wbd.BasePrice = item.Price + Math.Round(item.Price.Value * wb.Nds.Value / 100, 2); } db.SaveChanges(); if (wb.WType == 16) { 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.Save(wb.WbillId); } }
public double GetDistance(WaybillList WBList) { return(WBList.GetFullDistanceForCarId(id)); }