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