adduser.cs

实现c#的计费系统 包括计费员 管理员 普通用户等几种操作角色 课程设计时编写

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

namespace myBusinessRole
{
    public partial class AddUser : Form
    {
        public AddUser()
        {
            InitializeComponent();
        }
        UserInfo userInfo = new UserInfo();

        private void endAddButton_Click(object sender, EventArgs e)
        {
            //注册一个新用户
            //将经过合法检查后的新信息存放到一个userinfo类的对象实例中
            //访问用户表  将该用户的新信息存放
            userInfo.UserID = userIDTextBox.Text;
            userInfo.UserName = userNameTextBox.Text;
            userInfo.UserPassWord = userPassWordTextBox.Text;
            userInfo.HallID = hallIdTextBox.Text;
            userInfo.UserType = userTypeComboBox.Text;
            userInfo.UserPhone = userPhoneTextBox.Text;
            userInfo.UserAddress = userAddressTextBox.Text;
            userInfo.AccountDate = DateTime.Parse ( accountDateTextBox.Text);
            userInfo.UserState = userStatsTextBox.Text;
            userInfo.MonthStart = DateTime.Parse( monthStartTextBox.Text);
            userInfo.MonthEnd = DateTime.Parse( monthEndTextBox.Text);
            userInfo.PayDate = DateTime.Parse( payDateTextBox.Text);
            userInfo.PayAmount = decimal.Parse(payAmountTextBox.Text);
            userInfo.Balance = decimal.Parse(balanceTextBox.Text);
            userInfo.Remark = userRemarkTextBox.Text;
            //如果没有该用户则添加
            string condition;//条件表达式
            condition = "UserID='" + userIDTextBox.Text + "'";//得到输入的当前用户主键
            if (!userInfo.IsExist(condition))//如果不存在当前输入的用户就插入
            {
                if (userInfo.Insert() == true)//insert a record
                    MessageBox.Show("添加成功！");

                this.Close();
                
            }
            else //否则输出消息 该用户已经存在
            {
                MessageBox.Show("该用户已经存在！");
                userIDTextBox.Text = "";//将文本内容清空
                hallIdTextBox.Text = "";
                userPassWordTextBox.Text = "";
                userNameTextBox.Text = "";
                userTypeComboBox.SelectedIndex = 0;

                userPhoneTextBox.Text = "";
                userAddressTextBox.Text = "";
                accountDateTextBox.Text = "";
                userStatsTextBox.Text = "";
                monthStartTextBox.Text = "";

                monthEndTextBox.Text = "";
                payDateTextBox.Text = "";
                payAmountTextBox.Text = "";
                balanceTextBox.Text = "";
                userRemarkTextBox.Text = "";
                userIDTextBox.Focus();

            }
            
        }

        private void AddUser_Load(object sender, EventArgs e)
        {
            userIDTextBox.Text = "";//将文本内容清空
            hallIdTextBox.Text = "";
            userPassWordTextBox.Text = "";
            userNameTextBox.Text = "";
            userTypeComboBox.SelectedIndex = 0;

            userPhoneTextBox.Text = "";
            userAddressTextBox.Text = "";
            accountDateTextBox.Text = "";
            userStatsTextBox.Text = "";
            monthStartTextBox.Text = "";

            monthEndTextBox.Text = "";
            payDateTextBox.Text = "";
            payAmountTextBox.Text = "";
            balanceTextBox.Text = "";
            userRemarkTextBox.Text = "";
            userIDTextBox.Focus();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}