private void Copy2NyFakturaToolStripButton_Click(object sender, EventArgs e) { bool bVareforbrug = true; Tblactebisfaktura recActebisfaktura = tblactebisfakturaBindingSource.Current as Tblactebisfaktura; if (recActebisfaktura.Leveringsadresse.ToUpper().Contains("HAFSJOLD")) { DialogResult result = DotNetPerls.BetterDialog.ShowDialog( "TransSumma", //titleString " JA: Dette er en Hafsjold Data ApS anskaffelse.\nNEJ: Dette et vareforbrug.", //bigString null, //smallString "JA", //leftButton == OK "NEJ", //rightButton == Cancel global::nsPuls3060.Properties.Resources.Message_info); //iconSet if (result == DialogResult.OK) { bVareforbrug = false; } } Tblwfak recWfak = new Tblwfak { Sk = "K", Dato = recActebisfaktura.Ordredato, Konto = 200064, Kreditorbilagsnr = recActebisfaktura.Fakturanr }; foreach (Tblactebisordre recActebisordre in recActebisfaktura.Tblactebisordre) { Tblwfaklin recWfaklin = new Tblwfaklin { Antal = recActebisordre.Antal, Enhed = "stk", Pris = recActebisordre.Stkpris, Varenr = recActebisordre.Varenr.ToString(), Nettobelob = recActebisordre.Antal * recActebisordre.Stkpris, Tekst = getVaretekst(recActebisfaktura, recActebisordre, bVareforbrug), Konto = getVarenrKonto(recActebisordre.Varenr, bVareforbrug), Momskode = KarKontoplan.getMomskode(getVarenrKonto(recActebisordre.Varenr, bVareforbrug)) }; recWfak.Tblwfaklin.Add(recWfaklin); } FrmMain frmMain = this.ParentForm as FrmMain; try { FrmNyfaktura frmNyfaktura = frmMain.GetChild("Ny faktura") as FrmNyfaktura; frmNyfaktura.AddNyActebisFaktura(recWfak); } catch { Program.dbDataTransSumma.Tblwfak.InsertOnSubmit(recWfak); Program.dbDataTransSumma.SubmitChanges(); } }
private void tblwfaklinDataGridView1_MouseDown(object sender, MouseEventArgs e) { if (e.Button == System.Windows.Forms.MouseButtons.Right) { DataGridView.HitTestInfo hit = tblwfaklinDataGridView.HitTest(e.X, e.Y); int hitcol = hit.ColumnIndex; if (hit.Type == DataGridViewHitTestType.Cell && hit.ColumnIndex == 2) { tblwfaklinDataGridView.ClearSelection(); DataGridViewCell cellVarenr = tblwfaklinDataGridView.Rows[hit.RowIndex].Cells[hit.ColumnIndex]; cellVarenr.Selected = true; Point startPoint = tblwfaklinDataGridView.PointToScreen(new Point(e.X, e.Y)); FrmVareList m_frmVareList = new FrmVareList(startPoint); m_frmVareList.ShowDialog(); int?selectedVarenr = m_frmVareList.SelectedVarenr; m_frmVareList.Close(); if (selectedVarenr != null) { Tblwfak recWfak = tblwfakBindingSource.Current as Tblwfak; Tblwfaklin recWfaklin = ((DataGridView)sender).Rows[hit.RowIndex].DataBoundItem as Tblwfaklin; if (recWfaklin != null) { try { recVarer rec = (from k in Program.karVarer where k.Varenr == selectedVarenr select k).First(); recWfaklin.Varenr = rec.Varenr.ToString(); recWfaklin.Tekst = rec.Varenavn; recWfaklin.Enhed = rec.Enhed; if (recWfak.Sk == "S") { recWfaklin.Konto = rec.Salgskonto; recWfaklin.Momskode = KarKontoplan.getMomskode(rec.Salgskonto); recWfaklin.Pris = rec.Salgspris; } if (recWfak.Sk == "K") { recWfaklin.Konto = rec.Kobskonto; recWfaklin.Momskode = KarKontoplan.getMomskode(rec.Kobskonto); recWfaklin.Pris = rec.Kobspris; } } catch {} } } } else if (hit.Type == DataGridViewHitTestType.Cell && hit.ColumnIndex == 4) { tblwfaklinDataGridView.ClearSelection(); tblwfaklinDataGridView.Rows[hit.RowIndex].Cells[hit.ColumnIndex].Selected = true; Point startPoint = tblwfaklinDataGridView.PointToScreen(new Point(e.X, e.Y)); FrmKontoplanList m_frmKontoplanList = new FrmKontoplanList(startPoint, KontoType.Drift | KontoType.Status); m_frmKontoplanList.ShowDialog(); int? selectedKontonr = m_frmKontoplanList.SelectedKontonr; string selectedMomskode = m_frmKontoplanList.SelectedMomskode; m_frmKontoplanList.Close(); if (selectedKontonr != null) { Tblwfaklin recWfaklin = ((DataGridView)sender).Rows[hit.RowIndex].DataBoundItem as Tblwfaklin; if (recWfaklin != null) { recWfaklin.Konto = selectedKontonr; recWfaklin.Momskode = selectedMomskode; } } } else if (hit.Type == DataGridViewHitTestType.RowHeader) { this.contextMenuLineCopyPaste.Show(this.tblwfaklinDataGridView, new Point(e.X, e.Y)); } } }
public void ImportSalgsfakturaer() { int? lastFakid = null; Tblfak recFak = null; var rec_regnskab = Program.qryAktivRegnskab(); var qrySFak = from sfv in Program.karFakturavarer_s join sf in Program.karFakturaer_s on new { fakid = sfv.Fakid } equals new { fakid = sf.fakid } where sf.faknr != 0 && sf.faktype == 0 join fl in Program.dbDataTransSumma.Tblfaklin on new { regnskabsid = (int?)rec_regnskab.Rid, fakid = (int?)sfv.Fakid, sk = "S", line = (int?)sfv.Line } equals new { regnskabsid = fl.Regnskabid, fakid = fl.Fakid, sk = fl.Sk, line = fl.Faklinnr } into tblfaklin from fl in tblfaklin.DefaultIfEmpty(new Tblfaklin { Pid = 0, Fakpid = 0, Regnskabid = null }) where fl.Pid == 0 orderby sfv.Fakid, sfv.Line select new { Regnskabid = rec_regnskab.Rid, Sk = "S", Fakid = sfv.Fakid, Faknr = sf.faknr, Dato = sf.dato, debitornr = sf.debitornr, Faklinnr = sfv.Line, Varenr = sfv.Varenr, Tekst = sfv.VareTekst, Konto = sfv.Bogfkonto, Momskode = KarKontoplan.getMomskode(sfv.Bogfkonto), Antal = sfv.Antal, Enhed = sfv.Enhed, Pris = sfv.Pris, Rabat = sfv.Rabat, Moms = sfv.Moms, Nettobelob = sfv.Nettobelob, Bruttobelob = sfv.Bruttobelob, }; int antal = qrySFak.Count(); foreach (var s in qrySFak) { if ((!(s.Fakid == 0)) && (lastFakid != s.Fakid)) { try { recFak = (from f in Program.dbDataTransSumma.Tblfak where f.Regnskabid == rec_regnskab.Rid && f.Sk == "S" && f.Fakid == s.Fakid select f).First(); } catch { recFak = new Tblfak { Udskriv = true, Regnskabid = s.Regnskabid, Sk = s.Sk, Fakid = s.Fakid, Faknr = s.Faknr, Dato = s.Dato, Konto = s.debitornr }; Program.dbDataTransSumma.Tblfak.InsertOnSubmit(recFak); } } Tblfaklin recFaklin = new Tblfaklin { Sk = s.Sk, Regnskabid = s.Regnskabid, Fakid = s.Fakid, Faklinnr = s.Faklinnr, Varenr = s.Varenr.ToString(), Tekst = s.Tekst, Konto = s.Konto, Momskode = s.Momskode, Antal = s.Antal, Enhed = s.Enhed, Pris = s.Pris, Rabat = s.Rabat, Moms = s.Moms, Nettobelob = s.Nettobelob, Bruttobelob = s.Bruttobelob }; Program.dbDataTransSumma.Tblfaklin.InsertOnSubmit(recFaklin); if (!(s.Fakid == 0)) { recFak.Tblfaklin.Add(recFaklin); } lastFakid = s.Fakid; } Program.dbDataTransSumma.SubmitChanges(); }