Beispiel #1
0
        public DataTable selectAll(Model.ML_UserAccessType uat)
        {
            MySqlParameter[] para = new MySqlParameter[1];
            para[0] = new MySqlParameter("@AccessTypeName", uat.AccessTypeName);

            return(MySQLHelper.ExecuteDataTable(DBConnection.connectionString, CommandType.Text, "SELECT `Key`, AccessTypeName, UserKey, UpdatedDate, Deleted FROM useraccesstype WHERE AccessTypeName = COALESCE(@AccessTypeName, AccessTypeName)", para));
        }
Beispiel #2
0
 public System.Data.DataTable selectAll(Model.ML_UserAccessType uat)
 {
     return(new OBALog.Data.DL_UserAccessType().selectAll(uat));
 }