/// <summary>
/// 修改特殊机具设备资质
/// </summary>
/// <param name="equipmentQuality"></param>
public static void UpdateEquipmentQuality(Model.QualityAudit_EquipmentQuality equipmentQuality)
{
Model.SUBHSSEDB db = Funs.DB;
Model.QualityAudit_EquipmentQuality newEquipmentQuality = db.QualityAudit_EquipmentQuality.FirstOrDefault(e => e.EquipmentQualityId == equipmentQuality.EquipmentQualityId);
if (newEquipmentQuality != null)
{
newEquipmentQuality.ProjectId = equipmentQuality.ProjectId;
newEquipmentQuality.EquipmentQualityCode = equipmentQuality.EquipmentQualityCode;
newEquipmentQuality.UnitId = equipmentQuality.UnitId;
newEquipmentQuality.SpecialEquipmentId = equipmentQuality.SpecialEquipmentId;
newEquipmentQuality.EquipmentQualityName = equipmentQuality.EquipmentQualityName;
newEquipmentQuality.SizeModel = equipmentQuality.SizeModel;
newEquipmentQuality.FactoryCode = equipmentQuality.FactoryCode;
newEquipmentQuality.CertificateCode = equipmentQuality.CertificateCode;
newEquipmentQuality.CheckDate = equipmentQuality.CheckDate;
newEquipmentQuality.LimitDate = equipmentQuality.LimitDate;
newEquipmentQuality.InDate = equipmentQuality.InDate;
newEquipmentQuality.OutDate = equipmentQuality.OutDate;
newEquipmentQuality.ApprovalPerson = equipmentQuality.ApprovalPerson;
newEquipmentQuality.CarNum = equipmentQuality.CarNum;
newEquipmentQuality.Remark = equipmentQuality.Remark;
newEquipmentQuality.CompileMan = equipmentQuality.CompileMan;
newEquipmentQuality.CompileDate = equipmentQuality.CompileDate;
newEquipmentQuality.QRCodeAttachUrl = equipmentQuality.QRCodeAttachUrl;
db.SubmitChanges();
}
}
/// <summary>
/// 添加特殊机具设备资质
/// </summary>
/// <param name="equipmentQuality"></param>
public static void AddEquipmentQuality(Model.QualityAudit_EquipmentQuality equipmentQuality)
{
Model.SUBHSSEDB db = Funs.DB;
Model.QualityAudit_EquipmentQuality newEquipmentQuality = new Model.QualityAudit_EquipmentQuality
{
EquipmentQualityId = equipmentQuality.EquipmentQualityId,
ProjectId = equipmentQuality.ProjectId,
EquipmentQualityCode = equipmentQuality.EquipmentQualityCode,
UnitId = equipmentQuality.UnitId,
SpecialEquipmentId = equipmentQuality.SpecialEquipmentId,
EquipmentQualityName = equipmentQuality.EquipmentQualityName,
SizeModel = equipmentQuality.SizeModel,
FactoryCode = equipmentQuality.FactoryCode,
CertificateCode = equipmentQuality.CertificateCode,
CheckDate = equipmentQuality.CheckDate,
LimitDate = equipmentQuality.LimitDate,
InDate = equipmentQuality.InDate,
OutDate = equipmentQuality.OutDate,
ApprovalPerson = equipmentQuality.ApprovalPerson,
CarNum = equipmentQuality.CarNum,
Remark = equipmentQuality.Remark,
CompileMan = equipmentQuality.CompileMan,
CompileDate = equipmentQuality.CompileDate
};
db.QualityAudit_EquipmentQuality.InsertOnSubmit(newEquipmentQuality);
db.SubmitChanges();
CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.EquipmentQualityMenuId, equipmentQuality.ProjectId, null, equipmentQuality.EquipmentQualityId, equipmentQuality.CompileDate);
}
/// <summary>
/// 根据主键删除特殊机具设备资质
/// </summary>
/// <param name="equipmentQualityId"></param>
public static void DeleteEquipmentQualityById(string equipmentQualityId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.QualityAudit_EquipmentQuality equipmentQuality = db.QualityAudit_EquipmentQuality.FirstOrDefault(e => e.EquipmentQualityId == equipmentQualityId);
if (equipmentQuality != null)
{
CodeRecordsService.DeleteCodeRecordsByDataId(equipmentQualityId); //删除编号
CommonService.DeleteAttachFileById(equipmentQualityId); //删除附件
db.QualityAudit_EquipmentQuality.DeleteOnSubmit(equipmentQuality);
db.SubmitChanges();
}
}
/// <summary>
/// 保存QualityAudit_EquipmentQuality
/// </summary>
/// <param name="newItem">机具设备资质</param>
/// <returns></returns>
public static void SaveEquipmentQuality(Model.EquipmentQualityItem newItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.QualityAudit_EquipmentQuality newEquipmentQuality = new Model.QualityAudit_EquipmentQuality
{
EquipmentQualityId = newItem.EquipmentQualityId,
ProjectId = newItem.ProjectId,
EquipmentQualityCode = newItem.EquipmentQualityCode,
UnitId = newItem.UnitId,
SpecialEquipmentId = newItem.SpecialEquipmentId,
EquipmentQualityName = newItem.EquipmentQualityName,
SizeModel = newItem.SizeModel,
FactoryCode = newItem.FactoryCode,
CertificateCode = newItem.CertificateCode,
CheckDate = Funs.GetNewDateTime(newItem.CheckDate),
LimitDate = Funs.GetNewDateTimeOrNow(newItem.LimitDate),
InDate = Funs.GetNewDateTime(newItem.InDate),
OutDate = Funs.GetNewDateTime(newItem.OutDate),
ApprovalPerson = newItem.ApprovalPerson,
CarNum = newItem.CarNum,
Remark = newItem.Remark,
CompileMan = newItem.CompileManId,
};
var updateEquipmentQuality = Funs.DB.QualityAudit_EquipmentQuality.FirstOrDefault(x => x.EquipmentQualityId == newItem.EquipmentQualityId);
if (updateEquipmentQuality == null)
{
newEquipmentQuality.CompileDate = DateTime.Now;
newEquipmentQuality.EquipmentQualityId = SQLHelper.GetNewID();
newEquipmentQuality.EquipmentQualityCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.EquipmentQualityMenuId, newEquipmentQuality.ProjectId, newEquipmentQuality.UnitId);
EquipmentQualityService.AddEquipmentQuality(newEquipmentQuality);
}
else
{
EquipmentQualityService.UpdateEquipmentQuality(newEquipmentQuality);
}
if (!string.IsNullOrEmpty(newItem.AttachUrl))
{
////保存附件
UploadFileService.SaveAttachUrl(UploadFileService.GetSourceByAttachUrl(newItem.AttachUrl, 10, null), newItem.AttachUrl, Const.EquipmentQualityMenuId, newEquipmentQuality.EquipmentQualityId);
}
else
{
CommonService.DeleteAttachFileById(newEquipmentQuality.EquipmentQualityId);
}
}
