public frmTarihliKar()
{
InitializeComponent();
lokKategori.Properties.DataSource = kategoriDal.GetAll(context);
lookAnaGrup.Properties.DataSource = anagrupDal.GetAll(context);
lookAltGrup.Properties.DataSource = altgrupDal.GetAll(context);
lookMarka.Properties.DataSource = stokDal.StokListele(context);
lookUretici.Properties.DataSource = stokDal.StokListele(context);
dtpBaslangic.DateTime = new DateTime(DateTime.Now.Year, 1, 1);
dtpBitis.DateTime = new DateTime(DateTime.Now.Year, 12, 31);
}
public frmTarihliAlis()
{
InitializeComponent();
lokKategori.Properties.DataSource = kategoriDal.GetAll(context);
lookAnaGrup.Properties.DataSource = anagrupDal.GetAll(context);
lookAltGrup.Properties.DataSource = altgrupDal.GetAll(context);
lookMarka.Properties.DataSource = stokDal.StokListele(context);
lookUretici.Properties.DataSource = stokDal.StokListele(context);
dtpBaslangic.DateTime = new DateTime(DateTime.Now.Year, 1, 1, 00, 00, 00);
dtpBitis.DateTime = new DateTime(DateTime.Now.Year, 12, 31, 23, 59, 59);
dtpBaslangic.Properties.Mask.MaskType = MaskType.DateTimeAdvancingCaret;
dtpBitis.Properties.Mask.MaskType = MaskType.DateTimeAdvancingCaret;
}
public rptStokDurumu()
{
InitializeComponent();
BenimSalonumContext context = new BenimSalonumContext();
StokDAL stokDal = new StokDAL();
ObjectDataSource stokDataSource = new ObjectDataSource {
DataSource = stokDal.StokListele(context)
};
this.DataSource = stokDataSource;
colStokKodu.DataBindings.Add("Text", this.DataAdapter, "StokKodu");
colStokAdi.DataBindings.Add("Text", this.DataAdapter, "StokAdi");
colBarkod.DataBindings.Add("Text", this.DataAdapter, "Barkod");
colBirimi.DataBindings.Add("Text", this.DataAdapter, "Birimi");
colStokKdv.DataBindings.Add("Text", this.DataAdapter, "SatisKdv");
colStokGiris.DataBindings.Add("Text", this.DataAdapter, "StokGiris");
colStokCikis.DataBindings.Add("Text", this.DataAdapter, "StokCikis");
colMevcutStok.DataBindings.Add("Text", this.DataAdapter, "MevcutStok");
KullaniciAdi.Text = RoleTool.kullaniciEntity.KullaniciAdi;
}
public rptStokdurumu()
{
InitializeComponent();
netsatisContext context = new netsatisContext();
StokDAL stokDal = new StokDAL();
ObjectDataSource stokdatasource = new ObjectDataSource {
DataSource = stokDal.StokListele(context)
};
this.DataSource = stokdatasource;
colstokkodu.DataBindings.Add("Text", this.DataSource, "StokKodu");
colbarkod.DataBindings.Add("Text", this.DataSource, "Barkod");
colstokadı.DataBindings.Add("Text", this.DataSource, "StokAdi");
colbirimi.DataBindings.Add("Text", this.DataSource, "Birimi");
colstokgrubu.DataBindings.Add("Text", this.DataSource, "StokGrubu");
colstokaltgrubu.DataBindings.Add("Text", this.DataSource, "StokAltGrubu");
colstokkdv.DataBindings.Add("Text", this.DataSource, "SatisKdv");
colstokgiri.DataBindings.Add("Text", this.DataSource, "StokGiris");
colstokcik.DataBindings.Add("Text", this.DataSource, "StokCikis");
colmevcutsto.DataBindings.Add("Text", this.DataSource, "MevcutStok");
}
public rptStokDurumu()
{
InitializeComponent();
NetSatisContext context = new NetSatisContext();
StokDAL stokDal = new StokDAL();
ObjectDataSource stokDataSource = new ObjectDataSource {
DataSource = stokDal.StokListele(context)
};
this.DataSource = stokDataSource;
colStokKodu.DataBindings.Add("Text", this.DataSource, "StokKodu");
colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi");
colBirim.DataBindings.Add("Text", this.DataSource, "Birim");
colSatisKdv.DataBindings.Add("Text", this.DataSource, "SatisKdv");
colStokGiris.DataBindings.Add("Text", this.DataSource, "StokGiris");
colStokCikis.DataBindings.Add("Text", this.DataSource, "StokCikis");
colMevcutStok.DataBindings.Add("Text", this.DataSource, "MevcutStok");
XRSummary sumStokToplam = new XRSummary();
sumStokToplam.Func = SummaryFunc.Sum;
sumStokToplam.Running = SummaryRunning.Group;
sumStokToplam.FormatString = "{0:N2}";
lblToplamStok.DataBindings.Add("Text", null, "MevcutStok");
lblToplamStok.Summary = sumStokToplam;
}
public RptStokDurumu()
{
InitializeComponent();
YemekYemekContext context = new YemekYemekContext();
StokDAL stokdal = new StokDAL();
ObjectDataSource stokdataSource = new ObjectDataSource {
DataSource = stokdal.StokListele(context)
};
this.DataSource = stokdataSource;
colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi");
colStokKodu.DataBindings.Add("Text", this.DataSource, "StokKodu");
colBarkod.DataBindings.Add("Text", this.DataSource, "Barkod");
colBirimi.DataBindings.Add("Text", this.DataSource, "Birimi");
colStokGrubu.DataBindings.Add("Text", this.DataSource, "StokGrubu");
colStokAltGrubu.DataBindings.Add("Text", this.DataSource, "StokAltGrubu");
colStokGiris.DataBindings.Add("Text", this.DataSource, "StokGiris");
colStokCikis.DataBindings.Add("Text", this.DataSource, "StokCikis");
colMevcutStok.DataBindings.Add("Text", this.DataSource, "MevcutStok");
colSatisKdv.DataBindings.Add("Text", this.DataSource, "SatisKdv");
}
public rptStokDurumu()
{
InitializeComponent();
FaysConceptContext context = new FaysConceptContext();
StokDAL stokDAL = new StokDAL();
//linq sorguları yapmak için
ObjectDataSource stokDataSource = new ObjectDataSource {
DataSource = stokDAL.StokListele(context)
};
this.DataSource = stokDataSource;
colStokKodu.DataBindings.Add("Text", this.DataSource, "StokKodu");
colBarkodNo.DataBindings.Add("Text", this.DataSource, "BarkodNo");
colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi");
colBirimi.DataBindings.Add("Text", this.DataSource, "Birimi");
colStokGrubu.DataBindings.Add("Text", this.DataSource, "StokGrubu");
colStokAltGrubu.DataBindings.Add("Text", this.DataSource, "StokAltGrubu");
colStokGiris.DataBindings.Add("Text", this.DataSource, "StokGiris");
colStokCikis.DataBindings.Add("Text", this.DataSource, "StokCikis");
colMevcutStok.DataBindings.Add("Text", this.DataSource, "MevcutStok");
}
public void GetAll()
{
gridControl1.DataSource = stokdal.StokListele(context);
}
public void listele()
{
gridControl1.DataSource = stokDal.StokListele(context);
}
public void GetAll()
{
StokGridControl.DataSource = stokDal.StokListele(context);
}
private void frmStokSec_Load(object sender, EventArgs e)
{
gridcontStoklar.DataSource = stokDAL.StokListele(context);
}
private void FrmStokSec_Load(object sender, EventArgs e)
{
gridConStoklar.DataSource = stokdal.StokListele(context);
}
private void FrmStokSec_Load(object sender, EventArgs e)
{
GridContStokSec.DataSource = stokDal.StokListele(context);
}
private void GetAll()
{
gridControl1.DataSource = stokDAL.StokListele(context);
}
public rptStokDurumBakiye()
{
InitializeComponent();
NetSatisContext context = new NetSatisContext();
StokDAL stokDal = new StokDAL();
ObjectDataSource stokDataSource = new ObjectDataSource {
DataSource = stokDal.StokListele(context, false)
};
this.DataSource = stokDataSource;
colStokKodu.DataBindings.Add("Text", this.DataSource, "StokKodu");
colStokAdi.DataBindings.Add("Text", this.DataSource, "StokAdi");
colBirim.DataBindings.Add("Text", this.DataSource, "Birim");
//colAlisFiyati.DataBindings.Add("Text", this.DataSource, "AlisFiyati3");
//var stk = (int?)this.colAlisFiyati.Value;
//if (!stk.HasValue && stk != 0)
// colAlisFiyati.DataBindings.Add("Text", this.DataSource, "AlisFiyati2");
//stk = (int?)this.colAlisFiyati.Value;
//if (!stk.HasValue && stk != 0)
// colAlisFiyati.DataBindings.Add("Text", this.DataSource, "AlisFiyati1");
colAlisFiyati.DataBindings.Add("Text", this.DataSource, "AlisFiyati1");
colSatisFiyat.DataBindings.Add("Text", this.DataSource, "SatisFiyati1");
colMevcutStok.DataBindings.Add("Text", this.DataSource, "MevcutStok");
CalculatedField calcTutar = new CalculatedField();
this.CalculatedFields.Add(calcTutar);
calcTutar.Name = "Tutar";
calcTutar.Expression = "[MevcutStok]*[AlisFiyati1]";
colBakiye.DataBindings.Add("Text", null, "Tutar", "{0:C2}");
CalculatedField calcTutar2 = new CalculatedField();
this.CalculatedFields.Add(calcTutar2);
calcTutar2.Name = "Tutar2";
calcTutar2.Expression = "[MevcutStok]*[SatisFiyati1]";
colBakiye2.DataBindings.Add("Text", null, "Tutar2", "{0:C2}");
XRSummary sumStokToplam = new XRSummary();
sumStokToplam.Func = SummaryFunc.Sum;
sumStokToplam.Running = SummaryRunning.Group;
sumStokToplam.FormatString = "{0:C2}";
XRSummary sumStokToplam2 = new XRSummary();
sumStokToplam2.Func = SummaryFunc.Sum;
sumStokToplam2.Running = SummaryRunning.Group;
sumStokToplam2.FormatString = "{0:C2}";
lblToplamBakiye.DataBindings.Add("Text", null, "Tutar");
lblToplamBakiye.Summary = sumStokToplam;
lblToplamBakiye2.DataBindings.Add("Text", null, "Tutar2");
lblToplamBakiye2.Summary = sumStokToplam2;
}