public DataTable tododoldur()
{
DataTable ret = new DataTable();
using (baglan)
{
using (SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM vw_Todo", Baglan.Baglanti()))
{
da.Fill(ret);
}
}
return(ret);
}
public DataTable teknikGridDoldur(string projno)
{
projno = projno.Trim();
int sprojno = Convert.ToInt32(projno);
DataTable ret = new DataTable();
using (baglan)
{
using (SqlDataAdapter da = new SqlDataAdapter("SELECT KisiAdSoyad, GorevDurumTarih, DurumAd,GorevAd, " +
"GorevDurumAciklama, Ort_Bitirme_Gün FROM dbo.f_TeknikKartDetay(" + sprojno + ")", Baglan.Baglanti()))
{
da.Fill(ret);
}
}
return(ret);
}
public DataTable cmbTeknikUzmanDoldur()
{
DataTable ret = new DataTable();
using (baglan)
{
using (SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT KisiID, KisiAdSoyad FROM tblKisiler", Baglan.Baglanti()))
{
dataAdapter.Fill(ret);
}
}
return(ret);
}
internal object cmbKartNoDoldur()
{
DataTable ret = new DataTable();
using (baglan)
{
using (SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT KartNo FROM tblTeknikKart", Baglan.Baglanti()))
{
dataAdapter.Fill(ret);
}
}
return(ret);
}
public DataTable cmbProjeAdDoldur()
{
DataTable ret = new DataTable();
using (baglan)
{
using (SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT ProjeNo, ProjeAd FROM tblProjeler", Baglan.Baglanti()))
{
dataAdapter.Fill(ret);
}
}
return(ret);
}