/// <summary> /// 新增用户 /// </summary> /// <param name="userDto"></param> /// <returns></returns> public bool InsertUser(UserDto userDto) { try { _sysUserRepository.BeginTran();//开始事务 SysUser User = new SysUser(); User.Id = IdWorkerHelper.NewId(); User.Account = userDto.Account; User.Password = DESEncrypt.Encrypt(userDto.Password); User.RealName = userDto.RealName; User.Gender = userDto.Gender; User.DepartmentId = userDto.DepartmentId; User.Birthday = userDto.Birthday; User.Portrait = userDto.Portrait; User.Email = userDto.Email; User.Phone = userDto.Phone; User.Remark = userDto.Remark; User.Status = (int)StatusType.Enabled; User.IsDeleted = (int)IsDeletedType.No; User.CreateTime = DateTime.Now; User.CreateUserId = _userHelper.Id; User.ModifyTime = DateTime.Now; User.ModifyUserId = _userHelper.Id; bool result = _sysUserRepository.Insert(User); _sysUserRepository.CommitTran(); return(result); } catch (Exception ex) { _sysUserRepository.RollbackTran();//回滚事务 throw ex; } }
public void AddMenu(sys_menu dto, string funcs) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = "admin"; if (!string.IsNullOrEmpty(dto.menu_url)) { dto.menu_type = 1; } if (dto.parent_id == 0) { dto.menu_level = 1; } else { dto.menu_level = _sysmenuRepository.Queryable <sys_menu>().Where(s => s.id == dto.parent_id).Select(s => s.menu_level).First() + 1; } _sysmenuRepository.Insert(dto); if (!string.IsNullOrEmpty(funcs)) { var funcArray = funcs.Split(','); if (funcArray.Length > 0) { var list = new List <sys_menu_ref_operate>(); foreach (var func in funcArray) { var funcModel = new sys_menu_ref_operate(); funcModel.menu_id = dto.id; funcModel.operate_id = func.ToInt64(); list.Add(funcModel); } _sysmenurefoperateRepository.InsertRange(list); } } }
public void SaveRoleAuth(string roleId, string ids) { Sqldb.Deleteable <sys_role_authorize>().Where(s => s.role_id == SqlFunc.ToInt64(roleId)).ExecuteCommand(); if (!string.IsNullOrEmpty(ids)) { var list = new List <sys_role_authorize>(); var menuIds = ids.ToObject <List <ZtreeDto> >(); foreach (var mid in menuIds) { mid.pId = mid.pId ?? "0"; var model = new sys_role_authorize(); model.id = IdWorkerHelper.NewId(); model.role_id = roleId.ToInt64(); model.menu_id = mid.id.ToInt64(); model.menu_pid = mid.pId.ToInt64(); model.create_time = DateTime.Now; model.create_person = UserCookie.AccountName; list.Add(model); } if (list.Any()) { Sqldb.Insertable(list).ExecuteCommand(); } } }
/// <summary> /// 修改Demo(异步) /// </summary> /// <param name="Name"></param> /// <param name="Sex"></param> /// <param name="Age"></param> /// <param name="Remark"></param> /// <returns></returns> public async Task <bool> InsertDemoAsync(string Name, string Sex, int Age, string Remark) { try { _testRepository.BeginTran();//开始事务 var result = false; long Id = IdWorkerHelper.NewId(); string sql = "INSERT INTO Demo(Id,Name,Sex,Age,Remark) VALUES(@Id,@Name,@Sex,@Age,@Remark)"; SugarParameter[] Parameter = new SugarParameter[] { new SugarParameter("@Id", Id), new SugarParameter("@Name", Name), new SugarParameter("@Sex", Sex), new SugarParameter("@Age", Age), new SugarParameter("@Remark", Remark) }; result = await _testRepository.ExecuteSqlAsync(sql, Parameter); _testRepository.CommitTran();//提交事务 return(result); } catch (Exception ex) { _testRepository.RollbackTran();//回滚事务 throw ex; } }
/// <summary> /// 添加Demo /// </summary> /// <param name="Name"></param> /// <param name="Sex"></param> /// <param name="Age"></param> /// <param name="Remark"></param> /// <returns></returns> public ResultModel <bool> InsertDemo(string Name, string Sex, int Age, string Remark) { var result = new ResultModel <bool>(); try { _demoRepository.BeginTran(); //开始事务 long Id = IdWorkerHelper.NewId(); string sql = "insert into Demo(Id,Name,Sex,Age,Remark) values(@Id,@Name,@Sex,@Age,@Remark)"; SugarParameter[] Parameter = new SugarParameter[] { new SugarParameter("@Id", Id), new SugarParameter("@Name", Name), new SugarParameter("@Sex", Sex), new SugarParameter("@Age", Age), new SugarParameter("@Remark", Remark) }; result.Data = _demoRepository.ExecuteSql(sql, Parameter); _demoRepository.CommitTran();//提交事务 return(result); } catch (Exception ex) { _demoRepository.RollbackTran();//回滚事务 throw ex; } }
/// <summary> /// 新增 /// </summary> /// <param name="dto"></param> public void InsertRoleData(sys_role dto, LoginUserDto UserCookie) { dto.role_code = dto.role_code ?? string.Empty; dto.id = IdWorkerHelper.NewId(); dto.create_person = UserCookie.AccountName; dto.create_time = DateTime.Now; Sqldb.Insert(dto).ExecuteAffrows(); }
public void InsertRoleData(sys_role dto) { dto.role_code = dto.role_code ?? string.Empty; dto.id = IdWorkerHelper.NewId(); dto.create_person = UserCookie.AccountName; dto.create_time = DateTime.Now; _sysroleRepository.Insert(dto); }
public void InsertRoleData(sys_role dto) { dto.role_code = dto.role_code ?? string.Empty; dto.id = IdWorkerHelper.NewId(); dto.create_person = UserCookie.AccountName; dto.create_time = DateTime.Now; Sqldb.Insertable(dto).ExecuteCommand(); }
public void InsertFunc(sys_operate dto) { dto.id = IdWorkerHelper.NewId(); dto.func_icon = dto.func_icon ?? "tag"; dto.func_class = dto.func_class ?? "btn-blue"; dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; Sqldb.Insertable(dto).ExecuteCommand(); }
public void InsertFunc(sys_operate dto) { dto.id = IdWorkerHelper.NewId(); dto.func_icon = dto.func_icon ?? "tag"; dto.func_class = dto.func_class ?? "btn-blue"; dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; _sysfuncRepository.Insert(dto); }
public void InsertData(sys_user dto) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; dto.fax = dto.fax ?? string.Empty; dto.email = dto.email ?? string.Empty; dto.mobile_phone = dto.mobile_phone ?? string.Empty; Sqldb.Insertable(dto).ExecuteCommand(); }
public void InsertData(sys_user dto) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; dto.fax = dto.fax ?? string.Empty; dto.email = dto.email ?? string.Empty; dto.mobile_phone = dto.mobile_phone ?? string.Empty; _sysuserRepository.Insert(dto); }
public void InsertData(demo dto) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; dto.name = dto.name ?? string.Empty; dto.sex = dto.sex ?? string.Empty; dto.age = dto.age; dto.remark = dto.remark ?? string.Empty; Sqldb.Insertable(dto).ExecuteCommand(); }
public void InsertAreaData(sys_area dto) { dto.id = IdWorkerHelper.NewId(); dto.zipcode = dto.zipcode; dto.name = dto.name; dto.name = dto.name ?? string.Empty; dto.province_code = dto.province_code; dto.city_code = dto.city_code; dto.city_level = dto.city_level; _sysareaRepository.Insert(dto); }
public void InsertData(demo dto) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; dto.name = dto.name ?? string.Empty; dto.sex = dto.sex ?? string.Empty; dto.age = dto.age; dto.remark = dto.remark ?? string.Empty; _demoRepository.Insert(dto); }
public void InsertAreaData(sys_area dto) { dto.id = IdWorkerHelper.NewId(); dto.zipcode = dto.zipcode; dto.name = dto.name; dto.name = dto.name ?? string.Empty; dto.province_code = dto.province_code; dto.city_code = dto.city_code; dto.city_level = dto.city_level; Sqldb.Insertable(dto).ExecuteCommand(); }
public void InsertDicData(sys_dictionary dto) { dto.id = IdWorkerHelper.NewId(); dto.create_person = UserCookie.AccountName; dto.create_time = DateTime.Now; if (dto.parent_id != 0) { var dicCode = _sysdicRepository.Queryable <sys_dictionary>().Where(s => s.id == dto.parent_id).Select(s => s.dic_code).First(); dto.dic_code = dicCode; } _sysdicRepository.Insert(dto); }
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 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(); }
/// <summary> /// 新增数据 /// </summary> /// <param name="dto"></param> public void InsertData(sys_user dto, LoginUserDto UserCookie, string refExperts) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = UserCookie.AccountName; dto.fax = dto.fax ?? string.Empty; dto.email = dto.email ?? string.Empty; dto.mobile_phone = dto.mobile_phone ?? string.Empty; Sqldb.Insert(dto).ExecuteAffrows(); }
/// <summary> /// 测试图片上传 /// </summary> /// <param name="FilePath"></param> /// <returns></returns> public bool TestUpLoadEnclosure(string FilePath) { try { _enclosureRepository.BeginTran();//开始事务 Enclosure Enclosure = new Enclosure(); Enclosure.Id = IdWorkerHelper.NewId(); Enclosure.FilePath = FilePath; bool result = _enclosureRepository.Insert(Enclosure); _enclosureRepository.CommitTran();//提交事务 return(result); } catch (Exception ex) { _enclosureRepository.RollbackTran();//回滚事务 throw ex; } }
/// <summary> /// 新增 /// </summary> /// <param name="dto"></param> public void InsertDicData(sys_dictionary dto, LoginUserDto UserCookie) { dto.id = IdWorkerHelper.NewId(); dto.create_person = UserCookie.AccountName; dto.create_time = DateTime.Now; if (dto.parent_id != 0) { var dicCode = Sqldb.Select <sys_dictionary>().Where(s => s.id == dto.parent_id).First(s => s.dic_code); dto.dic_code = dicCode; } else { dto.dic_code = ""; } Sqldb.Insert(dto).ExecuteAffrows(); }
/// <summary> /// 新增 /// </summary> /// <param name="dto"></param> public void AddMenu(sys_menu dto, string funcs) { dto.id = IdWorkerHelper.NewId(); dto.create_time = DateTime.Now; dto.create_person = "admin"; //dto.menu_icon = dto.menu_font; if (!string.IsNullOrEmpty(dto.menu_url)) { dto.menu_type = 1; } if (dto.parent_id == 0) { dto.menu_level = 1; } else { dto.menu_level = Sqldb.Queryable <sys_menu>().Where(s => s.id == dto.parent_id).Select(s => s.menu_level) .First() + 1; } Sqldb.Insertable(dto).ExecuteCommand(); //设置菜单下按钮 if (dto.menu_type == 1 && !string.IsNullOrEmpty(funcs)) { var funcArray = funcs.ToObject <List <SysFuncDto> >(); var list = new List <sys_operate>(); foreach (var func in funcArray) { var funcModel = new sys_operate(); funcModel.menu_id = dto.id; funcModel.func_cname = func.title; funcModel.func_name = func.funcname; funcModel.func_icon = func.icon; funcModel.func_url = func.url; funcModel.in_table = func.intable; funcModel.func_sort = func.funcSort; funcModel.id = func.id > 0 ? func.id : IdWorkerHelper.NewId(); list.Add(funcModel); } Sqldb.Insertable(list).ExecuteCommand(); } }
/// <summary> /// 新增Demo /// </summary> /// <param name="Name"></param> /// <param name="Sex"></param> /// <param name="Age"></param> /// <param name="Remark"></param> /// <returns></returns> public bool InsertDemo(string Name, string Sex, int Age, string Remark) { try { _demoRepository.BeginTran();//开始事务 Demo Demo = new Demo(); Demo.Id = IdWorkerHelper.NewId(); Demo.Name = Name; Demo.Sex = Sex; Demo.Age = Age; Demo.Remark = Remark; bool result = _demoRepository.Insert(Demo); _demoRepository.CommitTran(); return(result); } catch (Exception ex) { _demoRepository.RollbackTran();//回滚事务 throw ex; } }
/// <summary> /// 修改 /// </summary> /// <param name="dto"></param> public void UpdateMenu(sys_menu dto, string funcs) { if (!string.IsNullOrEmpty(dto.menu_url)) { dto.menu_type = 1; } if (dto.parent_id == 0) { dto.menu_level = 1; } else { dto.menu_level = Sqldb.Queryable <sys_menu>().Where(s => s.id == dto.parent_id) .First(s => s.menu_level) + 1; } Sqldb.Update <sys_menu>(dto).SetSource(dto).IgnoreColumns(s => new { s.create_time, s.create_person }).ExecuteAffrows(); //设置菜单下按钮 Sqldb.Delete <sys_operate>().Where(s => s.menu_id == dto.id).ExecuteAffrows(); if (dto.menu_type == 1 && !string.IsNullOrEmpty(funcs)) { var funcArray = funcs.ToObject <List <SysFuncDto> >(); var list = new List <sys_operate>(); foreach (var func in funcArray) { var funcModel = new sys_operate(); funcModel.menu_id = dto.id; funcModel.func_cname = func.title; funcModel.func_name = func.funcname; funcModel.func_icon = func.icon; funcModel.func_url = func.url; funcModel.in_table = func.intable; funcModel.id = func.id > 0 ? func.id : IdWorkerHelper.NewId(); funcModel.func_sort = func.funcSort; list.Add(funcModel); } Sqldb.Insert(list).ExecuteAffrows(); } }
/// <summary> /// 新增日志 /// </summary> /// <param name="sysLog"></param> /// <returns></returns> public bool InsertLog(SysLog sysLog) { try { _sysLogRepository.BeginTran();//开始事务 SysLog Log = new SysLog(); Log.Id = IdWorkerHelper.NewId(); Log.LogStatus = sysLog.LogStatus; Log.IpAddress = sysLog.IpAddress; Log.LogType = sysLog.LogType; Log.Remark = sysLog.Remark; Log.CreateTime = DateTime.Now; Log.CreateUserId = _userHelper.Id; bool result = _sysLogRepository.Insert(Log); _sysLogRepository.CommitTran(); return(result); } catch (Exception ex) { _sysLogRepository.RollbackTran();//回滚事务 throw ex; } }
public JsonResult TestUpLoadPicture(IFormFile uploadfile) { var result = new ResultModel <bool>(); try { uploadfile = Request.Form.Files[0]; var now = DateTime.Now; //var webRootPath = _hostingEnvironment.WebRootPath; var webRootPath = @"D:\Github\Nzh.Master\Nzh.Master\"; var filePath = string.Format("/UpLoad/Images/{0}/", now.ToString("yyyyMMdd")); if (!Directory.Exists(webRootPath + filePath)) { Directory.CreateDirectory(webRootPath + filePath); } if (uploadfile != null) { //文件后缀 var fileExtension = Path.GetExtension(uploadfile.FileName); //判断后缀是否是图片 const string fileFilt = ".gif|.jpg|.php|.jsp|.jpeg|.png|......"; //图片 //const string fileFilt = ".doc|.xls|.ppt|.txt|.pdf|.html|......"; //附件 if (fileExtension == null) { return(new JsonResult(new ResultModel <string> { Code = -1, Msg = "上传的文件没有后缀" })); } if (fileFilt.IndexOf(fileExtension.ToLower(), StringComparison.Ordinal) <= -1) { return(new JsonResult(new ResultModel <string> { Code = -1, Msg = "上传的文件不是图片" })); } //判断文件大小 long length = uploadfile.Length; if (length > 1024 * 1024 * 2) //2M { return(new JsonResult(new ResultModel <string> { Code = -1, Msg = "上传的文件不能大于2M" })); } var strDateTime = DateTime.Now.ToString("yyMMddhhmmssfff"); //取得时间字符串 var strRan = Convert.ToString(new Random().Next(100, 999)); //生成三位随机数 var saveName = strDateTime + strRan + fileExtension; //插入图片数据 var picture = new Enclosure { Id = IdWorkerHelper.NewId(), FilePath = filePath + saveName, }; using (FileStream fs = System.IO.File.Create(webRootPath + filePath + saveName)) { uploadfile.CopyTo(fs); fs.Flush(); } result = _enclosureService.TestUpLoadPicture(picture); Logger.Info(JsonConvert.SerializeObject(result)); //此处调用日志记录函数记录日志 return(new JsonResult(new ResultModel <string> { Code = 0, Msg = "上传成功", })); } return(new JsonResult(new ResultModel <string> { Code = -1, Msg = "上传失败" })); } catch (Exception ex) { result.Code = -1; result.Msg = ex.Message; } return(Json(result)); }