popedom.cs

进存销系统..适合书店的进销存..功能可以满足一般的需求.很简单

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace BookStore.Forms
{
    public partial class PopeDom : Form
    {
        private string SelUser = "Select * from Users";
        private DataTable UserInfoDT = new DataTable();
        private DataTable PopeDomDT = new DataTable();

        public PopeDom()
        {
            InitializeComponent();
        }

        //Load事件 选择第一个用户
        private void PopeDom_Load(object sender, EventArgs e)
        {
            UserInfoDT = DataAccess.Narnu.GetDataTableBySql(SelUser);
            this.dg_PopeDom.DataSource = UserInfoDT;

            this.dg_PopeDom.Select(0);
            int UserID = int.Parse(UserInfoDT.Rows[0][0].ToString());
            string StrSQL = "select 权限名称 from 权限清单 where 用户编号=" + UserID;
            PopeDomDT = DataAccess.Narnu.GetDataTableBySql(StrSQL);
            for (int i = 0; i < PopeDomDT.Rows.Count; i++)
            {
                for (int j = 0; j < clb_PopeDom.Items.Count; j++)
                {
                    if (PopeDomDT.Rows[i][0].ToString() == clb_PopeDom.Items[j].ToString())
                    {
                        this.clb_PopeDom.SetItemChecked(j, true);
                    }
                }
            }
        }

        //选择不同的用户 显示不同的权限
        private void dg_PopeDom_MouseUp(object sender, MouseEventArgs e)
        {
            int intCurrntRow = this.dg_PopeDom.CurrentCell.RowNumber;
            int UserID = int.Parse(this.UserInfoDT.Rows[intCurrntRow][0].ToString());
            string StrSQL = "select 权限名称 from 权限清单 where 用户编号=" + UserID;
            PopeDomDT = DataAccess.Narnu.GetDataTableBySql(StrSQL);
            for (int i = 0; i < this.clb_PopeDom.Items.Count; i++)
            {
                this.clb_PopeDom.SetItemChecked(i, false);
            }
            for (int i = 0; i < PopeDomDT.Rows.Count; i++)
            {
                for (int j = 0; j < clb_PopeDom.Items.Count; j++)
                {
                    if (PopeDomDT.Rows[i][0].ToString() == clb_PopeDom.Items[j].ToString())
                    {
                        this.clb_PopeDom.SetItemChecked(j, true);
                    }
                }
            }
        }

        //保存修改后的权限
        private void btn_Save_Click(object sender, EventArgs e)
        {
            ArrayList Items = new ArrayList();
            int intCurrntRow = this.dg_PopeDom.CurrentCell.RowNumber;
            int UserID = int.Parse(this.UserInfoDT.Rows[intCurrntRow][0].ToString());
            foreach (object checkedItem in this.clb_PopeDom.CheckedItems)
            {
                Items.Add(checkedItem.ToString().Trim());
            }
            try
            {
                for (int i = 0; i < Items.Count; i++)
                {
                    string strSQL = "insert into 权限清单 (用户编号,权限名称) values (" +
                                    UserID + ",'" + Items[i].ToString().Trim() + "')";
                    DataAccess.Narnu.DoSqlString(strSQL);

                }
                MessageBox.Show("权限更改成功！");
            }
            catch
            {
                MessageBox.Show("权限更改出现错误！");
            }
        }

    }
}