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();
}
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();
}
void fillLed()
{
this.MaximizeBox = true;
#region person
DataTable dtPerson = new DataTable();
DataTable dtVekil = new DataTable();
string sql = "";
FrmIKMain main = (FrmIKMain)Application.OpenForms["FrmIKMain"];
_Ref = main.pRef;
if (_Ref != 0)
{
db.parameterDelete();
db.AddParameterValue("@ref", _Ref);
if (int.Parse(db.GetScalarValue("Select count(*) from tbUnit where aRef=@ref").ToString()) > 0)
{
db.parameterDelete();
db.AddParameterValue("@aRef", _Ref);
int unitRef = int.Parse(db.GetScalarValue("select ref from tbUnit where aRef=@aRef").ToString());
db.parameterDelete();
db.AddParameterValue("@unit", unitRef);
dtPerson = db.GetDataTable(@"Select Ref, name +' ' + surname as [Ad Soyad],mission from tbPerson with(nolock) WHERE unit=@unit
AND(ExitDate is null OR exitDate = '01.01.1900')");
}
else
{
db.AddParameterValue("@ref", _Ref);
dtPerson = db.GetDataTable("Select Ref, name +' ' + surname as [Ad Soyad],mission from tbPerson with(nolock) WHERE ref=@ref");
}
db.AddParameterValue("@Ref", _Ref);
int newUnit = int.Parse(db.GetScalarValue("select unit from tbPerson where Ref=@Ref").ToString());
db.AddParameterValue("@unit", newUnit);
dtVekil = db.GetDataTable(@"Select Ref, name +' ' + surname as [Ad Soyad],mission from tbPerson with(nolock) WHERE unit=@unit
AND(ExitDate is null OR exitDate = '01.01.1900')");
}
else
{
dtPerson = db.GetDataTable("Select Ref, name +' ' + surname as [Ad Soyad],mission from tbPerson with(nolock) WHERE ExitDate is null OR exitDate = '01.01.1900' ORDER BY [Ad Soyad] asc");
dtVekil = db.GetDataTable("Select Ref, name +' ' + surname as [Ad Soyad],mission from tbPerson with(nolock) WHERE ExitDate is null OR exitDate = '01.01.1900' ORDER BY [Ad Soyad] asc");
}
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 = dtPerson;
#endregion
#region vekil
ledVekil.flaLookUp.Properties.ValueMember = "Ref";
ledVekil.flaLookUp.Properties.DisplayMember = "Ad Soyad";
ledVekil.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ref", Caption = "dbNo", Visible = false
});
ledVekil.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "Ad Soyad", Caption = "Ad Soyad"
});
ledVekil.flaLookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo()
{
FieldName = "mission", Caption = "Görev"
});
ledVekil.flaLookUp.Properties.DataSource = dtVekil;
#endregion
cmbIzinTuru.flashCombo.Properties.Items.Add("Askerlik");
cmbIzinTuru.flashCombo.Properties.Items.Add("Babalık");
cmbIzinTuru.flashCombo.Properties.Items.Add("Denkleştirme");
cmbIzinTuru.flashCombo.Properties.Items.Add("Doğum");
cmbIzinTuru.flashCombo.Properties.Items.Add("Evlilik");
cmbIzinTuru.flashCombo.Properties.Items.Add("İstirahat");
cmbIzinTuru.flashCombo.Properties.Items.Add("Mazeret");
cmbIzinTuru.flashCombo.Properties.Items.Add("Taşınma");
cmbIzinTuru.flashCombo.Properties.Items.Add("Ücretsiz");
cmbIzinTuru.flashCombo.Properties.Items.Add("Vefat");
cmbIzinTuru.flashCombo.Properties.Items.Add("Yıllık");
}
