/// <summary>
/// 执行方法 并返回数据
/// </summary>
public object ExeMethod(string[] classInfo, string value, IPEndPoint client)
{
try
{
var mytypes = GetAllTypes();
foreach (var my in mytypes.Where(my => my.Name.ToLower().Equals(classInfo[0].ToLower() + "controller")))
{
return(ReflexTools.ExecuteMethod(my, classInfo[1], value, client));
}
throw new Exception("没有找到相关类或方法:" + classInfo[0]);
}
catch (Exception em)
{
return(null);
}
}
/// <summary>
/// 执行带一个存储过程参数的的SQL语句。
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <param name="content">参数内容,比如一个字段是格式复杂的文章，有特殊符号，可以通过这个方式添加</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString, string content)
{
return((int)ReflexTools.ExecuteMethod(conType, "ExecuteSqlCon", new object[] { SQLString, content }));
}
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <param name="cmdParms">参数</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString, params DbParameter[] cmdParms)
{
return((int)ReflexTools.ExecuteMethod(conType, "ExecuteSqlPar", new object[] { SQLString, cmdParms }));
}
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString)
{
return((int)ReflexTools.ExecuteMethod(conType, "ExecuteSql", new object[] { SQLString }));
}
//
/// <summary>
/// 执行查询语句，返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public static DataSet Query(string SQLString)
{
return((DataSet)ReflexTools.ExecuteMethod(conType, "Query", new object[] { SQLString }));
}
/// <summary>
/// 得到一个数据集合
/// </summary>
/// <param name="SQLString">sql语句</param>
/// <returns>DataTable</returns>
public static DataTable GetTable(string SQLString)
{
return((DataTable)ReflexTools.ExecuteMethod(conType, "GetTable", new object[] { SQLString }));
}
/// <summary>
/// 测试是否连接到数据库
/// </summary>
/// <returns>连接状态</returns>
public static bool TestConnect()
{
return((bool)ReflexTools.ExecuteMethod(conType, "TestConnect", null));
}
//数据库连接字符串(web.config来配置)，可以动态更改connectionString支持多数据库.
public static void SetConnection(string connectionStr)
{
ReflexTools.ExecuteMethod(conType, "SetConnection", new object[] { connectionStr });
}
