/// <summary>
/// 设置实体
/// </summary>
/// <param name="sqlBuilder"></param>
/// <param name="accreditUserEntity">实体</param>
private void SetEntity(SQLBuilder sqlBuilder, AccreditUserEntity accreditUserEntity)
{
sqlBuilder.SetValue(AccreditUserTable.FieldAccreditFromUserId, accreditUserEntity.AccreditFromUserId);
sqlBuilder.SetValue(AccreditUserTable.FieldAccreditToUserId, accreditUserEntity.AccreditToUserId);
sqlBuilder.SetValue(AccreditUserTable.FieldAccreditDateTime, accreditUserEntity.AccreditDateTime);
sqlBuilder.SetValue(AccreditUserTable.FieldAccreditStatus, accreditUserEntity.AccreditStatus);
sqlBuilder.SetValue(AccreditUserTable.FieldAcWorkflowId, accreditUserEntity.AcWorkflowId);
sqlBuilder.SetValue(AccreditUserTable.FieldAcWorktaskId, accreditUserEntity.AcWorktaskId);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="accreditUserEntity">实体</param>
public int UpdateEntity(AccreditUserEntity accreditUserEntity)
{
var sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, accreditUserEntity);
sqlBuilder.SetWhere(AccreditUserTable.FieldAUserId, accreditUserEntity.AUserId);
return(sqlBuilder.EndUpdate());
}
/// <summary>
///
/// </summary>
/// <param name="auserid"></param>
/// <returns></returns>
public AccreditUserEntity GetAccreditUserInfo(string auserid)
{
AccreditUserEntity entity = null;
DataTable dt = GetAccreditUserTable(auserid);
if (dt != null && dt.Rows.Count > 0)
{
entity = BaseEntity.Create <AccreditUserEntity>(dt);
}
return(entity);
}
/// <summary>
/// 更新任务授权
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="entity">实体</param>
/// <returns>大于0成功</returns>
public int UpdateAccreditUser(UserInfo userInfo, AccreditUserEntity entity)
{
var returnValue = -1;
var parameter = ParameterUtil.CreateWithOutMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName);
ServiceUtil.ProcessWorkFlowDbWithTransaction(userInfo, parameter, dbProvider =>
{
var manager = new AccreditUserManager(dbProvider, userInfo);
returnValue = manager.UpdateAccreditUser(entity);
});
return(returnValue);
}
/// <summary>
/// 增加AccreditUser
/// </summary>
/// <param name="entity">实体</param>
/// <returns>增加成功后的主键</returns>
public string Insert(AccreditUserEntity entity)
{
string returnStr = string.Empty;
try
{
if (!accreditExists(entity.AccreditFromUserId, entity.AccreditToUserId, entity.AcWorkflowId, entity.AcWorktaskId)) //有效的授权是否存在
{
returnStr = this.AddEntity(entity);
}
}
catch (Exception ex)
{
throw ex;
}
return(returnStr);
}
/// <summary>
/// 任务授权
/// </summary>
/// <param name="fromUserId">授权UserId</param>
/// <param name="toUserId">被授权UserId</param>
/// <param name="workflowId">流程模板Id</param>
/// <param name="worktaskId">任务模板Id</param>
/// <returns></returns>
public string AssignAccredit(string fromUserId, string toUserId, string workflowId, string worktaskId)
{
try
{
var au = new AccreditUserEntity
{
AUserId = BusinessLogic.NewGuid(),
AccreditFromUserId = fromUserId,
AccreditToUserId = toUserId,
AcWorkflowId = workflowId,
AcWorktaskId = worktaskId
};
return(string.IsNullOrEmpty(RDIFrameworkService.Instance.WorkFlowHelperService.InsertAccreditUser(this.CurrentUser, au)) ? WorkFlowConst.OtherErrorCode : WorkFlowConst.SuccessCode);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新AccreditUser
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int UpdateAccreditUser(AccreditUserEntity entity)
{
int returnInt = -1;
if (entity.AUserId.Trim().Length == 0 || entity.AUserId == null)
{
throw new Exception("Update方法错误，AUserId不能为空！");
}
try
{
returnInt = this.UpdateEntity(entity);
}
catch (Exception ex)
{
throw ex;
}
return(returnInt);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="accreditUserEntity">实体</param>
public string AddEntity(AccreditUserEntity accreditUserEntity)
{
var sequence = string.Empty;
this.Identity = false;
if (accreditUserEntity.AUserId != null)
{
sequence = accreditUserEntity.AUserId.ToString();
}
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, AccreditUserTable.FieldAUserId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(accreditUserEntity.AUserId))
{
sequence = BusinessLogic.NewGuid();
accreditUserEntity.AUserId = sequence;
}
sqlBuilder.SetValue(AccreditUserTable.FieldAUserId, accreditUserEntity.AUserId);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(AccreditUserTable.FieldAUserId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(AccreditUserTable.FieldAUserId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(accreditUserEntity.AUserId))
{
if (string.IsNullOrEmpty(sequence))
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
accreditUserEntity.AUserId = sequence;
}
sqlBuilder.SetValue(AccreditUserTable.FieldAUserId, accreditUserEntity.AUserId);
}
}
}
this.SetEntity(sqlBuilder, accreditUserEntity);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString(CultureInfo.InvariantCulture);
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="accreditUserEntity">实体</param>
public int Update(AccreditUserEntity accreditUserEntity)
{
return(this.UpdateEntity(accreditUserEntity));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="accreditUserEntity">实体</param>
/// <param name="identity">自增量方式</param>
/// <param name="returnId">返回主键</param>
/// <returns>主键</returns>
public string Add(AccreditUserEntity accreditUserEntity, bool identity, bool returnId)
{
this.Identity = identity;
this.ReturnId = returnId;
return(this.AddEntity(accreditUserEntity));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="accreditUserEntity">实体</param>
/// <returns>主键</returns>
public string Add(AccreditUserEntity accreditUserEntity)
{
return(this.AddEntity(accreditUserEntity));
}
/// <summary>
/// 判断用户是否是该任务节点的操作者
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool isTaskOperator(AccreditUserEntity entity)
{
return(IsTaskOperator(entity.AccreditFromUserId, entity.AcWorkflowId, entity.AcWorktaskId));
}