C# (CSharp) Stok_Takip SQL_Commands.SelectID示例

示例#1

文件： DataAccessProjeler.cs 项目： ogzkaan/StokTakip

 public int ProjeID(String projeAdi)
 {
     using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Controller.cnnVal("DB1")))
     {
         return(SQL_Commands.SelectID(projeAdi, "Proje_Adi", "ID_Proje", "Projeler"));
     }
 }

示例#2

 public int personelID(String personelAdi)
 {
     using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Controller.cnnVal("DB1")))
     {
         return(SQL_Commands.SelectID(personelAdi, "Isim", "ID_Personel", "Personel"));
     }
 }

示例#3

 /*
  * ürün takip tableına erişim metodları
  */
 public int UrunID(String SeriNo)
 {
     using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Controller.cnnVal("DB1")))
     {
         return(SQL_Commands.SelectID(SeriNo, "Urun_Seri_No", "ID_Urun", "Urun"));
     }
 }