/// <summary>
/// 编辑图文消息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public DocPic EditDocPic(DocPicEditReqeust info)
{
ValiDatas.valiData(info);
ValiCode(info.Code, info.Id);
using (var db = new DefaultContainer()) {
var row = db.Db_BaseDocSet.OfType <Db_DocPic>().Single(p => p.Id == this.Id);
row.Caption = info.Caption;
row.Code = info.Code;
row.Content = info.Content;
row.Descript = info.Descript;
//删除原来的分类
db.Database.ExecuteSqlCommand("delete from Db_BaseDocTreeSet where Db_BaseDocId=@docId", new SqlParameter("@docId", this.Id));
//新增分类
if (info.TreeIds != null)
{
if (info.TreeIds.Count > 0)
{
List <Db_BaseDocTree> dbTrees = new List <Db_BaseDocTree>();
foreach (var item in info.TreeIds)
{
dbTrees.Add(new Db_BaseDocTree()
{
Id = Guid.NewGuid().ToString(),
Db_BaseDocId = this.Id,
TreeId = item
});
}
db.Db_BaseDocTreeSet.AddRange(dbTrees);
}
}
db.SaveChanges();
return(new DocPic(row));
}
}
/// <summary>
/// 验证用户名和密码是否正确
/// </summary>
/// <param name="condtion"></param>
/// <returns>验证通过返回后台用户对象 验证不通过直接抛出DataNotFundException异常</returns>
public static UserManager checkLogin(UserManagerLoginRequest condtion)
{
ValiDatas.valiData(condtion);
using (var db = new DefaultContainer()) {
//判断数据库是否为空，如果为空则添加一个管理员用户
var count = (from c in db.Db_BaseUserSet.OfType <Db_ManagerUser>()
select c.Id).Count();
if (count == 0)
{
return(UserManager.create(new UserManagerCreateRequest()
{
fullName = "管理员",
loginName = "admin",
roleNames = new string[] { "admin" }
}));
}
var row = db.Db_BaseUserSet.OfType <Db_ManagerUser>().SingleOrDefault(p =>
p.loginName == condtion.loginName &&
p.passWord.ToLower() == condtion.passWord.ToLower() &&
p.isDeleted == false
);
if (row == null)
{
throw new DataNotFundException("用户名或者密码错误");
}
if (row.isDisabled)
{
throw new ValiDataException("已被禁用的用户无法登录");
}
return(new UserManager(row));
}
}
/// <summary>
/// 新增/编辑
/// </summary>
/// <param name="rows"></param>
/// <returns></returns>
public static List <WorkFlowRole> Edit(List <WorkFlowRole> rows)
{
List <WorkFlowRole> result = new List <WorkFlowRole>();
foreach (var item in rows)
{
ValiDatas.valiData(item);
}
using (var db = new DefaultContainer()) {
foreach (var item in rows)
{
if (string.IsNullOrEmpty(item.Id))
{
Db_WorkFlowRole dbRole = new Db_WorkFlowRole()
{
CreatedOn = DateTime.Now,
Descript = string.IsNullOrEmpty(item.Descript) ? null : item.Descript,
Id = Guid.NewGuid().ToString(),
RoleName = item.RoleName
};
db.Db_WorkFlowRoleSet.Add(dbRole);
result.Add(new WorkFlowRole(dbRole));
}
else
{
var row = db.Db_WorkFlowRoleSet.Single(p => p.Id == item.Id);
row.RoleName = item.RoleName;
row.Descript = item.Descript;
result.Add(new WorkFlowRole(row));
}
}
db.SaveChanges();
}
return(result);
}
/// <summary>
/// 更新文档图片集
/// </summary>
/// <param name="filesList"></param>
public void UpdatImgFileList(List <BaseDocImgFile> filesList)
{
if (filesList == null)
{
filesList = new List <BaseDocImgFile>();
}
foreach (var item in filesList)
{
ValiDatas.valiData(item);
}
using (var db = new DefaultContainer()) {
//删除原来的
db.Database.ExecuteSqlCommand("delete from Db_BaseDocFileSet where Db_BaseDocId =@docId", new SqlParameter("@docId", this.Id));
if (filesList.Count > 0)
{
List <Db_BaseDocFile> dbFiles = new List <Db_BaseDocFile>();
foreach (var item in filesList)
{
dbFiles.Add(new Db_BaseDocFile()
{
Caption = item.Caption,
CreatedOn = DateTime.Now,
Db_BaseDocId = this.Id,
Descript = item.Descript,
Seq = item.Seq,
FileId = item.FileId,
Id = Guid.NewGuid().ToString()
});
}
db.Db_BaseDocFileSet.AddRange(dbFiles);
db.SaveChanges();
}
}
}
/// <summary>
/// 编辑基础信息 - 姓名与手机号
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
public UserManager editBaseInfo(UserManagerBaseEditRequest condtion)
{
ValiDatas.valiData(condtion);
this.fullName = condtion.fullName;
this.mobilePhone = condtion.mobilePhone;
saveBaseInfo();
return(this);
}
/// <summary>
/// 编辑用户信息 信息与角色
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
public UserManager edit(UserManagerEditRequest condtion)
{
ValiDatas.valiData(condtion);
this.fullName = condtion.fullName;
this.mobilePhone = condtion.mobilePhone;
this.rolesList = condtion.roleNames.ToList();
save();
return(this);
}
/// <summary>
/// 修改用户的密码
/// </summary>
/// <param name="condtion"></param>
public void changePwd(UserChangePwdRequst condtion)
{
ValiDatas.valiData(condtion);
using (var db = new DefaultContainer()) {
var dbuser = db.Db_BaseUserSet.OfType <Db_ManagerUser>().Single(p => p.Id == this.Id);
if (dbuser.passWord.ToLower() != condtion.oldPwd.ToLower())
{
throw new ValiDataException("您提供的旧密码错误");
}
dbuser.passWord = condtion.newPwd;
db.SaveChanges();
}
}
public BaseResponse <UserManager> setDisabled(string Id, UserManagerSetDisabledRequest condtion)
{
ValiDatas.valiData(condtion);
var thisUser = UserManager.getUserById(User.Identity.Name);
UserManager user = UserManager.getUserById(Id);
user.saveDisabled(condtion.isDisabled);
//记录到日志
//操作员
UserLog.create(string.Format("将用户[{0}]设置为{1}，备注：{2}", user.getNameString(), (condtion.isDisabled ? "已禁用" : "未禁用"), condtion.remark), "用户禁用设置", thisUser);
//被编辑
UserLog.create(string.Format("被用户[{0}]设置为{1}，备注：{2}", thisUser.getNameString(), (condtion.isDisabled ? "已禁用" : "未禁用"), condtion.remark), "用户禁用设置", user);
return(BaseResponse.getResult(user, "设置成功"));
}
/// <summary>
/// 批量新增/编辑业务流程定义
/// </summary>
/// <param name="condtion"></param>
public static List <WorkFlowDefinition> EditDefs(List <WorkFlowDefinition> condtion)
{
List <WorkFlowDefinition> result = new List <WorkFlowDefinition>();
if (condtion != null)
{
if (condtion.Count > 0)
{
foreach (var item in condtion)
{
ValiDatas.valiData(condtion);
}
using (var db = new DefaultContainer())
{
foreach (var item in condtion)
{
if (string.IsNullOrEmpty(item.Id))
{
//新增
Db_WorkFlowDefinition dbDef = new Db_WorkFlowDefinition()
{
Id = SysHelps.GetNewId(),
Caption = item.Caption,
Descript = string.IsNullOrEmpty(item.Descript)? null :item.Descript,
CreatedOn = DateTime.Now
};
db.Db_WorkFlowDefinitionSet.Add(dbDef);
result.Add(new WorkFlowDefinition(dbDef));
}
else
{
//编辑
var dbDef = db.Db_WorkFlowDefinitionSet.Single(p => p.Id == item.Id);
dbDef.Caption = item.Caption;
dbDef.Descript = item.Descript;
result.Add(new WorkFlowDefinition(dbDef));
}
}
db.SaveChanges();
}
}
}
return(result);
}
/// <summary>
/// 新增图文集
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static DocPic CreateDocPic(DocPicEditReqeust info)
{
ValiDatas.valiData(info);
ValiCode(info.Code);
using (var db = new DefaultContainer()) {
var newId = Guid.NewGuid().ToString();
Db_DocPic newRow = new Db_DocPic()
{
Caption = info.Caption,
Code = info.Code,
Content = info.Content,
CreatedOn = DateTime.Now,
Descript = info.Descript,
DocType = BaseDocType.图文集.GetHashCode(),
Id = newId
};
//所在分类信息
if (info.TreeIds != null)
{
if (info.TreeIds.Count > 0)
{
List <Db_BaseDocTree> dbTrees = new List <Db_BaseDocTree>();
foreach (var item in info.TreeIds)
{
dbTrees.Add(new Db_BaseDocTree()
{
Id = Guid.NewGuid().ToString(),
Db_BaseDocId = newId,
TreeId = item
});
}
db.Db_BaseDocTreeSet.AddRange(dbTrees);
}
}
db.Db_BaseDocSet.Add(newRow);
db.SaveChanges();
return(new DocPic(newRow));
}
}
/// <summary>
/// 创建一个后台用户
/// </summary>
/// <param name="condtion"></param>
/// <returns></returns>
public static UserManager create(UserManagerCreateRequest condtion)
{
ValiDatas.valiData(condtion);
lock (locker)
{
//验证登录名是否已存在
var count = getLoginNameCount(condtion.loginName);
if (count > 0)
{
throw new ValiDataException("该登录名已存在，创建失败");
}
string newId = Guid.NewGuid().ToString();
Db_ManagerUser user = new Db_ManagerUser()
{
createdOn = DateTime.Now,
fullName = condtion.fullName,
loginName = condtion.loginName,
mobilePhone = condtion.mobilePhone,
passWord = SysSetingsHelp.DefaultAdminPwd,
Id = newId,
};
//角色
foreach (var role in condtion.roleNames)
{
user.Db_BaseUserRole.Add(new Db_BaseUserRole()
{
Id = Guid.NewGuid().ToString(),
roleName = role,
});
}
using (var db = new DefaultContainer())
{
var newrow = db.Db_BaseUserSet.Add(user);
db.SaveChanges();
return(getUserById(newId));
}
}
}