using MyGlassEdit.ng.optima.model;
|
using MyGlassEdit.ng.optima.util;
|
using Newtonsoft.Json;
|
using ng.optima.config;
|
using ng.optima.server;
|
using ng.optima.util;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace MyGlassEdit.ng.optima.server
|
{
|
public static class AdminDB
|
{
|
public static bool AdminLogin(string uName,string uPwd) {
|
string str = string.Format(@"Select * from optimize_admin where login_name ='{0}' and password ='{1}'", uName, uPwd);
|
DataTable dataTable = MySqlDbHelper.SelectForTable(str);
|
if (dataTable == null || dataTable.Rows.Count <= 0) {
|
|
return false;
|
}
|
|
List<AdminModel> adminModel = DataTableUtil.ToModel<AdminModel>(dataTable);
|
if (adminModel.Count > 1) {
|
return false;
|
}
|
|
AdminModel admin = adminModel[0];
|
admin.login_num++;
|
admin.last_login_time = DateTime.Now;//.ToString("yyyy-MM-dd HH:mm:ss");
|
|
LoginAdminInfo.id = admin.Id;
|
LoginAdminInfo.name = admin.name;
|
LoginAdminInfo.login_name = admin.login_name;
|
LoginAdminInfo.limits = admin.limits;
|
LoginAdminInfo.login_num = admin.login_num;
|
LoginAdminInfo.o_id = admin.o_id;
|
LoginAdminInfo.h_id = admin.h_id;
|
LoginAdminInfo.m_id = admin.m_id;
|
LoginAdminInfo.password = admin.password;
|
LoginAdminInfo.last_login_time = admin.last_login_time;
|
LoginAdminInfo.last_login_ip = SystemUtil.GetSystemIP();
|
LoginAdminInfo.last_logout_time = admin.last_logout_time;
|
|
//获取用户钢化的配置
|
//ConfigDB.GetAdminConfig(1,LoginAdminInfo.h_id);
|
//获取用户打标的配置
|
//ConfigDB.GetAdminConfig(2,LoginAdminInfo.m_id);
|
//获取用户系统的配置
|
//ConfigDB.GetAdminConfig(3,LoginAdminInfo.o_id);
|
|
SystemConfig.ReadSet();
|
OptimaConfig.OptimaConfigRead();
|
|
return UpdateAdminInfo();
|
}
|
|
|
/// <summary>
|
/// 更新用户信息
|
/// </summary>
|
/// <returns></returns>
|
public static bool UpdateAdminInfo() {
|
StringBuilder sql = new StringBuilder();
|
sql.Append("update optimize_admin set");
|
sql.AppendFormat(" login_name = '{0}',",LoginAdminInfo.login_name);
|
sql.AppendFormat(" password = '{0}',",LoginAdminInfo.password);
|
sql.AppendFormat(" m_id = '{0}',",LoginAdminInfo.m_id);
|
sql.AppendFormat(" h_id='{0}',", LoginAdminInfo.h_id);
|
sql.AppendFormat(" o_id = '{0}',", LoginAdminInfo.o_id);
|
sql.AppendFormat(" login_num = '{0}',", LoginAdminInfo.login_num);
|
sql.AppendFormat(" last_login_ip = '{0}',", LoginAdminInfo.last_login_ip);
|
sql.AppendFormat(" last_login_time = '{0}',",LoginAdminInfo.last_login_time);
|
sql.AppendFormat(" last_logout_time = '{0}'",LoginAdminInfo.last_logout_time);
|
sql.AppendFormat(" where Id = '{0}'", LoginAdminInfo.id);
|
return MySqlDbHelper.Update(sql.ToString());
|
}
|
|
|
public static bool UpdateAdminLoginInfo() {
|
|
|
|
|
return false;
|
|
}
|
|
}
|
}
|
