/// <summary>
/// 写登录日志
/// </summary>
public static void SaveLoginLog(SYS_LOGIN_LOG log)
{
CommonDAL commonbll = new CommonDAL();
//写数据库
SYS_LOGIN_LOG loginfo = new SYS_LOGIN_LOG();
commonbll.Add(log, false);
//写登陆日志
//string path = System.Configuration.ConfigurationManager.AppSettings["LoginLogPath"].ToString();
//string file = Path.Combine(path, string.Format("{0:yyyy-MM-dd}", DateTime.Now) + ".txt");
//if (!Directory.Exists(path))
//{
// DirectoryInfo d = Directory.CreateDirectory(path);
//}
//if (!File.Exists(file))
//{
// FileStream stream = File.Create(file);
// stream.Close();
//}
//FileInfo fi = new FileInfo(file);
//using (StreamWriter sw = fi.AppendText())
//{
// string str = "IP地址为XXX的XXX用户在" + DateTime.Now.ToShortTimeString() + "登录" + log.IsOK;
// sw.WriteLine(str);
// sw.Flush();
//}
}
////// <summary>
////// 分页查询
////// </summary>
////// <param name="pageIndex"></param>
////// <param name="pageSize"></param>
////// <param name="whLamdba"></param>
////// <param name="recordCount"></param>
////// <param name="pageCount"></param>
////// <returns></returns>
///public List<SYS_LOGIN_LOG> PageQuery<TKey>(int pageIndex, int pageSize, Expression<Func<SYS_LOGIN_LOG, bool>> whLamdba,Expression<Func<SYS_LOGIN_LOG, TKey>> orderByLamdba, out int recordCount, out int pageCount)
///{
/// List<SYS_LOGIN_LOG> list = null;
/// try
/// {
/// if (pageIndex == 0)
/// {
/// pageIndex = 1;
/// }
/// list = idal.PageQuery(pageIndex, pageSize, out recordCount, out pageCount, whLamdba, orderByLamdba);
/// }
/// catch (Exception ex)
/// {
/// recordCount = 0;
/// pageCount = 0;
/// Logger.Error(string.Format("SYS_LOGIN_LOG_BLL 分页查询异常，异常信息：{0}", ex.ToString()));
/// }
/// return list;
///}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="modle"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public DataTable PageQuery(SYS_LOGIN_LOG modle, int pageIndex, int pageSize, out int recordCount, out int pageCount)
{
DataTable dt = new DataTable();
using (var dbcontext = DbFactory.Create())
{
try
{
SearchCondition condition = new SearchCondition();
if (modle != null)
{
#region 组装查询条件
//if (!string.IsNullOrWhiteSpace(modle.PlayerNickname))
//{
// condition.AddCondition("a.PlayerNickname", modle.PlayerNickname, SqlOperator.Like, true);
//}
#endregion
}
PagerInfo pager = new PagerInfo();
#region 组装存储过程调用参数
//pager.curPage = pageIndex;
//pager.pageSize = pageSize;
//pager.isDescending = true;
//pager.fields = "a.*,c.GameName";
//pager.sortField = "a.UploadTime";
//pager.indexField = "a.ID";
//pager.where = null;
//pager.condition = condition;
//pager.tableName = "[ZhpGame].[dbo].[Zhp_GameRecord] a left join [Zhp_OnlineGame] b on a.Gameid=b.Gameid left join [Zhp_GameConfig] c on b.GameCode= c.GameCode ";
#endregion
dt = dbcontext.PageQuery(pager, out recordCount, out pageCount);
}
catch (Exception ex)
{
recordCount = 0;
pageCount = 0;
Logger.Error(string.Format("SYS_LOGIN_LOG_BLL 分页查询异常，异常信息：{0}", ex.ToString()));
}
}
return(dt);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="pkId">主键</param>
/// <returns></returns>
public SYS_LOGIN_LOG GetById(string pkId)
{
SYS_LOGIN_LOG model = null;
using (var dbcontext = DbFactory.Create())
{
try
{
int id = Convert.ToInt32(pkId);
Expression <Func <SYS_LOGIN_LOG, bool> > exp = a => a.ID == id;
model = dbcontext.Get(exp);
}
catch (Exception ex)
{
Logger.Error(string.Format("SYS_LOGIN_LOG_BLL 根据主键获取实体异常,异常信息:{0}", ex.ToString()));
}
}
return(model);
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="model">新实体</param>
/// <returns></returns>
public bool Edit(SYS_LOGIN_LOG model)
{
bool success = false;
using (var dbcontext = DbFactory.Create())
{
try
{
dbcontext.Update(model);
dbcontext.Save();
success = true;
}
catch (Exception ex)
{
success = false;
Logger.Error(string.Format("SYS_LOGIN_LOG_BLL 编辑记录异常,异常信息:{0}", ex.ToString()));
}
}
return(success);
}
/// <summary>
/// 根据条件获取列表
/// </summary>
/// <param name="querymodel">条件</param>
/// <returns></returns>
public List <SYS_LOGIN_LOG> GetList(SYS_LOGIN_LOG querymodel)
{
List <SYS_LOGIN_LOG> list = null;
using (var dbcontext = DbFactory.Create())
{
try
{
int id = Convert.ToInt32(querymodel.ID);
Expression <Func <SYS_LOGIN_LOG, bool> > exp = a => a.ID == id;
Expression <Func <SYS_LOGIN_LOG, bool> > temp = a => 1 == 1;
exp = CompileLinqSearch.AndAlso(exp, temp);
list = dbcontext.Find(exp);
}
catch (Exception ex)
{
Logger.Error(string.Format("SYS_LOGIN_LOG_BLL 根据条件获取列表异常,异常信息:{0}", ex.ToString()));
}
}
return(list);
}
public ActionResult Login(LoginViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
SYS_LOGIN_LOG sys_login_log = new SYS_LOGIN_LOG();
//登录日志对象赋值
sys_login_log.LOGIN_TIME = System.DateTime.Now; // 登录时间
sys_login_log.SYS_USER_ID = model.username.Trim(); // userAccount.Value; // 用户名
sys_login_log.LOGINIP = Request.UserHostAddress; // 用户 ip
if (Session["CheckCode"] != null)
{
#region 验证录入项
string code = Session["CheckCode"].ToString();
string errMsg = "";
if (!code.ToUpper().Equals(model.code.Trim().ToUpper()))//验证码错误
{
errMsg += "验证码不正确！\\n";
errorInfo += "验证码不正确";
Response.Write("<script>alert('验证码不正确!')</script>");
return(View(model));
}
#endregion
#region 登录
try
{
string account = model.username.Trim();
StringHelper stringHelper = new StringHelper();
string pwd = stringHelper.ToMD5(model.password.Trim()); // 数据库存储的是加密过后的数据
// Response.Write("<script>alert('"+ pwd + "')</script>");
string sql = "select * from USERINFO where username='******'";
CommonBLL combll = new CommonBLL();
DataTable dt = combll.ExecuteTable(sql);
if (dt.Rows.Count == 0)
{
Response.Write("<script>alert('用户不存在!!')</script>");
errorInfo += ". 用户不存在";
sys_login_log.IS_SUCCESS = "用户不存在";
LogM.SaveLoginLog(sys_login_log);
return(Content("用户不存在"));
}
if (dt.Rows[0]["password"].ToString() != pwd)
{
Response.Write("<script>alert('用户名或密码错误!')</script>");
errorInfo += ". 密码错误！";
sys_login_log.IS_SUCCESS = "密码错误";
LogM.SaveLoginLog(sys_login_log);
return(Content("密码错误"));;
}
sys_login_log.IS_SUCCESS = "登录成功";
LogM.SaveLoginLog(sys_login_log);
//登陆成功，跳转到主页
return(Content("login success"));
//RedirectToAction("Index");
}
catch (Exception e1)
{
try
{
/*登录失败：记录登录失败日志*/
errorInfo += ". 服务器数据库异常->";
errorInfo += e1.Message;
sys_login_log.IS_SUCCESS = errorInfo;
LogM.SaveLoginLog(sys_login_log);
}
catch { }
}
#endregion
}
return(Content("loginning"));
}