userinfo.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace myBusinessRole
{
    /// <summary>  
	/// 用户表      用户的具体信息 
    /// /// </summary>
    class UserInfo:IDbOperater
    {
      
       #region  字段的声明
        string userID;//用户ID
        string hallID;//营业厅ID
        string userPassWord;//用户密码
        string userName;//用户姓名
        string userType;//用户类型(操作员/用户)
        string userPhone;//联系电话
        string userAddress;//地址
        DateTime accountDate;//开户日期
        string userState;//管理状态
        DateTime monthStart;//包月开始
        DateTime monthEnd;//包月到期
        DateTime payDate;//交费日期
        decimal payAmount;//交费金额
        decimal balance;//剩余金额
        string remark;//备注
       #endregion

       #region 属性定义
        /// <summary>
        /// 用户ID
        /// </summary>
       public  string UserID
         {
             set { userID = value; }
            get { return  userID; }
          }
          /// <summary>
          /// 营业厅ID
          /// </summary>
          public string HallID
          {
              set { hallID = value; }
              get { return hallID; }
          }
          /// <summary>
          /// 用户密码
          /// </summary>
          public string UserPassWord
          {
              set { userPassWord = value; }
              get { return userPassWord; }
          }
          /// <summary>
          /// 用户姓名
          /// </summary>
          public string UserName
          {
              set { userName = value; }
              get { return userName; }
          }
          /// <summary>
          /// 用户类型
          /// </summary>
          public string UserType
          {
              set { userType= value; }
              get { return userType; }
          }
          /// <summary>
          /// 联系电话
          /// </summary>
          public string UserPhone
          {
              set { userPhone = value; }
              get { return userPhone; }
          }
          /// <summary>
          /// 地址
          /// </summary>
          public string UserAddress
          {
              set { userAddress = value; }
              get { return userAddress; }
          }
          /// <summary>
          /// 开户日期
          /// </summary>
          public DateTime AccountDate
          {
              set { accountDate = value; }
              get { return accountDate; }
          }
          /// <summary>
          /// 管理状态
          /// </summary>
          public string UserState
          {
              set { userState = value; }
              get { return userState; }
          }
          /// <summary>
          /// 包月开始
          /// </summary>
          public DateTime MonthStart
          {
              set { monthStart = value; }
              get { return monthStart; }
          }
          /// <summary>
          /// 包月到期
          /// </summary>
          public DateTime MonthEnd
          {
              set { monthEnd = value;}
              get { return monthEnd; }
          }
          /// <summary>
          /// 交费日期
          /// </summary>
          public DateTime PayDate
          {
              set { payDate = value; }
              get { return payDate; }
          }
          /// <summary>
          /// 交费金额
          /// </summary>
          public decimal PayAmount
          {
              set { payAmount = value; }
              get { return payAmount; }
          }
          /// <summary>
          /// 剩余金额
          /// </summary>
          public decimal Balance
          {
              set { balance = value; }
              get { return balance; }
          }
          /// <summary>
          /// 备注
          /// </summary>
        public string Remark
          {
              set { remark = value; }
              get { return remark; }
          }
     
    #endregion

       #region 实现接口(数据库操作对象)的方法
          #region 清空所有变量 void Clear()
          /// <summary>
          ///Clear()
          ///</summary>
          public void Clear()
          {
              userID="";//用户ID
              hallID = "";//营业厅ID
              userPassWord = "";//用户密码
              userName = "";//用户姓名
              userType = "";//用户类型(操作员/用户)
              userPhone = "";//联系电话
              userAddress = "";//地址
              accountDate = DateTime.Now;//开户日期
              userState = "";//管理状态
              monthStart = DateTime.Now;//包月开始
              monthEnd = DateTime.Now;//包月到期
              payDate = DateTime.Now;//交费日期
              payAmount = 0;//交费金额
              balance = 0;//剩余金额
              remark = "";//备注

          }
          #endregion

          #region 判断能否删除 public bool IsDeleteFromKey()
          /// <summary>
          ///IsDeleteFromKey() 根据主键判断能否删除此记录
          ///</summary>
          public bool IsDeleteFromKey()
          {

              //定义变量
              bool dbOk = false;//是否存在记录
              bool isDelete = false;//是否可以删除
              try
              {
                  //用户表和用户角色表有外键关系，要判断用户角色表中是否有记录存在
                  UserRole userRole = new  UserRole();
                 userRole.UserID=userID;
                 dbOk = userRole.IsExist(" UserID = '" + userID + "'");
                  if (dbOk)
                  {
                      //记录存在，不能删除
                      isDelete = false;
                  }
                  else
                  {
                      //没有有关的记录，可以删除
                      isDelete = true;
                  }
              }
              catch (Exception e)
              {
                  throw e;
              }


              return isDelete;
          }
          #endregion

          #region 根据主键删除 public bool DeleteFromKey()
          /// <summary>
          ///DeleteFromKey() 
          ///在IsDeleteFromKey()之后应用的方法
          ///如果能删除，根据主键删除
          ///</summary>
          public bool DeleteFromKey()
          {

              //生成Sql语句
              StringBuilder Sql = new StringBuilder();
              Sql.Append(" DELETE FROM UserInfo ");
              Sql.Append(" WHERE UserID='" + userID + "'");
              try
              {
                  //访问数据库并返回
                  DB db = new DB();
                  return db.ExecuteSql(Sql.ToString());
              }
              catch (Exception e)
              {
                  throw e;
              }
          }
          #endregion

          #region 根据条件删除 public bool Delete(string condition)
          /// <summary>
          ///Delete()  根据条件删除， condition为不含“where”的条件
          ///建议慎重使用，因为没有对应的判断，删除不能保证成功
          ///如果出错，返回的是数据库不能删除的错误信息
          ///</summary>
          public bool Delete(string condition)
          {

              //生成Sql语句
              StringBuilder Sql = new StringBuilder();
              Sql.Append(" DELETE FROM UserInfo ");
              if (!(condition == null || condition == ""))//如果条件是空不执行否则增加查询条件
              {
                  Sql.Append(" WHERE " + condition);