private void btnSil_Click(object sender, EventArgs e)
{
DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
bool beginTrans = false;
if (re == DialogResult.Yes)
{
try {
DataGridViewRow dr = dataGridView1.SelectedRows[0];
if (dr != null)
{
if (StokCariCategory.Stok == _stokCari)
{
StokCategory sc = _mngCatStok.GetById(dr.Cells[clId.Name].Value.ToString(), false);
beginTrans = true;
BeginTransaction();
sc.ParentCategory = null;
_mngCatStok.Delete(sc);
}
if (StokCariCategory.Cari == _stokCari)
{
CariCategory cc = _mngCatCari.GetById(dr.Cells[clId.Name].Value.ToString(), false);
beginTrans = true;
BeginTransaction();
cc.ParentCategory = null;
_mngCatCari.Delete(cc);
}
}
} catch (Exception) { } finally {
try {
if (beginTrans)
{
CommitTransaction();
}
if (_useParent)
{
LoadData(_parentCategory);
}
else
{
LoadData();
}
} catch (Exception exc) {
MessageBox.Show(exc.Message); LogWrite.Write(exc);
}
}
}
}
void setData()
{
try {
if (_stokCari == StokCariCategory.Stok)
{
StokCategory sc = _mngStkCat.GetById(_categoryId, false);
if (sc != null && sc.ParentCategory != null)
{
txtSelectedCategory.Text = string.Format("{0}", sc.ParentCategory.Id);
txtCatCode.Text = sc.Id;
txtCatName.Text = sc.CategoryName;
txtCatCode.Enabled = false;
}
else if (sc != null)
{
txtCatCode.Text = sc.Id;
txtCatName.Text = sc.CategoryName;
chkAnaKategori.Checked = true;
txtCatCode.Enabled = false;
}
}
else
{
CariCategory cc = _mngCariCat.GetById(_categoryId, false);
if (cc != null && cc.ParentCategory != null)
{
txtSelectedCategory.Text = string.Format("{0}", cc.ParentCategory.Id);
txtCatCode.Text = cc.Id;
txtCatName.Text = cc.CategoryName;
txtCatCode.Enabled = false;
}
else if (cc != null)
{
txtCatCode.Text = cc.Id;
txtCatName.Text = cc.CategoryName;
txtCatCode.Enabled = false;
chkAnaKategori.Checked = true;
}
}
} catch (Exception exc) {
LogWrite.Write(exc);
MessageBox.Show(exc.Message);
}
}
void Kaydet()
{
if (string.IsNullOrEmpty(txtCatCode.Text))
{
errorProvider1.SetError(txtCatCode, "kategori kodunu giriniz");
return;
}
if (string.IsNullOrEmpty(txtCatName.Text))
{
errorProvider1.SetError(txtCatName, "kategori ismini giriniz");
return;
}
if (!chkAnaKategori.Checked && string.IsNullOrEmpty(txtSelectedCategory.Text))
{
errorProvider1.SetError(txtSelectedCategory, "ana kategori seçiniz");
return;
}
try {
if (StokCariCategory.Stok == _stokCari)
{
StokCategory sc = _mngStkCat.GetById(txtCatCode.Text, false);
if (sc == null)
{
sc = new StokCategory {
Id = txtCatCode.Text
}
}
;
sc.CategoryName = txtCatName.Text;
if (chkAnaKategori.Checked)
{
sc.ParentCategory = null;
}
else
{
StokCategory parent = _mngStkCat.GetById(txtSelectedCategory.Text, false);
sc.ParentCategory = parent;
}
sc.Sube = UserInfo.Sube;
BeginTransaction();
_mngStkCat.SaveOrUpdate(sc);
}
else
{
CariCategory cc = _mngCariCat.GetById(txtCatCode.Text, false);
if (cc == null)
{
cc = new CariCategory {
Id = txtCatCode.Text
}
}
;
cc.CategoryName = txtCatName.Text;
if (chkAnaKategori.Checked)
{
cc.ParentCategory = null;
}
else
{
CariCategory parent = _mngCariCat.GetById(txtSelectedCategory.Text, false);
cc.ParentCategory = parent;
}
cc.Sube = UserInfo.Sube;
BeginTransaction();
_mngCariCat.SaveOrUpdate(cc);
}
} catch (Exception) {
} finally {
try {
CommitTransaction();
this.Close();
} catch (Exception exc) {
MessageBox.Show(exc.Message);
LogWrite.Write(exc);
}
}
}
//T Deneme<T, IdT>(IManagerBase<T, IdT> mng,IdT id)
//{
// return mng.GetById(id,false);
//}
void AssStokValues(Stok stok)
{
CultureInfo ci = new CultureInfo("tr-TR");
stok.StokAdi = txtStokIsmi.Text;
//stok.KdvOrani = txtAlisKdvOrani.Text.ParseNullable<double>(x => double.Parse(x, ci));
stok.AlisKdvOrani = txtAlisKdvOrani.Text.ParseStruct <double>(x => double.Parse(x, ci));
stok.SatisKdvOrani = txtSatisKdvOrani.Text.ParseStruct <double>(x => double.Parse(x, ci));
stok.AnaBirim = txtAnaBirim.Text.Trim();
stok.AltBirim1 = txtAltBirim1.Text.Trim();
stok.Carpan1 = txtCarpan1.Text.ParseNullable <double>(x => double.Parse(x, ci));
stok.AltBirim2 = txtAltBirim2.Text.Trim();
stok.Carpan2 = txtCarpan2.Text.ParseNullable <double>(x => double.Parse(x, ci));
stok.AltBirim3 = txtAltBirim3.Text.Trim();
stok.Carpan3 = txtCarpan3.Text.ParseNullable <double>(x => double.Parse(x, ci));
stok.AsgariMiktar = txtAsgariMiktar.Text.ParseNullable <int>(x => int.Parse(x, ci));
stok.AzamiMiktar = txtAzamiMiktar.Text.ParseNullable <int>(x => int.Parse(x, ci));
stok.AlisFiyat1 = txtAlisFyt1.Text.ParseNullable <double>(delegate(string x) { return(double.Parse(x, ci)); });
stok.AlisFiyat2 = txtAlisFyt2.Text.ParseNullable <double>(delegate(string x) { return(double.Parse(x, ci)); });
stok.AlisFiyat3 = txtAlisFyt3.Text.ParseNullable <double>(delegate(string x) { return(double.Parse(x, ci)); });
//stok.AlisDovTipi = mngKur.GetByKurName(cmbAlisFytKur.Text);
stok.SatisFiyat1 = txtSatisFyt1.Text.ParseNullable <double>(x => double.Parse(x, ci));
stok.SatisFiyat2 = txtSatisFyt2.Text.ParseNullable <double>(x => double.Parse(x, ci));
stok.SatisFiyat3 = txtSatisFyt3.Text.ParseNullable <double>(x => double.Parse(x, ci));
//stok.SatDovTipi = mngKur.GetByKurName(cmbSatisFyt.Text);
stok.SubelerdeOrtak = chkSubelerdeOrtak.Checked;
StokCategory parentCat1 = null;
StokCategory parentCat2 = null;
StokCategory parentCat3 = null;
StokCategory parentCat4 = null;
if (!string.IsNullOrEmpty(txtStGrup1.Text))
{
parentCat1 = mngStokCat.GetById(txtStGrup1.Text, false);
if (parentCat1 == null)
{
//mngStokCat.BeginTransaction();
stok.Grup1 = parentCat1 = mngStokCat.Save(new StokCategory()
{
Id = txtStGrup1.Text, Sube = UserInfo.Sube
});
//mngStokCat.CommitTransaction();
}
else
{
stok.Grup1 = parentCat1;
}
}
else
{
stok.Grup1 = null;
}
if (parentCat1 != null && !string.IsNullOrEmpty(txtStGrup1.Text) && !string.IsNullOrEmpty(txtStGrup2.Text))
{
parentCat2 = mngStokCat.GetById(txtStGrup2.Text, false);
if (parentCat2 == null)
{
//mngStokCat.BeginTransaction();
parentCat2 = new StokCategory {
Id = txtStGrup2.Text, Sube = UserInfo.Sube, ParentCategory = parentCat1
};
stok.Grup2 = mngStokCat.Save(parentCat2);
//mngStokCat.CommitTransaction();
}
else
{
stok.Grup2 = parentCat2;
}
}
else
{
stok.Grup2 = null;
}
if (parentCat2 != null && !string.IsNullOrEmpty(txtStGrup2.Text) && !string.IsNullOrEmpty(txtStGrup3.Text))
{
parentCat3 = mngStokCat.GetById(txtStGrup3.Text, false);
if (parentCat3 == null)
{
//mngStokCat.BeginTransaction();
parentCat3 = new StokCategory {
Id = txtStGrup3.Text, Sube = UserInfo.Sube, ParentCategory = parentCat2
};
stok.Grup3 = mngStokCat.Save(parentCat3);
//mngStokCat.CommitTransaction();
}
else
{
stok.Grup3 = parentCat3;
}
}
else
{
stok.Grup3 = null;
}
if (parentCat3 != null && !string.IsNullOrEmpty(txtStGrup3.Text) && !string.IsNullOrEmpty(txtStGrup4.Text))
{
parentCat4 = mngStokCat.GetById(txtStGrup4.Text, false);
if (parentCat4 == null)
{
//mngStokCat.BeginTransaction();
parentCat4 = new StokCategory {
Id = txtStGrup4.Text, Sube = UserInfo.Sube, ParentCategory = parentCat3
};
stok.Grup4 = mngStokCat.Save(parentCat4);
//mngStokCat.CommitTransaction();
}
else
{
stok.Grup4 = parentCat4;
}
}
else
{
stok.Grup4 = null;
}
if (parentCat4 != null && !string.IsNullOrEmpty(txtStGrup4.Text) && !string.IsNullOrEmpty(txtStGrup5.Text))
{
StokCategory parentCat5 = mngStokCat.GetById(txtStGrup5.Text, false);
if (parentCat5 == null)
{
//mngStokCat.BeginTransaction();
parentCat5 = new StokCategory {
Id = txtStGrup5.Text, Sube = UserInfo.Sube, ParentCategory = parentCat4
};
stok.Grup5 = mngStokCat.Save(parentCat5);
//mngStokCat.CommitTransaction();
}
else
{
stok.Grup5 = parentCat5;
}
}
else
{
stok.Grup5 = null;
}
stok.Barkod1 = txtBarkod1.Text; stok.Barkod2 = txtBarkod2.Text; stok.Barkod3 = txtBarkod3.Text;
}
public DataTable StokMalMaliyetRaporu(string subeKodu, string stokKodu,string stokGrup, DateTime? startDate, DateTime? finishDate) {
IDbConnection con = Session.Connection;
IDbCommand cmd = con.CreateCommand();
StringBuilder query = new StringBuilder();
query.AppendFormat(@" SELECT st.STOK_KODU StokKodu,st.STOK_ADI StokIsmi,
sum(case when sh.GCKOD='G' then sh.GCMIK else 0 end) as AlışMiktar,
sum(case when sh.GCKOD='C' then sh.GCMIK else 0 end) as SatişMiktar,
sum(case when sh.GCKOD='G' then (sh.BIRIM_FIYAT*sh.GCMIK)
end)/
sum(case when (sh.GCMIK<>0 and sh.GCKOD='G') then sh.GCMIK end ) as OrtalamaAlışFiyat
,
sum(case when sh.GCKOD='C' then (sh.BIRIM_FIYAT*sh.GCMIK)
end)/
sum(case when (sh.GCMIK<>0 and sh.GCKOD='C') then sh.GCMIK end ) as OrtalamaSatışFiyat
FROM StokHareket sh INNER JOIN
Stok st ON sh.STOK_KODU = st.STOK_KODU
where (st.SUBE_KODU='{0}' or st.SubelerdeOrtak=1)
", subeKodu);
if (!string.IsNullOrEmpty(stokGrup)) {
IStokCategoryManager mng=new StokCategoryManager();
StokCategory sc=mng.GetById(stokGrup,false);
StringBuilder qin = new StringBuilder();
List<string> ary = mng.GetCategoryOfAllSubCategory(sc).Select(x => x.Id).ToList();
ary.Insert(0,string.Format("{0}" ,stokGrup));
foreach (var item in ary) {
qin.AppendFormat("'{0}'",item); qin.Append(",");
}
qin.Remove(qin.Length - 1, 1);
query.AppendFormat(" and (st.Grup1 in({0}) or st.Grup2 in({0}) or st.Grup3 in({0}) or st.Grup4 in({0}) )",qin);
}
if (startDate.HasValue && finishDate.HasValue)
query.AppendFormat(" and {0} between '{1}' and '{2}' ", SqlTypeHelper.GetDate("sh.TARIH"), startDate.Value.JustDate().ToString("yyyy-MM-dd"), finishDate.Value.JustDate().ToString("yyyy-MM-dd"));
if (!string.IsNullOrEmpty(stokKodu))
query.AppendFormat(" and st.STOK_KODU='{0}'", stokKodu);
query.Append(" group by st.STOK_KODU,st.STOK_ADI");
cmd.CommandText = query.ToString();
IDataReader dread = null;
DataTable dt = new DataTable();
try {
dread = cmd.ExecuteReader();
dt.Columns.AddRange(
new DataColumn[]
{
new DataColumn("StokKodu",typeof(string)),
new DataColumn("StokIsmi",typeof(string)),
new DataColumn("AlisMiktar",typeof(double)),
new DataColumn("SatisMiktar",typeof(double)),
new DataColumn("KalanMiktar",typeof(double)),
new DataColumn("OrtalamaAlisFiyat",typeof(double)),
new DataColumn("OrtalamaSatisFiyat",typeof(double)),
new DataColumn("AlisTutar",typeof(double)),
new DataColumn("SatisTutar",typeof(double)),
new DataColumn("YuzdeKarOranı",typeof(double)),
new DataColumn("KalanMalinMaliyeti",typeof(double))
}
);
while (dread.Read()) {
DataRow dr = dt.NewRow();
dr[0] = dread[0].ToStringOrEmpty();
dr[1] = dread[1].ToStringOrEmpty();
dr[2] = dread[2].ToStringOrEmpty("0");
dr[3] = dread[3].ToStringOrEmpty("0");
dr[4] = (double.Parse(dread[2].ToStringOrEmpty("0")) - double.Parse(dread[3].ToStringOrEmpty("0"))).ToString("F2");
dr[5] =double.Parse( dread[4].ToStringOrEmpty("0")).ToString("F2");
dr[6] =double.Parse(dread[5].ToStringOrEmpty("0")).ToString("F2");
dr[7] =(double.Parse(dr[2].ToStringOrEmpty("0")) * double.Parse(dr[5].ToStringOrEmpty("0"))).ToString("F2");
dr[8] = (double.Parse(dr[3].ToStringOrEmpty("0")) * double.Parse(dr[6].ToStringOrEmpty("0"))).ToString("F2");
double oa=double.Parse(dr[5].ToStringOrEmpty("0"));
double os=double.Parse(dr[6].ToStringOrEmpty("0"));
dr[9] = (((os-oa)/oa)*100).ToString("F2");
dr[10] = (oa * double.Parse(dr[4].ToString())).ToStringOrEmpty("0");
dt.Rows.Add(dr);
}
} catch (Exception exc) { throw exc; } finally {
if (dread != null && !dread.IsClosed)
dread.Close();
}
return dt;
}
