sujinlee

exec :pt_no := '88888888'; 
   select *
     from ACPPRICD
    where PT_NO = :pt_no ; 

 
 define in_pt_no = '88888888'
   select *
     from ACPPRICD

sujinlee

        public bool ValidateData(object data)
        {
            foreach (PropertyInfo propertyInfo in data.GetType().GetProperties())
            {
                if (propertyInfo.PropertyType == typeof(DateTime) )
                {
                    if (Convert.ToDateTime(propertyInfo.GetValue(data))  == DateTime.MinValue)
                    {
                        propertyInfo.SetValue(data, DateTime.Now);
                    }