/// <summary>
/// 正常写日志；文件和数据库都写。
/// </summary>
/// <param name="logInfo"></param>
public void WriteLog(sys_log logInfo, LogMsgLevel logMsgLevel)
{
#region logInfo参数补充
if (logInfo == null)
{
logInfo = new sys_log();
}
logInfo.create_date = DateTime.Now;
logInfo.modify_date = logInfo.create_date;
logInfo.status = 0;
logInfo.local_ip = GetLocalIP();
logInfo.visitor_ip = GetClientIP();
#endregion
//log4net按配置等级来写文本日志
LogHelper.Write(JsonHelper.ToJson(logInfo), logMsgLevel);
//判断数据库日志级别，写数据库日志
var task = Task.Factory.StartNew(
() =>
{
try
{
logService.Add(logInfo);
}
catch (Exception ex)
{
LogHelper.Write("Famliy.Finance.BLL.LogBusiness.WriteLog() error.", ex);
}
});
}
public string InsertUseTransactionScope(bool success)
{
//插入数据，使用数据库事务，多连接时会命名用到MSDTC
using (TransactionScope trans = new TransactionScope())
{
try
{
var service1 = IoCHelper.Resolve <ICRUDService <sys_log> >();
sys_log e1 = new sys_log()
{
Id = GuidHelper.NewGuid().ToString(),
CreateDate = DateTime.Now
};
int i1 = service1.Insert(e1);
var service2 = IoCHelper.Resolve <ICRUDService <sys_file> >();
string id = success ? GuidHelper.NewGuid().ToString() : GuidHelper.NewGuid().ToString().PadRight(100, '0');
sys_file e2 = new sys_file()
{
Id = id,
CreateDate = DateTime.Now
};
int i2 = service2.Insert(e2);
trans.Complete();
return($"成功{i1},{i2}");
}
catch (Exception)
{
Transaction.Current.Rollback();
throw;
}
}
}
public async Task <ActionResult> _login(string username, string password)
{
sys_log logEntity = new sys_log();
logEntity.moduleName = "AuthenticationController - login";
logEntity.type = DbLogType.Login.ToString();
User dao = new User();
var resul = dao.Login(username);
MessageLogin systemMessage = new MessageLogin();
password = Encrypt.MD5Hash(password.Trim(), 16);
if (resul == null)
{
systemMessage.IsSuccess = false;
systemMessage.Message = SystemMessageConst.AccountNotExist;
logEntity.result = false;
logEntity.description = "Lỗi đăng nhập，" + systemMessage.Message;
}
else
{
if (resul.password != password)
{
systemMessage.IsSuccess = false;
systemMessage.Message = SystemMessageConst.PasswordNotCorrect;
logEntity.result = false;
logEntity.description = "Lỗi đăng nhập，" + systemMessage.Message;
}
else
{
var center = db.sys_center.FirstOrDefault(x => x.id == resul.id_center);
var department = db.sys_department.FirstOrDefault(x => x.id == resul.id_department);
var postion = db.sys_param.FirstOrDefault(x => x.code == resul.postion.ToString() && x.type == "Postion");
SessionUser sessionUser = new SessionUser();
sessionUser.id = resul.id;
sessionUser.username = resul.username;
sessionUser.avartar = resul.avartar;
sessionUser.id_center = resul.id_center;
sessionUser.name_center = center.name;
sessionUser.name_department = department.name;
sessionUser.fullname = resul.fullname;
Session["session"] = sessionUser;
systemMessage.IsSuccess = true;
systemMessage.Message = "/Home/Index";
logEntity.account = resul.username;
logEntity.result = true;
logEntity.description = "Đăng nhập thành công";
new LogApp().WriteDbLog(logEntity);
}
}
var t_result = await Task.FromResult(systemMessage);
return(Json(new
{
result = t_result
}, JsonRequestBehavior.AllowGet));
}
public void WriteDbLog(sys_log entiSysLog)
{
entiSysLog.date = DateTime.Now;
entiSysLog.account = Env.GetUserInfo("name");
entiSysLog.ipAddress = Common.Common.Net.Ip;
entiSysLog.creatorTime = DateTime.Now;
entiSysLog.creatorUserId = Convert.ToInt32(Env.GetUserInfo("userid"));
Insert(entiSysLog);
}
private sys_log builderSysLog(object message, string traceId, string uName, LogType logType, string title = null)
{
sys_log log = new sys_log();
log.LogType = (int)logType;
log.Content = LogMsg(message);
log.AppName = Const.SettingService.AppName;
log.Title = title;
log.Uname = uName;
log.TraceId = traceId;
return(log);
}
public void WriteLog(LogType logtype, string logmsg, LogState logstate)
{
sys_log log = new sys_log();
log.id = IdWorkerHelper.NewId();
log.operation = UserCookie.AccountName;
log.logtime = DateTime.Now;
log.logtype = logtype.ToString();
log.logmsg = logmsg;
log.loglevel = logstate.ToString();
log.logip = "127.0.0.1"; //TODO
Sqldb.Insertable(log).ExecuteCommand();
}
public void WriteLog(LogType logtype, string logmsg, LogState logstate)
{
sys_log log = new sys_log();
log.id = IdWorkerHelper.NewId();
log.operation = UserCookie.AccountName;
log.logtime = DateTime.Now;
log.logtype = logtype.ToString();
log.logmsg = logmsg;
log.loglevel = logstate.ToString();
log.logip = UserCookie.IP;
_syslogRepository.Insert(log);
}
public void WriteDbLog(bool result, string resultLog)
{
sys_log logEntity = new sys_log();
logEntity.id = Common.GuId();
logEntity.date = Common.ConvertToTimestamp(DateTime.Now);
// logEntity.account = Env.GetUserInfo("name");
logEntity.result = result;
logEntity.description = resultLog;
logEntity.ipAddress = Net.Ip;
logEntity.creatorTime = DateTime.Now;
// logEntity.creatorUserId = Convert.ToInt32(Env.GetUserInfo("userid"));
Insert(logEntity);
}
/// <summary>
/// 传递一个sys_log对象进行插入数据库
/// </summary>
/// <param name="sys_log"></param>
/// <returns></returns>
public static int saveLog(sys_log sys_log)
{
int iReturn = 0;
try
{
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
sys_log.createDate = System.DateTime.Now;
iReturn = db.Insertable(sys_log).ExecuteCommand();
}
catch (Exception ex) {
}
return(iReturn);
}
public static void Error(string ApplicationName, string FunctionName, string Detail)
{
using (sartas3 db = new sartas3())
{
sys_log l = new sys_log();
l.LogID = Guid.NewGuid().ToString();
l.ApplicationName = ApplicationName;
l.FunctionName = FunctionName;
l.Detail = Detail;
l.OpTime = DateTime.Now;
l.State = "异常";
db.sys_log.Add(l);
db.SaveChanges();
}
}
/// <summary>
/// 后台管理人员操作日志
/// </summary>
/// <param name="sys_log_ip"></param>
/// <param name="sys_log_content"></param>
/// <param name="sys_admin_name"></param>
public static void LogTxt(string sys_log_content, string sys_admin_name)
{
D8MallEntities db = new D8MallEntities();
sys_log log = new sys_log();
log.sys_log_id = Guid.NewGuid().ToString("N");
log.sys_log_ip = GetIP();
log.sys_log_name = "LOG" + DateTime.Now.ToFileTime().ToString();
log.sys_log_content = DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒") + sys_admin_name + sys_log_content;
log.sys_admin_id = sys_admin_name;
log.sys_log_adddate = DateTime.Now;
db.sys_log.Add(log);
db.SaveChanges();
}
public static void ReturnCheckRuleAndSaveLog(string typeLog, bool stutus, string data)
{
var entity = new DB_CSEntities1();
string controllerName = HttpContext.Current.Request.RequestContext.RouteData.Values["controller"].ToString();
var menu = entity.Menu.FirstOrDefault(m => m.MenuURL == controllerName);
if (menu != null)
{
sys_log logEntity = new sys_log();
logEntity.moduleName = controllerName;
logEntity.type = typeLog;
logEntity.result = stutus;
logEntity.description = data;
new LogApp().WriteDbLog(logEntity);
}
}
public override void OnActionExecuted(HttpActionExecutedContext actionExecutedContext)
{
//HttpContext.Current
if (HttpContext.Current.Session != null && HttpContext.Current.Session.Count > 0)
{
sys_log log = new sys_log()
{
IP = GetIp.getIp(),
UserName = HttpContext.Current.Session["UserName"].ToString(),
Target = Target,
Date = DateTime.Now
};
logFactory.CreatLogService().AddLog(log);
}
else
{
HttpContext.Current.Response.Redirect("/admin/error");
}
base.OnActionExecuted(actionExecutedContext);
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public dynamic AddLog(sys_log log)
{
try
{
//user.IsEnable = true;
db.BeginTransaction();
// var sql = String.Format(@"insert sys_role(RoleName,Description) values (@0,@1) ");
// int result = (int)db.Insert("sys_role", "role.RoleName,", role.RoleName, role.Description);
var result = (int)db.Insert(log);
db.CompleteTransaction();
return true;
}
catch (Exception)
{
return false;
}
return false;
}
public string Insert(bool success)
{
//插入数据
var service1 = IoCHelper.Resolve <ICRUDService <sys_log> >();
sys_log e1 = new sys_log()
{
Id = GuidHelper.NewGuid().ToString(),
CreateDate = DateTime.Now
};
int i1 = service1.Insert(e1);
var service2 = IoCHelper.Resolve <ICRUDService <sys_file> >();
string id = success ? GuidHelper.NewGuid().ToString() : GuidHelper.NewGuid().ToString().PadRight(100, '0');
sys_file e2 = new sys_file()
{
Id = id,
CreateDate = DateTime.Now
};
int i2 = service2.Insert(e2);
return($"成功{i1},{i2}");
}
public string InsertUseDbContextTransaction(bool success)
{
//插入数据，使用数据库事务，不支持多连接。
var dbContext = IoCHelper.Resolve <IDbContextCore>();
using (IDbContextTransaction trans = dbContext.BeginTransaction())
{
try
{
var service1 = IoCHelper.Resolve <ICRUDService <sys_log> >();
service1.Use(dbContext);
sys_log e1 = new sys_log()
{
Id = GuidHelper.NewGuid().ToString(),
CreateDate = DateTime.Now
};
int i1 = service1.Insert(e1);
var service2 = IoCHelper.Resolve <ICRUDService <sys_file> >();
service2.Use(dbContext);
string id = success ? GuidHelper.NewGuid().ToString() : GuidHelper.NewGuid().ToString().PadRight(100, '0');
sys_file e2 = new sys_file()
{
Id = id,
CreateDate = DateTime.Now
};
int i2 = service2.Insert(e2);
trans.Commit();
return($"成功{i1},{i2}");
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
}
public sys_log EntityFields <T>(T entity)
{
sys_log slog = new sys_log();
Dictionary <string, object> fields = new Dictionary <string, object>();
Type type = entity.GetType();
slog.tablename = type.Name;
PropertyInfo[] proinfos = type.GetProperties();
foreach (var item in proinfos)
{
string colname = string.Empty;
object colval = null;
var attrs = item.GetCustomAttributes(typeof(DbFieldAttribute));
if (attrs.Count() > 0)
{
DbFieldAttribute attr = attrs.First() as DbFieldAttribute;
colname = attr.FieldName;
colval = item.GetValue(entity);
fields.Add(colname, colval);
}
}
slog.fields = fields.Where(t => t.Value != null).ToDictionary(t => t.Key, t => t.Value);
StringBuilder cols = new StringBuilder();
StringBuilder vals = new StringBuilder();
slog.fields.ToList().ForEach(t => cols.Append(t.Key + ","));
slog.fields.ToList().ForEach(t => vals.Append($"'{t.Value}',"));
StringBuilder sql = new StringBuilder();
sql.Append("select ");
sql.Append(cols.ToString().Substring(0, cols.Length - 1));
sql.Append($" from {slog.tablename} where id = :id ");
slog.querysql = sql.ToString();
slog.insertsql = $"insert into {slog.tablename} ({cols.ToString().Substring(0, cols.Length - 1)}) values ({vals.ToString().Substring(0, vals.Length - 1)})";
return(slog);
}
/// <summary>
/// 退出
/// </summary>
/// <returns></returns>
public ActionResult LoginOut()
{
ILogFactory logFactory=new LogFactory();
sys_log log = new sys_log()
{
IP = GetIp.getIp(),
UserName = Session["UserName"].ToString(),
Target = "退出",
Date = DateTime.Now
};
logFactory.CreatLogService().AddLog(log);
Session.RemoveAll();
return RedirectToAction("index", "Home");
}
public returnR resetPsw(JObject userObj)
{
returnR r = new returnR();
r.code = (int)sysEnum.还没有执行;
if (userObj == null)
{
r.code = (int)sysEnum.参数必填;
return(r);
}
//这里执行
try
{
#region 判断用户
string userId = userObj["userId"].ToString();
if (string.IsNullOrEmpty(userId))
{
r.code = (int)sysEnum.参数必填;
r.msg = "userId必填";
return(r);
}
string pwd = userObj["psw"].ToString();
if (string.IsNullOrEmpty(pwd))
{
r.code = (int)sysEnum.参数必填;
r.msg = "用户密码必填";
return(r);
}
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
#endregion
sysLoginInCls si = public_method.getLoginInObject();
pwd = DES_En_De.UserMd5(pwd);//这里进行加密
int iReturn = db.Updateable <sys_user>()
.SetColumns(it => new sys_user()
{
pwd = pwd
,
updateUserId = si.loginUserId
,
updateDate = DateTime.Now
})
.Where(it => it.userId.ToString() == userId).ExecuteCommand();
if (iReturn > 0)
{
r.code = (int)sysEnum.操作成功;
r.msg = "重置密码成功";
#region //写日志
sys_log sys_log = new sys_log();
sys_log.logType = "重置";
sys_log.logText = "重置用户id[" + userId + "]密码成功";
sys_log.createUserId = si.loginUserId;
public_method.saveLog(sys_log);
#endregion
return(r);
}
else
{
r.code = (int)sysEnum.执行数据库失败;
r.msg = "重置密码失败";
return(r);
}
}
catch (Exception ex)
{
r.code = (int)sysEnum.发生异常;
r.msg = ex.Message;
}
return(r);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(sys_log log)
{
string connStr = string.Empty;
logService.Add(log);
}
public void ProcessRequest(HttpContext context)
{
SessionModel sm = new SessionModel();
string token = "";
string sid = "";
string sysuid = "0";
string sysflag = "";
string onecaruser = "******";
SysService.LogModel logmodel = new SysService.LogModel();
//写入操作日志
sys_log slog = new sys_log();
ResponseAppResult Result = null;
context.Response.ContentType = "text/plain";
try
{
Dictionary <string, string> inparams = GetParams(context);
if (inparams == null || inparams.Count == 0)
{
Result = new ResponseAppResult(ResState.ParamsImperfect, "参数错误！格式为JSON格式数据，详见服务接口文档。", null);
}
else
{
if (BaseParamsCheck(inparams, out Result))
{
if (inparams.ContainsKey("sysflag"))
{
inparams["sysflag"] = WebProc.GetAppSysflagKey(inparams["sysflag"]);
sysflag = inparams["sysflag"];
}
sid = inparams["sid"];
sysuid = inparams.Keys.Contains(sysuid) ? inparams["sysuid"] : "0";
logmodel.LogType = (int)SysService.LogType.LogTypeEnum.AppWebService;
AlarmProess ap = new AlarmProess();
AppProess app = new AppProess();
AppvdProess appvd = new AppvdProess();
ExtYQWL ey = new ExtYQWL();
switch (sid)
{
#region APP基本公共接口
case "app-car-getallonline":
Result = app.AppGetAllOnline(inparams);
break;
case "app-user-register":
Result = app.AppUserRegister(inparams);
break;
case "app-user-smscheckcode": //获取短信验证码
Result = app.AppSMSCode(inparams);
break;
case "app-user-login":
Result = app.AppUserLogin(inparams);
break;
case "app-user-login2":
Result = app.AppUserLogin2(inparams);
break;
case "app-user-changepwd":
Result = app.AppUserChangePwd(inparams);
break;
case "app-car-bind":
Result = app.AppUserCarBind(inparams); //用户车辆绑定
break;
case "app-user-update":
Result = app.AppUserUpdate(inparams);
break;
case "app-car-usercars":
Result = app.AppGetUserCars(inparams);
break;
case "app-car-seachusercars":
Result = app.AppSeachUserCars(inparams); //获取车辆列表
break;
case "app-car-unwrap":
Result = app.AppUnwrapUserCars(inparams);
break;
case "app-car-lasttrack":
Result = app.AppGetCarLastTrack(inparams);
break;
case "app-car-track":
Result = app.AppGetCarTrack(inparams);
break;
case "app-user-resetpwd": //重置密码
Result = app.AppUserResetPwd(inparams);
break;
case "app-car-seachforpages": //用户车辆检索 带分页
Result = app.AppSeachForPages(inparams);
break;
case "app-car-onlinecount": //用户车辆在线状态统计
Result = app.AppCarOnlineCount(inparams);
break;
#endregion
#region 报警器专用接口
case "alarm-car-track":
Result = ap.AlarmGetCarTrack(inparams);
break;
case "alarm-car-find":
Result = ap.AppSendFindCar(inparams);
break;
case "alarm-car-status":
Result = ap.AppGetCarStatues(inparams);
break;
case "alarm-car-remotecontrol":
Result = ap.AppSendControl(inparams);
break;
case "alarm-car-alertview":
Result = ap.AppGetAppAlarmAlert(inparams);
break;
case "alarm-obd-sendobddiagn":
Result = ap.AppSendOBDDiagn(inparams);
break;
case "alarm-obd-sendobddriver":
Result = ap.AppSendOBDDriver(inparams);
break;
case "alarm-obd-getobddiagn":
Result = ap.AppGetOBDDiagnResult(inparams);
break;
case "alarm-obd-getobddriver":
Result = ap.AppGetOBDDriverResult(inparams);
break;
#endregion
#region 外部专用接口
case "ext-yqwl-vinupload":
Result = ey.AppVINUpload(inparams);
break;
case "ext-yqwl-carowner":
Result = ey.AppGetCarInfoByCarno(inparams);
break;
#endregion
#region APP应用端接口
case "appvd-user-register": //用户注册
Result = appvd.AppvdUserRegister(inparams);
break;
case "appvd-user-login": //用户登录
Result = appvd.AppUserLogin(inparams);
break;
case "appvd-user-update": //用户修改信息
Result = appvd.AppvdUserUpdate(inparams);
break;
case "appvd-apk-version": //获取APK指定版本
Result = appvd.AppvdGetApkVersion(inparams);
break;
#endregion
}
}
else
{
Result = new ResponseAppResult(ResState.ParamsImperfect, "参数错误！参数不完整，详见服务接口文档。", null);
}
Result.sid = inparams.Keys.Contains("sid") ? inparams["sid"] : "";
Result.sequ = inparams.Keys.Contains("sequ") ? inparams["sequ"] : "";
//定位监控定时取最新轨迹不记录日志，因操作太频繁
if (sid != "" && !sid.Equals("alarm-car-lasttrack") && sysflag != "")
{
logmodel.SysFlag = sysflag;
logmodel.SysName = "AppService";
logmodel.UserId = Int32.Parse(sysuid);
if ((ResState)Result.state == ResState.Success)
{
logmodel.LogResult = "成功";
logmodel.LogContent = "操作成功";
}
else
{
logmodel.LogResult = "失败";
logmodel.LogContent = ((ResState)Result.state).ToString() + "-" + Result.msg;
}
logmodel.OneCarUser = onecaruser;
slog.WriteSysLog(logmodel);
}
}
}
catch (Exception ex)
{
LogHelper.WriteError("执行异常：", ex);
Result = new ResponseAppResult(ResState.OperationFailed, ex.Message, "");
//logmodel.LogContent = LogType.GetEnumName(LogType.LogTypeEnum.excepetion) + ex.Message;
if (!string.IsNullOrEmpty(sysuid))
{
logmodel.UserId = Int32.Parse(sysuid);
}
else
{
logmodel.UserId = -1;
}
logmodel.SysFlag = sysflag;
logmodel.SysName = "WebGISAppService";
logmodel.LogContent = ((ResState)Result.state).ToString() + "-" + ex.Message;
logmodel.LogResult = "失败";
logmodel.OneCarUser = onecaruser;
//slog.WriteSysLog(logmodel);
}
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd' 'HH':'mm':'ss";
Result.msg = Result.msg.Replace("\"", "");
string strRes = JsonConvert.SerializeObject(Result, timeConverter);
if (Result.state != 200)
{
LogHelper.WriteInfo("AppService Response:" + strRes);
}
context.Response.Write(strRes.Replace("null", "\"\""));
}
public void UpdateLog <T>(T entity, T orginalobj)
{
if (!islog)
{
return;
}
object id = 0;
StringBuilder txt = new StringBuilder();
sys_log slog = EntityFields <T>(entity);
slog.fields.TryGetValue("id", out id);
sys_user user = CacheManager.Instance().Current_User;
txt.Append($"[{user.name}]更新{slog.tablename},");
var cnames = slog.fields.Select(t => t.Key);
Type orgtype = orginalobj.GetType();
PropertyInfo[] orgproinfos = orgtype.GetProperties().Where(t => cnames.Contains(t.Name)).ToArray();
foreach (var item in orgproinfos)
{
string fn = string.Empty;
object fv = null;
object fvnew = null;
var orgattrs = item.GetCustomAttributes(typeof(DbFieldAttribute));
if (orgattrs.Count() > 0)
{
DbFieldAttribute attr = orgattrs.First() as DbFieldAttribute;
fn = attr.FieldName;
fv = item.GetValue(orginalobj);
string coltype = item.PropertyType.Name;
slog.fields.TryGetValue(fn, out fvnew);
switch (coltype)
{
case "Int32":
if (Convert.ToInt32(fv) != Convert.ToInt32(fvnew ?? 0))
{
txt.Append($"[{attr.Label}]:{fv}->{fvnew},");
}
break;
case "String":
if (fv.ToString() != (fvnew ?? "").ToString())
{
txt.Append($"[{attr.Label}]:{fv}->{fvnew},");
}
break;
case "DateTime":
if (Convert.ToDateTime(fv) != Convert.ToDateTime(fvnew))
{
txt.Append($"[{attr.Label}]:{fv}->{fvnew},");
}
break;
case "Double":
if (Convert.ToDouble(fv) != Convert.ToDouble(fvnew ?? 0))
{
txt.Append($"[{attr.Label}]:{fv}->{fvnew},");
}
break;
case "Float":
if (Convert.ToSingle(fv) != Convert.ToSingle(fvnew ?? 0))
{
txt.Append($"[{attr.Label}]:{fv}->{fvnew},");
}
break;
case "Decimal":
if (Convert.ToDecimal(fv) != Convert.ToDecimal(fvnew ?? 0))
{
txt.Append($"[{attr.Label}]:{fv}->{fvnew},");
}
break;
default:
break;
}
}
}
log.Info(txt.ToString());
}
public returnR userDel(JObject passJson)
{
returnR r = new returnR();
r.code = (int)sysEnum.还没有执行;
if (passJson == null)
{
r.code = (int)sysEnum.参数必填;
return(r);
}
//这里执行
try
{
sysLoginInCls si = public_method.getLoginInObject();
string userIdList = passJson["userIdList"].ToString();
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
string[] useridArray = userIdList.Split(',');
List <string> list = new List <string>();
for (int i = 0; i < useridArray.Length; i++)
{
list.Add(useridArray[i]);
}
int iReturn = db.Updateable <sys_user>()
.SetColumns(it => new sys_user()
{
flag = (int)sysEnum.数据被删除
, updateUserId = si.loginUserId
, updateDate = DateTime.Now
})
.Where(it => list.Contains(it.userId.ToString())).ExecuteCommand();
if (iReturn > 0)
{
r.code = (int)sysEnum.操作成功;
r.msg = "成功删除用户";
#region //写日志
sys_log sys_log = new sys_log();
sys_log.logType = "删除";
sys_log.logText = "删除用户id[" + userIdList + "]";
sys_log.createUserId = si.loginUserId;
public_method.saveLog(sys_log);
#endregion
return(r);
}
else
{
r.code = (int)sysEnum.执行数据库失败;
r.msg = "删除用户失败";
return(r);
}
}
catch (Exception ex)
{
r.code = (int)sysEnum.发生异常;
r.msg = ex.Message;
}
return(r);
}
private void Insert(sys_log entiSysLog)
{
db.Entry(entiSysLog).State = EntityState.Added;
db.SaveChanges();
}
public returnR userUpdate(JObject userObj)
{
returnR r = new returnR();
r.code = (int)sysEnum.还没有执行;
if (userObj == null)
{
r.code = (int)sysEnum.参数必填;
return(r);
}
//这里执行
try
{
#region 判断用户
string userId = userObj["userId"].ToString();
if (string.IsNullOrEmpty(userId))
{
r.code = (int)sysEnum.参数必填;
r.msg = "userId必填";
return(r);
}
string username = userObj["userName"].ToString();
if (string.IsNullOrEmpty(username))
{
r.code = (int)sysEnum.参数必填;
r.msg = "用户名称必填";
return(r);
}
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
var dataList = db.Queryable <sys_user>()
.Where(it => it.userName == username && it.flag == 1 && it.userId.ToString() != userId).ToList();
if (dataList.Count > 0)
{
r.code = (int)sysEnum.数据库中已经存在;
r.msg = "数据库中已存在[" + username + "]";
return(r);
}
#endregion
sysLoginInCls si = public_method.getLoginInObject();
string realName = userObj["realName"].ToString();
sys_user sys_user = new sys_user();
sys_user.userId = int.Parse(userId);
sys_user.userName = username;
sys_user.realName = realName;
sys_user.roleId = int.Parse(userObj["roleId"].ToString());
sys_user.dataRoleId = int.Parse(userObj["dataRoleId"].ToString());
sys_user.phone = userObj["phone"].ToString();
sys_user.email = userObj["email"].ToString();
sys_user.remarks = userObj["remarks"].ToString();
sys_user.updateUserId = si.loginUserId; //更新人
sys_user.updateDate = System.DateTime.Now; //更新时间
sys_user.flag = 1; //默认开启
//这里转换一下
int iReturn = db.Updateable(sys_user)
.IgnoreColumns(it => new { it.createDate, it.createUserId, it.pwd }).ExecuteCommand();
if (iReturn > 0)
{
r.code = (int)sysEnum.操作成功;
r.msg = "更新[" + username + "]成功";
#region //写日志
sys_log sys_log = new sys_log();
sys_log.logType = "更新";
sys_log.logText = Newtonsoft.Json.JsonConvert.SerializeObject(sys_user);
sys_log.createUserId = si.loginUserId;
public_method.saveLog(sys_log);
#endregion
return(r);
}
else
{
r.code = (int)sysEnum.执行数据库失败;
r.msg = "更新[" + username + "]失败";
return(r);
}
}
catch (Exception ex)
{
r.code = (int)sysEnum.发生异常;
r.msg = ex.Message;
}
return(r);
}
