public void LoadSRMSessionFromURL()
{
string mCompanyID = Request.QueryString["p1"].ToString();
string mUserID = Request.QueryString["p2"].ToString();
string mToken = Request.QueryString["p3"].ToString();
string mStartPage = Request.QueryString["p4"].ToString();
if (Session["insSUser"] != null)
{
SUser insSUser = (SUser)Session["insSUser"];
if (insSUser.CompanyID == mCompanyID && insSUser.ID == mUserID && insSUser.Token == mToken)
{
Response.Redirect(mStartPage, false);
return;
}
}
DbNewAssistant DNB = new DbNewAssistant("B2B_ASUSB2B_DB");
string sql = string.Format(@"SELECT *
FROM ASUSB2B.B2BPT_USER_LOG
WHERE USER_ID='{0}' AND SESSION_ID='{1}' AND WORK_STATUS='Y'", mUserID, mToken);
DataTable dt = DNB.DoSelect(sql);
if (dt.Rows.Count > 0)
{
SUser insSUser = new SUser();
insSUser.ID = mUserID;
insSUser.CompanyID = mCompanyID;
insSUser.Token = mToken;
insSUser.SessionID = Session.SessionID;
insSUser.IP = Request.UserHostAddress;
Session["insSUser"] = insSUser;
}
Response.Redirect(mStartPage);
}
public void DeleteUserTest()
{
SUser suser = new SUser();
suser.DeleteUser(Guid.Parse("727491a4-5c14-42cb-b0af-9f93456ecbaf"));
Assert.Fail();
}
public ResponseBase ChangeInfo(int userId, string mail, string first, string last)
{
ResponseBase rs = new ResponseBase();
try
{
using (var db = new IEDEntities())
{
SUser user = db.SUsers.FirstOrDefault(x => x.Id == userId && !x.IsDeleted);
if (user == null)
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "change info", Message = "Tài Khoản đang thao tác không tồn tại. Vui lòng kiểm tra lại."
});
}
else
{
user.Email = mail;
user.FisrtName = first;
user.LastName = last;
user.UpdatedUser = userId;
user.UpdatedDate = DateTime.Now;
db.SaveChanges();
rs.IsSuccess = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(rs);
}
/// <summary>
/// 方法执行完毕,添加用户行为
/// </summary>
/// <param name="filterContext"></param>
public override void OnActionExecuting(ActionExecutingContext context)
{
if (User.Claims.Count() > 0)
{
string userId = User.Claims.Where(t => t.Type == "ID").FirstOrDefault().Value;
CurrentUser = new SUserService().GetUserById(ESCConvert.ConvertToInt(userId));
ViewBag.CurrentUser = CurrentUser;
}
else
{
context.Result = RedirectToAction("Index", "Account");
return;
}
//记录行为日志 增删改
if (context.HttpContext.Request.Method.Equals("POST", StringComparison.OrdinalIgnoreCase))
{
SBehaviorLog log = new SBehaviorLog()
{
HttpMethod = context.HttpContext.Request.Method,
ReqDate = DateTime.Now,
ReqIP = context.HttpContext.Request.Host.Host,
ReqUrl = context.HttpContext.Request.Path.Value,
UserId = CurrentUser.ID,
ReqParams = GetFormData(),
UserName = CurrentUser.UserName
};
logService.AddBehaviorLog(log);
}
base.OnActionExecuting(context);
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool RemoveUser(SUser user)
{
//删除用户角色关系
uRepository.RemoveUserRoleByUser(user.ID);
//删除用户
return(uRepository.Delete(user));
}
public async Task <IHttpActionResult> ChangePasswordEmail(ChangePasswordBindingModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
SUser suser = new SUser();
var user = suser.GetUserByEmail(model.Email);
if (AppUserManager.VerifyUserToken(user.Id, DateTime.Today.ToShortDateString(), model.Token.Replace("#ChangePassword", "")))
{
string settok = UserManager.GeneratePasswordResetToken(user.Id);
IdentityResult result = UserManager.ResetPassword(user.Id, settok, model.NewPassword);
return(Json(new { success = true, issue = model.Email, errors = "", tipo = model.Email, UserEmail = model.Email, Url = Url.Content("/Freelance/Logout").ToString() }));
if (!result.Succeeded)
{
return(GetErrorResult(result));
}
}
else
{
return(Json(new { success = false, issue = model.Email, errors = "", tipo = model.Email, UserEmail = model.Email, Url = Url.Content("/Freelance/Logout").ToString() }));
}
}
public ContentResult Update()
{
ResultData <string> rt = new ResultData <string>();
SUser u = GetUpdate <SUser>();
//非空验证和属性格式验证
string msg = uService.CheckUser(u);
if (!string.IsNullOrEmpty(msg))
{
rt.message = msg;
rt.status = -1;
return(ReturnResult(rt));
}
//验证用户是否存在
if (uService.IsNotExits(u, false))
{
u.UpdateDate = DateTime.Now;
u.UpdateBy = this.CurrentUser.ID;
uService.UpdateUser(u);
}
else
{
rt.status = -1;
rt.message = "用户编码已经存在.";
}
return(ReturnResult(rt));
}
public ResponseBase Delete(int accountId, int actionUserId)
{
ResponseBase rs = null;
try
{
using (var db = new IEDEntities())
{
rs = new ResponseBase();
SUser user = db.SUsers.FirstOrDefault(x => x.Id == accountId && !x.IsDeleted);
if (user != null)
{
user.IsDeleted = true;
user.DeletedUser = actionUserId;
user.DeletedDate = DateTime.Now;
db.SaveChanges();
rs.IsSuccess = true;
}
else
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "Delete Account", Message = "Tài Khoản đang thao tác không tồn tại. Vui lòng kiểm tra lại!"
});
}
}
}
catch (Exception ex)
{
throw ex;
}
return(rs);
}
public ActionResult Index(string email)
{
//if (SessionBag.Current.Logout == true && SessionBag.Current.Logout!=null)
// return Redirect(Url.Content("~/Static/index.html"));
if (!string.IsNullOrEmpty(email))
{
SUser suser = new SUser();
var user = suser.GetUserByEmail(email);
SessionBag.Current.User = user;
ViewBag.IdUser = user.Id;
if (user != null)
{
return(View(user));
}
else
{
return(RedirectToAction("Logout", "Freelance", new { area = "" }));
/*return Redirect(Url.Content("~/Freelance/Logout"))*/;
}
}
else
{
return(RedirectToAction("Logout", "Freelance", new { area = "" }));
//return Redirect(Url.Content("~/Static/index.html"));
}
}
internal UserInfo(SUser user)
{
Id = user.Id;
UserStatusId = user.UserStatusId;
FirstName = user.FirstName;
LastName = user.LastName;
}
/// <summary>
/// 根据用户获取列权限
/// </summary>
/// <param name="user"></param>
/// <param name="tableName"></param>
/// <param name="resourceName"></param>
/// <returns></returns>
public List <SCPermission> GetCPermissionByUserAndResource(SUser user, string tableName, string resourceName)
{
//如果不是管理员,则只能查询自己的权限
string strSql = "";
List <SCPermission> cPerms = new List <SCPermission>();
if (user.SuperUser == BoolEnum.No)
{
strSql = " SELECT CP.*,CE1.EnumDesc AS VisibleName,CE2.EnumName AS DisabledName,CE3.EnumName AS RequiredName FROM SCPermission CP WITH(NOLOCK)";
strSql += " LEFT JOIN SRole R WITH(NOLOCK) ON CP.RoleID=R.ID";
strSql += " LEFT JOIN SUserRole UR WITH(NOLOCK) ON R.ID=UR.RoleID";
strSql += " LEFT JOIN SUser U WITH(NOLOCK) ON U.ID=UR.UserID";
strSql += " LEFT JOIN SCommonEnum CE1 WITH(NOLOCK) ON CP.Visible=CE1.EnumField AND CE1.EnumType='Bool'";
strSql += " LEFT JOIN SCommonEnum CE2 WITH(NOLOCK) ON CP.Disabled=CE2.EnumField AND CE2.EnumType='Bool'";
strSql += " LEFT JOIN SCommonEnum CE3 WITH(NOLOCK) ON CP.Required=CE3.EnumField AND CE3.EnumType='Bool'";
strSql += " WHERE CP.TableName='" + tableName + "' AND U.ID=" + user.ID;
strSql += " ORDER BY CP.OrderIndex ASC";
cPerms = dbContext.Connection.Query <SCPermission>(strSql).ToList();
}
if (cPerms.Count < 1)
{
strSql = " SELECT C.*,CE1.EnumDesc AS VisibleName,CE2.EnumName AS DisabledName,CE3.EnumName AS RequiredName FROM SColumn C WITH(NOLOCK)";
strSql += " LEFT JOIN SCommonEnum CE1 WITH(NOLOCK) ON C.Visible=CE1.EnumField AND CE1.EnumType='Bool'";
strSql += " LEFT JOIN SCommonEnum CE2 WITH(NOLOCK) ON C.Disabled=CE2.EnumField AND CE2.EnumType='Bool'";
strSql += " LEFT JOIN SCommonEnum CE3 WITH(NOLOCK) ON C.Required=CE3.EnumField AND CE3.EnumType='Bool'";
strSql += " WHERE C.TableName='" + tableName + "'";
strSql += " ORDER BY C.OrderIndex ASC";
cPerms = dbContext.Connection.Query <SCPermission>(strSql).ToList();
}
return(cPerms);
}
/// <summary>
/// 根据用户获取按钮权限
/// </summary>
/// <param name="user">用户</param>
/// <param name="controllerName">控制器名称</param>
/// <returns></returns>
public List <SOperator> GetOPermissionByUserAndResource(SUser user, string resourceName)
{
//如果不是管理员,则只能查询自己的权限
string strSql = "";
if (user.SuperUser == BoolEnum.Yes)
{
strSql = " SELECT O.* FROM SOperator O WITH(NOLOCK) LEFT JOIN SResource RS WITH(NOLOCK) ON O.ResourceID=RS.ID";
strSql += " WHERE RS.ResourceName='" + resourceName + "'";
strSql += " ORDER BY O.OrderIndex ASC";
}
else
{
strSql = " SELECT DISTINCT O.* FROM SOperator O WITH(NOLOCK)";
strSql += " LEFT JOIN SOPermission OP WITH(NOLOCK) ON OP.OperatorID= O.ID";
strSql += " LEFT JOIN SRolePermission RP WITH(NOLOCK) ON RP.ResourceID=OP.ResourceID";
strSql += " LEFT JOIN SRole R WITH(NOLOCK) ON RP.RoleID=R.ID";
strSql += " LEFT JOIN SUserRole UR WITH(NOLOCK) ON R.ID=UR.RoleID";
strSql += " LEFT JOIN SUser U WITH(NOLOCK) ON U.ID=UR.UserID";
strSql += " LEFT JOIN SResource RS WITH(NOLOCK) ON RP.ResourceID=RS.ID";
strSql += " WHERE RS.ResourceName='" + resourceName + "' AND U.ID=" + user.ID;
strSql += " ORDER BY O.OrderIndex ASC";
}
return(dbContext.Connection.Query <SOperator>(strSql).ToList());
}
public void SetDefaultData(string ID)
{
DataSet ds = dbs.GetSqlDataSet("select * from eagent where id=" + ID);
if (ds.Tables[0].Rows.Count > 0)
{
// DLUser.Items.Add(new Ext.Net.ListItem(ds.Tables[0].Rows[0]["PAgent"].ToString(), ds.Tables[0].Rows[0]["PAgentID"].ToString()));
DataTable TTB = new DataTable();
TTB.Columns.Add("userID");
TTB.Columns.Add("fullname");
DataRow dr = TTB.NewRow();
dr["userid"] = ds.Tables[0].Rows[0]["PAgentID"].ToString();
dr["fullname"] = ds.Tables[0].Rows[0]["PAgent"].ToString();
TTB.Rows.Add(dr);
SUser.DataSource = TTB;
SUser.DataBind();
DLUser.SelectedIndex = 0;
TXTBdate.Text = ds.Tables[0].Rows[0]["Bdate"].ToString();
TXTEdate.Text = ds.Tables[0].Rows[0]["Edate"].ToString();
string ckk = ds.Tables[0].Rows[0]["St"].ToString();
if (ckk == "1")
{
CK.Checked = true;
}
}
}
public ContentResult Add()
{
ResultData <string> rt = new ResultData <string>();
SUser u = GetAdd <SUser>();
//非空验证和属性格式验证
string msg = uService.CheckUser(u);
if (!string.IsNullOrEmpty(msg))
{
rt.message = msg;
rt.status = -1;
return(ReturnResult(rt));
}
//验证用户是否存在
if (uService.IsNotExits(u, true))
{
u.CreateBy = this.CurrentUser.ID;
u.CreateDate = DateTime.Now;
u.UpdateDate = DateTime.Now;
//获取默认密码
//string dftPassord = new ConfigurationManagerWrapper().AppSettings["DefaultPwd"];
// u.Pwd = dftPassord;
uService.AddUser(u);
}
else
{
rt.status = -1;
rt.message = "用户编码已经存在.";
}
return(ReturnResult(rt));
}
public override IEnumerator Start()
{
Caching.ClearCache();
Global.Initialize();
MVersion versions = new MVersion();
SUser sUser = Global.SUser;
List <IEnumerator> list = new List <IEnumerator>();
list.Add(sUser.Download(TileAsset.Url, versions.tile, (AssetBundle assetbundle) => {
TileAsset.assetbundle = assetbundle;
TileCacher.Instance.Reset(TileAsset.Data.tiles);
TileAsset.Clear();
}));
list.Add(sUser.Download(ImageAssetBundleManager.mapUrl, versions.map, (AssetBundle assetbundle) => {
ImageAssetBundleManager.map = assetbundle;
}, false));
/*list.Add(sUser.Download(ConstantAsset.Url, versions.constant, (AssetBundle assetbundle) => {
* ConstantAsset.assetbundle = assetbundle;
* Global.Constant = ConstantAsset.Data.constant;
* }));*/
Debug.Log("Start");
for (int i = 0; i < list.Count; i++)
{
Debug.Log(i + "/" + list.Count);
yield return(this.StartCoroutine(list[i]));
}
Debug.Log("Start Over");
loadComplete = true;
}
public string Add(string url, SUser user, int acctionUserId)
{
string result2;
try
{
AccountApi.AccountClient.BaseAddress = new Uri(url);
string str = string.Concat(new object[]
{
"user="******"&&acctionUserId=",
acctionUserId
});
HttpResponseMessage result = AccountApi.AccountClient.GetAsync("api/AccountApi/Add?" + str).Result;
result.EnsureSuccessStatusCode();
result2 = HttpContentExtensions.ReadAsAsync <string>(result.Content).Result;
return(result2);
}
catch (Exception)
{
}
result2 = null;
return(result2);
}
public List <OfferUser> GetSetProjetToUser(int Id)
{
//Guid userInfoId = new Guid(IdUser.ToString());
SUser suser = new SUser();
SProject sproject = new SProject();
SOffer soffer = new SOffer();
var offeruser = soffer.GetOfferUserById(Id);
var user = suser.GetUserById(new Guid(offeruser.IdUser));
var offere = soffer.GetOffer(offeruser.IdOffer);
Persistence.Entities.Project project = new Persistence.Entities.Project();
Persistence.Entities.ProjectUser projectuser = new Persistence.Entities.ProjectUser();
projectuser.IdUser = offeruser.IdUser;
project.IdCategory = offere.Category.Id;
project.IdOffer = offere.Id;
//project.Inicio = soffer.GetPhaseInitial(idoffer).InitPhase;
//project.Fin= soffer.GetPhaseFinal(idoffer).FinishPhase;
//project.Phases = new List<OfferPhase>();
//project.Phases = soffer.GetOfferPhases(idoffer).Select(e=>new OfferPhase().InjectFrom(e)).Cast<OfferPhase>().ToList();
project.Postulantes = soffer.GetOfferUser(offeruser.IdOffer).OfferUsers.Count();
project.Status = Persistence.Entities.StatusProject.EnCurso;
sproject.Insert(project, projectuser);
return(GetOfferUsers(offeruser.IdOffer));
}
/// <summary>
/// 判断是否系统管理员
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool IsSuperUser(SUser user)
{
if (user.UserCode.Equals("admin") && user.SuperUser == BoolEnum.Yes)
{
return(true);
}
return(false);
}
public string GetUser(string token, int id, Culture culture = Culture.En)
{
if (!CheckToken(token))
{
return(null);
}
return(ToJson(SUser.Convert(DataManager.Users.Find(id), HttpContext, culture)));
}
public string Authenticate(string token, AuthenticationProvider provider, string id, string name, string lastName, string image, Culture culture = Culture.En)
{
if (!CheckToken(token))
{
return(null);
}
return(ToJson(SUser.Convert(DataManager.Users.Authenticate(provider, id, name, lastName, image), HttpContext, culture)));
}
public ActionResult DeleteConfirmed(int id)
{
SUser sUser = db.SUsers.Find(id);
db.SUsers.Remove(sUser);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void Initialize()
{
App.Model.Scriptable.LanguageAsset languageAsset = Resources.Load("Language/Japanese/wordsasset") as App.Model.Scriptable.LanguageAsset;
Language.Reset(languageAsset.words);
SceneManager = new SceneManager();
SUser = new SUser();
SGacha = new SGacha();
SBattlefield = new SBattlefield();
}
public List <ZonaFl.Persistence.Entities.AspNetUsers> GetUsers()
{
List <ZonaFl.Persistence.Entities.AspNetUsers> users = new List <ZonaFl.Persistence.Entities.AspNetUsers>();
List <RegisterBindingModel> usersmodel = new List <RegisterBindingModel>();
SUser suser = new SUser();
users = suser.GetAllUsers();
return(users);
}
public ActionResult Signup([Bind(Include = "Id,Account,Name,Password")] SUser sUser)
{
if (ModelState.IsValid)
{
db.SUsers.Add(sUser);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View(sUser));
}
public ActionResult Edit([Bind(Include = "Id,Account,Name,Password")] SUser sUser)
{
if (ModelState.IsValid)
{
db.Entry(sUser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sUser));
}
public static void Initialize()
{
battleEvent = new BattleEvent();
sharpEvent = new SharpEvent();
battleManager = new Manager.BattleManager();
charactersManager = new Manager.BattleCharactersManager();
mapSearch = new TileMap();
aStar = new AStar();
AppManager = new AppManager();
SUser = new SUser();
}
public ContentResult Login()
{
ContentResult cr = new ContentResult();
string code = Request.Form["UserName"];
string pwd = Request.Form["Password"];
SUser user = uService.GetUserByCode(code).FirstOrDefault();
if (user != null)
{
if (user.Pwd.Equals(pwd.Trim()))
{
////客户端保存用户编码 微软自带的认证太复杂，本质就是cookie进行加密和解密
//HttpContext.Response.Cookies.Append(CookieConst.ESC_USR_UID, user.UserCode, new CookieOptions()
//{
// Expires = DateTimeOffset.Now.AddDays(7)
//});
var claims = new List <Claim>
{
new Claim("UserCode", user.UserCode),
new Claim("UserName", user.UserName),
new Claim("ID", user.ID.ToString()),
};
var claimsIdentity = new ClaimsIdentity(
claims, CookieAuthenticationDefaults.AuthenticationScheme);
var authProperties = new AuthenticationProperties
{
ExpiresUtc = DateTimeOffset.UtcNow.AddDays(7),
RedirectUri = "/Home/Index",
IsPersistent = true
};
HttpContext.SignInAsync(
CookieAuthenticationDefaults.AuthenticationScheme,
new ClaimsPrincipal(claimsIdentity),
authProperties).Wait();
cr.Content = "true" + user.UserName;
}
else
{
cr.Content = "用户密码错误!";
}
}
else
{
cr.Content = "用户不存在!";
}
return(cr);
}
// GET: SUsers/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SUser sUser = db.SUsers.Find(id);
if (sUser == null)
{
return(HttpNotFound());
}
return(View(sUser));
}
//檢查帳密
public bool CheckPw(string account, string password)
{
SUser user = db.SUsers.Where(x => x.Account == account && x.Password == password).SingleOrDefault();
if (user != null)
{
Session["user"] = user.Name;
return(true);
}
else
{
return(false);
}
}
public ResponseBase ChangePassword(int userId, string oldPass, string password)
{
ResponseBase rs = null;
try
{
using (var db = new IEDEntities())
{
rs = new ResponseBase();
SUser user = db.SUsers.FirstOrDefault(x => x.Id == userId && !x.IsDeleted);
if (user == null)
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "change pass", Message = "Tài Khoản đang thao tác không tồn tại. Vui lòng kiểm tra lại."
});
}
else
{
var old = GlobalFunction.EncryptMD5(oldPass);
if (user.PassWord.Equals(old))
{
user.IsRequireChangePW = true;
user.NoteForgotPassword = null;
user.IsForgotPassword = false;
user.PassWord = GlobalFunction.EncryptMD5(password);;
user.UpdatedUser = userId;
user.UpdatedDate = DateTime.Now;
db.SaveChanges();
rs.IsSuccess = true;
}
else
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "change pass", Message = "Mật khẩu cũ không đúng. Vui lòng kiểm tra lại."
});
}
}
}
}
catch (Exception ex)
{
//add Error
throw ex;
}
return(rs);
}
public static async Task <AuthentificatedUser> SignInAsync(IIdentity identity)
{
using (DatabaseContext dc = new DatabaseContext()) {
SUser user = await dc.Set <SUser>().AsNoTracking().Where(
u => u.UserStatusId == (int)User.UserStatusEnum.Approoved && u.SUserLogin.Any(ul => ul.Login == identity.Name && ul.ProviderName == identity.AuthenticationType)).FirstOrDefaultAsync();
if (user == null)
{
throw new AuthentificationException();
}
return(new AuthentificatedUser <int>(user.Id, user.FirstName + " " + user.LastName, "MY_OAUTH"));
}
}
