clsprocgroupitem.cs

以构建的方式来实现对通用的查询统计

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
using System.Collections;
using dist.hb.EnvQueryStat.Pub;

namespace dist.hb.EnvQueryStat.StatSet
{
  class clsProcGroupItem
  {
    private OleDbConnection m_OleDbConn;
    public OleDbConnection OleDbConn
    {
      get { return m_OleDbConn; }
      set
      {
        if (value == null) return;
        if (value == m_OleDbConn) return;
        m_OleDbConn = value;
      }
    }
    public int m_nStatInstID;//统计ID
    public ListBox MainGroupContent;
    public ListBox SecondGroupContent;
    //=====================================
    public void LoadGroupContent()
    {
      if (MainGroupContent == null || SecondGroupContent == null) return;
      MainGroupContent.Items.Clear();
      SecondGroupContent.Items.Clear();
      string strSQL;
      strSQL = "SELECT code, name, GroupType FROM FS_GroupContent  " +
                "where StatInstID = " + m_nStatInstID.ToString();

      OleDbConnection connection = new OleDbConnection(m_OleDbConn.ConnectionString);

      connection.Open();
      OleDbCommand command = new OleDbCommand(strSQL, connection);
      OleDbDataReader reader = command.ExecuteReader();
      if (!reader.HasRows) return;
      while(reader.Read())
      {
        DictItem item = new DictItem();
        item.code = reader.GetString(0);
        item.name = reader.GetString(1);
        if (reader.GetInt32(2) == 0) MainGroupContent.Items.Add(item);
        else SecondGroupContent.Items.Add(item);
      }
      reader.Close();

    }

    public void DeleteGroupContent()
    {
      string strSQL;
      strSQL = "DELETE  FROM FS_GroupContent  WHERE StatInstID =" + m_nStatInstID.ToString();
      OleDbCommand command = new OleDbCommand(strSQL, m_OleDbConn);
      command.ExecuteNonQuery();
      command.Dispose();
    }

    public void SaveGroupContent()
    {
      DeleteGroupContent();

      DataSet ds = new DataSet();
      string strSQL;
      strSQL = "SELECT GroupCode, StatInstID, code,name, GroupType FROM FS_GroupContent  " +
                "where StatInstID = " + m_nStatInstID.ToString();
      OleDbDataAdapter Adapter = new System.Data.OleDb.OleDbDataAdapter(strSQL, m_OleDbConn);

      OleDbCommandBuilder custCB = new OleDbCommandBuilder(Adapter);
      OleDbCommand cmd = new OleDbCommand();

      cmd.Connection = m_OleDbConn;
      //cmd.Transaction = m_tran;
      cmd.CommandType = CommandType.Text;
      cmd.CommandText = strSQL;
      Adapter.SelectCommand = cmd;

      Adapter.Fill(ds, "FS_GroupContent");
      DataTable dt = ds.Tables["FS_GroupContent"];
      //处理主分组
      int i = clsDbPub.GetMaxValue(m_OleDbConn, "FS_GroupContent", "GroupCode");
      foreach (DictItem var in MainGroupContent.Items)
      {
         DataRow dr = dt.NewRow();
        i++;
        dr["GroupCode"] = i;
        dr["StatInstID"] = m_nStatInstID;
        dr["code"] = var.code;
        dr["name"] = var.name;
        dr["GroupType"] = 0;
        dt.Rows.Add(dr);
      }
      //处理次分组
      foreach (DictItem var in SecondGroupContent.Items)
      {
        DataRow dr = dt.NewRow();
        i++;
        dr["GroupCode"] = i;
        dr["StatInstID"] = m_nStatInstID;
        dr["code"] = var.code;
        dr["name"] = var.name;
        dr["GroupType"] = 1;
        dt.Rows.Add(dr);
      }
      Adapter.Update(ds, "FS_GroupContent");
    }
    public ArrayList GetMainGroupContent()
    {
      ArrayList AList = new ArrayList();
      foreach (object var in MainGroupContent.Items)
      {
        AList.Add(var);
      }
      return AList;
    }
    public ArrayList GetSecondGroupContent()
    {
      ArrayList AList = new ArrayList();
      foreach (object var in SecondGroupContent.Items)
      {
        AList.Add(var);
      }
      return AList;
    }


  }

}