public JsonResult Login(string username, string password) { try { tb_user_model user = Common.GetUser(username, password); if (null != user) { if (user == null) { return(Json(new { code = -1, message = "用户在平台中未开权限。" })); } FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(user.id + " " + user.username + " " + username + "," + "token" + " " + user.userrole, false, (int)FormsAuthentication.Timeout.TotalMinutes); string enticket = FormsAuthentication.Encrypt(ticket); HttpCookie cookieofau = new HttpCookie(FormsAuthentication.FormsCookieName, enticket); Response.AppendCookie(cookieofau); return(Json(new { code = 0, message = "登录成功!" })); } else { return(Json(new { code = -1, message = "用户在平台中未开权限。" })); } } catch (Exception exp) { return(Json(new { code = -1, message = "登陆出错,请咨询管理员。错误信息:" + exp.Message })); } }
public virtual bool Edit(DbConn PubConn, tb_user_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //用户工号 new ProcedureParameter("@userstaffno", model.userstaffno), //用户名 new ProcedureParameter("@username", model.username), //用户角色 new ProcedureParameter("@userrole", model.userrole), //用户创建时间 new ProcedureParameter("@usercreatetime", model.usercreatetime), //用户手机号码 new ProcedureParameter("@usertel", model.usertel), //用户email new ProcedureParameter("@useremail", model.useremail), //上一次错误发送时间 new ProcedureParameter("@lastsenderrortime", model.lastsenderrortime), //错误发送时间间隔(单位:分钟) new ProcedureParameter("@errorsendintervaltime", model.errorsendintervaltime) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_user set userstaffno=@userstaffno,username=@username,userrole=@userrole,usercreatetime=@usercreatetime,usertel=@usertel,useremail=@useremail,lastsenderrortime=@lastsenderrortime,errorsendintervaltime=@errorsendintervaltime where id=@id", Par); return(rev == 1); }
public virtual bool Add(DbConn PubConn, tb_user_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //用户工号 new ProcedureParameter("@userstaffno", model.userstaffno), //用户名 new ProcedureParameter("@username", model.username), //用户角色 new ProcedureParameter("@userrole", model.userrole), //用户创建时间 new ProcedureParameter("@usercreatetime", model.usercreatetime), //用户手机号码 new ProcedureParameter("@usertel", model.usertel), //用户email new ProcedureParameter("@useremail", model.useremail), //上一次错误发送时间 new ProcedureParameter("@lastsenderrortime", model.lastsenderrortime), //错误发送时间间隔(单位:分钟) new ProcedureParameter("@errorsendintervaltime", model.errorsendintervaltime) }; int rev = PubConn.ExecuteSql(@"insert into tb_user(userstaffno,username,userrole,usercreatetime,usertel,useremail,lastsenderrortime,errorsendintervaltime) values(@userstaffno,@username,@userrole,@usercreatetime,@usertel,@useremail,@lastsenderrortime,@errorsendintervaltime)" , Par); return(rev == 1); }
public virtual bool Edit(DbConn PubConn, tb_user_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //员工工号 new ProcedureParameter("@userstaffno", model.userstaffno), // new ProcedureParameter("@username", model.username), //员工角色,查看代码枚举:开发人员,管理员 new ProcedureParameter("@userrole", model.userrole), // new ProcedureParameter("@usercreatetime", model.usercreatetime), //员工手机号码 new ProcedureParameter("@usertel", model.usertel), // new ProcedureParameter("@useremail", model.useremail), //登录密码 new ProcedureParameter("@userpsw", model.userpsw) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_user set userstaffno=@userstaffno,username=@username,userrole=@userrole,usercreatetime=@usercreatetime,usertel=@usertel,useremail=@useremail,userpsw=@userpsw where id=@id", Par); return(rev == 1); }
public ActionResult Login(string appid, string sign, string returnurl, string username, string password, string validate) { try { returnurl = returnurl ?? ""; username = username ?? ""; password = password ?? ""; validate = validate ?? ""; ViewBag.username = username; XXF.BasicService.CertCenter.CertCenterProvider ccp = new XXF.BasicService.CertCenter.CertCenterProvider(XXF.BasicService.CertCenter.ServiceCertType.manage); if (!string.IsNullOrEmpty(appid)) { //外部授权 if (returnurl.Length < 2) { throw new Exception("returnurl错误!"); } string appsecret = ccp.GetAppSecret(appid); if (appsecret == "") { throw new Exception("appid不存在!"); } Dictionary <string, string> para = new Dictionary <string, string>();//需要参加签名的参数对 para.Add("appid", appid); para.Add("returnurl", returnurl); if (sign != GetSign(para, appsecret)) { throw new Exception("签名错误!"); } } AuthToken re = ccp.Login(username, password); if (re != null) { username = re.userid; #region 6写auth Cookie tb_user_model user = Common.GetUserName(username); if (user == null) { throw new Exception("用户在平台中未开权限。"); } FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(user.id + " " + user.username + "," + re.token + " " + user.userrole, false, (int)FormsAuthentication.Timeout.TotalMinutes); string enticket = FormsAuthentication.Encrypt(ticket); HttpCookie cookieofau = new HttpCookie(FormsAuthentication.FormsCookieName, enticket); Response.AppendCookie(cookieofau); #endregion return(RedirectToAction("index", "TimeWatchLogApiDayReport", new { userid = user.id })); } else { ModelState.AddModelError("", ccp.result.msg); return(View()); } } catch (Exception exp) { ModelState.AddModelError("", "登陆出错,请咨询管理员。错误信息:" + exp.Message); return(View()); } }
public ActionResult Login(string appid, string sign, string returnurl, string username, string password, string validate) { try { returnurl = returnurl ?? ""; username = username ?? ""; password = password ?? ""; validate = validate ?? ""; ViewBag.username = username; if (ConfigHelper.Configuration.GetValue <string>("LoginUser").Contains(";" + username.NullToEmpty() + "," + password.NullToEmpty() + ";")) { UserLoginInfo.CurrentUserLoginInfo = new UserLoginInfo() { UserName = username.NullToEmpty() }; } if (UserLoginInfo.CurrentUserLoginInfo != null) { #region 6写auth Cookie tb_user_model user = Common.GetUserName(username); if (user == null) { throw new Exception("用户已登陆,但该用户未在平台中开权限,请联系管理员添加。"); } UserLoginInfo.CurrentUserLoginInfo.UserModel = user; var claims = new List <Claim> { new Claim(ClaimTypes.Name, user.username), }; var claimsIdentity = new ClaimsIdentity( claims, CookieAuthenticationDefaults.AuthenticationScheme); HttpContext.SignInAsync( CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(claimsIdentity)); #endregion return(RedirectToAction("index", "Task", new { userid = user.id })); } else { ModelState.AddModelError("", "用户未登陆成功,请联系管理员在web.config中配置用户,并在平台后台开启权限"); return(View()); } } catch (Exception exp) { ModelState.AddModelError("", "登陆出错,请咨询管理员。错误信息:" + exp.Message); return(View()); } }
public virtual tb_user_model CreateModel(DataRow dr) { var o = new tb_user_model(); // if (dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } //用户工号 if (dr.Table.Columns.Contains("userstaffno")) { o.userstaffno = dr["userstaffno"].Tostring(); } //用户名 if (dr.Table.Columns.Contains("username")) { o.username = dr["username"].Tostring(); } //用户角色 if (dr.Table.Columns.Contains("userrole")) { o.userrole = dr["userrole"].ToByte(); } //用户创建时间 if (dr.Table.Columns.Contains("usercreatetime")) { o.usercreatetime = dr["usercreatetime"].ToDateTime(); } //用户手机号码 if (dr.Table.Columns.Contains("usertel")) { o.usertel = dr["usertel"].Tostring(); } //用户email if (dr.Table.Columns.Contains("useremail")) { o.useremail = dr["useremail"].Tostring(); } //上一次错误发送时间 if (dr.Table.Columns.Contains("lastsenderrortime")) { o.lastsenderrortime = dr["lastsenderrortime"].ToDateTime(); } //错误发送时间间隔(单位:分钟) if (dr.Table.Columns.Contains("errorsendintervaltime")) { o.errorsendintervaltime = dr["errorsendintervaltime"].Toint(); } return(o); }
public virtual tb_user_model CreateModel(DataRow dr) { var o = new tb_user_model(); // if (dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } //员工工号 if (dr.Table.Columns.Contains("userstaffno")) { o.userstaffno = dr["userstaffno"].Tostring(); } // if (dr.Table.Columns.Contains("username")) { o.username = dr["username"].Tostring(); } //员工角色,查看代码枚举:开发人员,管理员 if (dr.Table.Columns.Contains("userrole")) { o.userrole = dr["userrole"].ToByte(); } // if (dr.Table.Columns.Contains("usercreatetime")) { o.usercreatetime = dr["usercreatetime"].ToDateTime(); } //员工手机号码 if (dr.Table.Columns.Contains("usertel")) { o.usertel = dr["usertel"].Tostring(); } // if (dr.Table.Columns.Contains("useremail")) { o.useremail = dr["useremail"].Tostring(); } // if (dr.Table.Columns.Contains("userpsw")) { o.userpsw = dr["userpsw"].Tostring(); } return(o); }
public ActionResult Login(string appid, string sign, string returnurl, string username, string password, string validate) { try { returnurl = returnurl ?? ""; username = username ?? ""; password = password ?? ""; validate = validate ?? ""; ViewBag.username = username; if (System.Configuration.ConfigurationManager.AppSettings["LoginUser"].Contains(";" + username.NullToEmpty() + "," + password.NullToEmpty() + ";")) { UserLoginInfo.CurrentUserLoginInfo = new UserLoginInfo() { UserName = username.NullToEmpty() }; } if (UserLoginInfo.CurrentUserLoginInfo != null) { #region 6写auth Cookie tb_user_model user = Common.GetUserName(username); if (user == null) { throw new Exception("用户已登陆,但该用户未在平台中开权限,请联系管理员添加。"); } UserLoginInfo.CurrentUserLoginInfo.UserModel = user; #endregion return(RedirectToAction("index", "Task", new { userid = user.id })); } else { ModelState.AddModelError("", "用户未登陆成功,请联系管理员在web.config中配置用户,并在平台后台开启权限"); return(View()); } } catch (Exception exp) { ModelState.AddModelError("", "登陆出错,请咨询管理员。错误信息:" + exp.Message); return(View()); } }
public tb_user_model GetUserName(DbConn PubConn, string userstaffno) { return(SqlHelper.Visit(ps => { ps.Add("userstaffno", userstaffno); string sql = "select id,username,userrole from tb_user where userstaffno=@userstaffno"; DataSet ds = new DataSet(); PubConn.SqlToDataSet(ds, sql, ps.ToParameters()); if (ds.Tables[0].Rows.Count > 0) { tb_user_model m = CreateModel(ds.Tables[0].Rows[0]); return m; } else { return null; } })); }
public ActionResult Add(tb_user_model model) { using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); tb_user_dal dal = new tb_user_dal(); model.usercreatetime = DateTime.Now; model.lastsenderrortime = DateTime.Now; model.errorsendintervaltime = (model.errorsendintervaltime == 0?1:model.errorsendintervaltime); model.usertel = model.usertel.NullToEmpty(); model.useremail = model.useremail.NullToEmpty(); if (model.id == 0) { dal.Add(PubConn, model); } else { dal.Edit(PubConn, model); } } return(RedirectToAction("index")); }
public virtual bool Add(DbConn PubConn, tb_user_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { //员工工号 new ProcedureParameter("@userstaffno", model.userstaffno), // new ProcedureParameter("@username", model.username), //员工角色,查看代码枚举:开发人员,管理员 new ProcedureParameter("@userrole", model.userrole), // new ProcedureParameter("@usercreatetime", model.usercreatetime), //员工手机号码 new ProcedureParameter("@usertel", model.usertel), // new ProcedureParameter("@useremail", model.useremail) }; int rev = PubConn.ExecuteSql(@"insert into tb_user(userstaffno,username,userrole,usercreatetime,usertel,useremail) values(@userstaffno,@username,@userrole,@usercreatetime,@usertel,@useremail)" , Par); return(rev == 1); }
public ActionResult Add(tb_user_model model) { return(this.Visit(EnumUserRole.Admin, () => { using (DbConn PubConn = DbConn.CreateConn(Config.TaskConnectString)) { PubConn.Open(); tb_user_dal dal = new tb_user_dal(); model.usercreatetime = DateTime.Now; model.usertel = model.usertel.NullToEmpty(); model.useremail = model.useremail.NullToEmpty(); if (model.id == 0) { dal.Add(PubConn, model); } else { dal.Edit(PubConn, model); } } return RedirectToAction("index"); })); }
public ActionResult Login(string appid, string sign, string returnurl, string username, string password, string validate) { if (System.Configuration.ConfigurationManager.AppSettings["loginType"] == "1") { tb_user_model user = Common.GetUser(username, password); if (null != user) { if (user == null) { throw new Exception("用户在平台中未开权限。"); } FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(user.id + " " + user.username + " " + username + "," + "token" + " " + user.userrole, false, (int)FormsAuthentication.Timeout.TotalMinutes); string enticket = FormsAuthentication.Encrypt(ticket); HttpCookie cookieofau = new HttpCookie(FormsAuthentication.FormsCookieName, enticket); Response.AppendCookie(cookieofau); return(RedirectToAction("index", "Task", new { userid = user.id })); } } return(View()); //try //{ // returnurl = returnurl ?? ""; // username = username ?? ""; // password = password ?? ""; // validate = validate ?? ""; // ViewBag.username = username; // XXF.BasicService.CertCenter.CertCenterProvider ccp = new XXF.BasicService.CertCenter.CertCenterProvider(XXF.BasicService.CertCenter.ServiceCertType.manage); // if (!string.IsNullOrEmpty(appid)) // { //外部授权 // if (returnurl.Length < 2) // { // throw new Exception("returnurl错误!"); // } // string appsecret = ccp.GetAppSecret(appid); // if (appsecret == "") // { // throw new Exception("appid不存在!"); // } // Dictionary<string, string> para = new Dictionary<string, string>();//需要参加签名的参数对 // para.Add("appid", appid); // para.Add("returnurl", returnurl); // if (sign != Common.GetSign(para, appsecret)) // { // throw new Exception("签名错误!"); // } // } // AuthToken re = ccp.Login(username, password); // if (re != null) // { // username = re.userid; // #region 6写auth Cookie // tb_user_model user = Common.GetUserName(username); // if (user == null) // throw new Exception("用户在平台中未开权限。"); // FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(user.id + " " + user.username + " " + username + "," + re.token + " " + user.userrole, false, (int)FormsAuthentication.Timeout.TotalMinutes); // string enticket = FormsAuthentication.Encrypt(ticket); // HttpCookie cookieofau = new HttpCookie(FormsAuthentication.FormsCookieName, enticket); // Response.AppendCookie(cookieofau); // #endregion // return RedirectToAction("index", "Task", new { userid = user.id }); // } // else // { // ModelState.AddModelError("", ccp.result.msg); // return View(); // } //} //catch (Exception exp) //{ // ModelState.AddModelError("", "登陆出错,请咨询管理员。错误信息:" + exp.Message); // return View(); //} }