public List<string> GetStatusNotDisplayTCByList(List<string> status) { try { List<string> result = new List<string>(); using (OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["dbnet"].ConnectionString)) { using (OracleCommand comm = new OracleCommand("pkg_aut_module.fn_get_status", conn)) { comm.CommandType = CommandType.StoredProcedure; comm.BindByName = true; comm.ArrayBindCount = status.Count; comm.Parameters.Add("p_status", OracleDbType.Varchar2, status.ToArray(),ParameterDirection.Input); comm.Parameters.Add("Vli", OracleDbType.RefCursor, null, ParameterDirection.ReturnValue); DataTable dt = new DataTable(); conn.Open(); using (OracleDataReader reader = comm.ExecuteReader()) { if (reader.HasRows) { dt.Load(reader); List<DataRow> dr = dt.AsEnumerable().ToList(); while (reader.Read()) { foreach (var row in dr.AsEnumerable()) { result.Add(Convert.ToString(row["status_display"])); } } reader.Close(); conn.Dispose(); } } } } return result; } catch (Exception e) { throw; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)