/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="proc">存储过程名称</param>
/// <param name="paramlist">参数</param>
public static void ExeNoProc(string proc, SqlParameter[] paramlist)
{
DataSet ds = new DataSet();
SDEDataBaseClass sc = new SDEDataBaseClass();
sc.OpenConn();
try
{
SqlCommand comm = new SqlCommand();
comm.Connection = sc.conn;
comm.CommandTimeout = 20;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = proc;
if (paramlist != null && paramlist.Length > 0)
{
foreach (SqlParameter param in paramlist)
{
comm.Parameters.Add(param);
}
}
comm.ExecuteNonQuery();
}
catch
{
}
sc.CloseConn();
}
/// <summary>
/// 返回分页的DataSet
/// </summary>
/// <param name="sql"></param>
/// <param name="startRecord"></param>
/// <param name="maxRecords"></param>
/// <param name="srcTables"></param>
/// <returns>参见模型</returns>
public static DataSet FullDataSet(string sql, int startRecord, int maxRecords, string srcTables)
{
if (startRecord < 0)
{
startRecord = 0;
}
SDEDataBaseClass sc = new SDEDataBaseClass();
sc.OpenConn();
SqlCommand comm = new SqlCommand(sql, sc.conn);
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(comm);
adp.Fill(ds, startRecord, maxRecords, srcTables);
sc.CloseConn();
return(ds);
}
/// <summary>
/// 根据SQL语句和表名返回DATASE
/// </summary>
/// <param name="sql">查询的语句</param>
/// <returns>返回 DataSet</returns>
public static DataSet FullDataSet(string sql)
{
SDEDataBaseClass sc = new SDEDataBaseClass();
sc.OpenConn();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, sc.conn);
try
{
da.Fill(ds);
}
catch
{
}
sc.CloseConn();
return(ds);
}
/// <summary>
/// 执行不返回值的SQL语句
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns>false/true 失败/成功</returns>
public static bool ExeSql(string sql)
{
SDEDataBaseClass sc = new SDEDataBaseClass();
sc.OpenConn();
bool bln = false;
try
{
SqlCommand comm = new SqlCommand(sql, sc.conn);
comm.ExecuteNonQuery();
bln = true;
}
catch
{
bln = false;
}
sc.CloseConn();
return(bln);
}
