public SimpleResult UserTransaction([FromBody] UserTransaction param)
{
try
{
if (param == null)
{
return(new SimpleResult {
StatusCode = "000003", Content = "请求错误，请检查输入参数！"
});
}
if (string.IsNullOrEmpty(param.UserName))
{
return(new SimpleResult {
StatusCode = "000003", Content = "请求错误，业务操作用户输入不合法！"
});
}
LogIntoDb.Log(_dbLog, param.UserName, param.UserTransactionType.ToString(), param);
var theuser =
_db.USERS.FirstOrDefault(a => a.USERNAME == param.UserName);
if (theuser == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserName
});
}
if (theuser.DISABLED != true)
{
return(new SimpleResult {
StatusCode = "000014", Content = "用户已经停用"
});
}
if (theuser.PASSWORD != CdmEncrypt.Encrypt(param.Password))
{
return(new SimpleResult {
StatusCode = "000004", Content = "密码错误"
});
}
// Log.Info("UserTransaction input:" + JsonConvert.SerializeObject(param));
if (param.UserTransactionType == UserTransactionType.Login)
{
return(new SimpleResult
{
StatusCode = "000000",
Content = "ok",
Users =
{
new PoliceUser
{
AuthorityLevel = (AuthorityLevel)int.Parse(theuser.AUTHORITYLEVEL),
RealName = theuser.REALNAME,
CountyCode = theuser.COUNTYCODE,
Permission = JsonConvert.DeserializeObject <Dictionary <string, bool> >(theuser.LIMIT),
PoliceCode = theuser.POLICENUM
}
}
});
}
if (!PermissionCheck.CheckLevelPermission(param, theuser))
//if (!PermissionCheck.CheckLevelPermission(param, _db))
{
return(new SimpleResult {
StatusCode = "000007", Content = "没有权限"
});
}
var userslist = new List <PoliceUser>();
switch (param.UserTransactionType)
{
case UserTransactionType.Add:
var u = new USERS
{
AUTHORITYLEVEL = ((int)param.UserInfo.AuthorityLevel).ToString(),
COUNTYCODE = param.UserInfo.CountyCode,
LIMIT = JsonConvert.SerializeObject(param.UserInfo.Permission),
PASSWORD = CdmEncrypt.Encrypt("888888"),
POLICENUM = param.UserInfo.PoliceCode,
ID = new Random().Next(),
DEPARTMENT = " ff",
POST = param.UserInfo.UserRole.ToString(),
DISABLED = true,
USERNAME = param.UserInfo.UserName,
REALNAME = param.UserInfo.RealName,
};
_db.USERS.Add(u);
_db.SaveChanges();
break;
case UserTransactionType.Disable:
var disableuser =
_db.USERS.FirstOrDefault(a => a.USERNAME == param.UserInfo.UserName);
if (disableuser == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserInfo.UserName
});
}
disableuser.DISABLED = false;
_db.SaveChanges();
break;
case UserTransactionType.Update:
var userUpdate =
_db.USERS.FirstOrDefault(a => a.USERNAME == param.UserInfo.UserName);
if (userUpdate == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserInfo.UserName
});
}
userUpdate.REALNAME = param.UserInfo.RealName;
userUpdate.COUNTYCODE = param.UserInfo.CountyCode;
userUpdate.POST = ((int)param.UserInfo.UserRole).ToString();
userUpdate.AUTHORITYLEVEL = ((int)param.UserInfo.AuthorityLevel).ToString();
userUpdate.LIMIT = JsonConvert.SerializeObject(param.UserInfo.Permission);
_db.SaveChanges();
break;
case UserTransactionType.ChangePass:
var userPu =
_db.USERS.FirstOrDefault(a => a.USERNAME == param.UserInfo.UserName);
if (userPu == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserInfo.UserName
});
}
userPu.PASSWORD = CdmEncrypt.Encrypt(param.UserInfo.Password);
_db.SaveChanges();
break;
case UserTransactionType.ResetPass:
var rpUser =
_db.USERS.FirstOrDefault(a => a.USERNAME == param.UserInfo.UserName);
if (rpUser == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserInfo.UserName
});
}
rpUser.PASSWORD = CdmEncrypt.Encrypt("888888");
_db.SaveChanges();
break;
//case UserTransactionType.GetUserList:
// using (var userdb = new UserDbc())
// {
// var theuser =
// userdb.USERS.Where(a => a.COUNTYCODE == param.UserInfo.CountyCode);
// userslist.AddRange(theuser.Select(users => new PoliceUser
// {
// // AuthorityLevel = (AuthorityLevel) int.Parse(users.AUTHORITYLEVEL),
// CountyCode = users.COUNTYCODE,
// Notation = string.Empty,
// // Permission = JsonConvert.DeserializeObject<Dictionary<string, bool>>(users.LIMIT),
// PoliceCode = users.POLICENUM,
// RealName = users.REALNAME,
// UserName = users.USERNAME,
// // UserRole = (UserRole) int.Parse(users.POST)
// }));
// }
// return new SimpleResult { StatusCode = "000000", Content = "", Users = userslist };
// break;
//default:// for test
case UserTransactionType.GetUserList:
var getuser =
_db.USERS.Where(a => a.COUNTYCODE == param.UserInfo.CountyCode);
foreach (USERS users in getuser)
{
var pu = new PoliceUser();
// Log.InfoFormat("from db:{0}", users.LIMIT);
pu.Permission = JsonConvert.DeserializeObject <Dictionary <string, bool> >(users.LIMIT);
pu.CountyCode = users.COUNTYCODE;
pu.Notation = string.Empty;
pu.PoliceCode = users.POLICENUM;
pu.RealName = users.REALNAME;
pu.UserName = users.USERNAME;
pu.Disabled = users.DISABLED;
pu.AuthorityLevel = (AuthorityLevel)int.Parse(users.AUTHORITYLEVEL);
userslist.Add(pu);
}
//userslist.AddRange(theuser.Select(users => new PoliceUser
//{
// // AuthorityLevel = (AuthorityLevel) int.Parse(users.AUTHORITYLEVEL),
// CountyCode = users.COUNTYCODE,
// Notation = string.Empty,
// Permission = JsonConvert.DeserializeObject<Dictionary<string, bool>>(users.LIMIT),
// PoliceCode = users.POLICENUM,
// RealName = users.REALNAME,
// UserName = users.USERNAME,
// // UserRole = (UserRole) int.Parse(users.POST)
//}));
// Task.Run( () => LogIntoDb.Log(_dbLog, param.UserName, DateTime.Now, param.UserTransactionType.ToString(), JsonConvert.SerializeObject(param)));
// LogIntoDb.Log(_dbLog, param.UserName, param.UserTransactionType.ToString(), param);
return(new SimpleResult {
StatusCode = "000000", Content = "", Users = userslist
});
break;
}
// Log.Info("before ok----------------");
// LogIntoDb.Log(_dbLog, param.UserName,param.UserTransactionType.ToString(), param);
return(new SimpleResult {
StatusCode = "000000", Content = "ok"
});
}
catch (DbEntityValidationException e)
{
var err = string.Empty;
foreach (var eve in e.EntityValidationErrors)
{
var err1 =
string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
err += err1;
Log.InfoFormat(err1);
foreach (var ve in eve.ValidationErrors)
{
var err2 = string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
Log.InfoFormat(err2);
err += err2;
}
}
return(new SimpleResult {
StatusCode = "000003", Content = "DbEntityValidationException:" + err
});
}
catch (EntityDataSourceValidationException ex)
{
Log.Error("EntityDataSourceValidationException", ex);
return(new SimpleResult {
StatusCode = "000003", Content = "EntityDataSourceValidationException:" + ex.Message
});
}
catch (OracleException ex)
{
Log.Error("OracleException", ex);
return(new SimpleResult {
StatusCode = "000003", Content = "OracleException:" + ex.Message
});
}
catch (DbUpdateException ex)
{
Log.Error("DbUpdateException", ex);
return(new SimpleResult {
StatusCode = "000003", Content = "DbUpdateException:" + (ex.ToString().Contains("违反唯一约束条件 (CITY.USERSNAME)") ? "用户名已经存在" : ex.ToString())
});
}
catch (Exception ex)
{
Log.Error("UserTransaction", ex);
return(new SimpleResult {
StatusCode = "000003", Content = ex.Message
});
}
}
public UserTransaction()
{
UserInfo = new PoliceUser();
}
