/// <summary>
/// 根据日志ID获取日志信息
/// </summary>
/// <param name="auditID">日志ID</param>
/// <param name="type">父对象类型ID</param>
/// <returns>日志信息</returns>
public AuditHdrInfo GetAuditInfo(int auditID, int type)
{
AuditHdrInfo info = this.auditLogDao.GetAuditHdrLog(auditID);
info.DetailInfo = this.auditLogDao.GetAuditDetailLog(auditID, type);
return(info);
}
public void SaveFujiClass2s(List <FujiClass2Info> infos, FujiClass2Info.SectionType type, UserInfo userInfo)
{
List <FujiClass2Info> existsInfos = this.QueryFujiClass2sByIDs(infos.Select(info => info.ID).ToList());
DataTable dt = FujiClass2Info.ConvertFujiClass2DataTable(infos);
switch (type)
{
case FujiClass2Info.SectionType.Labour:
this.fujiClassDao.UpdateFujiClass2Labour(dt);
break;
case FujiClass2Info.SectionType.Contract:
this.fujiClassDao.UpdateFujiClass2Contract(dt);
break;
case FujiClass2Info.SectionType.Spare:
this.fujiClassDao.UpdateFujiClass2Spare(dt);
break;
case FujiClass2Info.SectionType.Repair:
this.fujiClassDao.UpdateFujiClass2Repair(dt);
this.UpdateFaultRates(infos.SelectMany(info => info.Repairs).ToList());
break;
}
//转换日志信息
infos.Sort();
existsInfos.Sort();
List <AuditHdrInfo> audits = new List <AuditHdrInfo>();
int len = existsInfos.Count;
for (int i = 0; i < len; i++)
{
AuditHdrInfo audit = existsInfos[i].ConvertAudit(infos[i], userInfo);
audit.DetailInfo = audit.DetailInfo.Concat(FaultRateInfo.ConvertAuditDetail(existsInfos[i].Repairs, infos[i].Repairs)).ToList();
audits.Add(audit);
}
DataTable auditDT = audits.ConvertAuditDT();
DataTable auditDetailDT = null;
this.auditDao.AddAuditHdr(auditDT);
for (int i = 0; i < len; i++)
{
if (auditDetailDT == null)
{
auditDetailDT = audits[i].DetailInfo.ConvertAuditDetailDT(SQLUtil.ConvertInt(auditDT.Rows[i]["ID"]));
}
else
{
auditDetailDT.Merge(audits[i].DetailInfo.ConvertAuditDetailDT(SQLUtil.ConvertInt(auditDT.Rows[i]["ID"])));
}
}
this.auditDao.AddAuditDetail(auditDetailDT);
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="userID">操作者id</param>
/// <param name="objectTypeID">操作对象类型</param>
/// <param name="objectID">对象ID</param>
/// <param name="dt">修改字段信息</param>
/// <param name="operation">操作方式</param>
public void AddAuditLog(int userID, int objectTypeID, int objectID, DataTable dt, int operation = AuditHdrInfo.AuditOperations.Update)
{
AuditHdrInfo auditHdrInfo = new AuditHdrInfo();
auditHdrInfo.TransUser.ID = userID;
auditHdrInfo.ObjectType.ID = objectTypeID;
auditHdrInfo.ObjectID = objectID;
auditHdrInfo.Operation.ID = operation;
auditHdrInfo = this.auditLogDao.AddAuditHdr(auditHdrInfo);
this.auditLogDao.AddAuditDetail(auditHdrInfo.ID, dt);
}
/// <summary>
/// 新增日志
/// </summary>
/// <param name="info">日志信息</param>
/// <returns>日志信息</returns>
public AuditHdrInfo AddAuditHdr(AuditHdrInfo info)
{
sqlStr = "INSERT INTO tblAuditHdr(UserID,Operation,ObjectTypeID,ObjectID,UpdateDate) " +
" VALUES(@UserID,@Operation,@ObjectTypeID,@ObjectID,GETDATE() );" +
" SELECT @@IDENTITY";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@UserID", SqlDbType.Int).Value = info.TransUser.ID;
command.Parameters.Add("@Operation", SqlDbType.Int).Value = info.Operation.ID;
command.Parameters.Add("@ObjectTypeID", SqlDbType.Int).Value = info.ObjectType.ID;
command.Parameters.Add("@ObjectID", SqlDbType.Int).Value = info.ObjectID;
info.ID = SQLUtil.ConvertInt(command.ExecuteScalar());
return(info);
}
}
public void UpdateComponents(List <ComponentInfo> infos, UserInfo userInfo)
{
List <ComponentInfo> existsInfos = this.QueryComponentsByIDs(infos.Select(info => info.ID).ToList());
foreach (ComponentInfo info in infos)
{
this.componentDao.UpdateComponent(info);
}
DataTable dt = FaultRateInfo.ConvertFaultRateDataTable(infos.SelectMany(component => component.FaultRates).ToList());
this.faultRateDao.UpdateFaultRates(dt);
// 零件转换日志信息
infos.Sort();
existsInfos.Sort();
List <AuditHdrInfo> audits = new List <AuditHdrInfo>();
int len = existsInfos.Count;
for (int i = 0; i < len; i++)
{
AuditHdrInfo audit = existsInfos[i].ConvertAudit(infos[i], userInfo);
audit.DetailInfo = audit.DetailInfo.Concat(FaultRateInfo.ConvertAuditDetail(existsInfos[i].FaultRates, infos[i].FaultRates)).ToList();
//if(audit.DetailInfo.Count>0)
audits.Add(audit);
}
DataTable auditDT = audits.ConvertAuditDT();
DataTable auditDetailDT = null;
this.auditDao.AddAuditHdr(auditDT);
for (int i = 0; i < len; i++)
{
if (auditDetailDT == null)
{
auditDetailDT = audits[i].DetailInfo.ConvertAuditDetailDT(SQLUtil.ConvertInt(auditDT.Rows[i]["ID"]));
}
else
{
auditDetailDT.Merge(audits[i].DetailInfo.ConvertAuditDetailDT(SQLUtil.ConvertInt(auditDT.Rows[i]["ID"])));
}
}
this.auditDao.AddAuditDetail(auditDetailDT);
}
