/// <summary> /// 驗證登錄 /// </summary> public void Authenticate_users() { string Username = Request["Username"]; string Password = Request["Password"]; using (var db = new SSM2_PRODEntities()) { var Select = db.M_User.Where(t => t.UserID == Username).FirstOrDefault(); if (Select != null && Select.Password == Password) { Select.CancelDate = DateTime.Now; db.SaveChanges(); result = "Success"; Response.ContentType = "Application/json"; Response.Write(result); Response.End(); } else if (Select != null && Select.Password != Password) { result = "Fail"; Response.ContentType = "Application/json"; Response.Write(result); Response.End(); } else { result = "Error"; Response.ContentType = "Application/json"; Response.Write(result); Response.End(); } } }
///// <summary> ///// 功能權限顯示 ///// </summary> //public void GetShowFunctionList() //{ // string LoginUserID = Request["LoginUserID"]; // using (var db = new VehicleEntities()) // { // var rst = from hdr in db.Permissions.Where(p => p.LoginID == LoginUserID) // select new { FunctionTree = hdr.FunctionTreeID, FunctionListName = hdr.FunctionNameID, IsShow = hdr.IsShow }; // result = JsonConvert.SerializeObject(rst); // Response.ContentType = "Application/text"; // Response.Write(result); // Response.End(); // } //} /// <summary> /// 獲取菜單 /// </summary> public void MenuShow() { string LoginUserID = Request["LoginUserID"]; Menu result = new Menu(); string Car_Mang = ""; string Car_Info = ""; string Statement = ""; using (var db = new SSM2_PRODEntities()) { var LoginRole = db.M_UserRole.Where(t => t.UserID == LoginUserID); var SystemFunc = db.M_SystemFunc.Where(t => t.SystemCode == "VEHICLESYSTEM"); var SystemFuncAccessRights = db.M_SystemFuncAccessRights.Where(t => t.SystemCode == "VEHICLESYSTEM"); var SystemRole = db.M_SystemFuncAccessRights.Where(t => t.SystemCode == "VEHICLESYSTEM").Select(t => t.RoleID).Distinct(); foreach (var RoleID in SystemRole) { foreach (var lr in LoginRole.Where(t => t.RoleID == RoleID)) { foreach (var Func in SystemFunc.Where(t => t.FuncTagID == "VS01")) { foreach (var FuncAccessRights in SystemFuncAccessRights.Where(t => t.FuncCode == Func.FuncCode && t.RoleID == RoleID)) { if (FuncAccessRights.FuncCode == "VS01001") { Car_Info = Car_Info + VS01001; } if (FuncAccessRights.FuncCode == "VS01002") { Car_Info = Car_Info + VS01002; } if (FuncAccessRights.FuncCode == "VS01003") { Car_Info = Car_Info + VS01003; } } } foreach (var Func in SystemFunc.Where(t => t.FuncTagID == "VS02")) { foreach (var FuncAccessRights in SystemFuncAccessRights.Where(t => t.FuncCode == Func.FuncCode && t.RoleID == RoleID)) { if (FuncAccessRights.FuncCode == "VS02001") { Car_Mang = Car_Mang + VS02001; } if (FuncAccessRights.FuncCode == "VS02002") { Car_Mang = Car_Mang + VS02002; } if (FuncAccessRights.FuncCode == "VS02003") { Car_Mang = Car_Mang + VS02003; } if (FuncAccessRights.FuncCode == "VS02004") { Car_Mang = Car_Mang + VS02004; } if (FuncAccessRights.FuncCode == "VS02005") { Car_Mang = Car_Mang + VS02005; } } } foreach (var Func in SystemFunc.Where(t => t.FuncTagID == "VS03")) { foreach (var FuncAccessRights in SystemFuncAccessRights.Where(t => t.FuncCode == Func.FuncCode && t.RoleID == RoleID)) { if (FuncAccessRights.FuncCode == "VS03001") { Statement = Statement + VS03001; } } } } } result.Car_Mang = Car_Mang; result.Car_Info = Car_Info; result.Statement = Statement; } Response.ContentType = "Application/text"; Response.Write(JsonConvert.SerializeObject(result)); Response.End(); }