/// <summary>
/// 添加新开项目作业许可证
/// </summary>
/// <param name="securityLicense"></param>
public static void AddSecurityLicense(Model.License_SecurityLicense securityLicense)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_SecurityLicense newSecurityLicense = new Model.License_SecurityLicense
{
SecurityLicenseId = securityLicense.SecurityLicenseId,
ProjectId = securityLicense.ProjectId,
SecurityLicenseCode = securityLicense.SecurityLicenseCode,
SecurityLicenseName = securityLicense.SecurityLicenseName,
NewProjectName = securityLicense.NewProjectName,
NewProjectPart = securityLicense.NewProjectPart,
UnitId = securityLicense.UnitId,
LimitDate = securityLicense.LimitDate,
SignMan = securityLicense.SignMan,
SignDate = securityLicense.SignDate,
ConfirmMan = securityLicense.ConfirmMan,
AddMeasure = securityLicense.AddMeasure,
AddMeasureMan = securityLicense.AddMeasureMan,
SecurityLicenseContents = securityLicense.SecurityLicenseContents
};
db.License_SecurityLicense.InsertOnSubmit(newSecurityLicense);
db.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectSecurityLicenseMenuId, securityLicense.ProjectId, null, securityLicense.SecurityLicenseId, securityLicense.SignDate);
}
/// <summary>
/// 根据主键删除新开项目作业许可证
/// </summary>
/// <param name="securityLicenseId"></param>
public static void DeleteSecurityLicenseById(string securityLicenseId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_SecurityLicense securityLicense = db.License_SecurityLicense.FirstOrDefault(e => e.SecurityLicenseId == securityLicenseId);
if (securityLicense != null)
{
///删除编码表记录
BLL.CodeRecordsService.DeleteCodeRecordsByDataId(securityLicenseId);
BLL.CommonService.DeleteAttachFileById(securityLicenseId); //删除附件
BLL.CommonService.DeleteFlowOperateByID(securityLicenseId); ////删除审核流程表
db.License_SecurityLicense.DeleteOnSubmit(securityLicense);
db.SubmitChanges();
}
}
/// <summary>
/// 修改新开项目作业许可证
/// </summary>
/// <param name="securityLicense"></param>
public static void UpdateSecurityLicense(Model.License_SecurityLicense securityLicense)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_SecurityLicense newSecurityLicense = db.License_SecurityLicense.FirstOrDefault(e => e.SecurityLicenseId == securityLicense.SecurityLicenseId);
if (newSecurityLicense != null)
{
newSecurityLicense.ProjectId = securityLicense.ProjectId;
newSecurityLicense.SecurityLicenseCode = securityLicense.SecurityLicenseCode;
newSecurityLicense.SecurityLicenseName = securityLicense.SecurityLicenseName;
newSecurityLicense.NewProjectName = securityLicense.NewProjectName;
newSecurityLicense.NewProjectPart = securityLicense.NewProjectPart;
newSecurityLicense.UnitId = securityLicense.UnitId;
newSecurityLicense.LimitDate = securityLicense.LimitDate;
newSecurityLicense.SignMan = securityLicense.SignMan;
newSecurityLicense.SignDate = securityLicense.SignDate;
newSecurityLicense.ConfirmMan = securityLicense.ConfirmMan;
newSecurityLicense.AddMeasure = securityLicense.AddMeasure;
newSecurityLicense.AddMeasureMan = securityLicense.AddMeasureMan;
newSecurityLicense.SecurityLicenseContents = securityLicense.SecurityLicenseContents;
db.SubmitChanges();
}
}
