public List <Model.UserMenu_Read> Get_UserMenu(Model.Criteria.UserMenu_Criteria criteria)
{
//string connStr = Properties.Settings.Default.InventoryControl_ConnectionString;
//SqlConnection conn = Common.DataHelper.getSQLServerConnectionObject(connStr);
DataSet ds = new DataSet();
//SqlDataAdapter adp = new SqlDataAdapter("usp_User_Menu", conn);
//adp.SelectCommand.CommandType = CommandType.StoredProcedure;
//adp.SelectCommand.Parameters.Add(new SqlParameter("@bmUserID", criteria.UserID));
//adp.SelectCommand.Parameters.Add(new SqlParameter("@bmUserAccount", criteria.UserAccount));
//adp.SelectCommand.Parameters.Add(new SqlParameter("@bmDept", criteria.Dept));
//adp.Fill(ds);
var result = ds.Tables[0].AsEnumerable().Select(s => new Model.UserMenu_Read
{
PAG_ID = s.Field <int?>("PAG_ID"),
PAG_Group = s.Field <int?>("PAG_GROUP"),
PAG_Group_Name = s.Field <string>("PAG_Group_Name"),
PAG_Name = s.Field <string>("PAG_Name"),
Level = s.Field <int?>("Level"),
PAG_CODE = s.Field <string>("PAG_CODE")
}).ToList();
return(result);
}
public List <Model.UserMenu_Read> Get_UserMenu_Permission(Model.Criteria.UserMenu_Criteria criteria)
{
return(_objDAL.Get_UserMenu(criteria));
}
