internal static int Select_Number(string select)
{
try
{
int count = 0;
using (DataTable table = PostgreSQLHelper_Policlinic.ExecuteSelectCommand(select, CommandType.Text))
{
if (table.Rows.Count > 0)
{
count = int.Parse(table.Rows[0][0].ToString());
}
}
return(count);
}
catch (Exception e)
{
return(0);
}
}
internal static string Select_String(string select)
{
try
{
string result = "";
using (DataTable table = PostgreSQLHelper_Policlinic.ExecuteSelectCommand(select, CommandType.Text))
{
if (table.Rows.Count > 0)
{
result = table.Rows[0][0].ToString();
}
}
return(result);
}
catch (Exception e)
{
return(string.Empty);
}
}
internal static List <string> Select_ArrayString(string select)
{
try
{
List <String> list = new List <string>();
using (DataTable table = PostgreSQLHelper_Policlinic.ExecuteSelectCommand(select, CommandType.Text))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
list.Add(row[0].ToString());
}
}
}
return(list);
}
catch (Exception e)
{
return(null);
}
}