Beispiel #1
0
 public csPdksV2(SqlConnection Baglanti, SqlTransaction Tr, int PdksHrID)
 {
     if (PdksHrID == -1)
     {
         _ID         = -1;
         _PersonelID = -1;
         _Zaman      = DateTime.Now;
         _YerID      = -1;
         _Tur        = PDKSTUR.Cikis;
     }
     else
     {
         Getir(Baglanti, Tr, PdksHrID);
     }
 }
Beispiel #2
0
        private void Getir(SqlConnection Baglanti, SqlTransaction Tr, int PdksHrID)
        {
            using (cmd = new SqlCommand("select * from Hareketler where Hareketler.ID = @ID", Baglanti, Tr))
            {
                cmd.Parameters.Add("@ID", SqlDbType.Int).Value = PdksHrID;

                using (dr = cmd.ExecuteReader())
                {
                    if (dr.Read())
                    {
                        _ID         = Convert.ToInt32(dr["ID"]);
                        _PersonelID = Convert.ToInt32(dr["PersonelID"]);
                        _Zaman      = Convert.ToDateTime(dr["Zaman"]);
                        _YerID      = Convert.ToInt32(dr["YerID"]);
                        _Tur        = (PDKSTUR)Enum.Parse(typeof(IslemTipi), dr["Tur"].ToString());
                    }
                }
            }
        }