C# (CSharp) DataLibrary.BusinessLogic SqlDataAccess.LoadDataWithId 예제들

예제 #1

        //public static List<SozlesmeDatabaseModel> LoadSozlesmeWithId(int ID)
        //{

        //    string sql = @"select * FROM SOZLESME WHERE SOZLESME_ID=:ID";

        //    return SqlDataAccess.LoadDataWithId<SozlesmeDatabaseModel>(sql, ID);
        //}
        public static SPDatabaseModel LoadSozlesmeWithId(int ID)
        {
            string sql  = "SELECT * FROM SOZLESME WHERE SOZLESME_ID = :ID ";
            string sqlP = "SELECT * FROM PERSONEL WHERE SOZLESME_ID = :ID";

            return(SqlDataAccess.LoadDataWithId(sql, sqlP, ID));
        }