/// <summary> /// 执行命令 /// </summary> /// <param name="mSqlInfo">SqlHelper信息对象</param> /// <param name="connName">数据库连接字符串名称</param> public object ExecuteNonQuery(SqlInfo mSqlInfo, string connName) { object result; Database database = DatabaseFactory.CreateDatabase(connName); using (DbCommand command = database.DbProviderFactory.CreateCommand()) { if (mSqlInfo.IsProc) { command.CommandType = CommandType.StoredProcedure; } command.CommandText = mSqlInfo.SqlOrProcName; if (mSqlInfo.Parameters != null) { foreach (DbParameter param in mSqlInfo.Parameters) { command.Parameters.Add(param); } } if (mSqlInfo.IsProc) { result = database.ExecuteScalar(command); } else { result = database.ExecuteNonQuery(command); } return(result); } }
/// <summary> /// 读取数据表 /// </summary> /// <param name="mSqlInfo">SqlHelper信息对象</param> /// <param name="connName">数据库连接字符串名称</param> /// <returns></returns> public DataTable ExecuteDataTable(SqlInfo mSqlInfo, string connName) { Database database = DatabaseFactory.CreateDatabase(connName); using (DbCommand command = database.DbProviderFactory.CreateCommand()) { if (mSqlInfo.IsProc) { command.CommandType = CommandType.StoredProcedure; } command.CommandText = mSqlInfo.SqlOrProcName; if (mSqlInfo.Parameters != null) { foreach (DbParameter param in mSqlInfo.Parameters) { command.Parameters.Add(param); } } DataSet ds = database.ExecuteDataSet(command); if (ds != null && ds.Tables != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(null); } } }
/// <summary> /// 执行命令 /// </summary> /// <param name="mSqlInfo">SqlHelper信息对象</param> public object ExecuteNonQuery(SqlInfo mSqlInfo) { return(ExecuteNonQuery(mSqlInfo, _ConnName)); }
/// <summary> /// 读取数据集表 /// </summary> /// <param name="mSqlInfo">命令SqlHelper信息对象</param> /// <returns></returns> public DataSet ExecuteDataSet(SqlInfo mSqlInfo) { return(ExecuteDataSet(mSqlInfo, _ConnName)); }
/// <summary> /// 读取数据表 /// </summary> /// <param name="mSqlInfo">命令SqlHelper信息对象</param> /// <returns></returns> public DataTable ExecuteDataTable(SqlInfo mSqlInfo) { return(ExecuteDataTable(mSqlInfo, _ConnName)); }
/// <summary> /// 读取一个数据 /// </summary> /// <param name="mSqlInfo">SqlHelper信息对象</param> /// <returns></returns> public object ExecuteScalar(SqlInfo mSqlInfo) { return(ExecuteScalar(mSqlInfo, _ConnName)); }