userinfo.cs

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

              }
              try
              {
                  //访问数据库并返回
                  DB db = new DB();
                  return db.ExecuteSql(Sql.ToString());
              }
              catch (Exception e)
              {
                  throw e;
              }
          }
          #endregion

          #region 根据主键更新 public bool UpdateFromKey()
          /// <summary>
          ///UpdateFromKey() 根据主键更新，由前台页面保证数据的合法性
          ///更新的内容在属性中存放。
          ///</summary>
          public bool UpdateFromKey()
          {

              //生成Sql语句
              StringBuilder Sql = new StringBuilder();
              Sql.Append(" UPDATE UserInfo SET ");

              Sql.Append(" UserID='" + userID + "' ");
              Sql.Append(" ,HallID='" + hallID + "' ");
              Sql.Append(" ,UserPassWord='" + userPassWord + "' ");
              Sql.Append(" ,UserName='" + userName + "' ");
              Sql.Append(" ,UserType='" + userType + "' ");

              Sql.Append(" ,UserPhone='" + userPhone + "' ");
              Sql.Append(" ,UserAddr='" + userAddress + "' ");
              Sql.Append(" ,AccountDate='" + accountDate + "' ");
              Sql.Append(" ,UserState='" + userState + "' ");
              Sql.Append(" ,MonthStart='" + monthStart + "' ");

              Sql.Append(" ,MonthEnd='" + monthEnd + "' ");
              Sql.Append(" ,PayDate='" + payDate + "' ");
              Sql.Append(" ,PayAmount='" + payAmount + "' ");
              Sql.Append(" ,Balance='" + balance + "' ");
              Sql.Append(" ,Remark='" + remark + "' ");
              Sql.Append(" WHERE UserID='" + userID + "'");
              try
              {
                  //访问数据库并返回
                  DB db = new DB();
                  return db.ExecuteSql(Sql.ToString());
              }
              catch (Exception e)
              {
                  throw e;
              }
          }
          #endregion

          #region 添加一条记录 public bool Insert()
          /// <summary>
          ///Insert() 添加一条记录，添加的内容在属性中存放
          ///由前台页面保证数据的合法性
          ///</summary>
          public bool Insert()
          {

              //生成Sql语句
              StringBuilder Sql = new StringBuilder();
              Sql.Append(" INSERT INTO UserInfo");
              Sql.Append(" (UserID,HallID, UserPassWord,UserName,UserType,");
              Sql.Append(" UserPhone,UserAddr,AccountDate,UserState,MonthStart,");
              Sql.Append(" MonthEnd,PayDate ,PayAmount ,Balance,Remark)");
              Sql.Append(" VALUES (");
              Sql.Append(" '" + userID + "' ");
              Sql.Append(" ,'" + hallID + "' ");
              Sql.Append(" ,'" + userPassWord + "' ");
              Sql.Append(" ,'" + userName + "' ");
              Sql.Append(" ,'" + userType + "' ");

              Sql.Append(" ,'" + userPhone + "' ");
              Sql.Append(" ,'" + userAddress + "' ");
              Sql.Append(" ,'" + accountDate + "' ");
              Sql.Append(" ,'" + userState + "' ");
              Sql.Append(" ,'" + monthStart + "' ");

              Sql.Append(" ,'" + monthEnd + "' ");
              Sql.Append(" ,'" + payDate + "' ");
              Sql.Append(" ,'" + payAmount + "' ");
              Sql.Append(" ,'" + balance + "' ");
              Sql.Append(" ,'" + remark + "' ");
              Sql.Append(" )");
              try
              {
                  //访问数据库并返回
                  DB db = new DB();
                  return db.ExecuteSql(Sql.ToString());
              }
              catch (Exception e)
              {
                  throw e;
              }
          }
          #endregion

          #region 给定条件的记录是否存在 public bool IsExist(string condition)
          /// <summary>
          ///IsExist() 给定条件的记录是否存在
          ///</summary>
          public bool IsExist(string condition)
          {

              //生成Sql语句
              StringBuilder Sql = new StringBuilder();
              Sql.Append(GetSqlString(condition));//由条件获得 相应的sql语句
    
              bool dbOk = false;//存放判断是否存在的结果
              string retOneData;//一条纪录
              try
              {
                  //访问数据库
                  DB db = new DB();
                  retOneData = db.GetOneData(Sql.ToString());//取按照sql语句执行结果中的第一条数据
           
                  if (retOneData != null && retOneData != "")//如果不是空 则存在满足条件的记录
                  {
                      dbOk = true;
                  }
              }
              catch (Exception e)
              {
                  throw e;
              }
              return dbOk;
          }
          #endregion

          #region 根据条件查询  public DataTable Query(string condition)
          /// <summary>
          ///Query() 根据条件查询，condition为不含“where”的条件
          ///由查询者保证condition的合法性
          ///</summary>
          public DataTable Query(string condition)
          {
              try
              {
                  //访问数据库并返回
                  DB db = new DB();
                  return db.GetDataTable(GetSqlString(condition));
              }
              catch (Exception e)
              {
                  throw e;
              }
          }
          #endregion

          #region 无条件查询  public DataTable Query()
          /// <summary>
          ///Query() 无条件查询
          ///</summary>
          public DataTable Query()
          {
              try
              {
                  //访问数据库并返回
                  DB db = new DB();
                  return db.GetDataTable(GetSqlString(""));
              }
              catch (Exception e)
              {
                  throw e;
              }
          }
          #endregion

          #region 根据主键查询 public Ret QueryFromKey()
          /// <summary>
          ///QueryFromKey() 根据主键查询
          ///要查询的主键在属性中存放，查询的结果存放在属性中
          ///</summary>
          public DataTable QueryFromKey()
          {

              //生成Sql语句
              StringBuilder Sql = new StringBuilder();
              Sql.Append(GetSqlString(" UserID='" + userID + "' "));

              //清空属性值
              this.Clear();
              //定义返回变量
              DataTable dt = new DataTable();
              try
              {
                  //访问数据库
                  DB db = new DB();
                  dt = db.GetDataTable(Sql.ToString());

                  //若访问数据库成功就给属性赋值
                  if (dt.Rows.Count > 0)
                  {
                      userID = dt.Rows[0]["UserID"].ToString();
                      hallID = dt.Rows[0]["HallID"].ToString();
                      userPassWord = dt.Rows[0]["UserPassWord"].ToString();
                      userName = dt.Rows[0]["UserName"].ToString();
                      userType = dt.Rows[0]["UserType"].ToString();

                      userPhone = dt.Rows[0]["UserPhone"].ToString();
                      userAddress = dt.Rows[0]["UserAddr"].ToString();
                      accountDate = DateTime.Parse(dt.Rows[0]["AccountDate"].ToString());
                      userState = dt.Rows[0]["UserState"].ToString();
                      monthStart = DateTime.Parse(dt.Rows[0]["MonthStart"].ToString());

                      monthEnd = DateTime.Parse(dt.Rows[0]["MonthEnd"].ToString());
                      payDate = DateTime.Parse(dt.Rows[0]["PayDate"].ToString());
                      payAmount = decimal.Parse( dt.Rows[0]["PayAmount"].ToString());
                      balance = decimal.Parse(dt.Rows[0]["Balance"].ToString());
                      remark = dt.Rows[0]["Remark"].ToString();
                  }
              }
              catch (Exception e)
              {
                  throw e;
              }

              return dt;
          }
          #endregion

          #region 根据条件获取查询SQL语句 public string GetSqlString(string condition)
          /// <summary>
          ///GetSqlString(string condition) 根据条件获取查询SQL语句
          ///</summary>
          public string GetSqlString(string condition)
          {

              //生成Sql查询语句
              StringBuilder Sql = new StringBuilder();
              Sql.Append(" SELECT ");
              Sql.Append(" UserID,HallID, UserPassWord,UserName,UserType,");
              Sql.Append(" UserPhone,UserAddr,AccountDate,UserState,MonthStart,");
              Sql.Append(" MonthEnd,PayDate,PayAmount,Balance,Remark");
              Sql.Append(" FROM UserInfo ");
              if (condition != null && condition != "")
              {
                  Sql.Append(" WHERE " + condition);
              }

              //返回
              return Sql.ToString();
          }
          #endregion



          #endregion
      


      }
}