/// <summary>
/// 取得用者相關資料
/// </summary>
/// <param name="userID">使用者帳號</param>
/// <returns></returns>
public static LoginUserInfoDataEntity GetUser(string userID)
{
LoginUserInfoDataEntity user = new LoginUserInfoDataEntity()
{
loginuserID = string.Empty,
loginuserName = string.Empty,
loginuserPassword = string.Empty,
deptID = string.Empty,
deptName = string.Empty
};
var strSQL = @"
SELECT
u.loginuserID
,u.loginuserPassword
,u.loginuserName
,u.deptID
,d.deptName
FROM LBOM_LOGIN_USER U
JOIN LBOM_dept D
ON U.DEPTID = d.DEPTID
WHERE u.loginuserID = @loginuserID
";
using (var conn = new SqlConnection(ConnectionString))
using (var cmd = new SqlCommand(strSQL, conn))
{
cmd.Parameters.Add(new SqlParameter("@loginuserID", userID));
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
//Mapper.CreateMap<IDataReader, LoginUserInfoDataEntity>();
//user = Mapper.Map<IDataReader, IList<LoginUserInfoDataEntity>>(dr).ToList().First();
user.deptID = dr["deptID"].ToString();
user.loginuserID = dr["loginuserID"].ToString();
user.loginuserName = dr["loginuserName"].ToString();
user.loginuserPassword = dr["loginuserPassword"].ToString();
user.deptName = dr["deptName"].ToString();
}
}
}
return(user);
}
/// <summary>
/// 登入處理
/// </summary>
/// <param name="user"></param>
/// <param name="isPersisten"></param>
protected void LoginProcess(LoginUserInfoDataEntity user, bool isPersisten = false)
{
//建立票證
var ticket = new FormsAuthenticationTicket(
version: 1,
name: user.loginuserID,
issueDate: DateTime.Now,
expiration: DateTime.Now.AddMinutes(30),
isPersistent: isPersisten,
userData: "",
cookiePath: FormsAuthentication.FormsCookiePath
);
var encTicket = FormsAuthentication.Encrypt(ticket);
var encryptedTicket = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
Session["userInfo"] = user;//將使用者資料物件存入SESSION
Response.Cookies.Add(cookie);
}
