/// <summary>
/// 执行SQL语句返回结果集
/// </summary>
/// <param name="execSQLFormat">传入参数实体</param>
/// <returns>返回SQL语句结果的json对象</returns>
public HttpResponseMessage ExecSQL(ExecSQLFormat execSQLFormat)
{
DataTable dt = DBHelp.GetDataTable_SQL(execSQLFormat.SqlText, execSQLFormat.ConnectName);
HttpResponseMessage responseMessage = DBHelp.ConvertToHttpResponseMessage(dt);
return(responseMessage);
}
public JObject ExecuteCommand(ExecSQLFormat execSQLFormat)
{
JObject obj = new JObject();
int count = DBHelp.ExecuteCommand(execSQLFormat.SqlText, execSQLFormat.ConnectName);
obj.Add("rows", count);
obj.Add("success", count >= 0);
return(obj);
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="execSQLFormat">传入参数实体</param>
/// <returns>返回SQL语句结果的json对象</returns>
public HttpResponseMessage ExecOracle(ExecSQLFormat execSQLFormat)
{
DataTable dt = DBHelp.GetDataTable_Oracle(execSQLFormat.SqlText, execSQLFormat.ConnectName);
List <string> allcolumns = new List <string>();
foreach (DataColumn item in dt.Columns)
{
allcolumns.Add(item.ColumnName);
}
string str_allcolumns = string.Join(",", allcolumns);
HttpResponseMessage responseMessage = DBHelp.ConvertToHttpResponseMessage(dt);
return(responseMessage);
}
