private void eventContainer_BeforeUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary<object, object> context)
{
if ((fields & ~UserTaskFieldDefine.ReadTime) != UserTaskFieldDefine.None)
{
ProcessTaskByIDType(task, idType);
}
}
public void OnBeforeUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields)
{
foreach (UserTaskOpEventContainer container in EventContainers)
{
container.OnBeforeUpdateUserTask(task, idType, fields, Context);
}
}
internal void OnBeforeUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary <object, object> context)
{
if (BeforeUpdateUserTask != null)
{
BeforeUpdateUserTask(task, idType, fields, context);
}
}
private static string GetUserTaskSelectFields(UserTaskFieldDefine returnFields)
{
ORMappingItemCollection mappings = ORMapping.GetMappingInfo <UserTask>();
StringBuilder strB = new StringBuilder();
if (returnFields != UserTaskFieldDefine.All)
{
foreach (EnumItemDescription desp in EnumItemDescriptionAttribute.GetDescriptionList(typeof(UserTaskFieldDefine)))
{
UserTaskFieldDefine enumItem = (UserTaskFieldDefine)desp.EnumValue;
if ((enumItem & returnFields) != UserTaskFieldDefine.None)
{
ORMappingItem mappingItem = GetMappingFromPropertyName(enumItem.ToString(), mappings);
if (mappingItem != null)
{
if (strB.Length > 0)
{
strB.Append(", ");
}
strB.Append(mappingItem.DataFieldName);
}
}
}
}
else
{
strB.Append("*");
}
return(strB.ToString());
}
internal int OnUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary <object, object> context)
{
int result = 0;
if (UpdateUserTask != null)
{
result = UpdateUserTask(task, idType, fields, context);
}
return(result);
}
public int OnUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields)
{
int result = 0;
foreach (UserTaskOpEventContainer container in EventContainers)
{
int r = container.OnUpdateUserTask(task, idType, fields, Context);
if (r > result)
{
result = r;
}
}
return(result);
}
public int UpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields)
{
ExceptionHelper.FalseThrow <ArgumentNullException>(task != null, "task");
int result = 0;
UserOpContext contexts = InitEventContexts();
contexts.OnBeforeUpdateUserTask(task, idType, fields);
using (TransactionScope scope = TransactionScopeFactory.Create())
{
result = contexts.OnUpdateUserTask(task, idType, fields);
scope.Complete();
}
return(result);
}
public UserTaskCollection GetUserAccomplishedTasks(UserTaskIDType idType, UserTaskFieldDefine returnFields, bool nolock, params string[] ids)
{
ExceptionHelper.FalseThrow <ArgumentNullException>(ids != null, "ids");
UserTaskCollection utc = new UserTaskCollection();
if (ids.Length > 0)
{
ORMappingItem keyItem = GetMappingItemFromIDType(idType);
InSqlClauseBuilder iBuilder = new InSqlClauseBuilder();
iBuilder.AppendItem(ids);
string sql = string.Format("SELECT {0} FROM WF.USER_ACCOMPLISHED_TASK{1} WHERE {2} {3}",
GetUserTaskSelectFields(returnFields),
nolock ? "(NOLOCK)" : string.Empty,
GetMappingItemFromIDType(idType).DataFieldName,
iBuilder.ToSqlStringWithInOperator(TSqlBuilder.Instance));
using (DbContext dbi = DbHelper.GetDBContext(GetConnectionName()))
{
Database db = DatabaseFactory.Create(dbi);
using (IDataReader dr = db.ExecuteReader(CommandType.Text, sql))
{
while (dr.Read())
{
UserTask ut = new UserTask();
ORMapping.DataReaderToObject(dr, ut);
utc.Add(ut);
}
}
}
}
return(utc);
}
public UserTaskCollection GetUserAccomplishedTasks(UserTaskIDType idType, UserTaskFieldDefine returnFields, bool nolock, params string[] ids)
{
ExceptionHelper.FalseThrow<ArgumentNullException>(ids != null, "ids");
UserTaskCollection utc = new UserTaskCollection();
if (ids.Length > 0)
{
ORMappingItem keyItem = GetMappingItemFromIDType(idType);
InSqlClauseBuilder iBuilder = new InSqlClauseBuilder();
iBuilder.AppendItem(ids);
string sql = string.Format("SELECT {0} FROM WF.USER_ACCOMPLISHED_TASK{1} WHERE {2} {3}",
GetUserTaskSelectFields(returnFields),
nolock ? "(NOLOCK)" : string.Empty,
GetMappingItemFromIDType(idType).DataFieldName,
iBuilder.ToSqlStringWithInOperator(TSqlBuilder.Instance));
using (DbContext dbi = DbHelper.GetDBContext(GetConnectionName()))
{
Database db = DatabaseFactory.Create(dbi);
using (IDataReader dr = db.ExecuteReader(CommandType.Text, sql))
{
while (dr.Read())
{
UserTask ut = new UserTask();
ORMapping.DataReaderToObject(dr, ut);
utc.Add(ut);
}
}
}
}
return utc;
}
/// <summary>
/// 根据Task的ID获得UserTask对象集合
/// </summary>
/// <param name="idType"></param>
/// <param name="returnFields"></param>
/// <param name="ids"></param>
/// <returns></returns>
public UserTaskCollection GetUserTasks(UserTaskIDType idType, UserTaskFieldDefine returnFields, params string[] ids)
{
return GetUserTasks(idType, returnFields, false, ids);
}
private static UpdateSqlClauseBuilder GetUpdateSqlClauseBuilderByUserTask(UserTask task, UserTaskFieldDefine fields)
{
string[] ignoredProperties =
GetIgnorPropertiesByEnum((int)fields, EnumItemDescriptionAttribute.GetDescriptionList(typeof(UserTaskFieldDefine)));
UpdateSqlClauseBuilder uBuilder = ORMapping.GetUpdateSqlClauseBuilder<UserTask>(task, ignoredProperties);
return uBuilder.AppendTenantCode();
}
private static UpdateSqlClauseBuilder GetUpdateSqlClauseBuilderByUserTask(UserTask task, UserTaskFieldDefine fields)
{
string[] ignoredProperties =
GetIgnorPropertiesByEnum((int)fields, EnumItemDescriptionAttribute.GetDescriptionList(typeof(UserTaskFieldDefine)));
UpdateSqlClauseBuilder uBuilder = ORMapping.GetUpdateSqlClauseBuilder <UserTask>(task, ignoredProperties);
return(uBuilder.AppendTenantCode());
}
internal int OnUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary<object, object> context)
{
int result = 0;
if (UpdateUserTask != null)
result = UpdateUserTask(task, idType, fields, context);
return result;
}
internal void OnBeforeUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary<object, object> context)
{
if (BeforeUpdateUserTask != null)
BeforeUpdateUserTask(task, idType, fields, context);
}
private static string GetUserTaskSelectFields(UserTaskFieldDefine returnFields)
{
ORMappingItemCollection mappings = ORMapping.GetMappingInfo<UserTask>();
StringBuilder strB = new StringBuilder();
if (returnFields != UserTaskFieldDefine.All)
{
foreach (EnumItemDescription desp in EnumItemDescriptionAttribute.GetDescriptionList(typeof(UserTaskFieldDefine)))
{
UserTaskFieldDefine enumItem = (UserTaskFieldDefine)desp.EnumValue;
if ((enumItem & returnFields) != UserTaskFieldDefine.None)
{
ORMappingItem mappingItem = GetMappingFromPropertyName(enumItem.ToString(), mappings);
if (mappingItem != null)
{
if (strB.Length > 0)
strB.Append(", ");
strB.Append(mappingItem.DataFieldName);
}
}
}
}
else
strB.Append("*");
return strB.ToString();
}
private static int eventContainer_UpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary <object, object> context)
{
ExceptionHelper.FalseThrow <ArgumentNullException>(task != null, "task");
WhereSqlClauseBuilder wBuilder = GetWhereSqlClauseBuilderByUserTask(task, idType);
UpdateSqlClauseBuilder uBuilder = GetUpdateSqlClauseBuilderByUserTask(task, fields);
string sql = string.Format("UPDATE WF.USER_TASK SET {0} WHERE {1}",
uBuilder.ToSqlString(TSqlBuilder.Instance),
wBuilder.ToSqlString(TSqlBuilder.Instance));
return(DbHelper.RunSql(sql, GetConnectionName()));
}
public void OnBeforeUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields)
{
foreach (UserTaskOpEventContainer container in EventContainers)
container.OnBeforeUpdateUserTask(task, idType, fields, Context);
}
private int eventContainer_UpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary<object, object> context)
{
AttachTransactionEvent();
return 0;
}
public int OnUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields)
{
int result = 0;
foreach (UserTaskOpEventContainer container in EventContainers)
{
int r = container.OnUpdateUserTask(task, idType, fields, Context);
if (r > result)
result = r;
}
return result;
}
private int eventContainer_UpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary <object, object> context)
{
Write(GetMessageContent(task), "UpdateUserTask");
return(0);
}
private int eventContainer_UpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary <object, object> context)
{
AttachTransactionEvent();
return(0);
}
/// <summary>
/// 根据Task的ID获得UserTask对象集合
/// </summary>
/// <param name="idType"></param>
/// <param name="returnFields"></param>
/// <param name="ids"></param>
/// <returns></returns>
public UserTaskCollection GetUserTasks(UserTaskIDType idType, UserTaskFieldDefine returnFields, params string[] ids)
{
return(GetUserTasks(idType, returnFields, false, ids));
}
private void eventContainer_BeforeUpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary <object, object> context)
{
if ((fields & ~UserTaskFieldDefine.ReadTime) != UserTaskFieldDefine.None)
{
ProcessTaskByIDType(task, idType);
}
}
public int UpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields)
{
ExceptionHelper.FalseThrow<ArgumentNullException>(task != null, "task");
int result = 0;
UserOpContext contexts = InitEventContexts();
contexts.OnBeforeUpdateUserTask(task, idType, fields);
using (TransactionScope scope = TransactionScopeFactory.Create())
{
result = contexts.OnUpdateUserTask(task, idType, fields);
scope.Complete();
}
return result;
}
private static int eventContainer_UpdateUserTask(UserTask task, UserTaskIDType idType, UserTaskFieldDefine fields, Dictionary<object, object> context)
{
ExceptionHelper.FalseThrow<ArgumentNullException>(task != null, "task");
WhereSqlClauseBuilder wBuilder = GetWhereSqlClauseBuilderByUserTask(task, idType);
UpdateSqlClauseBuilder uBuilder = GetUpdateSqlClauseBuilderByUserTask(task, fields);
string sql = string.Format("UPDATE WF.USER_TASK SET {0} WHERE {1}",
uBuilder.ToSqlString(TSqlBuilder.Instance),
wBuilder.ToSqlString(TSqlBuilder.Instance));
return DbHelper.RunSql(sql, GetConnectionName());
}
