void FillData()
{
bindCountry.DataSource = db.GetDataTable("select * from sysBankBranch order by Ref ASC");
RowCount = grdGrid.RowCount;
riledbank.DataSource = db.GetDataTable("select * from sysBank");
riLedCity.DataSource = db.GetDataTable("select * from sysCity");
}
private void btnLoadDb_Click(object sender, EventArgs e)
{
DataTable dtDb = db.GetDataTable("SELECT name DbName FROM master.dbo.sysdatabases");
for (int i = 0; i < dtDb.Rows.Count; i++)
{
cmbDb.flashCombo.Properties.Items.Add(dtDb.Rows[i][0].ToString());
}
}
void FillData()
{
db.AddParameterValue("@Ref", this._Ref);
dtList = db.GetDataTable("select * from sysRole where Ref=@Ref");
REf = int.Parse(dtList.Rows[0][0].ToString());
txtCode.SetString(dtList.Rows[0][1].ToString());
txtName.SetString(dtList.Rows[0][2].ToString());
txtDesc.SetString(dtList.Rows[0][3].ToString());
}
void FillLookUp()
{
FrmErpMain main = (FrmErpMain)Application.OpenForms["FrmErpMain"];
ledCurr.flaLookUp.Properties.Columns.Clear();
ledCurr.flaLookUp.Properties.ValueMember = "Ref";
ledCurr.flaLookUp.Properties.DisplayMember = "name";
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "code", Caption = "Kodu"
});
ledCurr.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledCurr.flaLookUp.Properties.DataSource = sysDb.GetDataTable("select * from sysCurrency");
sysDb.AddParameterValue("@act", true);
sysDb.AddParameterValue("@ref", Properties.Settings.Default.firmRef);
riLedBranch.DataSource = main.lstBranch.ToList();
db.AddParameterValue("@ref", this._Ref);
dgwBranch.DataSource = db.GetDataTable("select * from StSellPriceListBranch where listRef=@ref ");
}
void FillData()
{
dt = db.GetDataTable(this._Sql);
if (dt != null)
{
dgwList.DataSource = dt;
grdList.Columns["Ref"].Visible = false;
}
grdList.BestFitColumns();
}
void LookUpDoldur()
{
ledDb.flaLookUp.Properties.Columns.Clear();
ledGroup.flaLookUp.Properties.Columns.Clear();
ledRole.flaLookUp.Properties.Columns.Clear();
ledDb.flaLookUp.Properties.ValueMember = "Ref";
ledDb.flaLookUp.Properties.DisplayMember = "name";
ledDb.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledDb.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledDb.flaLookUp.Properties.DataSource = db.GetDataTable("select * from sysDatabase");
ledGroup.flaLookUp.Properties.ValueMember = "Ref";
ledGroup.flaLookUp.Properties.DisplayMember = "name";
ledGroup.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledGroup.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledGroup.flaLookUp.Properties.DataSource = db.GetDataTable("select * from sysUserGroup");
ledRole.flaLookUp.Properties.ValueMember = "Ref";
ledRole.flaLookUp.Properties.DisplayMember = "name";
ledRole.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledRole.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledRole.flaLookUp.Properties.DataSource = db.GetDataTable("select * from sysRole");
}
void FillPerson()
{
this.MaximizeBox = true;
ledPersonel.flaLookUp.Properties.ValueMember = "Ref";
ledPersonel.flaLookUp.Properties.DisplayMember = "Ad Soyad";
ledPersonel.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledPersonel.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ad Soyad", Caption = "Ad Soyad"
});
ledPersonel.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "mission", Caption = "Görev"
});
ledPersonel.flaLookUp.Properties.DataSource = db.GetDataTable("Select Ref,name + ' ' + surname as [Ad Soyad],mission from tbPerson WHERE tbPerson.ExitDate is null OR tbPerson.exitDate = '01.01.1900' ORDER BY [Ad Soyad] asc");
}
private void FrmCreatePermission_Load(object sender, EventArgs e)
{
groupControl3.Enabled = false;
fillLed();
if (_FormMod == Enums.enmFormMod.Guncelle)
{
this._Ref = kRef;
db.AddParameterValue("@ref", kRef);
DataTable dt = db.GetDataTable("select * from tbPermission with(nolock) where Ref=@ref");
ledPersonel.SetValue(int.Parse(dt.Rows[0]["pRef"].ToString()));
cmbIzinTuru.SetString(dt.Rows[0]["pType"].ToString());
dtpIzinBaslangic.SetDate(DateTime.Parse((dt.Rows[0]["pSDate"].ToString())));
dtpIzinBitisTarihi.SetDate(DateTime.Parse((dt.Rows[0]["pFDate"].ToString())));
dtpIseBaslamaTarihi.SetDate(DateTime.Parse((dt.Rows[0]["pWSDate"].ToString())));
txtWhy.SetString(dt.Rows[0]["why"].ToString());
txtDesc.SetString(dt.Rows[0]["desc"].ToString());
ledVekil.SetValue(int.Parse(dt.Rows[0]["vekil"].ToString()));
}
}
void fillData()
{
FrmIKMain main = (FrmIKMain)Application.OpenForms["FrmIKMain"];
DataTable dt = new DataTable();
if (main.who != "YSK")
{
db.AddParameterValue("@unit", main.pUnit);
dt = db.GetDataTable(@" SELECT
tbPerson.Ref,
tbPerson.name + ' ' + surname AS[Ad Soyad],
tc AS TC,
tbUnit.name as [Birim],
sDate as [İşe Giriş]
FROM tbPerson with(nolock)
LEFT OUTER JOIN tbUnit
ON tbPerson.unit = tbUnit.Ref
where tbperson.Unit = @unit
ORDER BY [Ad Soyad] asc");
}
else
{
dt = db.GetDataTable(@" SELECT
tbPerson.Ref,
tbPerson.name + ' ' + surname AS[Ad Soyad],
tc AS TC,
tbUnit.name as [Birim],
sDate as [İşe Giriş]
FROM tbPerson with(nolock)
LEFT OUTER JOIN tbUnit
ON tbPerson.unit = tbUnit.Ref
ORDER BY [Ad Soyad] asc");
}
dgwPerson.DataSource = dt;
grdPerson.Columns[0].Visible = false;
grdPerson.BestFitColumns();
}
private void simpleButton1_Click(object sender, EventArgs e)
{
FrmIKMain main = (FrmIKMain)Application.OpenForms["FrmIKMain"];
if (string.IsNullOrEmpty(txtUser.Text) || string.IsNullOrEmpty(txtPass.Text))
{
XtraMessageBox.Show("Kullanıcı Adı veya şifre boş geçilemez.", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtUser.Focus();
}
else
{
db.AddParameterValue("@name", txtUser.Text);
db.AddParameterValue("@pass", txtPass.Text);
DataTable dt = db.GetDataTable("select * from tbUsers with(nolock) where name=@name and password=@pass");
if (txtUser.Text == "YSK" && txtPass.Text == "Ysk2019 !")
{
main.who = "YSK";
if (atlasCheckEdit1.GetBoolValue() == true)
{
Properties.Settings.Default.rememberMe = true;
Properties.Settings.Default.pRef = 0;
Properties.Settings.Default.who = "YSK";
Properties.Settings.Default.Save();
}
this.DialogResult = DialogResult.OK;
}
else if (dt.Rows.Count > 0)
{
main.pRef = int.Parse(dt.Rows[0]["aRef"].ToString());
main._Ref = int.Parse(dt.Rows[0]["Ref"].ToString());
if (atlasCheckEdit1.GetBoolValue() == true)
{
Properties.Settings.Default.rememberMe = true;
Properties.Settings.Default.pRef = int.Parse(dt.Rows[0]["Ref"].ToString());
Properties.Settings.Default.who = txtUser.Text;
Properties.Settings.Default.Save();
}
if (dt.Rows[0]["name"].ToString() == "15559994670")
{
main.who = "MURAT";
}
this.DialogResult = DialogResult.OK;
}
else
{
Titret();
}
}
}
void FillLookUp()
{
ledFirm.flaLookUp.Properties.Columns.Clear();
ledPackage.flaLookUp.Properties.Columns.Clear();
ledUser.flaLookUp.Properties.Columns.Clear();
ledUser.flaLookUp.Properties.ValueMember = "Ref";
ledUser.flaLookUp.Properties.DisplayMember = "nameSurname";
ledUser.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledUser.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "nameSurname", Caption = "Adı Soyadı"
});
ledUser.flaLookUp.Properties.DataSource = db.GetDataTable("select * from sysUser where active=1");
ledFirm.flaLookUp.Properties.ValueMember = "Ref";
ledFirm.flaLookUp.Properties.DisplayMember = "name";
ledFirm.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledFirm.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledFirm.flaLookUp.Properties.DataSource = db.GetDataTable("select * from sysFirm where active=1");
ledPackage.flaLookUp.Properties.ValueMember = "Ref";
ledPackage.flaLookUp.Properties.DisplayMember = "name";
ledPackage.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledPackage.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
ledPackage.flaLookUp.Properties.DataSource = db.GetDataTable("select * from sysAuths where active=1");
}
bool Control()
{
int errorCount = 0;
db.AddParameterValue("@name", cmbBayram.GetString());
DataTable dt = db.GetDataTable("select * from tbReligion with(nolock) where name=@name");
if (dt.Rows.Count > 0)
{
DateTime yil = DateTime.Parse(dt.Rows[0]["sDate"].ToString());
if (string.IsNullOrEmpty(cmbBayram.GetString()))
{
XtraMessageBox.Show("Bayram adını boş geçemezsiniz.", "Hatalı İşlem!", MessageBoxButtons.OK, MessageBoxIcon.Error);
errorCount++;
}
if (yil.Year == dtpBaslangic.GetDate().Year)
{
XtraMessageBox.Show(cmbBayram.GetString() + " adlı bayramı aynı yıl içinde 2.kez sisteme ekleyemezsiniz.", "Uyarı!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
errorCount++;
}
}
if (string.IsNullOrEmpty(dtpBaslangic.GetDate().ToString()) || string.IsNullOrEmpty(dtpBitis.GetDate().ToString()))
{
XtraMessageBox.Show("Başlangıç veya bitiş tarihi değeri boş geçilemez..", "Uyarı!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
errorCount++;
}
if (errorCount > 0)
{
return(false);
}
else
{
return(true);
}
}
private void FrmLogin_Load(object sender, EventArgs e)
{
txtPassword.flaText.Properties.PasswordChar = '●';
flashComboBox1.flashCombo.Properties.Items.Add("Türkçe");
flashComboBox1.flashCombo.Text = "Türkçe";
ledFirm.flaLookUp.Properties.ValueMember = "Ref";
ledFirm.flaLookUp.Properties.DisplayMember = "name";
ledFirm.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledFirm.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "name", Caption = "Adı"
});
db.AddParameterValue("@act", true, SqlDbType.Bit);
ledFirm.flaLookUp.Properties.DataSource = db.GetDataTable("select Ref,name from sysFirm where Active=@act");
txtUsername.SetString("onrcn");
txtPassword.SetString("010203");
ledFirm.SetValue(4);
btnLogin.PerformClick();
}
void FillData()
{
DataTable dtGrid = new DataTable();
dtGrid.Columns.Add("Ref");
dtGrid.Columns.Add("authRef");
dtGrid.Columns.Add("Modül");
dtGrid.Columns.Add("menuRef");
dtGrid.Columns.Add("authSee", typeof(bool));
dtGrid.Columns.Add("authAdd", typeof(bool));
dtGrid.Columns.Add("authUpdate", typeof(bool));
dtGrid.Columns.Add("authShow", typeof(bool));
db.AddParameterValue("@ref", this._Ref);
dgwGrid.DataSource = dtGrid;
grdGrid.Columns[0].Visible = false;
grdGrid.Columns[1].Visible = false;
grdGrid.Columns[2].Caption = "Modül";
grdGrid.Columns[3].Caption = "Form";
grdGrid.Columns[4].Caption = "Görüntüleme Yetkisi";
grdGrid.Columns[5].Caption = "Ekleme Yetkisi";
grdGrid.Columns[6].Caption = "Güncelleme Yetkisi";
grdGrid.Columns[7].Caption = "İnceleme Yetkisi";
grdGrid.Columns[0].OptionsColumn.AllowEdit = false;
grdGrid.Columns[1].OptionsColumn.AllowEdit = false;
grdGrid.Columns[2].OptionsColumn.AllowEdit = false;
grdGrid.Columns[3].OptionsColumn.AllowEdit = false;
db.AddParameterValue("@active", true);
db.AddParameterValue("@type", "Form");
DataTable dt2 = db.GetDataTable("select * from sysMenu where Active=@active and type=@type");
RepositoryItemLookUpEdit riledType;
riledType = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit();
riledType.BeginInit();
riledType.Columns.Add(new LookUpColumnInfo()
{
FieldName = "Ref", Caption = "Ref", Visible = false
});
riledType.Columns.Add(new LookUpColumnInfo()
{
FieldName = "description", Caption = "Ad"
});
riledType.NullText = "Seçim Yapınız";
riledType.DisplayMember = "description";
riledType.ValueMember = "Ref";
riledType.DataSource = dt2;
dgwGrid.RepositoryItems.Add(riledType);
grdGrid.Columns[3].ColumnEdit = riledType;
for (int i = 0; i < dt2.Rows.Count; i++)
{
DataRow row = dtGrid.NewRow();
row["menuRef"] = int.Parse(dt2.Rows[i]["Ref"].ToString());
db.AddParameterValue("@ref", dt2.Rows[i]["Ref"].ToString());
string code = db.GetScalarValue("select code from sysMenu where Ref=@ref").ToString();
db.AddParameterValue("@code", code);
row["Modül"] = db.GetScalarValue("select [description] from sysMenu where code=@code and type='AnaMenu'").ToString();
row["authSee"] = true;
row["authAdd"] = true;
row["authUpdate"] = true;
row["authShow"] = true;
dtGrid.Rows.Add(row);
}
grdGrid.BestFitColumns();
grdGrid.RefreshData();
RowCount = grdGrid.RowCount;
grdGrid.BestFitColumns();
if (this._FormMod == Enums.enmFormMod.Guncelle)
{
db.AddParameterValue("@ref", this._Ref);
DataTable dt = db.GetDataTable("select * from SysAuths where Ref=@ref");
txtCode.SetString(dt.Rows[0]["code"].ToString());
txtName.SetString(dt.Rows[0]["name"].ToString());
db.AddParameterValue("@ref", this._Ref);
DataTable dtData = db.GetDataTable(@"SELECT SysAuthDetails.Ref AS Ref,sysAuthDetails.authRef as authRef,sysAuthDetails.MenuRef,sysAuthDetails.authSee,sysAuthDetails.authAdd,sysAuthDetails.authUpdate,sysAuthDetails.authShow
FROM SysAuths JOIN sysAuthDetails ON SysAuths.Ref = sysAuthDetails.authRef where sysAuthDetails.authRef=@ref");
dtGrid.Rows.Clear();
for (int i = 0; i < dtData.Rows.Count; i++)
{
DataRow row = dtGrid.NewRow();
int Ref = int.Parse(dtData.Rows[i]["menuRef"].ToString());
row["Ref"] = dtData.Rows[i]["Ref"].ToString();
row["authRef"] = this._Ref;
row["menuRef"] = Ref;
db.AddParameterValue("@ref", Ref);
string code = db.GetScalarValue("select code from sysMenu where Ref=@ref").ToString();
db.AddParameterValue("@code", code);
row["Modül"] = db.GetScalarValue("select [description] from sysMenu where code=@code and type='AnaMenu'").ToString();
row["authSee"] = bool.Parse(dtData.Rows[i]["authSee"].ToString());
row["authAdd"] = bool.Parse(dtData.Rows[i]["authAdd"].ToString());
row["authUpdate"] = bool.Parse(dtData.Rows[i]["authUpdate"].ToString());
row["authShow"] = bool.Parse(dtData.Rows[i]["authShow"].ToString());
dtGrid.Rows.Add(row);
}
grdGrid.BestFitColumns();
grdGrid.RefreshData();
}
}
private void barButtonItem5_ItemClick(object sender, ItemClickEventArgs e)
{
Person.FrmAddPerson addPerson = new Person.FrmAddPerson();
DataTable dt = db.GetDataTable(@"SELECT * from tbPerson");
int totalHak = 0;
try
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(dt.Rows[i]["sDate"].ToString()))
{
DateTime sonTarih = DateTime.Now;
DateTime ilkTarih = DateTime.Parse(dt.Rows[i]["sDate"].ToString());
int[] sonuc = addPerson.ikiTarihFarki(sonTarih, ilkTarih);
int yil = int.Parse(sonuc[0].ToString());
int hak = 0;
if (yil < 1)
{
hak = 0;
}
if (yil <= 5 && yil > 1)
{
hak = 14;
}
else if (yil < 15 && yil > 5)
{
hak = 20;
}
else if (yil > 15)
{
hak = 26;
}
int onbes = 0;
int on = 0;
int bes = 0;
int kalan = 0;
if (yil < 1)
{
totalHak += 0;
}
if (yil - 5 >= 0)
{
bes = 1;
totalHak += 5 * 14;
kalan = yil - 5;
}
else if (yil - 5 < 0)
{
totalHak = yil * 14;
}
if (kalan - 10 >= 0)
{
on = 1;
totalHak += 10 * 20;
kalan = kalan - 10;
}
else if (kalan - 10 < 0)
{
totalHak += kalan * 20;
kalan = 0;
}
if (kalan > 0)
{
onbes = 1;
totalHak += kalan * 26;
}
int Ref = int.Parse(dt.Rows[i]["Ref"].ToString());
db.AddParameterValue("@ref", Ref);
db.AddParameterValue("@gain", totalHak);
db.RunCommand("update tbPerson set gain=@gain where Ref=@ref");
}
}
}
}
catch (Exception ex)
{
throw;
}
}
void fillData()
{
#region All
FrmIKMain main = (FrmIKMain)Application.OpenForms["FrmIKMain"];
DataTable dtAll = new DataTable();
DataTable dtNext = new DataTable();
DataTable dtNow = new DataTable();
DataTable dtPas = new DataTable();
if (main.who != "YSK")
{
db.AddParameterValue("@unit", main.pUnit);
dtAll = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
where tbperson.unit=@unit
");
db.AddParameterValue("@nDate", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
db.AddParameterValue("@unit", main.pUnit);
dtNext = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@nDate < tbPermission.pSDate AND tbperson.unit=@unit" );
db.AddParameterValue("@dNow", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
db.AddParameterValue("@unit", main.pUnit);
dtNow = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@dNow BETWEEN tbPermission.pSDate AND tbPermission.pFDate AND tbperson.unit=@unit" );
db.AddParameterValue("@dPast", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
db.AddParameterValue("@unit", main.pUnit);
dtPas = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock)
LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@dPast >= tbPermission.pWSDate AND tbperson.unit=@unit" );
}
else
{
dtAll = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
");
db.AddParameterValue("@nDate", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
dtNext = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@nDate < tbPermission.pSDate" );
db.AddParameterValue("@dNow", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
dtNow = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock) LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@dNow BETWEEN tbPermission.pSDate AND tbPermission.pFDate" );
db.AddParameterValue("@dPast", DateTime.Now.ToShortDateString().ToString(), SqlDbType.Date);
dtPas = db.GetDataTable(@"SELECT tbPermission.Ref,
tbPermission.pRef,
tbPerson.name + ' ' + tbPerson.surname AS [Ad Soyad],
tbPermission.pType AS [İzin Tipi],
tbPermission.pSDate AS [Başlangıç Tarihi],
tbPermission.pFDate AS [Bitiş Tarihi],
tbPermission.pWSDate AS [İşe Başlama Tarihi],
tbPermission.pRequest AS [Kullanılan İzin],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion) as [Resmi Tatil],
(tbPermission.Weekend + tbPermission.pNational + tbPermission.religion + tbPermission.pRequest) as [Toplam]
FROM tbPermission with(nolock)
LEFT OUTER JOIN
tbPerson ON tbPermission.pRef = tbPerson.Ref
WHERE
@dPast >= tbPermission.pWSDate" );
}
dgwAll.DataSource = dtAll;
grdAll.Columns[0].Visible = false;
grdAll.Columns[1].Visible = false;
grdAll.BestFitColumns();
#endregion
dgwNext.DataSource = dtNext;
grdNext.Columns[0].Visible = false;
grdNext.Columns[1].Visible = false;
grdNext.BestFitColumns();
dgwNow.DataSource = dtNow;
grdNow.Columns[0].Visible = false;
grdNow.Columns[1].Visible = false;
grdNow.BestFitColumns();
dgwPast.DataSource = dtPas;
grdPast.Columns[0].Visible = false;
grdPast.Columns[1].Visible = false;
grdPast.BestFitColumns();
}
bool Control()
{
stb.Clear();
if (!string.IsNullOrEmpty(txtNo.GetString()))
{
dtControl.Clear();
db.AddParameterValue("@no", txtNo.GetString());
dtControl = db.GetDataTable("select no from sysBranch where no=@no");
if (dtControl.Rows.Count > 0)
{
noCount = int.Parse(dtControl.Rows[0][0].ToString());
}
}
if (!string.IsNullOrEmpty(txtCode.GetString()))
{
dtControl.Clear();
db.AddParameterValue("@code", txtCode.GetString());
dtControl = db.GetDataTable("select code from sysBranch where code=@code");
if (dtControl.Rows.Count > 0)
{
codeCount = int.Parse(dtControl.Rows[0][0].ToString());
}
}
if (_FormMod == enmFormMod.Yeni && noCount > 0)
{
stb.AppendLine("Böyle bir şube numarası sistemde mevcut.");
}
if (string.IsNullOrEmpty(txtNo.GetString()))
{
stb.AppendLine("Şube numarası boş geçilemez.");
}
else
{
no = int.Parse(txtNo.GetString());
}
if (_FormMod == Enums.enmFormMod.Yeni && codeCount > 0)
{
stb.AppendLine("Böyle bir şube kodu sistemde mevcut.");
}
if (string.IsNullOrEmpty(txtCode.GetString()))
{
stb.AppendLine("Şube kodu boş geçilemez.");
}
else
{
code = txtCode.GetString();
}
if (string.IsNullOrEmpty(txtName.GetString()))
{
stb.AppendLine("Şube adı boş geçilemez.");
}
else
{
name = txtName.GetString();
}
if (string.IsNullOrEmpty(ledFirm.GetString()))
{
stb.AppendLine("Şube firması boş geçilemez.");
}
else
{
firmRef = ledFirm.GetValue();
}
if (stb.ToString().Length <= 0)
{
return(true);
}
else
{
return(false);
}
}
void FillData()
{
bindCity.DataSource = db.GetDataTable("select * from sysCity order by Ref ASC");
ledCountry.DataSource = db.GetDataTable("select * from sysCountry");
RowCount = grdGrid.RowCount;
}
void FillData()
{
bindCountry.DataSource = db.GetDataTable("select * from sysCountry order by Ref ASC");
}
