public static DbCommand GetCreateAttachmentCommand(Database database, RegisterAttachmentEntityNewLogic attach)
{
DbCommand cmd = database.GetStoredProcCommand("P_CreateRegisterAttachment");
database.AddOutParameter(cmd, "Id", DbType.String, 36);
database.AddInParameter(cmd, "RegisterId", DbType.String, attach.RegisterId);
database.AddInParameter(cmd, "SaveName", DbType.String, attach.SaveName);
database.AddInParameter(cmd, "ShowName", DbType.String, attach.ShowName);
return cmd;
}
public string CreateRegisterWithAttachment(RegisterEntity entity, RegisterAttachmentEntityNewLogic[] registerAttachmentEntityNewLogic)
{
string registerId = string.Empty;
#region 使用事务
base.UseTran((tran) =>
{
DbCommand cmd = RegisterService.GetCreateRegisterCommand(this.Database, entity);
base.Database.ExecuteNonQuery(cmd, tran);
registerId = (string)base.Database.GetParameterValue(cmd, "RegisterId");
base.DeleteRelationData("registerattach", registerId, tran);
registerAttachmentEntityNewLogic.ToList().ForEach((item) =>
{
item.RegisterId = registerId;
DbCommand cmd1 = GetCreateAttachmentCommand(this.Database, item);
base.Database.ExecuteNonQuery(cmd1, tran);
var attachId = base.Database.GetParameterValue(cmd1, "Id").ToString();
});
});
#endregion
return registerId;
}
public void UpdateRegisterWithAttachment(RegisterEntity entity, RegisterAttachmentEntityNewLogic[] registerAttachmentEntityNewLogic)
{
base.UseTran((tran) =>
{
var cmd = GetUpdateRegisterCommand(this.Database, entity);
base.Database.ExecuteNonQuery(cmd, tran);
base.DeleteRelationData("registerattach", entity.RegisterId, tran);
registerAttachmentEntityNewLogic.ToList().ForEach((item) =>
{
#region CreateAttachment
DbCommand cmd1 = RegisterService.GetCreateAttachmentCommand(this.Database, item);
base.Database.ExecuteNonQuery(cmd1, tran);
var attachId = base.Database.GetParameterValue(cmd1, "Id").ToString();
#endregion
});
});
}
