loginstore.cs

简单的cI真的是很简单 你想要就下载吧

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using BRISDataAccess.Entity;
using BRISDataAccess.Linq;
namespace BRISDataAccess.DataAccess
{
  public class LoginStore
    {
      PlayerDataContext _playerContext = null;

      public LoginStore()
      {
          _playerContext=new PlayerDataContext();
      }

      //Get Users table's Entity Object
      public UserEntity UserObjectToEntity(Users user)
      {
          UserEntity userEntity = new UserEntity();
          userEntity.UserID = user.UserID;
          userEntity.UserGuid = user.UserGuid;
          return userEntity;

      }

      //define a method ,Get UserLoginInfo by means of inporting parameter ( userID)
      public UserCollection GetUsersInfo(int userID)
      {
          UserCollection userCollention = new UserCollection();
          IEnumerable<Users> userLoginList = from userLogin in _playerContext.Users
                                             where userLogin.UserID == userID
                                             select userLogin;
          foreach (Users users in userLoginList)
          {
              userCollention.Add(UserObjectToEntity(users));

          }
          return userCollention;



      }

      public UserCollection GetUserLonginInfo(int operatorID, string ticket)
      {
          UserCollection userCollention = new UserCollection();
          IEnumerable<Users> userLonginlist = from userLongin in _playerContext.Users
                                              where userLongin.UserID == operatorID && userLongin.UserGuid == ticket
                                              select userLongin;
          foreach (Users users in userLonginlist)
          { 
            userCollention.Add (UserObjectToEntity(users));
          
          
          }
       return userCollention ;
      
      }

      //Insert table UserLoginInfo 
      public void InsertUser(UserEntity userEntity)
      {

          _playerContext.ExecuteCommand(@"insert into Users Values({0},{1})", 
                                        userEntity.UserID,
                                        userEntity.UserGuid);
      }

      //define a method UpdateUsersGuid by means of inporting parameter(employeeID)
      public void UpdataUsersGuid(string ticket, int employeeID)
      {
          _playerContext.ExecuteCommand(@"update Users set UserGuID={0} where UserID={1}",
                                        ticket,
                                        employeeID);
      }

      // define a method ,Delete Users UserLoginInfo by means of importing parameter (employeeID)
      public void DeleteUsersInfo(Nullable<int> employeeID,string ticket)
      {
          _playerContext.ExecuteCommand(@"delete from Users where UserID={0}",
                                       employeeID );


      }
    }
}