/// <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();
}
