public List <parametre_carikart_rapor> PersonelRaporParametreleri(int kaynak_1_parametre_id = 0)
{
#region Query
string query = @"select * from parametre_carikart_rapor where isnull(kayit_silindi,0) = 0 and kaynak_1_parametre_id = @kaynak_1_parametre_id order by parametre";
#endregion
#region Parameters
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@kaynak_1_parametre_id", kaynak_1_parametre_id)
};
#endregion
dt = SqlHelper.ExecuteDataset(ConnectionStrings.SqlConn, CommandType.Text, query, parameters).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
personelparametreler = new List <parametre_carikart_rapor>();
for (int i = 0; i < dt.Rows.Count; i++)
{
personelparametre = new parametre_carikart_rapor();
personelparametre.parametre_id = dt.Rows[i]["parametre_id"].acekaToByte();
personelparametre.tanim = dt.Rows[i]["tanim"].acekaToString();
personelparametre.parametre = dt.Rows[i]["parametre"].acekaToByte();
personelparametre.kaynak_1_parametre_id = dt.Rows[i]["kaynak_1_parametre_id"].acekaToInt();
personelparametreler.Add(personelparametre);
parametre = null;
}
return(personelparametreler);
}
else
{
return(null);
}
}
public List <parametre_genel> PersonelParametreleri()
{
#region Query
string query = @"select * from parametre_genel where kayit_silindi = 0 and statu = 1 ";
#endregion
dt = SqlHelper.ExecuteDataset(ConnectionStrings.SqlConn, CommandType.Text, query).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
parametreler = new List <parametre_genel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
parametre = new parametre_genel();
parametre.parametre_id = dt.Rows[i]["parametre_id"].acekaToByte();
parametre.parametre_adi = dt.Rows[i]["parametre_adi"].acekaToString();
parametre.parametre_grup_id = dt.Rows[i]["parametre_grup_id"].acekaToString();
parametreler.Add(parametre);
parametre = null;
}
}
return(parametreler);
}
