推荐订阅源

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;

namespace Db
{
 /// <summary>
 /// Question 的摘要说明。
 /// </summary>
 public class Question
 {
  public Question()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }

  private SqlConnection conn;
  private SqlCommand cmd;
  private SqlDataReader dr;

  public void addQuestion(ArrayList a)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Question_add",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@Question",SqlDbType.VarChar,50).Value = a[0];
   cmd.Parameters.Add("@A",SqlDbType.Int).Value = a[1];
   cmd.Parameters.Add("@B",SqlDbType.Int).Value = a[2];
   cmd.Parameters.Add("@C",SqlDbType.Int).Value = a[3];
   cmd.Parameters.Add("@D",SqlDbType.Int).Value = a[4];
   cmd.Parameters.Add("@AA",SqlDbType.VarChar,50).Value = a[5];
   cmd.Parameters.Add("@BB",SqlDbType.VarChar,50).Value = a[6];
   cmd.Parameters.Add("@CC",SqlDbType.VarChar,50).Value = a[7];
   cmd.Parameters.Add("@DD",SqlDbType.VarChar,50).Value = a[8];
   cmd.Parameters.Add("@YesOrNo",SqlDbType.Int).Value = a[9];

   conn.Open();
   try
   {
    cmd.ExecuteNonQuery();
   }
   catch(Exception ex)
   {
    throw new Exception(ex.Message);
   }
   finally
   {
    cmd.Dispose();
    conn.Close();
   }
  }

  public SqlDataReader drQuestionWhereYesOrNo(int i)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Question_selWhereYesOrNo",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@YesOrNo",SqlDbType.Int).Value = i;

   conn.Open();
   dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
   return dr;
  }

  public SqlDataReader drQuestion()
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Question_sel",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   conn.Open();
   dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
   return dr;
  }

  public void updWhereQuestion(ArrayList a)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Question_updWhereQuestion",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@A",SqlDbType.Int).Value = a[0];
   cmd.Parameters.Add("@B",SqlDbType.Int).Value = a[1];
   cmd.Parameters.Add("@C",SqlDbType.Int).Value = a[2];
   cmd.Parameters.Add("@D",SqlDbType.Int).Value = a[3];
   cmd.Parameters.Add("@AA",SqlDbType.VarChar,50).Value = a[4];
   cmd.Parameters.Add("@BB",SqlDbType.VarChar,50).Value = a[5];
   cmd.Parameters.Add("@CC",SqlDbType.VarChar,50).Value = a[6];
   cmd.Parameters.Add("@DD",SqlDbType.VarChar,50).Value = a[7];
   cmd.Parameters.Add("@Question",SqlDbType.VarChar,200).Value = a[8];

   conn.Open();
   try
   {
    cmd.ExecuteNonQuery();
   }
   catch(Exception ex)
   {
    throw new Exception(ex.Message);
   }
   finally
   {
    cmd.Dispose();
    conn.Close();
   }
  }

  public void updQuestionWhereYesOrNo(string a,int i)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Question_updYesOrNoWhereQuestion",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@Question",SqlDbType.VarChar,50).Value = a.ToString();
   cmd.Parameters.Add("@YesOrNo",SqlDbType.Int).Value = i;

   conn.Open();
   try
   {
    cmd.ExecuteNonQuery();
   }
   catch(Exception ex)
   {
    throw new Exception(ex.Message);
   }
   finally
   {
    cmd.Dispose();
    conn.Close();
   }
  }

  public void updYesOrNo_0(int i)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Question_updYesOrNo_0",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@YesOrNo",SqlDbType.Int).Value = i;

   conn.Open();
   try
   {
    cmd.ExecuteNonQuery();
   }
   catch(Exception ex)
   {
    throw new Exception(ex.Message);
   }
   finally
   {
    cmd.Dispose();
    conn.Close();
   }
  }

  public void updQuestionWhereID(string a,int i)
  {   
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Question_updQuestionWhereID",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@Question",SqlDbType.VarChar,50).Value = a.ToString();
   cmd.Parameters.Add("@ID",SqlDbType.Int).Value = i;

   conn.Open();
   try
   {
    cmd.ExecuteNonQuery();
   }
   catch(Exception ex)
   {
    throw new Exception(ex.Message);
   }
   finally
   {
    cmd.Dispose();
    conn.Close();
   }
  }

  public void delQuestion(int i)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Question_del",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@ID",SqlDbType.Int).Value = i;

   conn.Open();
   try
   {
    cmd.ExecuteNonQuery();
   }
   catch(Exception ex)
   {
    throw new Exception(ex.Message);
   }
   finally
   {
    cmd.Dispose();
    conn.Close();
   }
  }
 }
}