public DataTable ExecuteDataset(SQL_Container SQL)
{
var dt = new DataTable();
switch (_DBType)
{
case DBType.MySql:
var list_mysql = new List <MySqlParameter>();
foreach (var item in SQL._SQL_Parameter)
{
list_mysql.Add(new MySqlParameter()
{
ParameterName = item.Key, Value = item.Value == null ? DBNull.Value : item.Value
});
}
dt = MySqlHelper.ExecuteDataset(_ConnectionString, SQL._SQL, list_mysql.ToArray()).Tables[0];
break;
case DBType.SqlServer:
default:
var list_sql = new List <SqlParameter>();
foreach (var item in SQL._SQL_Parameter)
{
list_sql.Add(new SqlParameter()
{
ParameterName = item.Key, Value = item.Value == null ? DBNull.Value : item.Value
});
}
dt = SqlHelper.ExecuteDataset(_ConnectionString, CommandType.Text, SQL._SQL, list_sql.ToArray()).Tables[0];
break;
}
return(dt);
}
public int ExecuteNonQuery(SQL_Container SQL)
{
var count = 0;
switch (_DBType)
{
case DBType.MySql:
var list_mysql = new List <MySqlParameter>();
foreach (var item in SQL._SQL_Parameter)
{
list_mysql.Add(new MySqlParameter()
{
ParameterName = item.Key, Value = item.Value == null ? DBNull.Value : item.Value
});
}
count = MySqlHelper.ExecuteNonQuery(_ConnectionString, SQL._SQL, list_mysql.ToArray());
break;
case DBType.SqlServer:
default:
var list_sql = new List <SqlParameter>();
foreach (var item in SQL._SQL_Parameter)
{
list_sql.Add(new SqlParameter()
{
ParameterName = item.Key, Value = item.Value == null ? DBNull.Value : item.Value
});
}
count = SqlHelper.ExecuteNonQuery(_ConnectionString, CommandType.Text, SQL._SQL, list_sql.ToArray());
break;
}
return(count);
}
