public bool ModifyTask(T_TASK task, String userName, String createUserMail, DateTime createTime)
{
bool isSucess = true;
using (var tran = DbContext.DbTransaction)
{
try
{
DbContext.Update(task);
var taskLog = new T_TASK_LOG();
taskLog.T_TASK_ID = task.ID;
taskLog.T_STATE = task.T_STATE;
taskLog.T_TITLE = task.T_TITLE;
taskLog.T_CONENT = task.T_CONENT;
taskLog.T_ASSIGNED_NAME = task.T_ASSIGNED_NAME;
taskLog.T_ASSIGNED_EMAIL = task.T_ASSIGNED_EMAIL;
taskLog.T_TYPE_NAME = task.T_TYPE_NAME;
taskLog.T_TIME = task.T_TIME;
taskLog.CREATE_USER_NAME = userName;
taskLog.CREATE_USER_MAIL = createUserMail;
taskLog.CREATE_TIME = createTime;
DbContext.Insert(taskLog);
}
catch (Exception e)
{
isSucess = false;
throw e;
}
finally
{
if (isSucess)
{
tran.Commit();
}
else
{
tran.Rollback();
}
}
return(isSucess);
}
}
public int CreateTask(T_TASK task, String userName)
{
int taskId = 0;
using (var tran = DbContext.DbTransaction)
{
try
{
DbContext.Insert(task);
var taskLog = new T_TASK_LOG();
taskLog.T_TASK_ID = task.ID;
taskLog.T_STATE = task.T_STATE;
taskLog.T_TITLE = task.T_TITLE;
taskLog.T_CONENT = task.T_CONENT;
taskLog.T_ASSIGNED_NAME = task.T_ASSIGNED_NAME;
taskLog.T_ASSIGNED_EMAIL = task.T_ASSIGNED_EMAIL;
taskLog.T_TYPE_NAME = task.T_TYPE_NAME;
taskLog.T_TIME = task.T_TIME;
taskLog.CREATE_USER_NAME = userName;
taskLog.CREATE_USER_MAIL = task.CREATE_USER_MAIL;
taskLog.CREATE_TIME = task.CREATE_TIME;
DbContext.Insert(taskLog);
taskId = task.ID;
}
catch (Exception e)
{
throw e;
}
finally
{
if (taskId > 0)
{
tran.Commit();
}
else
{
tran.Rollback();
}
}
return(taskId);
}
}
