public List <FatIrsUst> GetListByFtirsipAndSubeKodu(FTIRSIP ftirsip, string subeKodu) { ICriteria criteria = Session.CreateCriteria(typeof(FatIrsUst)).Add(Expression.Eq("Ftirsip", ftirsip)).SetMaxResults(GetMaxResult); ICriteria subeCriter = criteria.CreateCriteria("Sube").Add(Expression.Eq("Id", subeKodu)); return(criteria.List <FatIrsUst>() as List <FatIrsUst>); }
public FatIrsUst GetByBelgeNoBelgeTipAndSubeKodu(string belgeNo, FTIRSIP ftirsip, string subeKodu) { ICriteria criteria = Session.CreateCriteria(typeof(FatIrsUst)).Add(Expression.Eq("FatirsNo", belgeNo)).Add(Expression.Eq("Ftirsip", ftirsip)); ICriteria subeCriter = criteria.CreateCriteria("Sube").Add(Expression.Eq("Id", subeKodu)); return(criteria.UniqueResult <FatIrsUst>()); }
public void UpdateStokHarByFisNoAndFtirsip(string fisNo, FTIRSIP ftirsip,FTIRSIP desFtirsip,string desFisNo) { byte b=(byte)ftirsip; byte b2 = (byte)desFtirsip; IDbConnection con = Session.Connection; IDbCommand cmd = con.CreateCommand(); IDbTransaction trs =con.BeginTransaction(); string query = "update StokHareket set HTUR='F',FTIRSIP="+b2+",FisNo='"+desFisNo+"' where FisNo='" + fisNo + "' and FTIRSIP=" + b + " "; cmd.CommandText = query; cmd.Connection = con; cmd.Transaction = trs; try { cmd.ExecuteNonQuery(); trs.Commit(); } catch { trs.Rollback(); throw; } finally { //con.Close(); } }
public frmIrsFatura(string IrsNo, FTIRSIP ftirsip) { _irsNo = IrsNo; _ftirsip = ftirsip; mng = new ManagerFactory(Engine.GetConString(), Engine.GetSqlServerType()); mngFatUst = mng.GetFatirsUstManager(); mngCari = mng.GetCariManager(); mngSth = mng.GetStokHareketManager(); mngKasa = mng.GetKasaManager(); mngKasaHar = mng.GetKasaHarManager(); mngCariHrk = mng.GetCariHareketManager(); InitializeComponent(); try { _fatIrsUst = mngFatUst.GetByBelgeNoBelgeTipAndSubeKodu(_irsNo, _ftirsip, UserInfo.Sube.Id); if (_fatIrsUst.FatTipi == FatTipi.KapaliFat || _fatIrsUst.FatTipi == FatTipi.MuhtelifFat) { LoadKasa(); cmboxKasalar.Enabled = true; } txtFatNo.Text = mngFatUst.GetLastArtiOneFatIrsNoBySubeKoduAndFtirsip(UserInfo.Sube.Id, DetermineFtirsip(ftirsip)); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
public List <string> GetByBelgeTipAndSubeKodu(string subeKodu, FTIRSIP ftirsip, string fatNo) { ICriteria criteria = Session.CreateCriteria(typeof(FatIrsUst)).SetProjection(Projections.Property("FatirsNo")).Add(Expression.Eq("Ftirsip", ftirsip)) .Add(Expression.Like("FatirsNo", fatNo, MatchMode.Start)).SetMaxResults(GetMaxResult); ICriteria subeCriteria = criteria.CreateCriteria("Sube"); subeCriteria.Add(NHibernate.Criterion.Expression.Eq("Id", subeKodu)); return(criteria.List <string>() as List <string>); }
FTIRSIP DetermineFtirsip(FTIRSIP ftirsip) { if (FTIRSIP.AlisIrs == ftirsip) { return(FTIRSIP.AlisFat); } else { return(FTIRSIP.SatisFat); } }
public static string DetermineGCKodu(FTIRSIP ftirsip) { if (ftirsip == FTIRSIP.AlisFat || ftirsip == FTIRSIP.AlisIrs) { return("G"); } else { return("C"); } }
private void btnIrsaliyestir_Click(object sender, EventArgs e) { if (_currentSipUst != null && !_currentSipUst.Kapatilmis) { FTIRSIP desFtir = FTIRSIP.MusSip == _ftirsip ? FTIRSIP.SatisIrs : FTIRSIP.AlisIrs; frmFatura frm = new frmFatura(desFtir, _currentSipUst, FatNoTip.Irsaliye, listeStok); frm.WindowState = FormWindowState.Maximized; frm.txtBarkod.Focus(); frm.ShowDialog(); YeniSiparis(); } }
private void faturayaGitToolStripMenuItem_Click(object sender, EventArgs e) { try { DataGridViewRow r = dataGridView1.CurrentRow; if (r != null) { string fisNo = dataGridView1.CurrentRow.Cells["FisNo"].Value.ToStringOrEmpty(); string tip = dataGridView1.CurrentRow.Cells["Tip"].Value.ToStringOrEmpty(); string kod = dataGridView1.CurrentRow.Cells["GCKod"].Value.ToStringOrEmpty(); FTIRSIP ftir = FTIRSIP.AlisFat; Indeks.Data.Helper.FatNoTip fatn = Indeks.Data.Helper.FatNoTip.Fatura; if (tip == "Fatura") { fatn = Indeks.Data.Helper.FatNoTip.Fatura; if (kod == "MalAlış") { ftir = FTIRSIP.AlisFat; } else { if (fisNo.StartsWith("0ds")) { ftir = FTIRSIP.DirektSatis; } else { ftir = FTIRSIP.SatisFat; } } } else if (tip == "İrsaliye") { fatn = Indeks.Data.Helper.FatNoTip.Irsaliye; if (kod == "MalAlış") { ftir = FTIRSIP.AlisIrs; } else { ftir = FTIRSIP.SatisFat; } } frmFatura frm = new frmFatura(ftir, fatn, fisNo); frm.WindowState = FormWindowState.Maximized; frm.Show(); } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
public IList<StokHarRpr> GetByFisNoAndSubeKodu(string fisNo, string subeKodu,FTIRSIP ftirsip) { //ICriteria criteria = Session.CreateCriteria(typeof(StokHareket)).Add(Expression.Eq("FisNo",fisNo)); string kdvOrani = ""; if (ftirsip == FTIRSIP.AlisFat || ftirsip == FTIRSIP.AlisIrs || ftirsip == FTIRSIP.SaticiSip) kdvOrani = "sh.Stok.AlisKdvOrani"; else kdvOrani = "sh.Stok.SatisKdvOrani"; IQuery criter = Session.CreateQuery("select new StokHarRpr(sh.Stok.Barkod1,sh.Id,sh.Stok.Id,sh.Stok.StokAdi,sh.HareketMiktar,sh.HareketBirim,sh.GCMiktar,sh.BirimFiyat,sh.Isk1,sh.Isk2,sh.Isk3,sh.Isk4,sh.Isk5,sh.HareketMiktar*sh.BirimFiyat,sh.Kdv) from StokHareket sh where sh.FisNo=:fis and sh.FTIRSIP=:ftirsip and sh.Sube.Id=:subeKodu").SetString("fis", fisNo).SetString("subeKodu",subeKodu).SetEnum("ftirsip", ftirsip); return criter.List<StokHarRpr>(); //ICriteria fatirsUstCriteria = criteria.CreateCriteria("FatirsUst"); //fatirsUstCriteria.Add(NHibernate.Criterion.Expression.Eq("Id", fatirsUst)); //return criteria.List<StokHareket>(); }
public frmStokListe(FTIRSIP ftirsip, string fisNo) { InitializeComponent(); mngFac = new ManagerFactory(Engine.GetConString(), Engine.GetSqlServerType()); mngStokHar = mngFac.GetStokHareketManager(); try { dataGridView1.AutoGenerateColumns = false; IList <StokHarRpr> rpr = mngStokHar.GetByFisNoAndSubeKodu(fisNo, UserInfo.Sube.Id, ftirsip); dataGridView1.DataSource = rpr; dataGridView1.Columns[clTutar.Name].DefaultCellStyle.Format = "F2"; } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
public frmStok(Form frmFatSip, FTIRSIP ftirsip) { InitializeComponent(); this.frmFatSiip = frmFatSip; this.ftirsip = ftirsip; YukleDatalari(); if (frmFatSiip is frmFatura) { frmFatura f = frmFatSiip as frmFatura; txtStokKodu.Text = f.txtStokKodu.Text; txtBarkod1.Text = f.txtBarkod.Text; } else if (frmFatSiip is frmSiparis) { frmSiparis f = frmFatSiip as frmSiparis; txtStokKodu.Text = f.txtStokKodu.Text; txtBarkod1.Text = f.txtBarkod.Text; } }
public void TopluHareketSil(string fisNo, FTIRSIP ftirsip) { byte ftir = (byte)ftirsip; IDbConnection con = Session.Connection; IDbCommand cmd = con.CreateCommand(); string query = "delete from StokHareket where FTIRSIP=" + ftir + " and FisNo='" + fisNo + "' "; cmd.CommandText = query; //IDbTransaction trs = con.BeginTransaction(); cmd.Connection = con; cmd.ExecuteNonQuery(); //cmd.Transaction = trs; //try //{ // cmd.ExecuteNonQuery(); //trs.Commit(); //} //catch //{ // trs.Rollback(); // throw; //} }
public void TopluKalemSil(string fisNo, FTIRSIP ftirsip) { byte ftir = (byte)ftirsip; IDbConnection con = Session.Connection; IDbCommand cmd = con.CreateCommand(); string query = "delete from SiparisKalem where FTIRSIP=" + ftir + " and FisNo='" + fisNo + "' "; cmd.CommandText = query; IDbTransaction trs = con.BeginTransaction(); cmd.Connection = con; cmd.Transaction = trs; try { cmd.ExecuteNonQuery(); trs.Commit(); } catch { trs.Rollback(); throw; } }
public string GetLastArtiOneFatIrsNoBySubeKoduAndFtirsip(string subeKodu, FTIRSIP ftirsip) { ICriteria criteria = Session.CreateCriteria(typeof(FatIrsUst)).SetProjection(Projections.Max("FatirsNo")) .Add(Expression.Eq("Ftirsip", ftirsip)).SetMaxResults(1); ICriteria subeCriteria = criteria.CreateCriteria("Sube"); subeCriteria.Add(NHibernate.Criterion.Expression.Eq("Id", subeKodu)); string fatNo = criteria.UniqueResult <string>(); if (!string.IsNullOrEmpty(fatNo)) { for (int i = fatNo.Length - 1; i > 0; i--) { if (char.IsDigit(fatNo[i])) { int deger = int.Parse(fatNo[i].ToString()); deger = deger + 1; if (deger > 9) { fatNo = fatNo.Remove(i, 1); fatNo = fatNo.Insert(i, "0"); } else { fatNo = fatNo.Remove(i, 1); fatNo = fatNo.Insert(i, deger.ToString()); break; } } else { break; } } } return(fatNo); }
public frmFatRehber(Form form, FTIRSIP ftirsip) { InitializeComponent(); _frm = form; _ftirsip = ftirsip; _mngFac = new ManagerFactory(Engine.GetConString(), Engine.GetSqlServerType()); _mngFatIrsUst = _mngFac.GetFatirsUstManager(); _mngSipUst = _mngFac.GetSiparisUstManager(); try { dataGridView1.AutoGenerateColumns = false; if (_frm is frmFatura) { dataGridView1.DataSource = _mngFatIrsUst.GetListByFtirsipAndSubeKodu(ftirsip, UserInfo.Sube.Id); clTeslimTarih.Visible = false; clFatirsNo.HeaderText = "IrsaliyeNo"; if (ftirsip == FTIRSIP.SatisFat || ftirsip == FTIRSIP.AlisFat || ftirsip == FTIRSIP.DirektSatis) { clSevkTarih.Visible = false; clFatirsNo.HeaderText = "FaturaNo"; } } else if (_frm is frmSiparis) { EkranAyarla(); dataGridView1.DataSource = _mngSipUst.GetListByFtirsipAndSubeKodu(ftirsip, UserInfo.Sube.Id); clSevkTarih.Visible = false; clFatirsNo.HeaderText = "SiparişNo"; } } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } }
public frmStokSearch(FTIRSIP ftirsip) { InitializeComponent(); _ftirsip = ftirsip; }
public List <KodIsim> GetCariKodsBySubeKodu(string subeKodu, string cariKodIsim, FTIRSIP ftirsip) { KodIsim kodIsim = null; IQueryOver <Cari, Cari> over = Session.QueryOver <Cari>().Where(x => (x.Sube.Id == subeKodu || x.SubelerdeOrtak == true) && (x.Id.IsLike(cariKodIsim, MatchMode.Anywhere) || x.CariIsim.IsLike(cariKodIsim, MatchMode.Anywhere))); if (FTIRSIP.AlisFat == ftirsip || FTIRSIP.AlisIrs == ftirsip) { over.And(x => (x.CariTip == "S" || x.CariTip == "AS")); } else if (FTIRSIP.SatisFat == ftirsip || FTIRSIP.SatisIrs == ftirsip) { over.And(x => (x.CariTip == "A" || x.CariTip == "AS")); } return(over.SelectList(liste => liste.SelectGroup(c => c.Id).WithAlias(() => kodIsim.Kod) .SelectGroup(c => c.CariIsim).WithAlias(() => kodIsim.Isim) ).TransformUsing(Transformers.AliasToBean <KodIsim>()) .Take(GetMaxResult).List <KodIsim>() as List <KodIsim>); }
public HesaplaToplam(FTIRSIP ftirsip) { this.Ftirsip = ftirsip; }
public IList <StokHarRpr> GetByFisNoAndSubeKodu(string fisNo, string subeKodu, FTIRSIP ftirsip) { //IQuery criter = Session.CreateQuery("select new StokHarRpr(sh.Stok.Barkod1,sh.Id,sh.Stok.Id,sh.Stok.StokAdi,sh.HareketMiktar,sh.HareketBirim,sh.GCMiktar,sh.BirimFiyat,sh.Isk1,sh.Isk2,sh.Isk3,sh.Isk4,sh.Isk5,sh.HareketMiktar*sh.BirimFiyat,sh.Kdv) from StokHareket sh where sh.FisNo=:fis and sh.Sube.Id=:sk").SetString("fis", fisNo).SetString("sk", subeKodu); IQuery criter = Session.CreateQuery("select new StokHarRpr(sh.Stok.Barkod1,sh.Id,sh.Stok.Id,sh.Stok.StokAdi,sh.HareketMiktar,sh.HareketBirim,sh.GCMik,sh.BirimFiyat,sh.Isk1,sh.Isk2,sh.Isk3,sh.Isk4,sh.Isk5,sh.HareketMiktar*sh.BirimFiyat,sh.KdvOrani) from SiparisKalem sh where sh.FisNo=:fis and sh.Ftirsip=:ftirsip and sh.Sube.Id=:subeKodu").SetString("fis", fisNo).SetString("subeKodu", subeKodu).SetEnum("ftirsip", ftirsip); return(criter.List <StokHarRpr>()); }
//HesaplaGenelToplam genelToplamlar; //IList<StokHarRpr> listeStok; public frmSiparis(FTIRSIP ftirsip) : base() { InitializeComponent(); this._ftirsip = ftirsip; //mng = new ManagerFactory(Engine.GetConString(), Engine.GetSqlServerType()); mngSipUst = mng.GetSiparisUstManager(); mngSipKal = mng.GetSiparisKalemManager(); //mngStk = mng.GetStokManager(); //mngCari = mng.GetCariManager(); //mngSth = mng.GetStokHareketManager(); mngDizayn = mng.GetDizaynManager(); this.Text = _ftirsip.ToString(); //txtFatNo.DataSource=()=>(mngFatNo.GetFatNumaraBySubeKoduAndFatNoTip(txtFatNo.Text,UserInfo.Sube.Id,fatNoTip.ToEqualDatabaseValue())); txtStokKodu.DataSource = () => { try { return(mngStk.StokKods(txtStokKodu.Text, UserInfo.Sube).ToStringList(35, txtStokKodu.Ayirac)); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } return(null); }; txtCari.DataSource = () => { try { return(mngCari.GetCariKodsBySubeKodu(UserInfo.Sube.Id, txtCari.Text, ftirsip).ToStringList(15, txtCari.Ayirac)); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } return(null); }; txtFatNo.DataSource = () => { try { return(mngSipUst.GetByBelgeTipAndSubeKodu(UserInfo.Sube.Id, _ftirsip, txtFatNo.Text)); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } return(null); }; GetLastArtiSipNo(); this.Focus(); txtFatNo.Focus(); //txtFatNo.SelectAll(); txtFatNo.SelectionStart = txtFatNo.Text.Length; LoadDizayn(); dateTarih.initializeTimePiceker(); dtTeslimTarih.initializeTimePiceker(); filterDataGridView1.grd.CellClick += new DataGridViewCellEventHandler(grd_CellClick); }