public override int Update(FormM form, DFDictionary entity, ref string message)
{
try
{
var dict = new DFDictionary();
/*基本查询语句*/
var sql = "select * from WF_M_ROLE where 1=1";
/*查询条件*/
using (var db = Pub.DB)
{
var parameters = entity.To <WF_M_ROLE>();
var oldEntity = db.Query <WF_M_ROLE>(sql, parameters).FirstOrDefault();
if (oldEntity == null)
{
message = "记录已经不存在".GetRes();
return(DFPub.EXECUTE_ERROR);
}
var newDict = DFDictionary.Create <WF_M_ROLE>(oldEntity);
// 把更新的值更新进去
newDict.Merge(entity);
// 将 Dictionary 转成 Entity
var newEntity = newDict.To <WF_M_ROLE>();
db.Update <WF_M_ROLE>(newEntity);
return(DFPub.EXECUTE_SUCCESS);
}
}
catch (Exception ex)
{
message = ex.Message;
return(DFPub.EXECUTE_ERROR);
}
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
try
{
if (string.IsNullOrWhiteSpace(entity["ModuleId"]))
{
throw new Exception("请选择模块".GetRes());
}
if (string.IsNullOrWhiteSpace(entity["PMenuId"]))
{
throw new Exception("请选择父菜单".GetRes());
}
var parent = WF_M_MENULoader.Query(entity["PMenuId"]).FirstOrDefault();
var siblings = WF_M_MENULoader.Query(null, parent.MenuLabel).ToList();
var newEntity = entity.To <WF_M_MENU>();
newEntity.MenuId = Guid.NewGuid().ToString();
var user = Util.GetCurrentUser();
newEntity.CreateTime = DateTime.Now;
newEntity.CreateUser = user.UserName;
newEntity.LastModifyTime = DateTime.Now;
newEntity.LastModifyUser = user.UserName;
newEntity.MenuLabel = LabelHelper.GetNextLabelUsingSubLabelList(parent.MenuLabel, siblings.Select(a => a.MenuLabel).ToList());
WF_M_MENULoader.Insert(newEntity);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
catch (Exception ex)
{
message = ex.Message;
return(DFPub.EXECUTE_ERROR);
}
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
try
{
if (string.IsNullOrWhiteSpace(entity["CodeType"]))
{
throw new Exception("代码分类必须输入".GetRes());
}
if (string.IsNullOrWhiteSpace(entity["CodeName"]))
{
throw new Exception("代码名称必须输入".GetRes());
}
var currentUser = Util.GetCurrentUser();
var dict = new DFDictionary();
/*基本查询语句*/
var sql = "select * from WF_M_PUBLICCODE where 1=1";
/*查询条件*/
sql += " and CodeType=@CodeType and CodeName=@CodeName";
using (var db = Pub.DB)
{
var parameters = new { CodeName = entity["CodeName"], CodeType = entity["CodeType"] };
var oldEntity = db.Query <WF_M_PUBLICCODE>(sql, parameters).FirstOrDefault();
if (oldEntity != null)
{
message = "代码已经存在".GetRes();
return(DFPub.EXECUTE_ERROR);
}
var newEntity = entity.To <WF_M_PUBLICCODE>();
newEntity.CodeId = Guid.NewGuid().ToString();
newEntity.CodeType = entity["CodeType"];
newEntity.CodeName = entity["CodeName"];
newEntity.CodeValue = entity["CodeValue"];
newEntity.CodeLongValue = entity["CodeLongValue"];
newEntity.CodeOrder = ParseHelper.ParseInt(entity["CodeOrder"]);
newEntity.CreateUser = currentUser.UserName;
newEntity.CreateTime = DateTime.Now;
newEntity.LastModifyUser = currentUser.UserName;
newEntity.LastModifyTime = DateTime.Now;
db.Insert(newEntity);
// 默认为 role_user 角色组用户
UserRoleLoader.Create(newEntity.CodeId, Constants.ROLE_USER, currentUser.UserName);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
}
catch (Exception ex)
{
message = ex.Message;
return(DFPub.EXECUTE_ERROR);
}
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
if (string.IsNullOrWhiteSpace(entity["UserName"]))
{
throw new WFException("用户名必须输入".GetRes());
}
var currentUser = Util.GetCurrentUser();
var dict = new DFDictionary();
/*基本查询语句*/
var sql = "select * from WF_M_USER where 1=1";
/*查询条件*/
sql += " and UserName=@UserName";
using (var db = Pub.DB)
{
var parameters = new { UserName = entity["UserName"] };
var oldEntity = db.Query <WF_M_USER>(sql, parameters).FirstOrDefault();
if (oldEntity != null)
{
throw new WFException("用户名已经存在".GetRes());
}
if (entity["Category"] == "SENDER")
{
if (string.IsNullOrWhiteSpace(entity["CompanyName"]))
{
throw new WFException("请输入托运单位");
}
}
var newEntity = entity.To <WF_M_USER>();
newEntity.UserId = Guid.NewGuid().ToString();
newEntity.Password = HashHelper.GenerateUserHash(newEntity.UserName, "123456");
newEntity.Status = ParseHelper.ParseInt(entity["Status"]);
newEntity.CreateUser = currentUser.UserName;
newEntity.CreateTime = DateTime.Now;
newEntity.LastModifyUser = currentUser.UserName;
newEntity.LastModifyTime = DateTime.Now;
//var company = WF_M_COMPANYLoader.Get(newEntity.CompanyCode);
//newEntity.CompanyName = company.CompanyName;
db.Insert(newEntity);
// 默认为 role_user 角色组用户
UserRoleLoader.Create(newEntity.UserId, Constants.ROLE_USER, currentUser.UserName);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
using (var db = Pub.DB)
{
if (string.IsNullOrWhiteSpace(entity["ExecutorValue"]))
{
throw new WFException("请选择用户".GetRes());
}
var newEntity = entity.To <WF_M_STEPEXECUTOR>();
newEntity.ExecutorId = Guid.NewGuid().ToString();
newEntity.ExecutorPriority = ParseHelper.ParseInt(entity["ExecutorPriority"]);
db.Insert <WF_M_STEPEXECUTOR>(newEntity);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
try
{
if (string.IsNullOrWhiteSpace(entity["ResId"]))
{
throw new Exception("资源编号".GetRes());
}
var currentUser = Util.GetCurrentUser();
var dict = new DFDictionary();
/*基本查询语句*/
var sql = "select * from WF_M_RES where 1=1";
/*查询条件*/
sql += " and ResId=@ResId";
using (var db = Pub.DB)
{
var parameters = new { ResId = entity["ResId"] };
var oldEntity = db.Query <WF_M_RES>(sql, parameters).FirstOrDefault();
if (oldEntity != null)
{
message = "记录已经存在".GetRes();
return(DFPub.EXECUTE_ERROR);
}
var newEntity = entity.To <WF_M_RES>();
newEntity.ResId = entity["ResId"];
newEntity.English = entity["English"];
newEntity.ChineseSimplified = entity["ChineseSimplified"];
newEntity.ChineseTraditional = entity["ChineseTraditional"];
newEntity.CreateUser = currentUser.UserName;
newEntity.CreateTime = DateTime.Now;
newEntity.LastModifyUser = currentUser.UserName;
newEntity.LastModifyTime = DateTime.Now;
db.Insert(newEntity);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
}
catch (Exception ex)
{
message = ex.Message;
return(DFPub.EXECUTE_ERROR);
}
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
try
{
var currentUser = Util.GetCurrentUser();
var dict = new DFDictionary();
/*基本查询语句*/
var sql = "select * from WF_M_ROLE where 1=1";
/*查询条件*/
sql += " and RoleId=@RoleId";
using (var db = Pub.DB)
{
var parameters = new { RoleId = entity["RoleId"] };
var oldEntity = db.Query <WF_M_ROLE>(sql, parameters).FirstOrDefault();
if (oldEntity != null)
{
message = "该角色编号已经存在".GetRes();
return(DFPub.EXECUTE_ERROR);
}
var newEntity = entity.To <WF_M_ROLE>();
newEntity.RoleId = entity["RoleId"];
newEntity.RoleName = entity["RoleName"];
newEntity.Remark = entity["Remark"];
newEntity.CreateUser = currentUser.UserName;
newEntity.CreateTime = DateTime.Now;
newEntity.LastModifyUser = currentUser.UserName;
newEntity.LastModifyTime = DateTime.Now;
db.Insert(newEntity);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}
}
catch (Exception ex)
{
message = ex.Message;
return(DFPub.EXECUTE_ERROR);
}
}
public override int Insert(FormM form, DFDictionary entity, ref string message)
{
var item = WF_M_ROLE_MODELLoader.Get(entity["ModelId"], entity["RoleId"]);
if (item != null)
{
throw new WFException("记录已经存在");
}
var newEntity = entity.To <WF_M_ROLE_MODEL>();
var user = string.Empty;
user = Util.GetCurrentUser().UserName;
newEntity.CreateTime = DateTime.Now;
newEntity.CreateUser = user;
newEntity.LastModifyTime = DateTime.Now;
newEntity.LastModifyUser = user;
WF_M_ROLE_MODELLoader.Insert(newEntity);
message = "新增成功".GetRes();
return(DFPub.EXECUTE_SUCCESS);
}