public bool check_user_right(string username, int requiredRight) { bool isSuccess = false; using (Models.MerchantService db = new MerchantService()) { t_Users u = db.t_Users.Where(x => x.UserID == username).SingleOrDefault(); mUser mU = new mUser(); mU.UserID = u.UserID; mU.UserLevel = u.UserLevel; if (requiredRight == 1) { if (mU.UserLevel == 1 || mU.UserLevel == 3) { isSuccess = true; } } if (requiredRight == 2) { if (mU.UserLevel == 2 || mU.UserLevel == 3) { isSuccess = true; } } } return(isSuccess); }
public bool UserLogin(mUser user) { using (SqlConnection consql = new SqlConnection(ConfigurationManager.ConnectionStrings["MerchantServiceDB"].ConnectionString)) { consql.Open(); SqlCommand cmd = new SqlCommand("sp_u_login", consql); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", user.UserID); cmd.Parameters.AddWithValue("@Passwd", EncryptPassword(user.Passwd)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { return(true); } else { return(false); } } }