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); } }
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()); } } } }