杂志目录(数据库访问部分）
点击次数：31 次 发布日期：2008-11-27 01:34:22 作者：源代码网
|
using System.Configuration; using System.Data; using System.Data.SqlClient; namespace cj168.DataAccess { public class MagsDB { //SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); public void openConn() { //myConnection.Open(); } public void closeConn() { //myConnection.Close(); } public SqlDataReader GetMagIssue(int magID, int magYear) { SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlCommand myCommand = new SqlCommand("GetMagIssue", myConnection); myCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterMagID = new SqlParameter("@MagID", SqlDbType.Int, 4); parameterMagID.Value = magID; myCommand.Parameters.Add(parameterMagID); SqlParameter parameterMagYear = new SqlParameter("@MagYear", SqlDbType.Int, 4); parameterMagYear.Value = magYear; myCommand.Parameters.Add(parameterMagYear); myConnection.Open(); SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); return result; } public DataSet GetMagIssueCat(int magID, int magYear, int yearIssue) { SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlDataAdapter myCommand = new SqlDataAdapter("GetMagIssueCat", myConnection); myCommand.SelectCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterMagID = new SqlParameter("@MagID", SqlDbType.Int, 4); parameterMagID.Value = magID; myCommand.SelectCommand.Parameters.Add(parameterMagID); SqlParameter parameterMagYear = new SqlParameter("@MagYear", SqlDbType.Int, 4); parameterMagYear.Value = magYear; myCommand.SelectCommand.Parameters.Add(parameterMagYear); SqlParameter parameterYearIssue = new SqlParameter("@YearIssue", SqlDbType.Int, 4); parameterYearIssue.Value = yearIssue; myCommand.SelectCommand.Parameters.Add(parameterYearIssue); DataSet myDataSet = new DataSet(); //myConnection.Open(); myCommand.Fill(myDataSet); //SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); //return result; return myDataSet; } public DataSet GetSubCat(int magID, int magYear, int yearIssue, int catID) { SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlDataAdapter myCommand = new SqlDataAdapter("GetSubCat", myConnection); myCommand.SelectCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterMagID = new SqlParameter("@MagID", SqlDbType.Int, 4); parameterMagID.Value = magID; myCommand.SelectCommand.Parameters.Add(parameterMagID); SqlParameter parameterMagYear = new SqlParameter("@MagYear", SqlDbType.Int, 4); parameterMagYear.Value = magYear; myCommand.SelectCommand.Parameters.Add(parameterMagYear); SqlParameter parameterYearIssue = new SqlParameter("@YearIssue", SqlDbType.Int, 4); parameterYearIssue.Value = yearIssue; myCommand.SelectCommand.Parameters.Add(parameterYearIssue); SqlParameter parameterCatID = new SqlParameter("@CatID", SqlDbType.Int, 4); parameterCatID.Value = catID; myCommand.SelectCommand.Parameters.Add(parameterCatID); DataSet myDataSet = new DataSet(); //myConnection.Open(); //SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); //return result; myCommand.Fill(myDataSet); return myDataSet; } public DataSet GetMagArtTitle(int catIssueID) { SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlDataAdapter myCommand = new SqlDataAdapter("GetMagArtTitle", myConnection); myCommand.SelectCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterCatIssueID = new SqlParameter("@CatIssueID", SqlDbType.Int, 4); parameterCatIssueID.Value = catIssueID; myCommand.SelectCommand.Parameters.Add(parameterCatIssueID); //myConnection.Open(); //SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); //return result; DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet); return myDataSet; } public DataSet GetArtDetail(int txtID) { SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlDataAdapter myCommand = new SqlDataAdapter("GetArtDetail", myConnection); myCommand.SelectCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterTxtID = new SqlParameter("@txtID", SqlDbType.Int, 4); parameterTxtID.Value = txtID; myCommand.SelectCommand.Parameters.Add(parameterTxtID); //myConnection.Open(); //SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); //return result; DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet,"ArtDetail"); return myDataSet; } } /* public SqlDataReader GetMagIssue(int magID, int magYear, SqlConnection myConnection) { //SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); //myConnection.Open(); SqlCommand myCommand = new SqlCommand("GetMagIssue", myConnection); myCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterMagID = new SqlParameter("@MagID", SqlDbType.Int, 4); parameterMagID.Value = magID; myCommand.Parameters.Add(parameterMagID); SqlParameter parameterMagYear = new SqlParameter("@MagYear", SqlDbType.Int, 4); parameterMagYear.Value = magYear; myCommand.Parameters.Add(parameterMagYear); //myConnection.Open(); SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); return result; } public SqlDataReader GetMagIssueCat(int magID, int magYear, int yearIssue, SqlConnection myConnection) { //SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlCommand myCommand = new SqlCommand("GetMagIssueCat", myConnection); myCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterMagID = new SqlParameter("@MagID", SqlDbType.Int, 4); parameterMagID.Value = magID; myCommand.Parameters.Add(parameterMagID); SqlParameter parameterMagYear = new SqlParameter("@MagYear", SqlDbType.Int, 4); parameterMagYear.Value = magYear; myCommand.Parameters.Add(parameterMagYear); SqlParameter parameterYearIssue = new SqlParameter("@YearIssue", SqlDbType.Int, 4); parameterYearIssue.Value = yearIssue; myCommand.Parameters.Add(parameterYearIssue); //myConnection.Open(); SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); return result; } public SqlDataReader GetSubCat(int magID, int magYear, int yearIssue, int catID, SqlConnection myConnection) { //SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlCommand myCommand = new SqlCommand("GetSubCat", myConnection); myCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterMagID = new SqlParameter("@MagID", SqlDbType.Int, 4); parameterMagID.Value = magID; myCommand.Parameters.Add(parameterMagID); SqlParameter parameterMagYear = new SqlParameter("@MagYear", SqlDbType.Int, 4); parameterMagYear.Value = magYear; myCommand.Parameters.Add(parameterMagYear); SqlParameter parameterYearIssue = new SqlParameter("@YearIssue", SqlDbType.Int, 4); parameterYearIssue.Value = yearIssue; myCommand.Parameters.Add(parameterYearIssue); SqlParameter parameterCatID = new SqlParameter("@CatID", SqlDbType.Int, 4); parameterCatID.Value = catID; myCommand.Parameters.Add(parameterCatID); //myConnection.Open(); SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); return result; } public SqlDataReader GetMagArtTitle(int catIssueID, SqlConnection myConnection) { //SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlCommand myCommand = new SqlCommand("GetMagArtTitle", myConnection); myCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterCatIssueID = new SqlParameter("@CatIssueID", SqlDbType.Int, 4); parameterCatIssueID.Value = catIssueID; myCommand.Parameters.Add(parameterCatIssueID); //myConnection.Open(); SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); //SqlDataReader result = myCommand.ExecuteReader(); return result; } } */ /// <summary> /// Summary description for WebCustomControl1. /// </summary> < 源代码网供稿. |
