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);
}
