businesses.cs

commandBuilder应用数据库的使用

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using student.DB;

namespace student.Business
{
    public class Businesses
    {
        private SqlHelper db = new SqlHelper();
        private DataSet _ds;
        /// <summary>
        ///窗体初始化时加载数据
        /// </summary>
        /// <param name="dgv">Void</param>
        public void getDataGridViewValue(DataGridView dgv)
        {
            String sql = "select 编号,姓名,性别,年龄,班级 from v_student order by 编号 asc";
            DataSet ds = new DataSet();
            ds = db.getDataSet(sql);
            _ds = ds;
            dgv.DataSource = ds.Tables[0].DefaultView;
        }

        /// <summary>
        /// 更新数据
        /// </summary>
        /// <param name="dgv">DataGridView</param>
        /// <param name="ds">DataSet</param>
        public void updatData(DataGridView dgv,DataSet ds)
        {
            String sql ="select * from v_student";
            if (db.doUpdate(ds,sql,ds.Tables[0].TableName))
            {
                MessageBox.Show("数据更新成功","提示",MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                MessageBox.Show("数据更新失败,请检查数据是否合法!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
            }
        }

        /// <summary>
        /// 右键菜单相关操作
        /// </summary>
        /// <param name="dgv"></param>
        /// <param name="operType"></param>
        /// <param name="ds"></param>
        public void MenuOperation(DataGridView dgv,String operType,DataSet ds)
        {
            if (operType.Equals("删除"))
            {
                if (DialogResult.Yes== MessageBox.Show("数据删除后将不可恢复，真的要删除吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
                {
                    dgv.Rows.RemoveAt(dgv.CurrentRow.Index);
                    dgv.Refresh();
                    this.updatData(dgv, ds);
                }
                else
                {
                    return;
                }
            }
        }

        /// <summary>
        /// 将DataSet中的内容保存到student.txt中
        /// </summary>
        /// <param name="ds"></param>
        public void SavaData(DataSet ds)
        {
            StreamWriter sw = File.CreateText(Application.StartupPath + "\\studnet.txt");
            int rowCount=ds.Tables[0].Rows.Count;
            int colCount = ds.Tables[0].Columns.Count;
            
            foreach(DataRow row in ds.Tables[0].Rows)
            {
                String str = "";
                for (int i = 0; i < colCount; i++)
                {
                    if (row[i].ToString()=="False" || row[i].ToString()=="True")
                    {
                        //转换False True
                        int b = row[i].ToString().Equals("True") ? 1 : 0;
                        str += " " + b.ToString(); 
                    }
                    else
                    {
                        str += " " + row[i];
                    }
               }
                sw.WriteLine(str); 
            }
            sw.Flush();
            sw.Close();
            MessageBox.Show("数据转换保存成功","成功",MessageBoxButtons.OK,MessageBoxIcon.Information);
        }

        /// <summary>
        /// 得到DataSet
        /// </summary>
        public DataSet DataSetName
        {
            get
            {
                return _ds;
            }
        }
    }
}