推荐订阅源

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

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

  private SqlConnection conn;
  private SqlCommand cmd;
  private SqlDataReader dr;
  private DataSet ds;
  private SqlDataAdapter da;
  
  public void addCategory(ArrayList a)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Category_add",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@OrderID",SqlDbType.VarChar,50).Value = a[0];
   cmd.Parameters.Add("@DeepID",SqlDbType.VarChar,50).Value = a[1];
   cmd.Parameters.Add("@Category",SqlDbType.VarChar,50).Value = a[2];
   cmd.Parameters.Add("@FatherID",SqlDbType.VarChar,50).Value = a[3];

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

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

   cmd.Parameters.Add("@OrderID",SqlDbType.VarChar,50).Value = a[0];
   cmd.Parameters.Add("@DeepID",SqlDbType.VarChar,50).Value = a[1];
   cmd.Parameters.Add("@Category",SqlDbType.VarChar,50).Value = a[2];
   cmd.Parameters.Add("@FatherID",SqlDbType.VarChar,50).Value = a[3];
   cmd.Parameters.Add("@ID",SqlDbType.Int).Value = a[4];

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

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

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

  public SqlDataReader drCategoryWhereFatherID(string a)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Category_selWhereFatherID",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@FatherID",SqlDbType.VarChar,50).Value = a.ToString();

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

  public DataSet dsCategory()
  {
   conn = new SqlConnection(Str.con);
   da = new SqlDataAdapter();
   da.SelectCommand = new SqlCommand("Category_sel",conn);
   da.SelectCommand.CommandType = CommandType.StoredProcedure;

   conn.Open();
   try
   {
    ds = new DataSet();
    da.Fill(ds);
    return ds;
   }
   catch(Exception ex)
   {
    throw new Exception(ex.Message);
   }
   finally
   {
    da.SelectCommand.Dispose();
    conn.Close();
   }
  }

  public SqlDataReader drWhereOrderID(string a)
  {
   conn = new SqlConnection(Str.con);
   cmd = new SqlCommand("Category_selWhereOrderID",conn);
   cmd.CommandType = CommandType.StoredProcedure;

   cmd.Parameters.Add("@OrderID",SqlDbType.VarChar,50).Value = a.ToString();

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