/// <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;
}
}
/// <summary>
/// 保持数据
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public string Save(hangfire_task dto)
{
if (dto.id.EmptyId())
{
var exiteJob = Sqldb.Select <hangfire_task>()
.Where(s => s.assembly_namespace == dto.assembly_namespace && s.class_name == dto.class_name).Count();
if (exiteJob > 0)
{
throw new Exception($"任务{dto.assembly_namespace}.{dto.class_name}已存在");
}
dto.id = IdWorkerHelper.GenObjectId();
dto.excute_time = DateTime.Now;
dto.excute_status = 1;
int affect = Sqldb.Insert(dto).ExecuteAffrows();
if (affect < 1)
{
throw new Exception("任务添加失败");
}
return(dto.id);
}
else
{
int affect = Sqldb.Update <hangfire_task>().SetSource(dto).IgnoreColumns(s => new { s.excute_time, s.excute_status }).ExecuteAffrows();
if (affect < 1)
{
throw new Exception("任务添加失败");
}
return(dto.id);
}
}
//public List<AreaGridDto> GetList()
//{
// var specification = new Specification<Area>(u => u.DeletedMark == false);
// var sortingOtopns = new SortingOptions<Area, int?>(x => x.SortCode, isDescending: false);
// var list = areaRepository.FindAll(specification, sortingOtopns).ToList();
// return Mapper.Map<List<AreaGridDto>>(list);
//}
//public AreaOutputDto GetForm(string keyValue)
//{
// var id = Convert.ToInt64(keyValue);
// AreaOutputDto areaOutputDto = new AreaOutputDto();
// Area area = areaRepository.Get(id);
// AutoMapper.Mapper.Map<Area, AreaOutputDto>(area, areaOutputDto);
// return areaOutputDto;
//}
public void SubmitForm(AttachInputDto attachInputDto, string keyValue)
{
Attach attach = new Attach();
if (!string.IsNullOrEmpty(keyValue))
{
//var id = Convert.ToInt64(keyValue);
//area = areaRepository.Get(id);
//AutoMapper.Mapper.Map<AreaInputDto, Area>(areaInputDto, area);
//area.LastModificationTime = DateTime.Now;
//areaRepository.Update(area);
}
else
{
try
{
AutoMapper.Mapper.Map <AttachInputDto, Attach>(attachInputDto, attach);
attach.Id = IdWorkerHelper.GenId64();
attach.CreationTime = DateTime.Now;
attach.CreatorUserId = 1;
attachRepository.Add(attach);
}
catch
{
AutoMapper.Mapper.Map <AttachInputDto, Attach>(attachInputDto, attach);
attach.Id = IdWorkerHelper.GenId64();
attach.CreationTime = DateTime.Now;
attach.CreatorUserId = 1;
attachRepository.Add(attach);
}
}
}
/// <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;
}
}
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 SubmitForm(string menuData)
{
string appId = WxOperatorProvider.Provider.GetCurrent().AppId;
var specification = new Specification <WxMenu>(obj => obj.AppId == appId);
WxMenu wxMenu = wxMenuRepository.Find(specification);
if (wxMenu == null)
{
wxMenu = new WxMenu();
wxMenu.Id = IdWorkerHelper.GenId64();
wxMenu.AppId = appId;
wxMenu.MenuData = menuData;
wxMenu.CreationTime = System.DateTime.Now;
wxMenu.DeletedMark = false;
wxMenuRepository.Add(wxMenu);
}
else
{
wxMenu.MenuData = menuData;
wxMenu.LastModificationTime = System.DateTime.Now;
wxMenuRepository.Update(wxMenu);
}
JObject jo = (JObject)JsonConvert.DeserializeObject(menuData);
JObject menu = (JObject)jo["menu"];
JArray button = (JArray)menu["button"];
Debug.WriteLine(menu.ToString());
AccessTokenResult accessTokenResult = AccessTokenContainer.GetAccessTokenResult(appId);
WxJsonResult wxJsonResult = CommonApi.CreateMenu(accessTokenResult.access_token, menu);
}
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();
}
}
}
public void Subscribe(string toUserName, string fromUserName, DateTime subscribeTime)
{
var wxOfficialSpecification = new Specification <WxOfficial>(p => p.Account == toUserName);
WxOfficial wxOfficial = wxOfficialRepository.Find(wxOfficialSpecification);
var wxUserSpecification = new Specification <WxUser>(p => p.AppId == wxOfficial.AppId && p.OpenId == fromUserName);
WxUser wxUser = wxUserRepository.Find(wxUserSpecification);
if (wxUser == null)
{
wxUser = new WxUser();
wxUser.Id = IdWorkerHelper.GenId64();
wxUser.AppId = wxOfficial.AppId;
wxUser.OpenId = fromUserName;
wxUser.SubscribeTime = subscribeTime;
wxUser.SubscribeStatus = 1;
wxUserRepository.Add(wxUser);
}
else
{
wxUser.SubscribeStatus = 1;
wxUser.SubscribeTime = subscribeTime;
wxUserRepository.Update(wxUser);
}
}
/// <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;
}
}
//public WxApp GetEntityByAppId(string appId)
//{
// var specification = new Specification<WxApp>(p => p.AppId == appId);
// WxApp wxApp = wxAppRepository.Find(specification);
// return wxApp;
//}
public void SubmitForm(WxImageInputDto wxImageInputDto, string keyValue)
{
WxImage wxImage = new WxImage();
string appId = WxOperatorProvider.Provider.GetCurrent().AppId;
if (!string.IsNullOrEmpty(keyValue))
{
var id = Convert.ToInt64(keyValue);
wxImage = wxImageRepository.Get(id);
//AutoMapper.Mapper.Map<WxImageInputDto, WxImage>(wxImageInputDto, wxImage);
wxImage.FileName = wxImageInputDto.FileName;
wxImage.LastModificationTime = DateTime.Now;
wxImageRepository.Update(wxImage);
}
else
{
AutoMapper.Mapper.Map <WxImageInputDto, WxImage>(wxImageInputDto, wxImage);
wxImage.Id = IdWorkerHelper.GenId64();
wxImage.AppId = appId;
wxImage.DeletedMark = false;
wxImage.CreationTime = DateTime.Now;
wxImage.CreatorUserId = 1;
wxImageRepository.Add(wxImage);
}
}
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();
}
/// <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 ActionResult GenTaskId()
{
var id = IdWorkerHelper.GenObjectId();
var result = new ResultAdaptDto();
result.data.Add("taskId", id);
return(Data(result));
}
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 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 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 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();
}
public ActionResult Uploadimg()
{
var result = new ResultAdaptDto();
//long size = 0;
var files = Request.Form.Files;
if (files.Count == 0)
{
result.status = false;
result.msg = "没有文件信息";
return(Content(result.ToJson()));
}
string url = $"/upfiles/images/{DateTime.Now.ToString("yyyyMMdd")}";
var folder = GlobalParamsDto.WebRoot + url;
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
var file = files[0];
var filename = ContentDispositionHeaderValue
.Parse(file.ContentDisposition)
.FileName
.Trim('"');
int index = filename.LastIndexOf('.');
string extName = filename.Substring(index);
string guidstr = Guid.NewGuid().ToString("N");
string guidFileName = guidstr + extName;
//这个hostingEnv.WebRootPath就是要存的地址可以改下
filename = $"{folder}/{guidFileName}";
using (FileStream fs = System.IO.File.Create(filename))
{
file.CopyTo(fs);
fs.Flush();
}
var firstFileInfo = new FileInfo(filename);
if (firstFileInfo.Length > 200 * 1024)
{
string compressFileName = IdWorkerHelper.GenObjectId() + extName;
string compressFile = $"{folder}/{compressFileName}";
ImageUtilities.CompressImage(filename, compressFile, 90, 200);
guidFileName = compressFileName;
}
string imgurl = $"{ url}/{guidFileName}";
result.data.Add("url", imgurl);
return(Content(result.ToJson()));
}
/// <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();
}
public IActionResult Merge()
{
var result = new ResultAdaptDto();
try
{
string guid = RequestHelper.GetQueryString("guid");
string fileName = RequestHelper.GetQueryString("fileName");
var tempDir = GlobalParamsDto.WebRoot + "/UploadTemp/" + guid; // 缓存文件夹
var targetDir = GlobalParamsDto.WebRoot + "/upfiles/videos/" + DateTime.Now.ToString("yyyyMMdd"); // 目标文件夹
//uploadfile,uploadvideo
string action = RequestHelper.GetPostString("action");
if (action == "uploadfile")
{
targetDir = GlobalParamsDto.WebRoot + "/upfiles/attachments/" + DateTime.Now.ToString("yyyyMMdd"); // 目标文件夹
}
if (!System.IO.Directory.Exists(targetDir))
{
System.IO.Directory.CreateDirectory(targetDir);
}
int index = fileName.LastIndexOf('.');
string extName = fileName.Substring(index);
string guidFileName = IdWorkerHelper.GenObjectId() + extName;
var finalPath = Path.Combine(targetDir, guidFileName);
var files = System.IO.Directory.GetFiles(tempDir);//获得下面的所有文件
using (FileStream fs = System.IO.File.Create(finalPath))
{
foreach (var part in files.OrderBy(x => x.Length).ThenBy(x => x))//排一下序，保证从0-N Write
{
var bytes = System.IO.File.ReadAllBytes(part);
fs.Write(bytes, 0, bytes.Length);
bytes = null;
System.IO.File.Delete(part);//删除分块
}
fs.Flush();
}
string returnPath = "/upfiles/videos/" + DateTime.Now.ToString("yyyyMMdd") + "/" + guidFileName;
result.data.Add("url", returnPath);
result.data.Add("fileName", fileName);
}
catch (Exception ex)
{
result.status = false;
result.msg = ex.Message;
}
return(Content(result.ToJson()));
}
public void TestAsync4()
{
OperateLog operateLog = new OperateLog();
operateLog.Area = "hangfire";
operateLog.Controller = "OperateLog";
operateLog.Action = "TaskTest4";
operateLog.Method = "Task";
operateLog.UserId = 1035359633864265728;
operateLog.UserName = "******";
operateLog.Id = IdWorkerHelper.GenId64();
operateLog.DeletedMark = false;
operateLog.CreationTime = DateTime.Now;
operateLogRepository.Add(operateLog);
}
public void SubmitForm(OperateLogInputDto operateLogInputDto, string keyValue)
{
OperateLog operateLog = new OperateLog();
if (!string.IsNullOrEmpty(keyValue))
{
}
else
{
AutoMapper.Mapper.Map <OperateLogInputDto, OperateLog>(operateLogInputDto, operateLog);
operateLog.Id = IdWorkerHelper.GenId64();
operateLog.DeletedMark = false;
operateLog.CreationTime = DateTime.Now;
operateLogRepository.Add(operateLog);
}
}
