/// <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));
}
