/// <summary>
/// 获取用户附件作业完成详情
/// </summary>
/// <returns></returns>
public FileWorksContracts GetUserFileWork(long doWorkId)
{
string sql = "SELECT * FROM fileWorks WHERE DoWorkId = @DoWorkId";
FileWorksContracts model = null;
using (var dr = MySqlHelper.ExecuteReader(ReadConnectionString, sql, new MySqlParameter("@DoWorkId", doWorkId)))
{
if (dr.Read())
{
model = new FileWorksContracts()
{
DoId = dr.GetInt64("DoId"),
RecordId = dr.GetInt64("RecordId"),
WorkId = dr.GetInt64("WorkId"),
DoWorkId = dr.GetInt64("DoWorkId"),
SubmitUserId = dr.GetInt32("SubmitUserId"),
SubmitUserName = dr.GetString("SubmitUserName"),
WorkLevel = dr.GetDecimal("WorkLevel"),
WorkLong = dr.GetInt32("WorkLong"),
SubmitDate = dr.GetDateTime("SubmitDate"),
IsTimeOut = dr.GetBoolean("IsTimeOut"),
SubmitCount = dr.GetInt32("SubmitCount"),
Message = dr.GetString("Message"),
Comment = dr.GetString("Comment"),
CommentType = dr.GetInt32("CommentType"),
Status = dr.GetInt32("Status"),
FileCount = dr.GetInt32("FileCount")
};
}
}
return(model);
}
/// <summary>
/// 提交附件作业
/// </summary>
/// <param name="model"></param>
/// <param name="userAnswer"></param>
/// <returns></returns>
public long DoFileWork(FileWorksContracts model, IEnumerable <WorkAnswerContract> userAnswer = null)
{
if (model == null)
{
throw new ArgumentNullException("参数model为null");
}
using (var trans = new TransactionScope())
{
model.SubmitDate = DateTime.Now;
if (model.DoId == 0)
{
_fileWorksManager.Insert(model);
}
else
{
_fileWorksManager.Update(model);
}
_workAnserManager.Insert(model.DoId, 3, userAnswer);
trans.Complete();
}
if (model.DoId > 0)
{
_workBaseManager.UpdateDoWorkStatus(model.DoWorkId, model.SubmitDate, model.Status, model.WorkLong, 0m);
}
return(model.DoId);
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(FileWorksContracts model)
{
var bulider = new UpdateBuilder("fileWorks")
.RegisterField("WorkLevel", model.WorkLevel)
.RegisterField("WorkLong", model.WorkLong)
.RegisterField("SubmitDate", model.SubmitDate)
.RegisterField("IsTimeOut", model.IsTimeOut)
.RegisterField("SubmitCount", model.SubmitCount)
.RegisterField("Message", model.Message ?? string.Empty)
.RegisterField("Comment", model.Comment)
.RegisterField("CommentType", model.CommentType)
.RegisterField("FileCount", model.FileCount)
.RegisterField("Status", model.Status)
.RegisterClause(new EqualBuilder <long>("DoId", model.DoId));
return(AdoProvide.ExecuteNonQuery(WriteConnectionString, bulider) > 0);
}
/// <summary>
/// 添加单元作业完成记录,返回自增id
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public long Insert(FileWorksContracts model)
{
var bulider = new InsertBuilder("fileWorks")
.RegisterField("RecordId", model.RecordId)
.RegisterField("WorkId", model.WorkId)
.RegisterField("DoWorkId", model.DoWorkId)
.RegisterField("SubmitUserId", model.SubmitUserId)
.RegisterField("SubmitUserName", model.SubmitUserName ?? string.Empty)
.RegisterField("WorkLevel", model.WorkLevel)
.RegisterField("WorkLong", model.WorkLong)
.RegisterField("SubmitDate", model.SubmitDate)
.RegisterField("IsTimeOut", model.IsTimeOut)
.RegisterField("SubmitCount", model.SubmitCount)
.RegisterField("Message", model.Message ?? string.Empty)
.RegisterField("Comment", model.Comment ?? string.Empty)
.RegisterField("CommentType", model.CommentType)
.RegisterField("FileCount", model.FileCount)
.RegisterField("Status", model.Status);
model.DoId = AdoProvide.ExecuteScalar <long>(WriteConnectionString, bulider);
return(model.DoId);
}
