protected static SqlConnection getDb0Connection() { string connectionstring = LogicCenter.GetDB0ConnectionString(CommWebSetup.DB0_CodeString); //取得連線字串 SqlConnection connection = new SqlConnection(connectionstring); return(connection); }
private void button2_Click(object sender, EventArgs e) { LogicCenter lg = new LogicCenter("SR-NetWeb,sa,jcin@4257386~"); //var t = lg.GetShareBySales("M002", null); //var s = JsonConvert.SerializeObject(t); }
protected virtual LogicCenter openLogic() { LogicCenter dbLogic = new LogicCenter(CommSetup.CommWebSetup.DB0_CodeString); dbLogic.IP = System.Web.HttpContext.Current.Request.UserHostAddress; return(dbLogic); }
public bool EditUser(UserEditViewModel user, out string resultCode) { // 修改User角色權限Func Action <string, IEnumerable <RolesViewModel> > editUserRoles = (userNo, userRoles) => { userRoles = userRoles.OrderBy(r => r.ROLE_ID).ToList(); var o_user_role = _unitOfWork.Db.HRMT25.Where(u => u.USER_NO == userNo).OrderBy(r => r.ROLE_ID).ToList(); if (!LogicCenter.IsTheSame( userRoles, o_user_role, (ur, our) => ur.ROLE_ID == our.ROLE_ID)) { _unitOfWork.Db.HRMT25.RemoveRange(o_user_role); _unitOfWork.Db.HRMT25.AddRange(userRoles.Select(ur => new HRMT25() { ROLE_ID = ur.ROLE_ID, USER_NO = userNo, CHG_DATE = DateTime.Now, CHG_PERSON = user.CHG_PERSON, DEFAULT_YN = "" })); } }; try { // update user infos var o_user = _userRepo.Get(u => u.USER_NO == user.USER_NO).FirstOrDefault(); if (o_user == null) { resultCode = "notFindUser"; return(false); } if (string.IsNullOrEmpty(user.PHOTO)) // 圖片沒換就不更新,一樣使用舊圖 { user.PHOTO = o_user.PHOTO; } var n_user = _mapper.Map <UserEditViewModel, HRMT01>(user, o_user); n_user.CHG_DATE = DateTime.Now; n_user.CHG_PERSON = user.CHG_PERSON; // update user roles // only checked role to update editUserRoles(user.USER_NO, user.Roles.Where(r => r.CHECKED == true)); _unitOfWork.Db.SaveChanges(); resultCode = "edit user success"; } catch (Exception ex) { resultCode = ex.Message; return(false); } return(true); }
public IActionResult Login(string returnUrl, LogInModel model) { if (!ModelState.IsValid) { return(View(model)); } UserProfile findUser = _userService.LogIn(model, out string resultCode); if (findUser == null) { ModelState.AddModelError("LoginError", _localizer[resultCode].Value); return(View(model)); } // 要存的資訊: 看要存字串還是json var claims = new List <Claim>() { new Claim(ClaimTypes.Name, findUser.USER_NO), new Claim(ClaimTypes.NameIdentifier, findUser.USER_NO), new Claim(ClaimTypes.MobilePhone, findUser.PHONE ?? "") }; var roles = findUser.Roles .Select(r => new Claim(ClaimTypes.Role, LogicCenter.GetEnumName(r.ROLE_ID))); var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme); identity.AddClaims(claims); identity.AddClaims(roles); // 製作身分驗證Cookie var principal = new ClaimsPrincipal(identity); if (model.RememberMe) { HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, principal, new AuthenticationProperties { IsPersistent = true }); } else { // 過期時間 var timeSpanOffset = DateTimeOffset.UtcNow.AddMinutes(30); HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, principal, new AuthenticationProperties { IsPersistent = true, ExpiresUtc = timeSpanOffset }); } return(Redirect(returnUrl ?? Url.Action("Index", "Home"))); }
public IActionResult Login(string returnUrl, LogInModel model) { UserProfile findUser = _userService.LogIn(model, out string resultCode); if (findUser == null) { return(Ok(model)); } // 要存的資訊 var claims = new List <Claim>() { new Claim(ClaimTypes.Name, findUser.USER_NO), new Claim(ClaimTypes.NameIdentifier, findUser.USER_NO), new Claim(ClaimTypes.MobilePhone, findUser.PHONE ?? "") }; var roles = findUser.Roles .Select(r => new Claim(ClaimTypes.Role, LogicCenter.GetEnumName(r.ROLE_ID))); claims.AddRange(roles); // Json Web Token 登入 var token = new System.IdentityModel.Tokens.Jwt.JwtSecurityToken ( issuer: Configuration["Tokens:ValidIssuer"], audience: Configuration["Tokens:ValidAudience"], claims: claims, expires: DateTime.UtcNow.AddHours(1), /* 過期時間 */ signingCredentials: new SigningCredentials(new SymmetricSecurityKey (System.Text.Encoding.UTF8.GetBytes(Configuration["Tokens:IssuerSigningKey"])), SecurityAlgorithms.HmacSha256) ); string tokenString = new JwtSecurityTokenHandler().WriteToken(token); return(Ok( new { user = findUser, token = tokenString })); }
public override IEnumerable <DynamicNode> GetDynamicNodeCollection(ISiteMapNode nodes) { var is_tablet = (new WebInfo()).isTablet(); //var returnValue = new List<DynamicNode>(); LogicCenter log = new LogicCenter(CommWebSetup.DB0_CodeString); C47A0_JDMaskEntities db = LogicCenter.getDB0; try { LogicCenter.SetDB0EntityString(CommSetup.CommWebSetup.DB0_CodeString); IList <DynamicNode> colle_node = new List <DynamicNode>(); //if (!is_tablet) //{ #region PC Menu var items = db.Menu.Where(x => x.is_use == true && x.is_only_tablet == false).ToList(); var folder_items = items.Where(x => x.is_folder == true).OrderBy(x => x.sort); foreach (var item in folder_items) { DynamicNode folder_node = new DynamicNode(); folder_node.Title = item.menu_name; folder_node.Key = item.menu_id.ToString(); //dynamicNode.RouteValues.Add("genreId", item.menu_id); //製作連結參數 folder_node.Area = item.area; folder_node.Attributes.Add("IconClass", item.icon_class); folder_node.Clickable = false; folder_node.Roles.Add("Admins"); var get_roles = item.AspNetRoles.Select(x => x.Name); foreach (var role_name in get_roles) { folder_node.Roles.Add(role_name); } colle_node.Add(folder_node); var sub_items = items.Where(x => x.parent_menu_id == item.menu_id).OrderBy(x => x.sort); foreach (var sub_item in sub_items) { DynamicNode subNode = new DynamicNode(); subNode.Title = sub_item.menu_name; subNode.ParentKey = folder_node.Key; //dynamicNode.RouteValues.Add("genreId", item.menu_id); //製作連結參數 if (!string.IsNullOrEmpty(sub_item.area)) { subNode.Area = sub_item.area; } subNode.Controller = sub_item.controller; subNode.Action = sub_item.action; subNode.Clickable = true; subNode.Roles.Add("Admins"); var get_sub_roles = sub_item.AspNetRoles.Select(x => x.Name); foreach (var role_name in get_sub_roles) { subNode.Roles.Add(role_name); } colle_node.Add(subNode); } } #endregion //} //else //{ // #region Tablet // var items = db.Menu // .Where(x => x.is_use == true && x.is_on_tablet == true) // .ToList(); // foreach (var item in items) // { // DynamicNode item_node = new DynamicNode(); // item_node.Title = item.menu_name; // item_node.Key = item.menu_id.ToString(); // //dynamicNode.RouteValues.Add("genreId", item.menu_id); //製作連結參數 // item_node.Area = item.area; // item_node.Controller = item.controller; // item_node.Action = item.action; // //item_node.Attributes.Add("IconClass", item.icon_class); // item_node.Clickable = true; // //yield return item_node; // colle_node.Add(item_node); // } // #endregion //} return(colle_node); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } finally { db.Dispose(); } }
protected static C43A0_Mani520Entities getDB0() { LogicCenter.SetDB0EntityString(CommSetup.CommWebSetup.DB0_CodeString); return(LogicCenter.getDB0); }
private void button1_Click(object sender, EventArgs e) { LogicCenter lg = new LogicCenter("SR-NetWeb,sa,jcin@4257386~"); // lg.SettleCal(2015, 10); }
public static ApplicationDbContext Create() { string connstr = LogicCenter.GetDB0ConnectionString(CommSetup.CommWebSetup.DB0_CodeString); return(new ApplicationDbContext(connstr)); }
protected static C34A1_SYM_MotorEntities getDB0() { LogicCenter.SetDB0EntityString(CommSetup.CommWebSetup.DB0_CodeString); return(LogicCenter.getDB0); }
protected static C591613_TylynaEntities getDB0() { LogicCenter.SetDB0EntityString(CommWebSetup.DB0_CodeString); //取得連線字串 return(LogicCenter.getDB0); }