/// <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 }); }