public void SaveLoginInfo(hx_td_usrlogininfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into hx_td_usrlogininfo(");
strSql.Append("registerid,logintime,Loginusrname,loginusrpass,loginstate,loginIP,logincity,loginsource)");
strSql.Append(" values (");
strSql.Append("@registerid,@logintime,@Loginusrname,@loginusrpass,@loginstate,@loginIP,@logincity,@loginsource)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@registerid", SqlDbType.Int, 4),
new SqlParameter("@logintime", SqlDbType.DateTime),
new SqlParameter("@Loginusrname", SqlDbType.VarChar, 200),
new SqlParameter("@loginusrpass", SqlDbType.VarChar, 200),
new SqlParameter("@loginstate", SqlDbType.Int, 4),
new SqlParameter("@loginIP", SqlDbType.VarChar, 20),
new SqlParameter("@logincity", SqlDbType.VarChar, 200),
new SqlParameter("@loginsource", SqlDbType.Int, 4)
};
parameters[0].Value = model.registerid;
parameters[1].Value = model.logintime;
parameters[2].Value = model.Loginusrname;
parameters[3].Value = model.loginusrpass;
parameters[4].Value = model.loginstate;
parameters[5].Value = model.loginIP;
parameters[6].Value = model.logincity;
parameters[7].Value = model.loginsource;
object obj = DbHelper.GetSingle(strSql.ToString(), parameters);
}
public string LoginIN(string username, string userpassword, string Validatecode, int remember, bool realMobileUser = false)
{
string ip = Utils.GetRealIP();
string json = "";
B_member_table o = new B_member_table();
string strIdentify = "LoginValidateCode"; //随机字串存储键值，以便存储到Session中
var ts = true;
if (Settings.Instance.SiteDomain.IndexOf(PublicURL.NewPCUrl) >= 0)
{
ts = false;
}
if (realMobileUser || Session[strIdentify] != null)
{
if (realMobileUser && ts == false)
{
if (Session[strIdentify].ToString() != Validatecode)
{
json = @" {""rs"" : ""n"", ""error"" : ""验证码不对!""}";
return(json);
}
}
if (realMobileUser || Session[strIdentify].ToString() == Validatecode)
{
int userid = o.CheckLogin(username, userpassword);
if (userid > 0)
{
M_login mlogin = new M_login();
mlogin.userid = userid;
mlogin.username = username;
mlogin.codeno = Utils.SetSessioncode();
Utils.AddLoginCache(username, mlogin);
string sql = "update hx_member_table set lastlogintime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',lastloginIP='" + Utils.GetRealIP() + "' where registerid=" + userid.ToString();
LogInfo.WriteLog("登录信息更新" + sql);
DbHelperSQL.ExecuteSql(sql);
#region 登录成功
try
{
hx_td_usrlogininfo usrmode = new hx_td_usrlogininfo();
usrmode.logintime = DateTime.Now;
usrmode.Loginusrname = username;
usrmode.loginusrpass = "******";
usrmode.registerid = userid;
usrmode.loginIP = ip;
usrmode.logincity = GetIpToCity.GetAddressByIp(ip);
usrmode.loginsource = 1;
usrmode.loginstate = 0;
ef.hx_td_usrlogininfo.Add(usrmode);
int ie = ef.SaveChanges();
//登录发送1580奖励（活动时间:2017.1.9-1.24）
using (ChuanglitouP2P.BLL.EF.ActFacade actFacade = new ChuanglitouP2P.BLL.EF.ActFacade())
{
actFacade.LoginSendDKQ(userid);
}
}
catch (Exception tx)
{
throw (tx);
}
#endregion
var jmpUrl = DNTRequest.GetString("jmpUrl");
if (!string.IsNullOrEmpty(jmpUrl))
{
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rs = "y", url = jmpUrl }));
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rs = "y", url = "/" }));
}
else if (userid == -100)
{
#region 登录失败
try
{
hx_td_usrlogininfo usrmode = new hx_td_usrlogininfo();
usrmode.logintime = DateTime.Now;
usrmode.Loginusrname = username;
usrmode.loginusrpass = "******";
usrmode.registerid = userid;
usrmode.loginIP = ip;
usrmode.logincity = GetIpToCity.GetAddressByIp(ip);
usrmode.loginsource = 1;
usrmode.loginstate = 2;
ef.hx_td_usrlogininfo.Add(usrmode);
int ie = ef.SaveChanges();
}
catch { }
#endregion
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rs = "n", error = "禁止登录!" }));
}
else
{
#region 登录失败
try
{
hx_td_usrlogininfo usrmode = new hx_td_usrlogininfo();
usrmode.logintime = DateTime.Now;
usrmode.Loginusrname = username;
usrmode.loginusrpass = "******";
usrmode.registerid = userid;
usrmode.loginIP = ip;
usrmode.logincity = GetIpToCity.GetAddressByIp(ip);
usrmode.loginsource = 1;
usrmode.loginstate = 1;
ef.hx_td_usrlogininfo.Add(usrmode);
int ie = ef.SaveChanges();
}
catch { }
#endregion
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rs = "n", error = "用户名或密码错误!" }));
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rs = "n", error = "验证码不对!" }));
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rs = "n", error = "验证码过期!" }));
}
public string loginIn(string username, string userpassword, string Validatecode, int remember, bool realMobileUser = false)
{
string json = string.Empty;
B_member_table o = new B_member_table();
string strIdentify = "LoginValidateCode"; //随机字串存储键值，以便存储到Session中
string ip = Utils.GetRealIP();
if (realMobileUser || Session[strIdentify] != null)
{
if (!realMobileUser)
{
var ts = true;
if (Settings.Instance.SiteDomain.IndexOf(PublicURL.NewPCUrl) >= 0)
{
ts = false;
}
if (ts == false)
{
if (Session[strIdentify].ToString() != Validatecode)
{
json = @" {""rs"" : ""n"", ""error"" : ""验证码过期!""}";
return(json);
}
}
}
int userid = 0;
// int userid = o.CheckLogin(username, userpassword);
M_member_table mtb = o.CheckUsrLogin(username);
if (mtb == null)
{
json = @" {""rs"" : ""n"", ""error"" : ""该手机号未注册用户!""}";
return(json);
}
if (mtb.password != userpassword)
{
#region 登录失败
try
{
hx_td_usrlogininfo usrmode = new hx_td_usrlogininfo();
usrmode.logintime = DateTime.Now;
usrmode.Loginusrname = mtb.username;
usrmode.loginusrpass = "******";
usrmode.registerid = mtb.registerid;
usrmode.loginIP = ip;
usrmode.logincity = GetIpToCity.GetAddressByIp(ip);
usrmode.loginsource = 0;
usrmode.loginstate = 1;
ef.hx_td_usrlogininfo.Add(usrmode);
int ie = ef.SaveChanges();
}
catch { }
#endregion
json = @" {""rs"" : ""n"", ""error"" : ""用户名或密码错误!""}";
return(json);
}
userid = mtb.registerid;
if (userid > 0)
{
M_login mlogin = new M_login();
mlogin.userid = userid;
mlogin.username = username;
mlogin.codeno = Utils.SetSessioncode();
mlogin.UsrName = mtb.realname;
if (Utils.LoginWriteSession(mlogin, remember) > 0)
{
string sql = "update hx_member_table set LoginNum=LoginNum+1,lastlogintime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',lastloginIP='" + ip + "' where registerid=" + userid.ToString();
LogInfo.WriteLog("登录信息更新" + sql);
DbHelperSQL.ExecuteSql(sql);
#region 登录成功
try
{
hx_td_usrlogininfo usrmode = new hx_td_usrlogininfo();
usrmode.logintime = DateTime.Now;
usrmode.Loginusrname = mtb.username;
usrmode.loginusrpass = "******";
usrmode.registerid = mtb.registerid;
usrmode.loginIP = ip;
usrmode.logincity = GetIpToCity.GetAddressByIp(ip);
usrmode.loginsource = 0;
usrmode.loginstate = 0;
ef.hx_td_usrlogininfo.Add(usrmode);
int ie = ef.SaveChanges();
//登录发送1580奖励（活动时间:2017.1.9-1.24）
ActFacade actFacade = new ActFacade();
{
actFacade.LoginSendDKQ(userid);
}
}
catch (Exception tx)
{
throw (tx);
}
#endregion
if (realMobileUser)
{
json = @"{""rs"" : ""y"", ""url"" : ""/""}";
return(json);
}
if (Session["returnpage"] != null)
{
json = @"{""rs"" : ""y"", ""url"" : ""/""}";
json = json.Replace("/", Session["returnpage"].ToString());
Session["returnpage"] = null;
}
else
{
json = @" {""rs"" : ""y"", ""url"" : ""/""}";
}
return(json);
}
}
else if (userid == -100)
{
#region 登录失败
try
{
hx_td_usrlogininfo usrmode = new hx_td_usrlogininfo();
usrmode.logintime = DateTime.Now;
usrmode.Loginusrname = mtb.username;
usrmode.loginusrpass = "******";
usrmode.registerid = mtb.registerid;
usrmode.loginIP = ip;
usrmode.logincity = GetIpToCity.GetAddressByIp(ip);
usrmode.loginsource = 1;
usrmode.loginstate = 2;
ef.hx_td_usrlogininfo.Add(usrmode);
int ie = ef.SaveChanges();
}
catch { }
#endregion
json = @" {""rs"" : ""n"", ""error"" : ""禁止登录!""}";
return(json);
}
else
{
#region 登录失败
try
{
hx_td_usrlogininfo usrmode = new hx_td_usrlogininfo();
usrmode.logintime = DateTime.Now;
usrmode.Loginusrname = mtb.username;
usrmode.loginusrpass = "******";
usrmode.registerid = mtb.registerid;
usrmode.loginIP = ip;
usrmode.logincity = GetIpToCity.GetAddressByIp(ip);
usrmode.loginsource = 0;
usrmode.loginstate = 1;
ef.hx_td_usrlogininfo.Add(usrmode);
int ie = ef.SaveChanges();
}
catch { }
#endregion
json = @" {""rs"" : ""n"", ""error"" : ""用户名或密码错误!""}";
return(json);
}
}
else
{
json = @" {""rs"" : ""y"", ""error"" : ""验证码过期!""}";
}
return(json);
}
public ResultInfo <MemberEntity> Login(RequestParam <RequestLoginEntity> reqst)
{
//todo 添加登录验证代码
var ri = new ResultInfo <MemberEntity>("99999");
try
{
var un = reqst.body.userName.ToString();
var up = reqst.body.userPass.ToString();
if (string.IsNullOrEmpty(un))
{
ri.code = "1000000007";
}
else if (string.IsNullOrEmpty(up))
{
ri.code = "1000000008";
}
else
{
#region 验证用户名和密码是否正确
MemberEntity ent = _logic.SelectMemberEntityByName(un);
string pass = EncryptHelper.Encrypt(up);
if (ent != null && ent.password.ToLowerInvariant().Equals(pass.ToLowerInvariant()))
{
#region 登录成功
try
{
hx_td_usrlogininfo usrmode = new hx_td_usrlogininfo();
usrmode.logintime = DateTime.Now;
usrmode.Loginusrname = ent.username;
usrmode.loginusrpass = "******";
usrmode.registerid = ent.registerid;
usrmode.loginIP = Settings.Instance.ClientIp;
usrmode.logincity = GetIpToCity.GetAddressByIp(Settings.Instance.ClientIp);
if (reqst.header.appId != 123456)
{
usrmode.loginsource = 2;//安卓
}
else
{
usrmode.loginsource = 3;//ios
}
usrmode.loginstate = 0;
_logic.SaveLoginInfo(usrmode);
using (ActFacade actFacade = new ActFacade())
{
actFacade.SendBonusAfterLogin(ent.registerid.Value, Utils.GetDevicePlatformCode(reqst.header.appId.ToString()));
}
}
catch (Exception tx)
{
throw (tx);
}
#endregion
ri.code = "1";
ri.body = ent;
}
else
{
ri.code = "1000000009";
}
#endregion
}
ri.message = Settings.Instance.GetErrorMsg(ri.code);
return(ri);
}
catch (Exception ex)
{
LoggerHelper.Error(ex.ToString());
LoggerHelper.Error(JsonHelper.Entity2Json(reqst)); ri.code = "500";
ri.message = Settings.Instance.GetErrorMsg(ri.code);
return(ri);
}
}
/// <summary>
/// 保存用户登录信息
/// </summary>
/// <param name="usrmode"></param>
public void SaveLoginInfo(hx_td_usrlogininfo usrmode)
{
_dal.SaveLoginInfo(usrmode);
}
