SenBiTeSolution.DAL/tbl_User.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using SenBiTeSolution.Model;
using System.Data;
using System.Data.OleDb;
using SenBiTeSolution.DBUtility;

namespace SenBiTeSolution.DAL
{
     public class tbl_User
    {
         //添加用户
         public int AddUser(Model.tbl_User user)
         {
             string sqlString = "insert into tb_User(UserName,UserPwd,CreateDate,UserType) values(@UserName,@UserPwd,@CreateDate,@UserType)";

             OleDbParameter[] parameters = new OleDbParameter[4];

             parameters[0] = new OleDbParameter("@UserName", OleDbType.VarChar, 20);
             parameters[0].Value = user.UserName;

             parameters[1] = new OleDbParameter("@UserPwd", OleDbType.VarChar, 200);
             parameters[1].Value = user.UserPwd;

             parameters[2] = new OleDbParameter("@CreateDate", OleDbType.VarChar, 20);
             parameters[2].Value = user.CreateDate;

             parameters[3] = new OleDbParameter("@UserType", OleDbType.Integer, 4);
             parameters[3].Value = user.UserType;

             return DbHelperOleDb.ExecuteSql(sqlString, 1, parameters);
         }

         //修改用户
         public int UpdateUser(Model.tbl_User user)
         {
             string sqlString = "update tb_User set UserName=@UserName,UserPwd=@UserPwd,CreateDate=@CreateDate,UserType=@UserType where ID=@ID";

             OleDbParameter[] parameters = new OleDbParameter[5];

             parameters[0] = new OleDbParameter("@UserName", OleDbType.VarChar, 20);
             parameters[0].Value = user.UserName;

             parameters[1] = new OleDbParameter("@UserPwd", OleDbType.VarChar, 200);
             parameters[1].Value = user.UserPwd;

             parameters[2] = new OleDbParameter("@CreateDate", OleDbType.VarChar, 20);
             parameters[2].Value = user.CreateDate;

             parameters[3] = new OleDbParameter("@UserType", OleDbType.Integer, 4);
             parameters[3].Value = user.UserType;

             parameters[4] = new OleDbParameter("@ID", OleDbType.Integer, 4);
             parameters[4].Value = user.ID;

             return DbHelperOleDb.ExecuteSql(sqlString, 1, parameters);
         }