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