Esempi in C# (CSharp) per DataLibrary.BusinessLogic SqlDataAccess.LoadDatawithId

Esempio n. 1

        //public static PersonelAylikSaat LoadPersonelAylikSaatWithId(int id)
        //{
        //    string sql = @"select * FROM AYLIKSAAT WHERE PERSONEL_ID = :ID";
        //    return SqlDataAccess.LoadDatawithId<PersonelAylikSaat>(sql, id);

        //}

        public static dynamic LoadPersonelAylikSaatWithId(int id)
        {
            string sql = @"SELECT p.*, a.*, f.* FROM AYLIKSAAT a FULL OUTER JOIN PLANLANANAYLIKSAAT p ON a.PERSONEL_ID = p.PERSONEL_ID FULL OUTER JOIN FATURALANANAYLIKSAAT f ON p.PERSONEL_ID = f.PERSONEL_ID WHERE p.PERSONEL_ID = :ID";

            return(SqlDataAccess.LoadDatawithId <dynamic>(sql, id));
        }