public List <LoginVO> LoginAuthority(LoginVO login) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(ConnectionString); cmd.CommandText = @"select um.UserGroup_Code,u.User_ID,u.User_Name,s.Screen_Code,s.Pre_Type from User_Master u inner join UserGroup_Mapping m on m.User_ID = u.User_ID inner join UserGroup_Master um on m.UserGroup_Code = um.UserGroup_Code inner join ScreenItem_Authority s on s.UserGroup_Code = um.UserGroup_Code where u.User_ID = @User_ID and s.Screen_Code = @Screen_Code"; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@User_ID", login.User_ID); cmd.Parameters.AddWithValue("@Screen_Code", login.Screen_Code); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <LoginVO> list = Helper.DataReaderMapToList <LoginVO>(reader); cmd.Connection.Close(); return(list); } }
public List <LoginVO> LoginAuthority(LoginVO login) { LoginDAC dac = new LoginDAC(); return(dac.LoginAuthority(login)); }
public List <LoginVO> LoginOK(LoginVO login) { LoginDAC dac = new LoginDAC(); return(dac.LoginOK(login)); }